Link to home
Start Free TrialLog in
Avatar of gregoryrsmith
gregoryrsmith

asked on

help <a href="scenes25.cfm?folderNum=#FORM.number#"> work

Hi,

I'm trying to pass a form variable via the URL and retrieve with this query

<cfquery name="getFolderNumber" datasource="xxx">
SELECT folderNum
FROM imageNames
WHERE folderNum = #URL.folderNum#
</cfquery>
ASKER CERTIFIED SOLUTION
Avatar of sigmacon
sigmacon

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Tacobell777
Tacobell777

And make sure its an integer, if its a string you will need quotes around the value, i.e.

<cfquery name="getFolderNumber" datasource="xxx">
SELECT folderNum
FROM imageNames
WHERE folderNum = '#URL.folderNum#'
</cfquery>

But it would help to see some error message to solve your problems...
just a question why are u sending a form variable in the url, if u submit the form u will always get it in the processing page
kindly be more elaborate on your problem

Regards
Hart
You could also change the form to get instead of post and it will automatically go in the URL.