Here try this statement below copy and paste it and it will work.... But only if accunumber is not a string made by concatenating pyy, pmm and pui....
"Select
accnumber
from
tbl
Where
accnumber like '%" pyy & pmm & "%'"
& "and initials =...
you need a conditional module to check for the existence of certain search criteria and then build the SQL statement to run it based on that...
example
==>any word or any phrase:
WHERE strSearchCriteria LIKE '%strAny_Word_or_Phrase%'
==>exact word or phrase:
WHERE strSearchCriteria =...
You can also try this:
your_variable = Trim(Replace(your_variable,chr(39),"’"))
I'm assuming you are displaying the data in a browser once you've pulled it out from the database.
By the way if it doesn't show up right in this message board the value that you replace the apostrophy...
add a submit button to the form that when clicked submits the form to itself.
use the info typed by the user to run a SELECT statement against the database that will grab the matching info if any from the database and then run a loop to populate the drop down with the data you retrieve.
example...
Why don't you try and run a select statement against the database and grab the info you just added to it, in the page the user is redirected to.
OR
You can store the values the customer entered that were sent to the database in variables and then use those variables to build a querystring you...
Here is a suggestion.
<SELECT name="location">
<OPTION>-Select a Location-</OPTION>
<%
Do While Not RSEmps.EOF
Response.Write "<OPTION value=" & RSEmps("intLocationID") & ">"
Response.Write RSEmps("location")
Response.Write...
Correction to the error I made :)
I would like to know how to populate a table with the contents of a 2 field table in SQL. The way that I thought would work isn't.... Anyway here is the code I wrote to do it....
<%
Do While Not objRS.EOF
Response.Write "<TR>" & VBCRLF & "<TD...
I would like to know how to populate a table with the contents of a 2 field table in SQL. The way that I thought would work isn't.... Anyway here is the code I wrote to do it....
<%
Do While Not objRS.EOF
Response.Write "<TR>" & VBCRLF & "<TD width=% align=center valign=middle...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.