Search results for query: *

Did anyone find an answer for this?

when cf displays a value above 1,000 it puts a comma in the number, when I try to take the value of the field, it says that it can't be read as a number. Do I have to parse the number and take the comma out? This should be an easy one for you. thanks snivern

ok sorry about this, but the values are getting passed, but the error message say Too Few Parameters, Expected 2 Don't know what that means but here is my query statement. SELECT * FROM custdatatbl WHERE custdatatbl.lastname = #form.lastname# and custdatatbl.firstname = #form.firstname# and...

nvm, I got it but different error message, something's wrong with the select statement i'll try to figure it out.

I guess I don't know what you mean by passing form variables. the form on the search page is named custsearchform. the value of the textbox where I am placing the results would be custsearchform.lastname. Sounds right to me. I guess I am not getting something. sorry, this is new to me. but...

does the <cfquery name=&quot;Userinfo&quot; datasource=&quot;Users&quot;> SELECT desiredsfields FROM &quot;Tablename&quot; WHERE firstname = #FORM.form.firstname# AND lastname = #form.lastname# AND Phone = #form.phone# </cfquery> have to be on the search page? Tried that and don't think that...

Sorry guys, I know this is probably elementary. The book I bought for coldfusion doesn't really explain much. I created a form that takes 3 values(lastname, firstname, and phonenumber). After the user enters that info and clicks the submit button, I would like the database to be queried for...

Here is all the code for the page <cfif IsDefined(&quot;FORM.textfield&quot;)> <cfset MM_redirectLoginSuccess=&quot;clientsearch.cfm&quot;> <cfset MM_redirectLoginFailed=&quot;no.cfm&quot;> <cfquery name=&quot;dbquery&quot; datasource=&quot;register&quot;> SELECT username,password FROM...

I've been trying for two days to get this to work. I let dreamweaver write the code for me. The username and password that I enter in is in the database. but it keeps sending to the loginfailed page that I created. It never goes the loginsucceeded page.