Recent content by cf59102

I am trying to paint a white color over another layer - but it does not show up! Any suggestions would help.

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.

no am not - just outputting the dates!!

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! :)...

<cfoutput><OPTION VALUE="#YourQueryName.Field_State#" SELECTED>#YourQueryName.Field_State#'</cfoutput> <option value='Alabama'>Alabama</option> <option value='Nevada'>Nevada</option> <option value='Wyoming'>Wyoming</SELECT>

wait I think I got my code to you wrong it is my HTML set up is wrong.

Sorry they did not work for you....:(

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...

Have you checked the Macromedia exchange for such display codes?

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"...

do you want to display the selected field in the database record as the default option when they go back to update their record?