Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
add one color over another
I am trying to paint a white color over another layer - but it does not show up! Any suggestions would help.- cf59102
- Thread
- Replies: 0
- Forum: Corel: Painter
-
Simple Now () stumble...
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. -
-
Simple Now () stumble...
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... -
SQL to avoid empty text field in access
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... -
Selecting a list item - Filling in a form from stored data in DB
-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! :)... -
Selecting a list item - Filling in a form from stored data in DB
<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> -
Selecting a list item - Filling in a form from stored data in DB
wait I think I got my code to you wrong it is my HTML set up is wrong. -
Navigate via (First | < Prev | Next > | Last)
Sorry they did not work for you....:( -
a weird little r instead on my £
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? ;) -
Navigate via (First | < Prev | Next > | Last)
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... -
Navigate via (First | < Prev | Next > | Last)
Have you checked the Macromedia exchange for such display codes? -
Selecting a list item - Filling in a form from stored data in DB
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. -
Selecting a list item - Filling in a form from stored data in DB
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"... -
Selecting a list item - Filling in a form from stored data in DB
do you want to display the selected field in the database record as the default option when they go back to update their record? -
SQL to avoid empty text field in access
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... -
currency without zeros
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 -
Email notification
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... -
Email notification
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. -
Email notification
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...
