Adobe Community : All Content - All Communities

dataLabelStyle="value"

forums_noreply@adobe.com — Fri, 13 Feb 2009 05:10:37 GMT

Repost, really need help.

I have 3 cfchartseries within my cfchart. I want to display the values for one of the cfchartseries only, so I use
dataLabelStyle="value", which works.However,the other two cfchartseries also have their values displayed even though I do not have dataLabelStyle in them. I only want one of the cfchartseries to display the values.

What am I doing wrong, or what is going on here, can somebody please explain this to me ? Does dataLabelStyle even work ?

Excel Question

forums_noreply@adobe.com — Tue, 22 Jun 2010 16:19:20 GMT

I have a CF application that outputs carrier tracking numbers. I need to export this data to excel. If the output is 1Z234TY988784AQ, the export works fine because of the alphas. If the output is 1234567890, without any alpha, excel thinks it is a number and exports it in the scientific notation. If I put a space at the beginning or end, then the ouput works fine.

However, the user then takes the excel file and uses it to compare against another file with carrier tracking numbers. They claim they are not finding any matches becasue of the space.

How do I get around the scientific export ? Will csv file work ? I have not found any documentation yet on csv so I thought I would post my problem here.

Thanks

cffile upload question

forums_noreply@adobe.com — Thu, 03 Jun 2010 23:36:38 GMT

I have a form where users are required to upload documents, word, excel, gif, jpeg, anything.

I use cffile upload :

I then use a simple insert to put all the data into a table, including the uploaded docuemnt. The document column name is documentName and I use '#cffile.serverFile#' to insert. When I look in the table, everything is there and appears fine. The various uploaded docuemnts are someting line word_doc1.doc, word_doc2.doc, excel1.xls, picture1.gif, etc....differenent formats.

My question is when I retrieve the data for output, the documents just come out displayed as word_doc1.doc, word_doc2.doc, etc.....What do I need to do to display the actual word document (or excel, or gif.,etc.) instead of just the name.

I looked at another application and the uploaded document is moved to anohter folder and then opend as a link, but I dont think I can do that here.

What do I do to display the actual document ? Thanks

cfmail attachment

forums_noreply@adobe.com — Mon, 24 May 2010 23:57:24 GMT

I am trying to include an attachemnt in cfmail, for the first time.

Reviewing some of the online documentation and techniques, I found this easy one - I could not get it to work using variables so I hardcoded and it works.

A couple of questions :

The email has a body of text and it adds the atttachment before the text. What do I have to do to get the attachement after the text ?

Also, my form contains this : <td>Attachment: </td><td><input type="file" name="attachmentFile"></td>

Instead of hardcoding, how do I get the variable in there ? I tried to use the code below but it kept blowing up in the destination part (what I have in there now, I was just trying different things)

Help - Cannot Remember how to do this !

forums_noreply@adobe.com — Mon, 10 May 2010 16:30:00 GMT

I have a string data separated by a comma : xxx,aaa,bbb,ccc,ddd,eee,yyy, etc..... stored in sql table.

What is the command/technique to break up this string and display this data one on top of another :

xxx

aaa

bbb

ccc

ddd

eee

yyy

I remember doing it before but cannot remember how to do it and dont know what it is called to research.

Thanks

Linking to powerpoint

forums_noreply@adobe.com — Thu, 25 Feb 2010 17:38:56 GMT

I have a powerpoint document that I want to link to, so I have something like this :

<a href="../documentation/ClaimFormTrainingIntro.ppt" title="Claim Form Training">Claim Form Training</a>

It does open the document, but it appears to be cropped in the center, with alot of space to the right and left. If I open the document directly in powerpoint, it takes up the whole screen. But when I call it from the link, it does not appear right.

What else do I need to do to make the powerpoint link take up the entire screen ?

Warning message

forums_noreply@adobe.com — Fri, 29 Jan 2010 06:06:47 GMT

I have an order form with multiple line items. The user can go in and delete one or more of his lline items. For example, if his initial order had three line items and he goes in and deletes all three, he is cancelling his order. If that is the case, I would like to issue/popup a warning message saying something like 'are you sure you wish to cancel this order ?' and if the yes button is clicked, the order is cancelled and the user taken to a another screen. How do I display the warning message ?

Embedded carriage return

forums_noreply@adobe.com — Fri, 19 Feb 2010 04:05:47 GMT

We have an application with a textarea that is used for comments, free form text. It seems that if the user enters a line of text, then uses the enter key to go to the next line, it captures the carriage return. When the form is brought up for review, it is completely empty, yet all the data that was entered is in the table.

