Search results for query: *

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

Sorry just to update, I use the word top but really mean the Highest Bid. And when i said either query, i mean the first one i posted yesterday or the second one that i posted today..

Hi Thanks for your help. I need to find the highest Bid for each Car. A number of bids would be placed on a particular car so then i need to find out the winning bid that was placed on each car. Hope that makes sense.. I have another query looking at the Car end of things searching for the...

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

hi Thats why i mentioned the MS Access Unicode datasourse I have other websites that use this exact same code and works no problem, it's just this database has to have Access with Unicode to solve a character set problem.

This is the code: <cfoutput> UPDATE #form.tname# SET title = '#FORM.title#', content = '#FORM.content#', timestmp = #CreateODBCDateTime(Now())#, modBy = '#SESSION.userdet#' WHERE id = #FORM.id# </cfoutput> This is what is displayed when run: _________________________________ UPDATE...

Hi When you say initialize do you mean this <cfparam name="#form.tname#" default="">? My Datasource is MS Access with Unicode becuase i have a character set problem when i use MS Access in Coldfusion. From the Coldfusion Documentaion it says "Inserts and updates fail with the error "The field...

I changed the query slightly to this: <CFQUERY NAME="updateText" DATASOURCE="#APPLICATION.dsn#" MAXROWS="1"> UPDATE #form.tname# SET title = '#FORM.title#', content = '#FORM.content#', timestmp = #CreateODBCDateTime(Now())#, modBy = '#SESSION.userdet#' WHERE id = #FORM.id# </CFQUERY> Now...

Hi Tried CFOUTPUT and doesnt give the error i have been getting but the data i insert is not updated in the database?

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

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

The Data Type is Yes/No in the access database

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

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

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