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)

View Replies


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

Using RS.GetString

I learned from 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: 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 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
end if
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:

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

View Replies View Related

ASP Method

I have downloaded the DiscIDCalc program from CDDB. I've used it a lot because I've written my own application for my CD collections (keeping track of the track information of each CD, track duration etc). I've already got all my CDs into the application, I'm now just going through each of the disc again just to add in the DiscID information. I do it by running the DiscIDCalc program, generating the DiscID, and then then copying and pasting this DiscID into my application and then save it.
if anyone has successfully generated the DiscID within an asp page?
Now I have to have my browser up and this DiscIDCalc program up. Just want to know if there's a way to incorporate the two together (even if it means I'm not using the DiscIDCalc anymore.). This DiscIDCalc has a documentation for its DiscIDCalcDLL.dll but it's not something that I can CreateObject with, so I'm quite clueless... I don't want to use VB to write APIs for that

View Replies View Related

Using Get Method

I use query string to search for records by using GET method. This method will generate querystring automatically by using the form name. Using search field together with drop down is fine but the problem is when i didn't enter any keyword or left the search field blank it won't display any result.

Unless I put "%" in the search field. How do I make the querystring change to "%" whenever the field is blank so that all records will be displayed.

View Replies View Related


i am trying top update a field in my sql database but it wont let me??? does anyone know if my syntax is correct?? I have a field called userId in the database and want to replace it with my form request. Code:

View Replies View Related

Method Not Allowed

Method Not Allowed
The requested method POST is not allowed for the URL /Database/processForm.asp.

Apache/1.3.33 Server at Port 80

i just got this error, however, i have managed to post data into my database on this server b4, why is this error comin up now, could there be a prob with my asp file??

View Replies View Related

POST Method

Now this is a weird one. I'm having a problem with a system in development. When I post data from a form in IE 5.01 it works fine, but in IE 5.5 it refuses to post the data to the server and in IE 6 it's scatty -- works sometimes but not others. Anyone seen this before?
By the way -- this is normal VBS/ASP running on IIS 5 on an NT server

View Replies View Related

Redirect Method

can values of variables be transfered through response.redirect onto the next page

View Replies View Related

Post Method

I have a form that ignores my form validation code. My code works if I use the post method of <%=Request.ServerVariables("SCRIPT_NAME")%>.

But, If I post the form to another .asp page, which I prefer, the code doesn't work. Do anyone have any suggestions? Here's my code.

I have a form that ignores my form validation code. My code works if I use the post method of <%=Request.ServerVariables("SCRIPT_NAME")%>. But, If I post the form to another .asp page, which I prefer, the code doesn't work. Do anyone have any suggestions? Code:

View Replies View Related


I have a service provider that's sends sms messages from clients mobile
phones to my asp page, problem is I don't know how to show the data and they
are not being helpful.
The process is simple as outlined below (instructions from service provider

Example: If you provide this: then we
will do a post via a standard HTTP GET as follow:
How do I receive the url with the parameters in the address bar?

View Replies View Related

Email Method

I would like to know which method is best in ASP when using/coding for email via a form.

View Replies View Related

Best Method To Hide

What's the best method to hide, or not show a certain record when doing a pull from a database, as in I am pulling a list with a dozen category's and I don't what to show one of them.

View Replies View Related

ASP POST Method Bug

I have a demo.asp page, that can't pass hidden value "mr progrramer" to
itself using POST method. Only "mr" is passed.

I created a second asp file demo1.asp and passed "mr programmer" and whole
string (include space b/w mr and programmer was passed successfully).

The code for demo.asp is:

name = request.Form("name")
response.Write "hello " & request.Form("name")

' if name is empty then store some string with space in it
' problem is the word before space 'mr' is passed, but 'programer' is not
if len(name)=0 then
name = "mr programmer"
end if


View Replies View Related

POST Method

I have a .asp page that uses the post method and it works fine on my computer using iis. But when i put it on the web server (it has windows NT4) it wont work.

I've read that you have to do something to allow the post method on the server.

i know nothing about windows NT4 but can get access to the server. can someone please let me know what i have to do to get this to work?

Just to let you know the post method is for ssending a login and pass to another page that search a database for the record. If there is another way to do this that does not show the variables in the url please let me know. i am also willing to make it so that everything is on the same page so i dont have to pass anything.

View Replies View Related

Using The Find Method

Based on what the user selects in a combo box I need to find the value from another column in the same record. This is what I am using:

rsPrice.Find "Component='Desktop'"
If (rstPrice.BOF = True) or (rstPrice.EOF = True) Then
response.write("The Price for the Component Not Found")

curPrice =rsPrice("Score")
End If

I keep getting an error messages:

Microsoft OLE DB Provider for SQL Server (0x80040E29) Rowset does not support scrolling backward.

View Replies View Related

Renaming Method

I'm looking for a renaming method for folder objects.I have an ASP (JScript) application that I'm creating that acts as a document library. Users can upload files, create folders, etc.

Most places I go to basically have: copy, delete, move, create textfile as the only methods for the folder object - NOTHING about renaming.

View Replies View Related

ASP Update Method

The Folowing code is not working anymore.(500 error)

Set objRS = strSQL1.Execute
strSQL1 = "SELECT * FROM BannerRotor where BannerID=" & cstr(BannerID)
objRS.Open strSQL1, objConn , 2 , 3 , adCmdText
If not (objRS.BOF and objRS.EOF) Then
[ objRS.Fields("Exposures").Value =objRS.Fields("Exposures").Value + 1
End If

The .execute Method works fine

strSQL1 = "UPDATE BannerRotor SET Exposures=Exposures+1 WHERE BannerID=" & cstr(BannerID)
objConn.Execute strSQL1

W2003 + IIS6.0

View Replies View Related

Search Method

i have a search page script which consists of a text field and a pulldown menu. the search function using search text works but not the pulldown menu. do I have to set separate recordset for each of the search functions, one for the search using text field and another using pulldown menu?

View Replies View Related

Execute Method.

can i gain the two result. in an asp page which using a stored procedure with execute method.

i want to execute the query and return the count value the query at the same time. is it possible and how?must i use ado? it is not possible to make it with execute method in asp.

View Replies View Related

MapPath Method

I am coping a file from server to local on my computer using:

fso.CopyFile Server.MapPath("downloadworkfile.htm"), Server.MapPath("p:workingworkfile.htm"), true
I am getting MapPath method must be a virtual path. How do I reference a virtual path?

View Replies View Related

Post Method

Is there a limit to how many variables you can pass on using post method?

View Replies View Related

GetRows Method

When querying a database, I know I can fix the no. of returned rows/results to 20 (for example) using the GetString method:

myVar = objRs.GetString(, 20, , ,)

What syntax do I need to use to do the same with the GetRows method:

myVar = objRs.GetRows ?

View Replies View Related

Replace Method

I can see how this works, but can anyone clarify what purpose the 1, 1 serves?


strSearchKeywords = replace(strSearchKeywords, ",", "", 1, 1)

View Replies View Related

GET Or POST Method

when we should use GET method, when we should use POST method? GET method only sends limited amount of data, and it will show the data as part of URL. POST method won't show the data as part of URL, and can send any amount of data.

View Replies View Related

Get Method Maximum Len

the maximum size in car that i can send throught get method ?

View Replies View Related

Copyrights 2005-15, All rights reserved