If the textarea is entered without using the enter key, the data displays when the form is reviewed.

I have never encountered this problem before and tried it and it does indeed do what is described above. I entered the textarea without using the enter key and the data displays. I went back to edit and added the enter key to the textarea and the form is completely blank.

What is going on and how can I prevent this from happening ?

Opening powerpoint slide

forums_noreply@adobe.com — Tue, 09 Feb 2010 21:59:19 GMT

I have a form that contains muliple links to powerpoint documents.

Here is the command I am using for one of the documents :

<cfoutput>#variable#</cfoutput>

<br>
<a href="../documentation/powerpointdocument.ppt">Power Point Document</a>

The document does open in powerpoint and does contain all the slides, but it seems to be bunched together in the center of the screen with alot of space to the left and right of each slide. What can I do to make it fit the entir screen ? When I open directly in powerpoint,it displays just fine. This problem only occurs when I attempt to open it with the link.

Misinterpretation of common characters

forums_noreply@adobe.com — Fri, 05 Feb 2010 05:41:07 GMT

I have a description column in my sql table, defined as nvarchar 50.

I ran into this on situation that we did not account for.

The user entered a description of "Tape, Roll, size 6 ' ". I attempted to insert this value into the table using '#form.description#'. Needless to say, it blew up because it was interpreting the single quote after the 6 as another quote. To correct the problem, I eliminated the single quote after the six.

What is the proper way to handle situations like this, or any other situation the ColdFusion might interpret as one of its symbols ?

Powerpoint

forums_noreply@adobe.com — Tue, 02 Feb 2010 17:40:36 GMT

I am producing some charts with CF. Is there anyway to automatically put them into powerpoint slides ? Currently, it is a cut and paste manual method, but I am trying to automate this process.

Thanks for any help or advice.

Form Colors

forums_noreply@adobe.com — Wed, 20 Jan 2010 22:02:48 GMT

I am using CFFORM. For my cfinput, how do I make the text boxes and/or checkboxes a different color. The form has a mixture of display (no changes) and entry fields and some users are complaning that they cannot see which fields to enter/edit, so I want to make those a different color, like yellow, to stand out.

I tried <cfinput style="color:yellow"> and that did not work. I tried <cfinput style="background color:yellow'> and that just changed the background color to yellow, not the textbox, or the checkbox.

What is the command to make those a different color instead of the default white ?

thanks

Query and cfchart question

forums_noreply@adobe.com — Sat, 19 Dec 2009 22:56:50 GMT

I have this simple query :

SELECT top 10
SupplierName, supplierNumber
SUM(TOTALS) AS TOTAL
FROM tableName

It will give me a simple output like:

company1 12345 20

company2 98881 5

company3 76512 18

What I need to do is plot the query in pie chart, with a drilldown report for each pie slice (supplier name) :

Everything works fine. But when I go to the drilldown report, I cannot really search by supplierName because some companies might have the same name, but the supplier numbers are unique, so I have to search by supplier number. That is why I am passing that value also.

But when I click on pie slice for company 3, it passes the supplier name company 3, but the supplier number is always the first one, 12345, regardless of what slice I click on. I have cfoutput in the report and it shows company 3 and 12345.

How do I get the corresponding supplier number for the pie slice supplier name that I click on ? I need the corresponding supplier number so I can use it to search the query in the drilldown report.

I tried to combine the name and number in the query and have the chart display 12345 - Company 1 in the legend, but they do not want the number to display, just the name in the legend.

Decimal formatting

forums_noreply@adobe.com — Tue, 15 Dec 2009 18:05:56 GMT

I have a query that will caculate an average, here is the line of code :

cast(sum(agedDays) as decimal)/cast((sum(days_GT_60) + sum(days_31_60) + sum(days_5_30) + sum(days_LT_5)) as decimal) as averageAging

So if I have agedDays = 130 and the sum of the days = 17, the average is 130/17 = 7.6470588235294117647........

How do I just get the output to be 7.6 (rounded) ?

Would this be done in SQL or do I need to format it in ColdFusion ?

Query help/question

forums_noreply@adobe.com — Fri, 11 Dec 2009 00:18:09 GMT

I have this query below. It basically sums then number of days and other stuff. Orginally, for the city, I just had a where city = 'New York' and it would give me one line of output only and I was able to insert into a table.

Now they want to include ten cities. So instead of having ten queries, one for each city, I combimed all the cities into one query using the group by.

here is the query

