Hi there, SQL 2000 database with ASP I've found many things "out there" regarding updating and deleting multiple records with checkboxes but I can't seem to find anything about adding them. A user wants to create a price list for their client and they need to add parts to it in a separate ...more >>

Hi. I am fairly new to ASP. I have to build a website in ASP 3 that interfaces with VB 6 dll's. I've noticed some strange behavior, so I devised the following tests. Here's my test VB 6 function... Public Function ReturnGivenBool(blnReturn As Boolean) As Boolean ReturnGivenBool = blnR...more >>

Hi, I get the error below when I attempt to write to an access database. Reading is fine. I solved this on the DEV site by making the IUSR_machine a domain administrator. Now the website is up on a production server on SISNA. and I get the error. I get the error using a DSN or a DSN-les...more >>

<a onMouseOver="window.status='Get ID3 info from <%=Replace(strDisplayFileName, "'", "\'")%>';return true" onMouseOut="window.status='';return true" href="fileinfo.asp?TargetFile=<%=Server.URLEncode(strThisSubFolder & "\" & objFile.Name)%>" target="_blank"><img src="images/info.gif" width="10" ...more >>

I have a custom 404 error page. When I change my site properties in IIS (IIS 5.0, BTW) to point to a file, I still get the original 404 error page. But, then I copied my error page to my root, then pointed to it via URL and it works! BUT, I would prefer to use the file page instead of the URL. ...more >>

Hi All Bit of a dilemma here. I'm doing a content management system, whereby the user can enter the HTML code for a currency symbol, eg &pound; for £. My problem is that when I bring this data backup, say they want to edit the settings, then my ASP/HTML page is rendering the HTML code, eg...more >>

I have a 3 layer system, SQL Server 2000 database, COM+ dll's (VC++ 6) and ASP frontend, this system has been in production for quite some time using english, spanish and portuguese versions. Now I've been asked to test the system to function with Simplified chinese. The development of the system...more >>

Hi, What I would like to do is load a file's contents from a file on the server and put the contents into a record in a database. For this I need to load the contents in binary format into a variable. Anywhere I looked, I've only found text I/O in ASP. (FileSystemObject and TextStream). H...more >>

I have multiple IIS servers, all the same version and patch level. However, a recursive file display page that works on 2 of my servers, doesn't work on the third. strPhysicalPath = Server.MapPath(".") strPhysicalPath = strPhysicalPath & "\" Set objFSO = Server.CreateObject("Scripting.F...more >>

Im looking for an online site that I can format or tidy ASP pages. If any one also knows of a software application that can format asp /html pages id be greatfull of that link too. Regards Don Grover ...more >>

Hi, We have an application, written in ASP, that uses the ADODB.Stream to be able to open files and write byte arrays to the Response object. If one of our administrators patches the web servers this application runs on in Windows Update, I'm screwed, right? You've essentially just disabled th...more >>

Hi, I'm writing an ASP application to open an excel workbook, then run a macro stored in the excel file, which produces outputs that will be displayed back onto my ASP application. Now the problem I'm having is whenever I try to open a workbook (of any format, i.e. 97/2000, 95, or xp, and o...more >>

Hi. One of my servers keeps giving me the error below every 1 1/2 hours or so. Any ideas? Thanks Event Type: Error Event Source: Active Server Pages Event Category: None Event ID: 5 Date: 7/7/2004 Time: 6:15:40 AM User: N/A Computer: yyyyyy Description: Error: The Template Persis...more >>

I am having one form in ASP I am retriving the records of students from Database and displaying it in a tabular form in a student database there is a field called "paid" datatype:boolean(yes/no) in access. This field is displayed on the form with the help of format. I want there should be on...more >>

Hello all, I have installed iis and setup a new virtual directory, I then try to view it with the correct address but IE just hangs, nothing appears except the title on the titlebar and busy cursor. Going to view>source shows the source (which is correct). This was a previously working webs...more >>

I asked how to send an email using CDO instead of CDONTS and got several responses. They were all good, I tested the code and it works well. However, I forgot to mention that I need to set the email body to be in HTML rather than in plain text format. Would appreciate if someone could post a complet...more >>

I have and ASP form that sends out an email on Windows 2003. I get the following error: ActiveX component can't create object. What should I do to fix this? Set objMessage = CreateObject("CDO.Message") If Err.Number Then Response.Write Err.Description Else objMessage.From = "daverch@...more >>

I need to convert a variable, nNum, into a two-character string. nNum is always less than 100. If nNum is 0, the string needs to be "00", if it's 1, it needs to be "01", if it's 34, it needs to be "34". What's the best way to do this? Thanks, Bill. ...more >>

I have a script that looks for a phone number. I use an instr to see if it finds a - for the phone number. I them grab the 3 characters before and 4 after for the phone number. Works well, except when someone uses the - in the text. How can look for the second instance of the - if the right 4...more >>

Is this possible? I am planning to export data from SQL that generates HTML table. Instead of selecting the table and then copy then paste to excel, is ther a script(JS or VB) that will automatically export or open the Query to it. ...more >>

How can I insert the current date and time into a hideen form field in a UK format (dd/mm/yyy hh:mm:ss) that can be passed to a SQL DB? I have been using <%=Date()%> as my hiddenn fields value, but this only gives me the date, how can I modify this to give what I need? Thanks ...more >>

I can easily get the current date by using Date(), how about WorkWeek? Mark ...more >>

This one XP machine (with IE 6) is having a problem viewing any ActiveX controls (created on VB6) on the Internet Explorer browser. I put the same ActiveX control in a VB program, and when I run the VB program on that same machine, I can view the ActiveX control fine. He is using Citrix. The sam...more >>

I have a "homegrown" dll that I am using in IIS (VBScript). I need to replace it on a production server, but I don't want to stop/restart server in order to replace the dll. Possible? TIA, Larry Woods ...more >>

How would I add a delete confirmation popup box for the following? Here's what I have... A table (not a form) that contains this line: <td align="center"><a href="delete.asp?username=<%=rsUsers("username")%>&startletter=<%=startlette r%>">Delete user</a></td> And delete.asp looks like th...more >>

I'm using a binary stream to send down a file with ASP from the web server. I've been having trouble with IE and getting it to recognize my file. I've added the filename as a paramater(?filename=file.jpgw) to handle IE's mime type mangling, but I'm still having trouble with IE's default Save As ...more >>

Hi all, I'm searching to find the name of the file in which i execute a script. example : i'm into /directory/page.asp and i d like to know which variable could help me to find the path of the file on server side. thanks a lot and have a nice day Laurent http://www.chazallet.com ...more >>

Can someone please help me with a good swearword filter, or assist me with my current one? This is the code I have currently, but it doesn't always work. I can do the same test, with the same word 4/5/6/7 times in a row, and sometimes it works, sometimes not. ===========================...more >>

Dear all, Sorry for cross posting. I have one page, create an object and save it in session scope, and then redirect to another page.In the new page, the object existed in session object, but can not access its property. The code of page one is : <% Class SiteInfo dim SiteID, SiteName ...more >>

The ASP page has multiple buttons, and when the user clicks different buttons, it will submit the form data to different URLs. My first approach was to use BUTTON type, and triggers javascript function to submit the form data. However, it didn't work properly and I changed to use SUBMIT type. ...more >>

When trying to load a file using ADODB.Stream, LoadFromFile method I get the following error: Safety Settings on this computer prohibit accessing a data source on another computer I'm running windows server 2003. I have the site security set to "Local Intranet" Any Suggestions? ...more >>

Hy, I try to open mht file generated by ASP use the Content-Type = "application/msword". When the browser show de "dowload dialog" and I click in the Save button the file open perfectly, but if I try to click in the Open button, the browser show the "downloading dialog" and stay perpetual tryi...more >>

I manipulate MSAgent AcitiveX object using VBScript at client side, I met a wierd problem when I debugged my ASPX page. when msagent recognize a phrase and fire event, my vbscript capture the event and do something, including make the agent do some animation and speech, then open a browser win...more >>

I have the following code using which I am writing to a text file. The select statement returns 3 records and I can see that from the response.write statement but when it writes to the file it only writes the top 2 records. It is missing the last record. The output on the screen is mac ad...more >>

Hi I am trying to create a CSV file with some fields in double quotes ("). I am not having any luck. This is what I want; "8684","COSTING","000010001","REG",X4,15.00, ,14,0,14,9,6 I am not sure how to create the double quotes. The ASP is this; strTemp = rsCAExport.Fields("Employer Nu...more >>

Hi there, I can't seem to find any info on this error message that's generated when sending email with CDO: "The pickup directory path is required and was not specified" Does anyone know whether the cdoSMTPServerPickupDirectory field of the Message object defaults and whether it's normal ...more >>

Hi all, I hope I'm in the right ng for this... I made an .asp page that allows users to toggle thru a directory of photos. The page accomplishes the following: selects a directory of photos based on a drop down uses the fso to obtain the # of photos in the directory cycles thru t...more >>

Hi, How aspx page can returned an image but the image isn't recognized format. Thanks Silvia...more >>

I use this code to create a table dynamically... strSQL = "CREATE TABLE (FirstName TEXT(30), LastName TEXT(20));" conn.execute(strSQL) This will create two text columns. How can I create some YES/NO columns instead of TEXT columns? ...more >>

Sometimes I have seen the URL doesn't have the file extension, like the following: http://server/signup?id=1001 rather than http://server/signup.asp?id=1001 anyone knows how to do that? please advise. thanks! ...more >>

I use this code to dynamically create a column in a table... strSQL = "CREATE TABLE (FirstName TEXT(30), LastName TEXT(20));" conn.execute(strSQL) This will create two text columns. How can I create some YES/NO columns instead of TEXT columns? ...more >>

I want to create an ASP page that can retrieve some data from my custom-written VB6 application (which would be running on a different computer than the ASP server). Is it possible/ workable/ feasible/ practical to create an activex dll (written in VB6) that would be in the ASP which could conne...more >>

I am trying to find a script to a "dealer locator" or "find a store near you". I will have two tables. One will include all US and Canada ZIPs including lat and longtitudes. The other one is a table of our dealers (or store) including thier ZIP codes. When the user enters his ZIP code, the appli...more >>

I have a function to cope with " and ' in a form field. The quotes replace works fine but the apostrophe one does not. this is driving me nuts. function clean_text() frm_title = Replace(frm_title,"'","''") frm_title = Replace(frm_title,"""", """""") end function I know this topic keeps com...more >>

I'm trying to find thorough documentation for creating graphs using serverside Excel from ASP. Any book recommendations? A well-documented COM wrapper would be nice if it allowed us to create may different types of graph, e.g. Wind Rose (for wind direction), thermometer, as well as standard...more >>

Hello, Is there a simple way to check whether a database driver is available on a remote server? I only have ftp access so I can only run ASP scripts. An ASP application on a host has died again. I'm getting either: Microsoft JET Database Engine error '80004005' Cannot open datab...more >>

Hallo, I have to make a web application in Javascript/ASP for tenniscourt reservation (based on Access database). I would like to do everything with one page, because the user must be able to change his day, hour or tenniscourt choice before really reserving it . I tried like this: The firs...more >>

"The Department of Homeland Security's U.S. Computer Emergency Readiness Team touched off a storm this week when it recommended for security reasons using browsers other than Microsoft Corp.'s Internet Explorer": http://story.news.yahoo.com/news?tmpl=story&cid=74&e=3&u=/cmp/20040702/tc_cmp/22103...more >>

Is it possible (and if so, how?) to have an asp form page that based upon a user's selection on a field, would generate a input field b that the user selects? For example: User selects "name" in a select statement which would list the possible names to select from or if the user selects...more >>

How can I select a comment node using selectSingleNode, sendo que selectSingleNode("#comment") don't works? thanks a lot ...more >>

I have a simple .asp page with a text field and submit button. When it runs on a Win 2000 Professional + IE6 client machine, and the .asp page is set "anonymous access" only on IIS, the contents I entered to the text field did not get submitted when I click the submit button. If the settin...more >>

I have decided to re-write the intranet site i created over a year ago. The coding is pretty awful and hard to read cos I made the mistake of not putting comments in or putting crappy comments in with the code. So I have decided to try and make things neater by grouping it into subs. So i have...more >>

I'm setting up some web-based (ASP) reports that query an Access DB. I also want certain people to be able to access and manipulate the database directly. However, if the database is open in Access, I cant access it via ASP: Microsoft JET Database Engine error '80004005' Could not use ''; f...more >>

I am trying to integrate an application into our extranets. The extranet technology has its own authentication system requiring a domain user but uses anonymous authentication (from the perspective of IIS). I can get the username/password, but IIS is not aware of the user. The application I a...more >>

i have a little problem that i can't fix, in the Regional option of the Win2k server control panel i have set the Euro currency and the date format with dd/mm/yyyy but all the peoples that use a simple asp script like asp ASP date(), get the $ currency and the Usa date as mm/dd/yyyy, do you know...more >>

Hi all, I have an important question to ask about how to trap events when the user close the browser window. I'm a ASP programmer and I have s MSSQL database with a user table where I'm able to track if the user is logged in or not. However this is not easy to track if the user close the brows...more >>

"I would like like the user to be able to click the Refresh button without resubmitting the form data." Why would you want the user to be able to click on the Refresh button? Do you mean that you want to PREVENT the from from resubmitting if the button is pressed? You may want to think a...more >>

When I insert info into a DB from a form, it cuts the string off at the first apostrophe ("). How would I make it insert the data as-is, with the apostrophes? Here is the code used to insert the Data: strsubject = " " & GetFormData("strsubject") & " " incident = " " & GetFormData("inc...more >>

Hi, We have one domain with a mixture of NT PDC's one Win2K DC (which was the first installed) and 4 Windows 2003 DC's. I created our sites as per MS documentation and created the subnets that match each site. I moved each server into its own site. I then create the Inter-site transport wit...more >>

I am using ASP to read code from a text file that I am displaying on my page. Because I do not want the code from the text file to be executed, I used the Server.HTMLEncode() method to display it as it is in the file. However, the spaces used to indent lines is still removed by the browser. I c...more >>

Does anyone know of a good way to use the JavaScript string.replace() method in an ASP form? Here is the scenario: I have a form that cannot accept apostrophes. I want to use the replace() so that the apostrophe is automatically replace with two '' . Reason being--SQL Server does not like ap...more >>

Folks, On one of my client's sites, we set up a subdirectory off the app's root directory that doesn't allow the Anonymous IUSR_ account in. When we (the system admins) follow a link to that directory, it presents the standard NT Challenge login screen. We need to know proper Windows cred...more >>

Hi I am trying to shutdown a COM+ application from an ASP page implemented using VBScript. I get: Err.Number=0x46 Err.Source=Microsoft VBScript runtime error Err.Description=Permission denied Should I be aware of any security issues here? Thanks Elie Grouchko ...more >>

Hi all. I'm thinking about learning ASP.NET. I currently have: Windows 2000 Pro Dreamweaver MX 2004 IE 6 NS 7 TextPad. 4.5 I currently code in ASP-Jscrip, server side/ MSSQL What do I need to beable to learn ASP.NET? What software, what Version of windows etc. any good URL...more >>

I've run into an interesting problem, and seemed to have stumped 3 newsgroups and 2 other forums. For some reason when I try to insert a record into a SQL table that has a Text column, the returned autogenerated Identity is wrong (on the VB side). This only occurs if the length of the value in...more >>

I know I've used something like this in the past, can't put my finger on it, tho... I need to find out the method/keyword for checking to see if a user is clicking into one webpage from a certain other webpage or url: hypothetical example: <%if referringurl = "http://www.yahoo.com" then ...more >>

Hello, i have an ASP Page that generates a PDF document. After the generation i save the generated document as a file. all works fine. the only strange thing is, that my document is stored twice on the filesystem. why is the page loaded twice??? regards Patrick ...more >>

I know this isn't really an ASP question, but I thought you guys might know the answer being that you work with textboxes alot. All of a sudden about 50% of my textboxes are yellow (as opposed to the usual white color). It started when I started on an ASP project, but this could have been co...more >>

Hi I have a script in ASP 3.0 which creates a CSV file on the server. After the code has run I want it to prompt the user to download the file (via the browser). I have spent a frustrating hour trying this. Can anyone help? Thanks Tim Cowan ...more >>

I am trying to run this code on a Windows 2003 Server. I have ASP enabled. Any idea why it doesn't work? <% newDB = "new.mdb" newDB = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & newDB Set cat = CreateObject("ADOX.Catalog") cat.Create newDB Set conn = CreateObj...more >>

I've always used some "third party" editor, such as dreamweaver, coldfusion, or even notepad to build ASP pages. I've recently acquired a copy of Interdev and I'm wondering how people feel about it. I like VS.NET, but I only have one license for it (at home). Is InterDev worth using? Thanks...more >>

I want to add a <p> after 10 results are given and do this in a loop after every 10 results. Here is my query and my current results code How would I modify this to add a <P> after every 10 results for ts? <% Response.Buffer = True Dim connStrx, rs, ss, ts, book1, verse1, chap1, booko...more >>

I have a situation where I need to send a text message to a cell phone. Any ideas? TIA, Larry Woods ...more >>

Hello friends, I am printing a payslip contains nearly 22 lines. Each time i am generating one employee payslip. If i print using window.print() prints the payslip and aligns to next page. I want to stop the printer and go back and generate next emp payslip. so that i can save paper. How can i...more >>