Thanks for your reply Jared.
There are several reasons I suggested using a local variable instead of the recordset object:
1. he had already created local variable "c" in his code ( c = rs("Name") )
2. local variables are much lighter than recordset objects (less overhead). Accessing the value of a local variable is much faster than accessing the data in an object. If you need to access that...
azrar
Last Activity: Feb 28 '11, 10:48 PM
Joined: Nov 5 '08
Location: Montreal, QC, Canada
-
I haven't tried ADC Cure: ISP Session, but the fact that their support forums returns a 500 error is not a good sign.
Session.Timeout does not work?Leave a comment:
-
That isn't an ASP question, it's an HTML question.
Constrain only one dimension (width or height) and the other will automatically adjust itself to honor the aspect ratio.Leave a comment:
-
I recommend reading up on XPath so you know how to target the data you want in an XML file.
http://www.w3schools.com/XPath/default.asp
Here's an example of how to implement xpath in ASP:
...Code:<% set xmlDoc = Server.CreateObject("Microsoft.XMLDOM") xmlDoc.async = False xmlDoc.LoadXML xml_data set nodes = xmlDoc.selectNodes("/products/product[@id='5063441']")Leave a comment:
-
Assuming you are creating a menu with multiple links
There are two ways you can do it.
First way is completely ASP:...Code:' assuming you are already displaying the category based on a value in the querystring current_cat_id = request.QueryString("cat") DO WHILE NOT rsLinks.eof cat_id = rs("cat_id").value cat_title = rs("cat_title").valueLeave a comment:
-
split()
Given the line:
"84016","Bags", "Belkin iPod Nano Remix Acrylcase black","19","Ye s","0.1","F8Z38 1EA"
You can make array out of the data like this:
The first and last element will have an extra quote in it. You can avoid that by tweaking the code...Code:myArray = Split(csv_data,Chr(34) & "," & Chr(34))
Leave a comment:
-
The problem is that you did not put quotation marks around the value attribute of the input.
Suggestion: use the local variable you created "c" instead of the recordset object.Code:<input type="text" name="T2" value="<%=rs("Name")%>" size="37" readonly style="position: relative">
...Code:<input type="text" name="T2"
Leave a comment:
-
Never pass messages in the POST or GET. For example, never have a page where the URL is something like
mysite.com/register.asp?ms g=please+enter+ your+email
..and then display the msg parameter in the QueryString in your HTML page.
Rather, have keep your QueryString paramaters coded, something like:
mysite.com/register.asp?ms g=email
or:
mysite.com/register.asp?ms g=23...Leave a comment:
-
It is not possible to save images from an external site onto your local server using ASP.Leave a comment:
-
use instr
Try something like this:
...Code:start_pos = Instr(1, csv_data, vbCrLf & Chr(34) & "84016") If start_pos > 0 Then '-- find the end of the line end_pos = Instr(start_pos + 2, csv_data, vbCrLf) '-- extract that one line based on start and end positions onerow = Mid(csv_data, start_pos, end_pos - start_pos) Else '-- the searched data does
Leave a comment:
-
Use javascript at the bottom of your page, something like this:
<script type="text/javascript">
document.form.s tate.value = "<%=state%> ";
//etc..
</script>Leave a comment:
No activity results to display
Leave a comment: