Search results for query: *

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?

I am running a query to pull some database records, but I want to avoid records that have an empty text field. So I was thinking of something like this: <CFQUERY> . . . . AND (Staff.MName <> '') </CFQUERY> but that did not seem to work - there is no space between my single quotes in the...

I want to display values from a currency field but without the zeros..any suggestions would be appreciated. For example instead of $75.00 I just want to disply $75

alsjka:When would the bit get updated? Would it be better to update the bit when the user updates the expire date? IMHO you might not need the bit field because you are running comparisons agains that expiry date - so if the record is renewed the expiry date would shift appropriately ahead. You...

alsjka hit the nail on the head. just do scheduled task for once a day and it shall do a direct comparison for every day.

Good suggestion Tek - another way could be is that set a value for a particular date (either exactly 30 or maybe 29 if you want to give a leeway of one day) and then send the email out only at that particular day - that way they get sent within the time limit you want but do not get sent every...