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!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jenmerr
  • Content: Threads
  • Order by date
  1. jenmerr

    SEO Friendly & Human Readable URLs

    I am looking to change a Coldfusion Dymnaic URL to a SEO Friendly / Human Readable URL. The URL looks like this at the moment: www.mywebsite.com/index.cfm?area=content&action=contentselect&menuid=1 I would like it to be more like www.mywebsite.com/aboutus Not sure what is the best way to...
  2. jenmerr

    Query to Select the Top Value

    Hi I need some help in writing a query to select the top bit for each car in a query. The code that i have so far selects the top value but wont return each car. <cfquery name="qBidSelect1" datasource="#request.dsName#"> select top 1 Bid.Bid, Bid.CustomerID , Bid.TenderID ...
  3. jenmerr

    Error in Updating Query

    Hi I am getting this error message below from this code: <CFQUERY NAME="updateText" DATASOURCE="#APPLICATION.dsn#" USERNAME="#APPLICATION.DB_UserName#" PASSWORD="#APPLICATION.DB_Password#" MAXROWS="1"> UPDATE #FORM.tName# SET Title = '#FORM.Title#', Content = '#FORM.content#', timeStmp =...
  4. jenmerr

    Missing argument name?

    HI I am getting this error below. I changed the datasource of the access database to be MS Access with Unicode because of a character set problem. Before i did this the page ran without any errors. Is there a different way of programming the below? Missing argument name. When using named...
  5. jenmerr

    SQL syntax for access

    Hi I am using Coldfusion with MS Access. The it's datasource is running on a setting called Access with Unicode. The code that runs perfectly in MS Access will not run under the new setting MS Access with Unicode. Here is an example <CFQUERY NAME="getMenu3" DATASOURCE="#APPLICATION.DSN#">...
  6. jenmerr

    SQL and Coldfusion - sql syntax for access

    Hi I am using Coldfusion with MS Access. The it's datasource is running on a setting called Access with Unicode. The code that runs perfectly in MS Access will not run under the new setting MS Access with Unicode. Here is an example <CFQUERY NAME="getMenu3" DATASOURCE="#APPLICATION.DSN#">...
  7. jenmerr

    Using Checkboxes and seaching through the results

    I have an enquiry form with a list of check boxes. In my search page it lists enquires that have been made. If a person select two or more it wont loop through the list and bring back the ones that were selected. Tried a number of queries and it starts returning nothing.. It will return the...

Part and Inventory Search

Back
Top