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
It's been a long time since I've needed any help with something, so I'm happy to come back and feel dumb again. I need to learn how to process XML data and generate pages driven from that data. I know the structure of the documents, I just need to grab the data from inside certain XML elements of the XML documents.
Can someone explain this or post a link to a good site? I've tried googling, but everything I find seems to explain how to print back the XML in HTML format.
How to send data through winhttpd and process the data in the target page?
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)
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 View RelatedWhen 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
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 RelatedI 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 RelatedI'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 RelatedI'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:
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:
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:
I'm a complete newbie to IIs and ASP (come from the Apache/Cold Fusion
world ). I've created a very simple ASP test page:
<%@ Language=VBScript %>
<% Response.Write "This is a test ASP page." %>
But when I access the page, it just displays the page as text, instead
of processing the ASP. I've looked at a half-dozen Microsoft KB
articles, but still no luck. I'm not getting an error, it's just not
processing.
I m facing a problem in ASP. That is on the production machine when I deploy my product at that time it dosenot perform a particular process. But on my devlopment machine it runs perfectly fine.
The only difference which lies is that on my devlopment machine in security tab of wwwroot/(website) a security permission with the name of VS Devlopers(machineVS Devlopers) exist but on the production machine it dosenot. What could be the possible problem.
Making good old fashioned asp page and need to be able to display the IIS COM+ process id's (i.e. those that show up when attaching to a process in InterDev(in debug/processes dialog box).
Is there a way to get these process id's show up in an asp page? You can tell I'm not to saavy when it comes to working my way around the WindowsAPI.
Just like to know if I am correct and no problems in this scenario:
I have page where the user clicks a button to save some information >>
gets directed to page 2 where a value gets returned from a recordset and the form is inserted automatically upon loading with the value (sequential for the database table) >>
the user then gets redirected to page 3 upon insertion into the database, if I use 'Select Top 1 ......' as a query to retrieve some information on this page am I sure that this is the correct record just inserted even if 2 or more people are saving at the same time?
i have to start a batch process from a dll to transfer
files created by this dll to remote ftp server. I created
a batch file:
ftp -n -v -i -s:D:atchftpcmds.txt ftp-server
and a file containing the ftp commands:
user username password
lcd D:atchmedia
mput *.*
quit
It works pefectly when i start it from the dosbox. But
when i call it from the vb dll implemented in IIS (shell
("D:atch ransfer.bat")), it does not complete the
transfer and hangs after 400-500 (small) files.
I need to select a csv file from my desktop through the "Browse.." button in my ASP page and upload the file and do further interrogation and extract the data to put into a database. What I'm struggling with is more the first parts with getting the file read properly in the second page so I can read and insert the data.The data below
describes the file. Quite a simple format.
Customer ID - Additional values are player IDs
193948294, 293, 294, 296, 290, 292
if it is possible to run a process after page has loaded? reason being is i have an application that uploads a file, then zip's it up. These are 50 megs sometimes, so zipping the file can take some time. It is a two stage process though, a user will upload a file, then fill out some more info, then submit, so while the user is filling out more info, I'd like to start zipping the file. Does anyone know if that is possible? and if so how to do it?
View Replies View Relatedwhen i call for a asp page i c some process still running in the status bar. but when i click on the same link again, i could not find the process. it happens alternatevely.why is this happening? how to prevent?
View Replies View RelatedGot a bit of code, which I want to loop through, unless the current value is "", in which case I need it to skip to the next one, but how do I do it?
Response.Write "<br />" & vbCrLf
For Each strItem In Request.Form
If strItem = "" THEN
'these next two lines, I only want to be processed if the above does
have a value in it
Response.Write "-" & strItem & "-" & vbCrLf
Response.Write "-" & Request.Form(strItem) & "<br />" & vbCrLf
End If
Next
Response.Write "<br />" & vbCrLf
Anybody have idea about Image processing tools available for ASP (like Imagemagick,I dont think ImageMagick will work with ASP).
I want to adjust the images uploaded to my site(ASP) to a particular resolution and do some image resolution changes, like creating thumbnails from originally uploaded images,etc..
I have created 2 tables on my db. one is for customers and one for corporate. this is to distinguish the records so that we wont mix up our clients. i have created a login page for both customer and corporate. however, i think there is something wrong with the login process code which process the login for users to our page. there is an error message:Error Type:
Provider (0x80020005)
Type mismatch.
(see highlight in red) for attached code.i am not sure if its correct but here is the code as attached
<%
Response.Buffer = True
strUserName = Request.Form("User_Name")
strPassword = Request.Form("User_Password")
Dim rs
Dim sqlStr
Dim record_found
record_found = 0
Dim vPath, pPath, ConString
vPath = "xxxxx.mdb" 'use this one if database is in root of cart folder
pPath = Server.MapPath( vPath )
ConString = "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=" & pPath & ";" & "JET OLEDB:"
Dim Conn, rsCatalog
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open ConString
sqlStr1 = "SELECT * from Customer WHERE User_Name = '" & strUserName & "' AND User_Password = '" & strPassword & "'"
sqlStr2 = "SELECT * from Corporate WHERE User_Name = '" & strUserName & "' AND User_Password = '" & strPassword & "'"
set rs = Server.CreateObject ("ADODB.Recordset")
adOpenStatic = 3
rs.CursorType = adOpenStatic
rs.Open sqlStr1, sqlStr2, conn
If (rs.RecordCount <= 0) Then
Response.Redirect("login.asp?from=no_record")
Else
record_found = 1
Response.Cookies("User_Name") = rs("User_Name")
Response.Cookies("User_Password") = rs("User_Password")
Response.Cookies("Login") = 1
Response.Cookies("View_Cart") = 0
End If
rs.Close
Set rs = Nothing
if record_found = 1 then
if Request.Form("hiddenVal") = "view_cart" then
Response.Redirect("view_cart.asp")
else
Response.Redirect("default.asp")
end if
end if
%>
I have few asp pages, which they get the information from a SQL server, while calling these pages, due to amount of data, sometimes it takes 10-15 seconds for loading the page.During this loading time I want to show the users something like a process bar so that the user is not left out with a blank page.
if anyone can guide me, how to show this process bar before completing the load process.
My asp.net code doesn't get executed by IIS. My file is
saved with .aspx extension. When i do a view source, all
the vb code is displayed. This shouldn't be visible if
the server is processing the code. How do i get IIS to
process my vb code is my .aspx files?
I'm developing an intranet application using W2k server and IE5.5 - 6.x
clients. I've got one particular function that calls a stored procedure to
update a number of records, depending on user input. The problem we have
run into is that this procedure can take a few minutes to complete in
certain circumstances, and of course IIS times out.
I've been doing some searching for a solution, but most of the answers I've
found relate to showing a 'Please wait' message while processing the page,
which doesn't help in this situation. The others I've found relate to using
MSMQ, which would probably help, but leads to a load of testing issues that
I'm not prepared to deal with at the moment.
Are there any other 'common' ways to handle this at the ASP level?
I am using Win2k, IIS 5 and vbscript as well as asp.
I want to run an asp page that creates a PDF (using a third party ASPPDF dll) as a background process to free up the main website as it takes about 3-4 minutes to render the PDF.
Any ideas on how to do this or where to look?
I'd like to process HTML documents in an ASP script, i.e. to remove any unwanted
elements and extract desired element and attributes. I know how to do it on
client side within IE using its HTML DOM. But what I'd like is to do it
server-side. Is there a way, for instance, to reuse MSIE technology to retrieve
interfaces like IHTMLElement, IHTMLDOMAttribute, aso, or just built-in features
that would allow me to do the same?
The asp script uses the WSHSHELL run method to launch a local application on the web server but The application process hangs each time when this is called from the web.
If the application is manually run from the command line or through a bat script (by double clicking on it), the application process launches and executes the batch file successfully.
If either of these actions are called from the .asp script, the application process.exe is seen running in the task manager and hangs.
i've recently done a basic website offline and haven't uploaded or found a host server yet. however i was wondering if there is a way to process the form input offline. I was told i need ASP functionality. but i'm not too familiar with it.
View Replies View Relateddoes anyone know of a way to check if a process is running on the server... using asp ? I basically have an html form and upon submittal of the form ... i would like to redirect to the response page when a certain process is no longer running . the logic is as follows Code:
1) user enters form values and clicks submit button
2) server side asp checks the server for a process "wpuba.exe"
3) if "wpuba.exe" is not running .. redirect to page2.asp
basically I want to wait for the "wpuba.exe" process to terminate before redirecting to the response page.
is there an industry standard method of costing out a project the problem i have is that when talking to a developer they say "i dont know how long it will take" which just isnt acceptable.
View Replies View RelatedWindows 2000 Adv Svr (SP4). .NET Fwk 1.1, .NET Fwk 1.0
(SP2), CMS2002 (SP1) and Commerce Server 2002 (SP2)(MSIB2.1).
Have noticed recently that the asp_net worker process runs at 70 - 80% CPU. Normally it runs at about 10 - 15%. A reboot clears this but then it creeps up again?