Answered
query prob
Having a little beginners bad-luck with the following code;
<html>
<head>
<cfparam name="lastname" type="string">
<cfquery name="GetIndiv" datasource="AS400" username="quser" password="quser" dbtype="odbc">
select ISLNAM from istatic
where ISLNAM = #ucase(lastname)#
</cfquery>
<cfif GetIndiv.recordcount is 0>
<cfoutput> <br> Invalid user ID or password <br> </cfoutput>
<cfelse>
<cfoutput> <br> query="GetIndiv" <br> </cfoutput>
</cfif>
</head>
</html>
If the value of lastname is "Smith", then I get an error saying that Smith is not a column name.
<html>
<head>
<cfparam name="lastname" type="string">
<cfquery name="GetIndiv" datasource="AS400" username="quser" password="quser" dbtype="odbc">
select ISLNAM from istatic
where ISLNAM = #ucase(lastname)#
</cfquery>
<cfif GetIndiv.recordcount is 0>
<cfoutput> <br> Invalid user ID or password <br> </cfoutput>
<cfelse>
<cfoutput> <br> query="GetIndiv" <br> </cfoutput>
</cfif>
</head>
</html>
If the value of lastname is "Smith", then I get an error saying that Smith is not a column name.
AdChoices