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!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Access Query - Too Few Parameters Error Expected 1
normally in SQL when you are trying to compare strings you will use: '%Entity%' With the '%' being the wildcard and not a '*'. Try that, see how you go. -
Can't get rid of this error.. tried everything :/ Err&Code included,
<A HREF="dlmagicview.cfm?&ItemID=#ItemID#">#ItemName#</A><BR> there is an & in the URL that shouldn't be there... -
HELP W/ QUERY!
The parameter Program.email is used only in the query and not outside of the CFQUERY tags. To refer to a parameter being extracted by a query you must use CFQUERYNAME.PARAMETER below I've changed the code you've submitted, assigning the values extracted from the query to variables within the...
