Got 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
I am trying to modify the code in an existing ASP page that displays records when it runs. The code in the where clause I wish to change is as follows:
where_clause = where_clause & "[DateWOCancelled] Is Null And IsNull([ACT_IS]) And ([PROP_IS] < Now())"
This works fine, but I need to have the clause also evaluate another field (Rev_IS) to see if it contains a date, and if it does check to see if it is < Now(). If the Rev_IS is not null, I don't care any longer about the date contained in Prop_IS. I only want to evaluate if Rev_IS < Now().
I'm starting in asp and I'm trying to do a simple sql query to display a number of records on a page using the limit clause. I keep getting a syntax error in my from clause. Here's what I'm doing:Code:
rstProd.Source = "SELECT * from TBL_PRODUITS LIMIT 0,10"
I have no problem using this clause with PHP so I was wondering if there's some restrictions with it in ASP??
I am using the DateDiff function to compare two dates in a query on a page. I then need to use the "Expression" created from that DateDiff function in a WHERE clause calculation, but it is not working correctly.
The page loads successfully with thre recordset populated, but the WHERE clause has no effect on the data. I'm guessing that I am doing something very wrong, but I have been staring at this for hours with no avail!
I am trying to connect Flash with ASP. I did few examples successfully, but I am stack on this one and I get error from the sql statement. I dont see anything wrong with it. The code is:
set conn = Server.CreateObject("ADODB.Connection") conn.ConnectionString = "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("example.mdb") conn.Open set record = Server.CreateObject("ADODB.Recordset") query = "SELECT * from TABLE WHERE NAME= " &action1 record.Open query, conn
The error which I get is: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.
When I create a ADODB.RecordSet object and then try to loop through the results, everything works fine, unless when I am done looping through the results I need to call the movefirst on the recordset object. If I happen to have used an ORDER BY in my SQL, it bombs out. Code:
I am trying to design a page that displays data from a query in groups of a field in the where clause and then displays a 'total' per each group. Code:
i got a field named register_date, its input a table named member when a user register in my system, What im trying to do is i want to display daily registration in seperate table, anyway the database im using is mdb file, and data type for register_date is data/time.
so below is my coding, but i can get the table to be displayed, can someone tell me what wrong with my coding? Code:
I have created the following code to create the recordset rsToBeApprovedLocalItemID. Unfortunately, the for next loop works properly only on the first cycle. The response.write(arrToBeApprovedCatSub(0)&arrToBeApprovedCatSub(1)&"<br>")works for each loop but the SQL statement sqlToBeApprovedLocalItemID returns a populated recordset only on the first loop.
On subsequent loops it is empty even though the arrToBeApprovedCatSub(0) and arrToBeApprovedCatSub(1) are alive and well. What's going on? This is truly weird behaviour. I have not come across something this funky before. 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?
when 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?
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.
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.
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 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
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.
does 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.
