|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| ||||||||||||||||||||||||||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
|
|
#1
December 14th, 2003, 02:59 PM
|
|||
|
|||
cold fusion help!!!!!!!!!!
I have problem mit cold fusion code
<CFQUERY NAME="get_movies" DATASOURCE="movies1"> SELECT * FROM movies WHERE ID = `#code` </CFQUERY> <HTML> <TITLE>Elvis Movies</TITLE> <CFOUTPUT QUERY="get_movies"> <B>Title:</B> #title# <P> <B>Year Released:</B> #year# <P> <B>My Rating:</B> #rating# <P> </CFOUTPUT> </HTML> Non stop i have this message Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. The error occurred in C:\Inetpub\wwwroot\CFIDE\index.cfm: line 3 1 : <CFQUERY NAME="get_movies" DATASOURCE="elvis1"> 2 : 3 : SELECT * FROM movies WHERE ID = `#code#` 4 : </CFQUERY> 5 : I use Access 2003 Please someone help me
|
|
#2
December 22nd, 2003, 02:13 PM
|
|||
|
|||
|
Are you sure ID is a string? You have '#code#', it will treat this as a string. If ID is a integer, try #code#.
|
|
| Viewing: Dev Articles Community Forums > Programming > Cold Fusion Development > cold fusion help!!!!!!!!!! |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
