I have an ASP script, which pulls user input from a form and I need to query my Access 2000 database. I'm using FrontPage 2000 for development and my site server has the FrontPage Extensions installed.
Here's my question. Are you limited to a single SQL query to return a recordset or is it...
Hi, unseth.
Your suggestion works perfectly! I can't believe that this isn't documented in my FrontPage, ASP or SQL manuals. I did find it in my VB manual and , since this is my first ASP project, didn't think to look their.
Thanks, again.
Size is the field name in the form that I am collecting user input from.
In addition to the two examples on my original message, I have tried the following with no luck.
...AND Size LIKE '%::" & Request.Form("Size") & "::%')"
...AND Size LIKE '%" &...
I have a database with a size field in it. That field contains both the single-quote (') and the pound sign (#). I have a search form set up and it works properly with one exception. Whenever I use the # sign, it appears that the query doesn't recognize it. No error is generated and no...
Thanks to everyone who responded. Here's the solution. Substitute the HTML equivalent for both a space and carriage return.
Here's what the original and final code looks like, should someone in the future have the same problem:
Original
<tr>
<td width="100%"><font...
I tried adding a scrolling textbox to my confimation page. The data is still 'stripped' when it loads into this new textbox. The solution, I think, has to do with passing the original data to the server.
I have a textbox on an ASP page, which is filled by a series of user queries. Once my customer is ready, he can display all of the query results in a single scrolling textbox. He can also edit the results of that textbox. The data layout within the textbox is in table form and Courier New is...
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.