Home All Groups Group Topic Archive Search About



Active Server Pages (ASP) Programming Discussion

microsoft.public.inetserver.asp.general
Score Error 80040e14
FayeC - 17 Dec 2005 5:29 PM - 2 messages
I am getting the following error: Microsoft JET Database Engine error '80040e14' Syntax error (missing operator) in query expression ''FayeC' user_email='whate***@none.com' user_compname='none' user_newsletter=1user_dnumber='12345678''. /asp/manageusers.asp, line 122 And I can't find the origin of the error. ...
Score Making site search engine friendly
Jordan - 17 Dec 2005 4:10 PM - 3 messages
I have a standard look to my site so I thought I might just make all the pages .asp pages and use #include statements to grab all the common content, however I want to be sure that all the big search engines crawl it without a ...
Score website statistic
i-cable hk - 17 Dec 2005 1:49 AM - 2 messages
I guess this is very common, but can't find it on the web: I would like to do site statistic and find out the visitor of our website: - ip address - the corresponding time - referal address Where can I download sample asp? ...
Score Select List Box from Array
dthmtlgod - 16 Dec 2005 7:04 PM - 4 messages
I have a string that was populated from a listbox. Now I want to bring up the record again for edit and want the listbox to have those records selected ONLY.  I am close I think.  Currently, it ...
Score ASP page hangs
MikeG - 16 Dec 2005 6:30 PM - 2 messages
Running IIS 6.0 on Server 2003 (no SP 1 yet) When calling an ASP from within a Perl script to perform a query against a web-enabled database (don't ask how we arrived at this architecture), the first query almost always times out with an Timer_EntityBody error.  Our ...
Score Dynamic Variables
scott - 16 Dec 2005 3:19 PM - 13 messages
Is there a way to create dynamic variables when looping through a recordset? For example below, after the 1st loop I'd have myVarA1 and myVarB1, after 2nd loop, I'd get myVarA2 and myVarB2. CODE *********************************** set objRS = GetMyRecordSet() i=1 ...
Score IP address and origin
Hugh Welford - 16 Dec 2005 1:14 PM - 3 messages
Hi, My site is being invaded by AFRICA SPAMMERS mostly from Ivory Coast ( according to my stats program) using USA or UK credentials (zip codes etc) to fool the registration monitor. Is there any way that I can grab the IP address as soon as someone lands on ...
Score DCOM + IIS + user credential
Lambuz - 16 Dec 2005 9:55 AM - 1 message
Hi all, we have this intranet scenario: - Active Directory - A web application secured with Integrated Windows Authentication on IIS 5 - machine A WIN 2000 adv srv     IIS 5 - machine B WIN 2000 adv srv     Custom COM object ...
Score Problem instantiating object from custom ActiveX DLL
Marja Ribbers-de Vroed - 16 Dec 2005 9:22 AM - 2 messages
I've been provided with a custom ActiveX DLL (written in C++) that reads a certiifcate to generate a signature for a passed XML string, and I'm having trouble instantiating it. The DLL is registered succesfully on my computer and I've explicitly granted IUSR_<machinename> to use it. ...
Score OLEDB Connection String
MasterChief - 16 Dec 2005 6:30 AM - 3 messages
I have a OLEDB Connection String that is working very well for me. My question is that I read that you can store the Connection String in a seperate include file or somewhere else. I am just wondering where is ...
Score Database into an array
MasterChief - 15 Dec 2005 10:27 PM - 3 messages
I have a database of Company titles that I want to grab from an access database, put into an asp array and then pass it to javascript so I can output it into a CSS styled javascript menu. Right now I am stuck on ...
Score Track Banner Clicks
Patrick Rouse - 15 Dec 2005 8:05 PM - 5 messages
Please point me to the correct newsgroup if this is the wrong place to post this question. My website is written in simple HTML and hosted on a windows server at secureserver.net (via GoDaddy).  I use an ASP Web Stats program called ...
Score Database fields in a input form
Veronika - 15 Dec 2005 6:26 PM - 2 messages
How can I specify formatting restrictions for special fields like Postal Code (format X1X 2C2) or date input field MM/DD/YYYY? I have Acces DB with these specs, but when I used FP2002 Database Interface Wizard, it ignores these. Also I am unable to "edit" any of the records ...
Score Script errors
Jeff - 15 Dec 2005 3:47 PM - 4 messages
Can someone help me here. I am getting an error that I haven't seen before. <% SET teams1 = Conn.Execute("SELECT * FROM teams WHERE team_initials = '" & var1 & "'") SET teams_wins = Conn.Execute("SELECT count(username) as wins1 FROM all_matches WHERE tour = " & var2 & " AND round = " & var3 & " AND team1 = ...
Score Forms Domain Authentication / Impersonation
Infospy - 15 Dec 2005 3:02 PM - 2 messages
Hi! I'm designing a Form Authentication to authenticate users in IIS in order to redirect them, already authenticated, to their webdav folders. This should work like this: IIS AuthApp ---> Check Login and Impersonate ------->  IIS WebDav after 3 days using code from MSDN Network, I can't seem to find out why it ...
Score whats the best way of migrating data (MS Access)
markrush - 15 Dec 2005 11:39 AM - 5 messages
if i have 2 datasources with different table names and column headers that i want to merge i.e. "ptitle" and "name" whats the best way of doing this? are there any standard routines or should i use something intermediary like xml? ...
Score '800a0e79' Operation is not allowed when the object is open
middletree - 15 Dec 2005 5:15 AM - 2 messages
I'm having a hard time finding out why I'm getting this error. Seems to work just fine on another site I built. I went to ASPFAQ.com, Microsoft.com, and some other sites. Have not been able to spot the problem yet. ...
Score buffer limit
middletree - 15 Dec 2005 4:40 AM - 4 messages
Here's the error I am getting: Response object error 'ASP 0251 : 80004005' Response Buffer Limit Exceeded Execution of the ASP page caused the Response Buffer to exceed its configured limit I then went to aspfaq.com, which told me to add the Response.Clear(), which ...
Score Reporting ASP
IMRAN SAROIA - 14 Dec 2005 8:57 PM - 13 messages
Hi, What is the best option for report in classical asp. Please advise ...
Score Binary Read problem with Request.form("var")
IMRAN SAROIA - 14 Dec 2005 8:56 PM - 4 messages
Hi, I am passing file through aspSmartUpload by using input file form control in my form. But I cannot use Request.Form("Variable") command in my called asp. And it says you cannot use it during or after binary read. I guess ...
Score Type mismatch: '[string: ""]'
exsuscito - 14 Dec 2005 6:00 PM - 3 messages
After about 30 minutes of frustration I finally discovered what was causing a general 500 internal server error and to my surprise it was something I seem to always take for granted for its simplicity.  A type mismatch error trying to compare a string to a numerical value, which ...
Score IIS 5 Serves HTML but won't serve ASP
Evan Nelson - 14 Dec 2005 5:56 PM - 5 messages
I'm not sure exactly what happened but my local development server will no longer serve ASP pages.  I can request HTML and they are served up fine.  When I ask for an ASP I get the generic 500 error.  The web log files show ...
Score if you can't just say NO!!!!!!
nikou_70 - 14 Dec 2005 5:00 PM - 4 messages
I don't know what you mean if you can't understand the code and you can't answer please just say NO... why you try to say story!!!! ...
Score Code Optimisation
poop - 14 Dec 2005 4:12 PM - 6 messages
It was recommended that i visit here, to get my code optimised. Are people here willing to do an optimisation? Ill post code if anyone is up for it!! Thanks in advance ...
Score Unicode - ASP VB code
Enoch Chan - 14 Dec 2005 2:56 PM - 4 messages
I need to read Chinese text from Access and use response.write to display on a web page. However some characters are not correctly displayed, they are displayed as ?. After some rearch, this problem can only be solved UNLESS the Chinese text ...
Score ASP.NET user in AD
Geir Waterloo - 14 Dec 2005 9:37 AM - 3 messages
It seems that the ASP.NET user in AD has been deleted. How can I get it back? Geir ...
Score error 2147016672 from client
Selvad71 - 14 Dec 2005 9:31 AM - 1 message
I have a simple asp page to create a mailbox. The Authentication method is window based. if i open the page from server (using domain administrator login) it works fine. if i open the same page from a client (using domain administrator login ...
Score converting rtf to JPEG?
Tim - 14 Dec 2005 8:56 AM - 10 messages
Since rtf files cause so many troubles, i.e., allow the users to download the files, slow loading, incompatible with other browser, and so on. Do you think I should convert them to JPEG files to embeb them into HTML? Once converting ...
Score Dynamically add posted form items into array
Daniel Gormley - 14 Dec 2005 12:52 AM - 2 messages
What I have is a form that is dynamically generated based on which database table its calling. Therefore, the number of category.name.count can be different. So I have this form generated and say with x amount of input boxes.. I ...
Score ADODB.Stream default filename wrong
tedqn - 14 Dec 2005 12:40 AM - 3 messages
I use the Stream method to serve certain file types to the user. If the type is pdf, it opens in the browser fine. My problem is with those that the browser doesn't have plug-ins such as ppt, word, etc. it ...
Score Server-Side Compression
Brian Staff - 13 Dec 2005 11:43 PM - 6 messages
I'm using IIS 5 and I've been reading about server to browser HTTP compression using "gzip" or "deflate" encoding. Can this be done in IIS 5? If so, it is a configuration setting or do I need to compress it myself before ...
Score Insert Excel Header from ASP
creed1 - 13 Dec 2005 11:37 PM - 3 messages
I am currently working with an Active Server Page (ASP) that is set to redirect its output to Excel using Response.ContentType = "application/vnd.ms-excel".  It works great, but I need to find a way to insert a header and/or footer into the resulting worksheet.  Does Excel ...
Score ASP and SQL Web Host Providers
Billy - 13 Dec 2005 11:02 PM - 6 messages
I'm looking for a web host provider that will host my small ASP web site with a MBD database back-end. Eventually, I will rewrite the site to ASP.net, and migrate the MDB into SQL Server. I basically want to be able to have all the functionality that I do now ...
Score submit form when mouseover
nikou_70 - 13 Dec 2005 10:41 PM - 7 messages
I have a page with image, image has some image map, I want to submit form when user mouseover that image map, my code is like this: <img src="Images/floor4.jpg"usemap="#planetmap" id="IMG1"> <map id="planetmap" name="planetmap"> ...
Score Determine if User Agent is a crawler?
Bill - 13 Dec 2005 7:36 PM - 2 messages
Is there a fast way, with Classic ASP, to determine if a user agent is a search engine spider? I know that ASP.NET has Request.Browser.Crawler, I'm looking to see if classic ASP has something built in, or do I have to look for strings in the user agent. ...
Score found something interesting - browser cache problem
preet - 13 Dec 2005 7:09 PM - 2 messages
Just pass date as a querystring , even if you do not want it like [link] No browser will ever cache this page because the url will change every second LOL This comes particularly handy when you are making remote calls using ...
Score request.servervariables error
preet - 13 Dec 2005 7:05 PM - 2 messages
I posted this elsewhere ; probably the wrong place so i am posting this again I am using the following script: hrefer=Request.Servervariables("HTTP_REFERER") hrhost=Request.Servervariables("REMOTE_HOST") hruagent=Request.Servervariables("HTTP_USER_AGENT") hriisid=Request.Servervariables("INSTANCE_ID") hrsname=Request.Servervariables("SERVER_NAME") ...
Score Limit access to ASP sites to domain users only
curious_Lee - 13 Dec 2005 5:13 PM - 1 message
Hi, all. We're running Windows 2003 Enterprise Edn. with IIS 6. We'd like to limit the access to two of our ASP apps to those who are on the domain --  without using the integrated domain authentication popup. In other words, we ...
Score ASP error in pm.asp line 192 (second try - Please help)
Raul Rodriguez - 13 Dec 2005 3:06 PM - 7 messages
I posted this question already but nobody could answer me. Please forgive for doing it again, but it's very important for my company. We have been searching for this error with different engines (Google, MSN, etc) and in different newsgroups but we didn't find any solution. Some people had the ...
Score ADVICE WANTED: Website Performance Issues
KWilliams - 13 Dec 2005 3:05 PM - 4 messages
I'd like to get some good advice about our old ASP site. You can see our home page at: [link] ....and an example application page at: [link] ...
Score ASP 3.0 moved from Win2000 to Win2003 (convert problem)
Magnus Lundberg - 13 Dec 2005 2:57 PM - 1 message
Hello, I got a new server with Windows 2003 on. I moved a site that works fine from a Windows 2000 server. On many pages i get a convertion like this: This is the code that i run to get the error: ...
Score CDOSYS With Variable Not Working
Jess - 13 Dec 2005 2:22 PM - 4 messages
Hi, I'm sending an email with CDOSYS.  In myMail.To  = emailSubmitter <-When I use a variable here it doesn't send.  When I use a specific address like anyb***@anywhere.com it works.  Here's how I set up emailSubmitter ...
Score ActiveX component can't create object: 'Scripting.FileSystemObject'
Astra - 13 Dec 2005 11:53 AM - 2 messages
Hi All Was running my ASP app no problem on a Windows XP Pro SP2 machine with IIS, dragged a copy my app folder and put it on another Windows XP Pro SP2 machine with IIS and I get the below problem: ...
Score Authentication of users to access html files
Arun - 13 Dec 2005 11:07 AM - 2 messages
I have a folder “Secured” under the root folder of the project In the project root web.config authentication is given as     <authentication mode="Forms">        <forms loginUrl="Login.aspx" timeout="15" /> ...
Score Most popular values in a recordset
Eddie - 13 Dec 2005 10:27 AM - 3 messages
Hi I am trying to soleve the following problem using an asp recordset (connects to sql) A column in the recordset contains integers between 1 and 5.  I am trying to find a way of concluding which integer is the most common, then the second ...
Score Call funtion of a dll from asp
Goldwind - 13 Dec 2005 8:12 AM - 5 messages
Hi, Can i call function from dll from an asp page (not COM)? The problem is that i want the asp page to call function from dll which will be in the same folder. I could have created a com dll but it means that the web hosting company ...
Score Sessions without Cookie
prioregroup.com - 13 Dec 2005 1:05 AM - 2 messages
Do you want manage ASP Sessions variables without Session Object and without Cookie ? A free sample code (GNU license) [link] thanks. ...
Score Turn Calculated Field Results into Currency
joshbell - 12 Dec 2005 10:08 PM - 10 messages
Hello, I am trying to trun some numbers into currency using a calculated value in a query. Although the result formats the results as currency, it sorts as a string would. Here is my statement: Penalty: IIf([datClaimPaidDate]-[datClaimLtrDate]>30,FormatCurrency(([datClaimPaidDate]-[datClaimLtrDate]-30)*50),"") ...
Score Getting 80070003: Error connecting to location
Mike Snetzko - 12 Dec 2005 9:37 PM - 1 message
Hi All -- I have a website on an IIS 6.0 server and I am trying to update the settings via asp page and vbscript.  Below is the code that is supposed to retrieve the Metapath, and it does, however it is erroring out with 80070003, Can not ...
Score image editor in microsoft visual studio
nikou_70 - 12 Dec 2005 6:54 PM - 2 messages
Hi, I want to put some hot spot in my image in HTML page with (microsoft visual studio), all of menu of image editor is inactive. How I can active them? ...
Score using variable in script
Jeff - 12 Dec 2005 4:58 PM - 4 messages
using access db and asp i have a variable from a form sRound = request.form("round")  and for now let us say this value is 3 now i want to include that 3 in sql, but it is part of a field name  which ...
Score global.asa and its engine ?
tolgay - 11 Dec 2005 9:31 PM - 2 messages
When a global.asa is changed does its engine need to restart or is it restarting itself or so? I mean for example there is a web site which contains asp pages and of course its global.asa file I wonder if there is an ...
Score Gettin detailed error information from IIS
Elie Grouchko - 11 Dec 2005 9:05 PM - 1 message
Hi I would like to email detailed error information from my website when an error occurs. I tried to use "On Error Resume Next" and if an error occurs check the Err object and the AspError object returned by Server.GetLastError(), but I ...
Score How CDONTS work ??
Jigar Mehta - 11 Dec 2005 2:08 PM - 3 messages
Hi, Talking about the cdonts objects.. i want to send the email in windows xp.. i downloaded cdonts.dll and registered it.. but still i am not able to send the mail.. is it so that i need to set the settings in the Virtual SMTP server ...
Score showing image on the internet
Tim - 11 Dec 2005 1:48 PM - 11 messages
Hi, I need help to show the images and the wav files on the internet. Also, do you think I should convert the wav files to MP3 for delivery faster on the internet? I think I would save those files on the web server, save the their ...
Score Hi, my global.asa is not being called..
Jigar Mehta - 11 Dec 2005 11:27 AM - 4 messages
Hi, My global.asa is not being called.. any idea what may be the problem ??? ===== Regards, Jigar Mehta ...
Next »