I am experiencing a problem that I have tried to reproduce several times and failed. This issue is intermittent in nature and does not occur in every case but some particular users have been getting this error on daily basis. When they submit a request, the system generates an error message...
I have fields defined based on a number that is keyed in, for example if i = 10 where i is an input field then the fields would be defined as <input name="field#i#">
which would result in field1, field2, --- field10. Is there a way to access these fields on the next page using the same loop? I...
I have fields define based on an input number, for example if user keys in 5 then the fields are defined as field1, field2, field3, field4, and field5. There are other fields defined too in the form. Is there are way to access these fields 1 - 5 in javascript by using something like...
Another approach would be to run the query as follows:
select level1, level2, level3
from table
group by level1, level2, level3
while displaying, only print levels if they change. Can also use sort if want to display levels alphabetically.
something like this should work:
<cfquery name = 'abc' ....
select distinct email
from users
where mailing = 'yes'
</cfquery>
this should provide only one record of that email address. Probably you would need to update such records to set the mailing flag after the mail is sent, to do that you...
I have not gone in detail of your code, but did you try using cfcontent with type ms-excel to save it as an excel. That would be lot simpler. Also, your <tr> and </tr> before and after Location is making it a separate row. You can take those out, make it like follows:
<tr>...
If I am not mistaken, IsDate() would return true if date is passed as 12/06 which it would consider as december of 2006,, but this would definitely fail in an SQL insert if date field is defined, so you just need to be careful.
Micheal,
take "qry1." & out from your evaluation part. The following should work:
<cfif toString(evaluate(TableValueField)) EQUAL toString(evaluate(CurrentFieldValue))>
<font color="red">sOptionValue: #evaluate(TableValueField)#</font><br>
<cfelse>
<font color="green">sOptionValue...
Dave, thanks for the quick response and although the logic you mentioned was supposed to work fine but it did not. Somehow, the main window still executed the code with the old information in the variables. The only thing I changed was setting opener.readytocontinue flag right before the close...
I am trying to open a window and run a query within it. The window is supposed to set certain calling window variables and the main window needs to execute some code after the called window is closed. But as soon as the window opened with the following:
var szURL =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.