select city,
sum(days_GT_60) as days_GT_60,
sum(days_31_60) as days_31_60,
sum(days_5_30) as days_5_30,
sum(days_LT_5) as days_LT_5
From
(
select city,
(case when (agedDays > 60) then 1 else 0 end) as days_GT_60,
(case when (agedDays > 30 and agedDays < 61) then 1 else 0 end) as days_31_60,
(case when (agedDays > 4 and agedDays < 31) then 1 else 0 end) as days_5_30,
(case when (agedDays < 5) then 1 else 0 end) as days_LT_5
from
(
select DATEDIFF(day, date_arrived, GETDATE()) + 1 AS agedDays,
city
FROM receivefile
WHERE status NOT IN ('Voided', 'Closed')
group by city
) as I
group by city
) as K
group by city

The figures are not coming out correctl now. When I just had one city, New York, I had a certain count. Now will all ten cities, the counts for New York are now differnent.

What is wroing with my query ? I think there are too many group by clauses ?

Ideally, it would give me ten lines of output, one for each city, then I can use cfloop to loop thru and add each record into a table, one record per city.

How to add extra character during input

forums_noreply@adobe.com — Mon, 30 Nov 2009 17:35:12 GMT

Lets say I have a form that contains a field name citycode, and the value entered could be xyz, abc, ddx, etc..any three letter combination.

What I want to do is add an extra character in front of the entered value, if the city is New York. So if the New York user enters xyz in the city code field, than tabs to to the next field, I want to automatically add 'N' in front of the entered xyz so that that the city code will display NXYZ, even though he entered xyz and is now at the next field.

How can this be done ? I konw I can check for the city during insert and then add the N in front of xyz to insert into the table, but I thought adding it during input might be better so that the new value can be displayed before inserting into the table.

Submit button and Enter button

forums_noreply@adobe.com — Mon, 23 Nov 2009 18:06:53 GMT

All of my forms have a submit button to process the page. However, a user filled out the form and hit the enter key on the keyboard instead of the submit button on the form,and nothing happened.

Needless to say, he complained,and now the boss said that all enter buttons on the keyboard should function the same as the submit button on the page.

I dont think I have ever done this before. Does this require javascript code to make both function the same, or is there anohter method ?

Error Message

forums_noreply@adobe.com — Wed, 18 Nov 2009 18:12:30 GMT

I am getting this error message when I attempt to update :

Error converting data type varchar to float.

It is telling me that I am trying to put an alphanumeric field into a numeric decimal field ?

Here is the code I am using for my update :

update gfmPartNumbers
    set conditionCode = '#Evaluate("form.conditionCode#gfmPartNumberID#")#',
       materialNumber = '#Evaluate("form.materialNumber#gfmPartNumberID#")#',
    quantity = '#Evaluate("form.quantity#gfmPartNumberID#")#',
    unitValue = '#Evaluate("form.unitValue#gfmPartNumberID#")#'

The conditionCode is datatype nvarchar lenght 20, the materialNumber is nvarchar length 50, the quantity is int length 4 and the unitValue is decimal length 9.

I checked all the values on the screen before submitting and they all look good. The error message does not pinpoint me anywhere, what else and where else can I look ?

Rounding Up

forums_noreply@adobe.com — Wed, 18 Nov 2009 16:42:59 GMT

I am doing a simple calculation and need to round up the output :

Here is my partial query :

