The code worked fine for me on another machine also. I suspect I might have a variable-name conflict going on. Will do some tests and let you know.
Thanks for the response.
I am trying to see a variable for today's date and then add a month to it to create another variable:
<cfset Variables.DateToday = Now()>
<cfset Variables.DateValReq = DateAdd("m", 1, variables.DateToday)>
However, my output comes out as the following:
Variables.DateToday shows up as...
Thanks - will give that a shot.
I do have a follow up...will I have to change this CFQUERY code if later if I upgrade this database to SQL server?
I do use the trim function and CFQUERYPARAM when I am inserting and updating records to eliminate padding and spaces...
Appreciate your feedback...
-See there is ">" after the selected tag...
-I have moved the cfoutput tags so they just nest the selected value.
-Even though it is not required, I added a closing option tag to each line.
Note the code above does not include the starting code for a select field, I forgot to inlcude it! :)...
Are you using the CFQUERYPARAM tag on your insert/update queries into the database?
BTW - where is the pound sign on the keyboard - I just looked and I could not find it.. (I am in the US) and should you not be using the EURO anyway? ;)
I found CF_paging V1.0
http://www.macromedia.com/cfusion/exchange/index.cfm#view=sn106&viewName=Exchange%20Search%20Details&loc=en_us&authorid=33575104&page=0&scrollPos=0&subcatid=0&snid=sn106&itemnumber=5&extid=1002938&catid=0
CF_PageList...
My example assumed that you had a database table of the states that you would then have to use a query to output the list. If you do not...just replace the "YourQueryState_List" portion of the code with the static state list.
I reread your post and it seems the above is what you want to do..
Actually it is quite easy.
Before you display the code run a CFQUERY that pulls the value of the record field and just place it in the html code that displays the selected value.
<tr>
<td>
State</td>
<td width="350"...
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.