Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsGeneralPHPASPPerlColdFusionFlashHTML, CSS, ScriptsBrowsers

Webmaster Forum / ColdFusion / Getting Started / October 2004



Tip: Looking for answers? Try searching our database.

Help with SQL & form

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Greggg - 26 Oct 2004 21:29 GMT
Hi,

I can't get this right, would appreciate help. Thank You.

     <form action="page3.cfm" method="post">
       <input name="hidden#num#" type="hidden" value="#num#">
                        </form>
I'm trying to get an image name that matches the value of the form, here's
what I have but it's not working.

<cfquery name="getBigPic" datasource="shalmy2">
SELECT       num,
     'imageName',
      folderNum     
FROM imageNames
WHERE num = #FORM["hidden" & num]#
</cfquery>

Thanks again,
Greg Smith
NateNielsen - 27 Oct 2004 03:39 GMT
hows this work :

<cfquery name="getBigPic" datasource="shalmy2">
SELECT num,
'imageName',
folderNum
FROM imageNames
WHERE num = #evaluate("FORM.hidden#num#")#
</cfquery>

Nate Nielsen
http://www.webclarity.com
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.