if i wanted to split the below SQL statement on two lines, what would the syntax be.... SQL = "UPDATE gallery WHERE g_id = " & Request.Form("g_id") & "SET g_name = " & Request.Form("g_name") & "g_add...more >>

Hi, I'm relatively clueless when it comes to correct ASP syntax. I'm testing out a search form for my company's website which is done in ASP. The results are displayed as per the code shown at the very bottom of this message. All I want to do is add a target="top" to the URL which is displayed...more >>

Hello, <%@ Language=VBScript %> <% Dim shipment_db Dim shipmentTable Set shipment_db = Server.CreateObject("ADODB.Connection") Set shipmentTable = shipment_db.Execute("SELECT * FROM shipment") Response.Write shipmentTable.RecordSetCount 'This line is error %> But this program can't cou...more >>

Hello All, In case the subject wasn't completely clear, I just upgraded to Windows XP Pro from Windows 2000 Pro. All my ASP stuff seems to work, except that when an ASP page generates an error, and the Error handling is set to "On Error Goto 0" the page just stops, as if I typed a response....more >>

Experimenting with response.flush() but can't seem to get it to work. This code <% response.write "<p>started</p>" response.flush() for i = 1 to 10000000 i = i +1 next response.write "<p>ended</p>" %> Should it not write started to the screen straight away and then a couple of seconds lat...more >>

Does ASP provide weblog functionality? For example, I want to collect the statistics of every page in the home page, how people access the pages, etc... In C:\WINNT\system32\LogFiles\W3SVC1, it has collections of web log file. I guess we can parse the file and do the analysis?? ...more >>

Hi, I'd like to adapt the query below to select records only if the Title field contains the string "Book" (as an example). I'd also like to use a different variant of the query elsewhere to select all records where the Title field does not contain the string "Book". I know my question s...more >>

I'm trying to do this: Set fso = CreateObject("Scripting.FileSystemObject") Set file = fso.CreateTextFile("C:\Program Files\Test\Uploads\res.xml", true) file.WriteLine(res.xml) file.Close() but in IE I only can see progress (in status) bar which never ends and never save anything...more >>

how can I format date that always return in fixed width. for example.. if the date is 1st jan, 2003.. it should return 01/01/2003 not 1/1/2003 i need date format always in 10 characters... thanx in advance.. dave ...more >>

If I want to show the current temperature in my web site, I will get the information from http://www.weather.com I heard someone told me to use Server.CreateObject("InetCtrl.Inet"). I am not sure if that object exists, since I couldn't search it. Any ideas?? ...more >>

Hi I try to get a simple calendar composant. Someone get it ? FV ...more >>

I want to know if we need id attribute? Or just name attribute is fine? For example: Name: <input type="text" id="text" name="fname"> ...more >>

Hi, I am trying to build an "in between" page to show an animated "Working.." gif while a long process runs on the server via ASP. The problem is that the table/gif is not displaying when I load the inbetween page.. This is my code snippet: Updating Room Type #<%=setRoomTypes.F...more >>

Hello, <%@ Language=VBScript %> <% dim a dim b a=11 b="11" if a=b then Response.Write "a=b" end if %> But can't shows "a=b".How can changes variable type? Thank you ...more >>

Hi everybody.... Here's a question for you. I think the answer is simple, but I'm not sure how to go about it...what I want to do is to break down a string into components. I already know about the LEFT, MID, and RIGHT properties, but I don't believe they'll work in this case. Anyway: I ...more >>

Hi I am looking for a good quality shopping cart that's free and open source. I have searched aspin.com and hotscripts.com but the only free ones I saw were pretty simple. I am looking for something like OSCommerce for PHP. John...more >>

Hi All I am having problem of content expiration it expires immidiately. Real problem is I am replacing some images on mouse over. On every mouse over its downloading images from server that takes time to display, and second thing is its working fine with same aaplication on server1 but when...more >>

We have an ASP.Net application that is being stored on a file share seperate from the IIS server machine. The application has been designed to use NT authentication (via User.Identity.Name) to control user access and security We have IIS configured to list the site as a virtual directory under t...more >>

The following code is try to validate if the user selects a radio button choice. I dont understand why document.UserInputs.question.value; gets undefined value even user make a choice. I tried text box and drop down list, and it works fine. <html> <head> <script type="text/javascript"> f...more >>

How do I request the actual page name that I'm on? This is going to go into an include file, and depending on which page I'm on, I'd like to do different things. I'm looking for "pagename.asp" ...more >>

Hello I do not know anything about asb but I just want to import this part of VBscript file to an asp code to help my frined. This part of code is working if I run it as a vbscript on the command line, but we could not get it run in a asb files. MyODBC = "SQLODBC MyUsername = "sa MyPassword = ...more >>

Is there a prepackaged query.asp for IIS 5.0 and windows 2000? If so, where can I find a copy? ...more >>

Hello, I am trying to create vanity URLs (I think that's what they are called) that link directly to an item's listing page on my site. Currently, the urls are set up something like the following: http://www.mydomain.com/productinfo.asp?prodID=00000 I am trying to configure them to be so...more >>

Hi All I am using Request.ServerVariables("HTTP_REFERER") to refer back in some pages but on clint side some pages refered back and some show error page not found. I dont know whats wrong with code. retstr = Request.ServerVariables("HTTP_REFERER") if instr(1,ucase(retstr),"STEPPAGE") > 0...more >>

Is there any limitation on how many file dsn can I use per IIS Server? ...more >>

First off I do not know alot about writing queries to an Access Database from an ASP page. This is why I need help. I have an Events database for 6 colleges in our metro area. On the homepage I have to display the next event for each college. That would give me 6 events listed on the page. I h...more >>

Hi, I have a form that allows you to do search, for each record found it populates the form fields with the data from the database and creates page sets for next and previous, now for the stange part, when the first record appears if i press update the values are passed no problem, however i...more >>

I have a form that has checkboxes. I would like when the user clicks the process button the next page will display the value of the boxes that were checked. ...more >>

Hi, Can anyone suggest a 3rd party tool to allow web developers to view/modify file based databases (like Access) over the web. I've found loads of HTML/Browser/RDS based ones, but are their any client side EXE kinds? -- Mike Collier BSc( Hons) Comp Sci http://www.adoanywhere.com/forum...more >>

hi, when i want to do an action to the database i am using the command Set myConn = Server.CreateObject("ADODB.Connection") myConn.Open = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("photoalbum.mdb") & "" Set RS1 = myConn.Execute(SQL1) is there something else i can...more >>