SELECT SUM(cycleTime) / COUNT(urdn_number) AS ceiling(cycleTime), count(urdn_number) as totalCount,
sum(totalValue) as totalCost, Month_Status
   FROM
   (
   SELECT distinct a.urdn_number,
   DATEDIFF(day, a.Date_Arrived, b.activity_date) + 1 AS cycleTime,

The cycle time variable needs to round up but it keeps rounding down. What am I doing wrong ? I even had the ceiling before the sum but that still did not work.

For example, my numbers are 206/14 = 14.7 and should round p to 15 but I still get 14 as my output.

Please help, driving me nuts.

Outputting large dollar amounts - how can I reduce ?

forums_noreply@adobe.com — Wed, 11 Nov 2009 00:40:57 GMT

I have to output 12 dollar amounts, one per month in a table with width 760.

The figures are rather large, like $285,025.46, $155,891.77, $6,961,692.85...etc.

They obvisouly will not fit in the table and will cause it to expand. What can I do to reduce the size and have it still be readable, such as 6.9M, or something like that, for the 6 million number ?

Or is there a better way to do this ?

How can I output this differently ?

forums_noreply@adobe.com — Fri, 06 Nov 2009 00:46:55 GMT

I currently output my report in a table using the following :

<table width="760" border="1" bordercolor="black" cellspacing="0" cellpadding="2">
          <tr bgcolor="#DCDEE0">
            <td class="TitleText" align="center"><b>Month/Year</b></font></td>
   <td class="TitleText" align="center"><b>Total Lots In</b></font></td>
   <td class="TitleText" align="center"><b>Total Lots Out</b></font></td>
          </tr>
          <cfoutput query="qryGetData">
          <tr>
            <td class="TitleText" align="center">#month_status#</td>
   <td class="TitleText" align="center">#totalLotsIn#</td>
   <td class="TitleText" align="center">#totalLotsout#</td>
          </tr>
    </cfoutput>
</table>

The outout looks something like this :

Month/Year Total Lots In Total Lots Out

1/09 10 20

2/09 30 30

etc...

How can I change the table to make the output look something like this :

1/09 2/09 3/09

In Out In Out In Out

10 20 30 30 40 50

etc..

Inserting cfmail contents into a comments field

forums_noreply@adobe.com — Wed, 28 Oct 2009 05:30:23 GMT

I have an application that will send out a cfmail (3 or 4 lines of content only). If is formatted in a table.

I also have a history log table where every transaction is recorded into a comments field. So when the cfmail is sent, a comment would be inserted into the history table with comments like 'Email sent to customer'. However, this comment is too plain, so they want to put the entire cfmail contents (3 or 4 lines) into the comments field.

How can I do this, including adding the table format/structure, into the comments ?

cfmail questions

forums_noreply@adobe.com — Sun, 20 Sep 2009 06:07:51 GMT

I have a query where I determine the number of days a request is still open. Here is the partial query :

SELECT DISTINCT
requestNumber,
DATEDIFF(day, date_arrived, GETDATE()) + 1 AS daysOpen
email,........

I then use cfmail to send an email to each email address. In the body of the email, I want to break it up into three categories based on the daysOpen

So I have this :

<cfoutput>display something here in GREEN..etc</cfoutput>

</cfif>

<cfoutput>display something here in BLUE, etc</cfoutput>

</cfif>

<cfouput>display somehting here in RED ,etc</cfoutput>

</cfif>

So for each email sent, the recipient show see three outputs, each in a different color.

However, this is not working and only the blue color is showing. I know there are daysOpen for the others also, but everything falls into the blue cateogry,

even daysOpen of 6, which according to the logic, should be green.

What am I doing wrong ? The logic makes sense to me but I guess it is incorrect. What do I need to do to get the three categories ?

How to separate names

forums_noreply@adobe.com — Sat, 19 Sep 2009 18:38:00 GMT

I have to search LDAP to get email address. However, all I have to work with is a name, such as Joe Smith. I can plug that in and it will find it.

However, sometimes nothing will be returned because the name in LDAP will be Joe X. Smith, and I only have Joe Smith to work with.

How can I break up the name Joe Smith into a first name of Joe and lastname of Smith ? I think I can then use the first name and lastname variables to search, thus bypassing any names with a middle initial. Also, it if is reversed and I have Joe X. Smith to work with, how can I still break up into first and last names without the middle initial. I just want a first and lastname to work with, so I can use that to search LDAP.

If this is not the proper way, what would be the best way to get email addresses from LDAP.

Thanks for any help.

Displaying data based on checkboxes

forums_noreply@adobe.com — Wed, 09 Sep 2009 18:05:14 GMT

I have a series of checkboxes that I dynamically generate from a table . Each checkbox represents a state. If I check on a checkbox for a particular state, how can I display the cities for that state ? Or check more than one checkbox, display all the cities for each checkbox that was checked.

overridding

forums_noreply@adobe.com — Thu, 20 Aug 2009 19:43:24 GMT

I have a form that submits to itself instead of an action page.

This is my submit button : <input type="submit" name="btnSubmit" style="width: 108px" value="Submit">

When the form is submitted, I check for the existence of the submit button and then do processing :

<cfif isDefined("form.fieldnames") and mid(form.fieldnames,1,4) is "Del_">
<cfloop index="i" list="#form.fieldnames#" delimiters=",">
<cfset select_urdn_number = listlast(i,"_")>

I basically have rows of data and each row contains a checkbox and I process all the transactions simultaneously that are checked.

What is happening now is that it seems to be treating form.btnSubmit as a form variable and attempting to insert it into the table and it is blowing up.

When I did this using an action page, there was no need to check for form.btnSubmit and the inserts worked without any problems.

How can I get around this problems ?

Pages timing out

forums_noreply@adobe.com — Thu, 30 Jul 2009 20:39:14 GMT

We have five in house built applications that run on the same server. However, one application seems to be timing out lately. Different pages, different hours of the day, different states (from CA, to TX, to MS, to FL), etc. Whenever one of the pages times out, the user calls and I try and duplicate by doing the exact same transaction on the same page, and it works for me without any issues. I call the sever admins located in AL and they say that the sever is fine and that the page is coded incorrected. Something call JRUN detected a problem and locked the page and when I used it, the lock was released.

This does not make sense to me. If the page/pages are coded in correctly, shouldnt they always fail ? Logically, that makes sense. But different pages fail at different times and we cannot pinpoint where teh problem is to try and fix it. One major difference between this app and the others is that this one still uses two pages, the form and action page. Some pages were rewritten to combine both into one page but that did not seem to solve the problem. We looked at the tables and they seem to be ok. We looked at the queries and ran thru analzyer and they completed quickly,no hangups. Everythihng seems to be ok, the data goes into the proper tables, etc. but some of the pages still time out. This app was running fine for the past year and half and the time outs just started happening about 2 months ago. At about the same time, the server crashed and was restored two days later. But this could just be a coincidence.

What could be causing the pages to time out ? Where else can we look to try and identify/isolate the problem ? Again, some people use it and it seems fine. But others using it wait awhile after submitting and then the page eventually times out. We are baffled and do not know what else can be done. None of the other apps seem to time out except for this one.

Any ideas or solutions will be greatly appreciated. Thanks

valuelist question

forums_noreply@adobe.com — Fri, 07 Aug 2009 04:36:37 GMT

I use valuelist to display a list of values :

#valuelist(qry.qualifierText, ", ")#

However, it will display continually across the page until it runs out of room, then wraps to the next line and continue until done.

How can I define it so that it will display only five on one line, then skip and dispaly the next five, then skip, etc. until completed ?

Retaining form values when moving between forms

forums_noreply@adobe.com — Fri, 07 Aug 2009 22:14:43 GMT

I can't remember if I asked this or someone else did, but I still cannot understand how to do this, so I am posting for help.

I have a form where I have to check off some values with checkboxes. I then have to enter an employee number. If I do not know it, I can click on an icon and it will take me to the master employee lookup site. Once I find what I am looking for, I click on that employee number and it returns me back to the original form, bringing back the selected employee number and plugging it into the employee number field. This works fine. But the problem I am having is that the check boxes that were checkws prior to the lookup are now gone and I have to recheck them all again.

How can I retain the checked checkboxes on the form after if comes back from the employee lookup ?

Pages time out

forums_noreply@adobe.com — Thu, 30 Jul 2009 03:33:16 GMT

Any ideas or solutions will be greatly appreciated. Thanks

Form and url variables - making them the same name

forums_noreply@adobe.com — Tue, 14 Jul 2009 18:31:20 GMT

I have a form that is entered when the user enters a part number. Inside the form, I do a bunch of query lookups using the form variabe, where partNumber = '#form.partNumber#'

However, I can also access this form from other forms, so I would then be using the url variable, where partNumber = '#url.partNumber#'

To determine whether I use the form or url variable, I pass a flag as I enter the form, and the check to determine which to use. For example, <cfif flag="form">, then where partNumber '#form.partNumber#" else where partNumber = '#url.partNumber#'

This seems to work ok, but is there a better way to do this ?

I just want to say where partNumber = '#partNumber#' and forget if it is form or url variable.

Leading Zeros

forums_noreply@adobe.com — Wed, 08 Jul 2009 18:57:39 GMT

I have a field labeled itemNo defined as nvarchar 50 in table on sql server.

On the form, when they enter the itemNo, I need it to be 00010, alsways 5 digits with leadgin zeros, because I have to use that as an exact match in a search later on. Most of the time, they only enter 10 and my search fails.

How do I automatically add the leading zeros to the form variable.I suppose I can check for length and insert it with the leading zeros, but I am using the form variable to check, so I would like that to have leading zeros.

Thanks

Creating dynamic value range, one week at a time

forums_noreply@adobe.com — Wed, 01 Jul 2009 03:45:38 GMT

Every Monday, I query a table to get data for the past week, every Monday (last Monday) to Sunday. I do some calculations with the data and insert the data and dates into a table.

I then use cfchart to create a graph using this data. The drilldown uses the same weekly date range to produce a report. So the record count for the chart and the report should be the same.

What I just discovered is that more data can be added to the query table after I have already obtained the data. Since the data for the chart is already in the table, it is static. But the report is dynamice since it uses the weekly date range everytime the drilldown is selected. This causes the count of the report to be different than the count of the chart.

Instead of gathering data every Monday and inserting into a table, for the chart, how can I make the chart data dynamic ?

I need to plot a rolling 12 weeks worth of data, always from Monday to Sunday, inclusive. So if I decide to run the chart on a Wednesday, how would I gather the twelve weeks worth of data, always from Monday to Sunday ? I need to make this dynamc.

The reports always work because the drilldown is pasing it the dates, thats why the count is always correct. But I do not know how to do this with the chart, which needs to be dynamic also, since static will not work.

Any help appreciated. Thanks

How to check for blank fields ?

forums_noreply@adobe.com — Mon, 29 Jun 2009 04:33:42 GMT

I have a form that contains six input fields used for email addresses.

Once all six are filled out, I can create a concatenated string with the six input fields, separated by a comma, to be used in the cfmail to part.

What if they do not fill out all six input fields and only fillout two of the input fields with email addresses. ?

What is an efficient way to check if a field was filled out or not, with an email address ? My concatenated string will then only contain 2 input fields.

CREATEODBCDATE

forums_noreply@adobe.com — Thu, 25 Jun 2009 15:08:37 GMT

I have a field named docDate that is defined as date time in sql table.

I want to query the table and find all records for docDate >= 05/18/2009 and docDate <= 05/24/2009

If I have this in my query, is it correct ? It seems to run fine thru analyzer but there are too many records for me to cound manuall to verify.

WHERE CONVERT(CHAR(10), docDate, 101) between #createodbcdate(lastWeek)# and #CreateODBCDate(todaysDate)#, where lastWeek is 05/18/2009 and todaysDate is 05/24/2009

How to tell between update and insert ?

forums_noreply@adobe.com — Wed, 27 May 2009 22:29:29 GMT

I have a form where a user can enter a value, press a button and anoher input would appear, add another value, press the button again, etc. When done, he submits and I use cfloop list to insert the data into a table.

When I bring up this form again, I check to see if there are any values in the table. If they are there, I display the values in a table, one per row. At the end, I have the button again, just in case they need to add more values.

Here is the problem that I am running into and do not know how to solve. How do I know whether they added a new value, or simply changed one of the existing values ? Or what is they did both, change an exisitng value and add a new value ?

This is the code I use if they chagned an exisitng value :

<cfloop index="dateCodeID" list="#form.dateCodeID#" delimiters=",">
<cfquery name="qryUpdateDateCodes" datasource="db">
udate table
set dateCode = '#Evaluate("form.dateCode#dateCodeID#")#'
where stockScreenID = '#form.stockScreenID#'
and dateCodeID = '#dateCodeID#'
</cfquery>
</cfloop>

and I would use the cfloop list to insert a new value, but how would I know which one to use when they submit ? I do not know whether an exisitng value(s) changed or new value(s) added.

Thanks

cgi.remote_user is blank

forums_noreply@adobe.com — Mon, 18 May 2009 20:26:18 GMT

I have been using cgi.remote_user to retrieve the logon ID of users, then pasing that value thru screens, all works fine.

However, we have defined a new datasource and when I tried to use cgi.remote_user, it is blank ? The dba is on vactaion so I cannot check with him. But I was wondering if anybody knows why cgi.remote_user is not returning anything this time. On other applications we have, it works fine, and I don't think I am doing anything differently.

Query help - getting the last record

forums_noreply@adobe.com — Mon, 18 May 2009 01:15:53 GMT

I have a history table that contains columns requestNo, status, and date. For example. for requestNo 1000, the first status is open and the date. The second record for reqeustNO 1000 might be review and the date, then status process and the date, and then status closed and the date. For requestNO 2000, the first record will be status open, then the next will be status reveiw.

How do I write a query to get the last record for each reqeustNO ? For example, the last record for requestNO 1000 will be status closed and the date. For reqeustNO 2000, the last record is review, and the date, etc.

What I really need to do is to find all last records with status of closed, for each reqeustNO.

Thanks

Outputting with cfloop ?

forums_noreply@adobe.com — Sat, 09 May 2009 01:23:57 GMT

I have a table that contains information for 4 states. I need to output the information in a table with each state in its own <td>. I currently do this by using four different queries, one per state. If a new state is added, then I have to create a fifth query.

I know this is not the best way to do this but I do not know how to do it any other way. Would I use cfloop to dynamically generate so that I do not have to create a new query ?

Help with Fusion Charts

forums_noreply@adobe.com — Tue, 05 May 2009 20:33:22 GMT

We just installed Fusion Charts on our server and I was told to start using that instead of cfchart.

Where can I find documentation, similar to cf docs, that explains all the commands and gives examples. I searched the web and cannot seem to find what I am looking for. Does anybody have a good website to look at ?

Also, does fusion charts completely replace cfchart, or does cfchart call the fusion charts commands ? I am completely new to this and was wondering can somebody show me an example of how fusion chart works ?

Thanks

How do I validate this ?

forums_noreply@adobe.com — Tue, 28 Apr 2009 04:39:26 GMT

I use the following code to dynamically generate input fields based on the quantity :

The problem I am having is that people purposely blowup the serialNumber field by exceeding the limit size 40. I can use maxlenght to prevent this, but I want to display an error message. How can I do this ?

Time Calculations in hours and minutes for same day or different day

forums_noreply@adobe.com — Mon, 20 Apr 2009 01:40:41 GMT

I have a start date/time of 4/13/09 10:08 and end date/time time of 4/13/09 11:55 and I need to calculate the time between both. It would be one hour and 47 minutes on the same day.

If I use datediff with hh, it returns 1 (one hour). If I use datediff with mm, it returns 0. What is the correct way/formula to calculate the time difference to come out with hours and minutes, and how do I add the am or pm ?

If the end date/time is 4/14/09 11:55, then that would be one day, one hour and 47 minutes, or 25 horus and 47 minutes ? How is that done if the date is the next day ?

cfchart and xml question - does anybody know how to do this ?

forums_noreply@adobe.com — Fri, 10 Apr 2009 04:05:31 GMT

I have a cfchart with two bars per date (x axis). I then added a line to complement the bars, with the line/point for each date represneting a percentage. I then use xml to create a second y axis to show the percentage amount. The problem I am running into is that with xml, the two bars are now on top of each other instead of side by side. Everytime I use xml this happens and I have to turn the bars into lines. How do I get around this ? I just want to have two bars side by side, with a line and a second Y axis.

cfchart question

forums_noreply@adobe.com — Wed, 08 Apr 2009 23:16:25 GMT

I have this partial query code. I calculate the daysdiff then sum them up base on if they are less than 3 days, greather than 3 days and less than 7, etc. :

SELECT
sum(CASE WHEN aging > 0   and aging <= 3   THEN 1 ELSE 0 END) as lessThanThreeDays,
sum(CASE WHEN aging > 3   and aging <= 7   THEN 1 ELSE 0 END) as greaterThanThreeDays,
sum(CASE WHEN aging > 7   and aging <= 30 THEN 1 ELSE 0 END) as greaterThanSevenDays,
sum(CASE WHEN aging > 30 and aging <= 60 THEN 1 ELSE 0 END) as greaterThanThirtyDays,
sum(CASE WHEN aging > 60 and aging <= 120 THEN 1 ELSE 0 END) as greaterThanSixtyDays,
sum(CASE WHEN aging > 120 and aging <= 240 THEN 1 ELSE 0 END) as greaterThanOneTwentyDays,
sum(CASE WHEN aging > 240 and aging <= 480 THEN 1 ELSE 0 END) as greaterThanTwoFortyDays,
sum(CASE WHEN aging > 480                  THEN 1 ELSE 0 END) as greaterThanFourEightyDays
FROM
(
SELECT

datediff(day, gfmMaster.dateArrived, getdate()) as aging

For my chart, the y axis will be number of days and the x axis will be days range (less than 3 days, greater than 3 days and less than 7 days, etc.)

I have a serieslabel for each date range but it does not like the serieslabel "<3", how can I get around that ?

<cfchartseries type="bar"
query="qryAging"

           valuecolumn="lessThanThreeDays"
   serieslabel="<3"
   seriescolor="blue"
            datalabelstyle="value">

Also, it is treating all the date ranges as one big one with the legend indicating which color is less than 3 days, etc. I would like it so that each date range is treated separately, like one bar for less than 3 days and the label as <3, one bar for greather than 3 days and less than 7 days, with the label as >3, etc. How can I do that ?

SQL Server Question

forums_noreply@adobe.com — Wed, 25 Mar 2009 17:15:44 GMT

I have a table in sql server. One column is quantity, datatype int and the other is price, datatype decimal. For cfinput, both are text and I predisplay 0.00 to let the user know the format.

What is happening now is that users are entered 1.5, etc., into the quantity field and the insert blows up because of the datatype. So I changed the quantityt datatype from int to decimal so it will accept 1.5. However, when I look in the table, the value is stored as 2 (it will round up or down) instead of 1.5. and displays as 2. The price works and looks fine, but the quanity does not work.

What do I need to do to retain the decimal, and what affect will that have on existing data that was previously int ?

sql sum question

forums_noreply@adobe.com — Tue, 24 Mar 2009 04:28:35 GMT

I need to produce a CF report only showing the top five suppliers, plus other information.

I count each supplier, with group by, then sum the count, with group by, to get the total occurrances of each supplier. My query/subquery is something like this :

select sum(supplierCount) as totalCount, supplier
from
(
select count(supplier) as suppliercount, supplier
from table
group by supplier
) as a
group by supplier
order by supplier

This appears to work and gives me the total occurrances of each supplier. I can then select the top 5. Howver, when I start including the other columns, the count/sum does not seem to work anymore and becomes 1 for each supplier. I even tried usign QofQ and that did not work.

How can I write the query to give me the total number of occurrances of each supplier, in addition to having the other columns on the report ?

How to preselect radio buttons

forums_noreply@adobe.com — Mon, 09 Mar 2009 17:56:59 GMT

I use the following to dynamically generate radio buttons from my query, a list of cities.

<cfloop query="qryGetCity">
<cfoutput>
<cfinput type="radio" name="cityID" value="#qryGetCity.cityID#">#qryGetCity.city#<br>
</cfoutput>
</cfloop>

When the user logs on, I validate their information from LDAP and then they are taken to this page to select their city.

What I need to do now is when they log on, I still need to validate their info from LDAP, but also ge the city and when they are taken to this page, preselect the city for them.

How would I do this with dynamically generated radio buttons ? I think I know how to do it if hardcoded, but I dont know with dynamic output.

Thanks

SQL Union

forums_noreply@adobe.com — Mon, 16 Mar 2009 20:59:04 GMT

I have a table by city, and population. I want to combine the populations of two cities into one. For example, the city of Ojai contains 10 people and the city of Santa Barbara contains 100 people. So for my output, I want to display the city as Santa Barbara and the population as 110

My query is something like this :

select sum(population), 'Santa Barbara' as city

from
(
select population from table where city='Ojai'
UNION
select populatoin from table where city='Santa Barbara'
)

It is giving me the population of the first record it finds, instead of both records.

Is using UNION not the right way to do it ?

I am going to try QofQ next.

xml and cfchart

forums_noreply@adobe.com — Thu, 05 Mar 2009 17:22:48 GMT

I have a cfchart with two series, one bar (total count for a period) and one line (average count for a period) I want to add a third series, anohter bar (total dollar for a period). The problem is that the dollar amount greatly exceeds the other two series in the y axis, makes them appear as if they did not exists at all.

So what I am doing now is using xml to create a second y axis for the dollar amount, Here is what I have so far :

<?xml version="1.0" encoding="UTF-8"?>
<frameChart is3d="false" >
<yAxis scaleMin="0" scaleMax="150" labelCount="10">
<labelStyle color="black" orientation="horizontal"/>
</yAxis>
<xAxis>
<labelStyle color="black" orientation="slanted"/>
</xAxis>
<elements place="Default" shape="bar" drawShadow="false">
<series index="2" shape="bar" isSecondAxis="true"/>
</elements>
</frameChart>

Here are the problems I am running into :
the bar for the dollar amount is stacked on top of the bar for the count, I want them side by side.
The series for the line (average count) is ok but it is now behind the bars, it used to be in front of the bars.
The scale for the original y axis is now in decimals, 10, 12.5, 16.8...etc, it used to be just whole numbers
The border around the chart and the 2nd y axis is blue, I do not know how to make it black
Is there a way to display the actual value/datapoint of the dollar only, on top of the bar ?

Anyone with xml experience that can help ? also, what is a good resource on the net that will have all the tags I am looking for ? right now, I am just getting them piece by piece and putting it together.

Automatic Page Reset

forums_noreply@adobe.com — Fri, 20 Feb 2009 15:10:19 GMT

I have a form that contains two dropdowns.When the values are selected, they are passed to another page and used in a query where statement. When they are done and return to the original page with the pulldowns, the selected values are still populating the boxes. A simple browser refresh will clear the values. However, they do not want to do this and want the page to automatically refresh to clear the values, when they go back in.

The javascript that I have found uses the meta tag but is set at intervals, which is not what I want. Other code uses the body onload but that seems to be an infinite loop.

Where can I find code to refresh the page once only, as soon as it is accessed. ?

thanks