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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by cf59102

  1. cf59102

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

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

    Simple Now () stumble...

    no am not - just outputting the dates!!
  4. cf59102

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

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

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

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

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

    Navigate via (First | &lt; Prev | Next &gt; | Last)

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

    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? ;)
  11. cf59102

    Navigate via (First | &lt; Prev | Next &gt; | 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...
  12. cf59102

    Navigate via (First | &lt; Prev | Next &gt; | Last)

    Have you checked the Macromedia exchange for such display codes?
  13. cf59102

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

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

    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?

Part and Inventory Search

Back
Top