Using RS.GetString

I learned from 4guysfromrolla.com to use the GetString method to speed up displaying database query in an HTML table. After converting a sample page to using GetString, the biggest improvement was the HTML source code. Before it was spread into 4 pages; now it is only on one page. I think it works beautifully.However, I think GetString can only be used for simple generic tables. I have a customized table, and I would really like to use GetString to produce a long string instead of creating 500 tables. You can see the page here: http://pjshimmer.homeunix.com/ Those who have experience using GetString, can you tell me if my table is feasible to use this function? The reason I ask is I use different font for diff cells, and I also produce various cell background based on some information.

View Replies


ADVERTISEMENT

Getstring (mid)

i have a date eg. 9/1/04, 28/9/04 (format,d,m,y). how to i get the int for d, m & y? i try use
Response.write Right(String1,2) just only got the y.
Anybody could help me to get only the d & m because of the date or month not always in 2 number format(01 for 1)

View Replies View Related

GetString Method

When using ActiveX Combo Boxes, can you use the GetString method to populate the control? I currently am using AddItem, however, it is taking a long time to process. I know that GetString works well to improve the performance. Here is my code while using AddItem:

while not rsClient.EOF
Response.Write chr(9) & "MenuForm.lstClient.additem " & chr(34) & replace(rsClient.Fields("Client Name").value,chr(34),"'") & " [" & trim(rsClient.Fields("Client Number").Value) & "]" & chr(34) & chr(13)
rsClient.MoveNext

View Replies View Related

Getstring / Getrows

I know that getstring or getrows increase performance but my question when to use this method. This is because what I know is this method will output all fields in a table and not just certain few.

View Replies View Related

GetString Function

I need to be able to use an asp administration page. However I am getting errors when I add apostrophes (') or parenthesis is also returning errors. I have been shown a long time ago a small few lines of code that can by pass this problem, anybody know the code?

View Replies View Related

Getstring Really Slow

I'm connecting to an Access table with 100+ rows of data of approx 20 columns wide. I'm using getstring to "Quickly" display it in a table, but it's un-useably slow.

View Replies View Related

Process Getstring Data

i get data using getstring function. can i process this data using java script?

set rsShow = conn.Execute("SELECT league_E FROM Market M WHERE id=1113 ")
if not rsShow.eof then
aa=rsShow.getstring()
end if
rsShow.close
set rsShow=nothing

View Replies View Related

Reading CSV Into Recordset Using GetString

I'm experiencing a little difficulty and having to resort to a work around.
I already found one bug, although stated the bug was only in ODBC, which I'm
not using. It appears to be in the OLEDB driver also. Code:

View Replies View Related

Request.querystring Or Recordset.GetString?

I can successfully get one field of information at a time and randomize it, but I need the whole string. I've been searching the internet trying to find an answer to this question and I found these two commands Request.querystring and Recordset.GetString, but I
don't think I know how to use them properly. Code:

View Replies View Related

Reading CSV Into Recordset Using GetString - Msdn Account

I have two(2) issues.

I'm experiencing a little difficulty and having to resort to a work around.
I already found one bug, although stated the bug was only in ODBC, which I'm
not using. It appears to be in the OLEDB driver also.

My connection was:
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strPath & ";" &
"Extended Properties='Text;HDR=NO;FMT=Delimited'"

I got information from here:
http://msdn.microsoft.com/library/d...ing03092004.asp

I am using a schema.ini file and in it was:Code:

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved