I'm using classic ASP with an Access 2003 database, running on Win 2003 Server (IIS 6), trying to update a table and get the following error: [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. - Err.Number:-2147217900 - SQL:UPDATE shipments SET shipmentDescription='$0...more >>

Pls look at this code, i want to call this function from an image click event. CPage=Cint(Request.Form("CurrentPage")) 'get CPage value from form's CurrentPage field Select Case Request.Form("Submit") Case "Previous" 'if prev button pressed CPage = Cint(CPage) - 1 'd...more >>

Pls help me.. pls c this code <FORM Action="<%=Request.ServerVariables("SCRIPT_NAME") %>" Method=POST> <Input Type=Hidden name="CurrentPage" Value="<%=CPage%>" > <% If CPage > 1 Then %> <Input type=Submit Name="Submit" Value="Previous"> <% ...more >>

Hi All, As you may have seen from my earlier post, I am trying to setup paging on an ASP application, I *think* this is 99% there. The only problem I have left, is when I get to the last page, I get the following error: ADODB.Field error '800a0bcd' Either BOF or EOF is True, or the curre...more >>

Hi All, I have just taken on maintenance of an app developed in ASP with JavaScript as the language. I am struggling with carrying out some math on a value derived from the querystring: if (Request.QueryString != "") { nPage = Request.QueryString("Page"); } else { nPage = 1; } ...more >>

When using cookies in classic asp, is it safe to assume that using a comma delimited list of values in one cookie is much more efficient than using multiple cookies? (example below) Response.Cookies("someCookie") = "101,102,103,104,105,106" If InStr(Request.Cookies("someCookie"),"103") > 0 The...more >>

Hi, I need to move a site ASAP, but it would be best to find a host that features both Persits ASPUpload and SoftArtisans' ImgWriter, in addition to SQL2000. Lots seems to have the first but not the second. I did find one that supports both ASP components but doesn't offer enough web spa...more >>

Is there somebody who can prove ASP.NET is faster than ASP ( need to quantify - how fast it is ) Thank you. Regards, Raj. ...more >>

I have the code below and in a random fashion it is responding extremely slowly. On in 3-4 times it takes ages to do the job... Any help will be much appreciated... It is the line: xml_http.Send("") that gets stuck. I am on IIS 6 on Windows Server 2003 Web Edition. <% pcode = request.quer...more >>

Hi all! All I want is a txt file I can write to... and I have a hard time doing it. Only a text file, which I can write strings too (incl timing). My ASP books do not have anything on it and some examples here dont work either. (I really should return to PHP and proper help.) BR Sonn...more >>

Hi Guys.. i know this might sound really really simple, but I'm kinda stuck..I have this form..which has a table (created from stored procedure values)..once the table is populated..i have some radio buttons (for each row of the table) and a main submit button. On clicking submit..i want to...more >>

Hello, I have a stored procedure named as usp_CheckLogin with two parameters as @usID, @Password also values of these parameters are to be extracted using Request.Form from the fields in the forms. Now How do I call this stored procedure from an ASP Page using a Connection ob...more >>

Hi, At the early testing stages of writing some simple ASP scripts hosted by my Windows 2003 Server but I have hit upon a problem. When I open an asp page, IE just returns the script rather than expected web page. What have I or am I doing wrong? Thanks, Joe ...more >>

Before I start I want to say that I use XP Home Edition, not pro, and therefore I didn't recive IIS with it. Alright I have now read this topic: http://groups.google.com/group/microsoft.public.inetserver.asp.general/browse_thread/thread/2cd320c5827d6a1a/97df7903d9b477d8?#97df7903d9b477d8 On ho...more >>

Here is source code: <% Set cdoConfig = CreateObject("CDO.Configuration") With cdoConfig.Fields .Item(cdoSendUsingMethod) = cdoSendUsingPort .Item(cdoSMTPServer) = "smtp.vol.cz" .Update End With Set cdoMessage = CreateObject("CDO.Message") ...more >>

hey gang. i am trying to pull a count from the top 16 records in a db. select count(top 16 (username)) as cnt2 from bracketdb_"&tourney_id&" where username <> 'BYE' order by POS this is what i need to do, however, it doesn't work. i am getting a systax error near TOP. this is using SQL...more >>

I have migrated to Vista Business and installed IIS 7.0. I moved some classic ASP pages from my old XP box running IIS to the new box. I've made no changes to the code, which worked fine on the old machine. They also run fine on a remote server. On the new machine, the ASP pages are running extr...more >>

I have a multidimensional array with 5 keys. I need to perform a alpha sort on the 3rd key. Does anyone have an example on how to do this? Here is an example of what my array consists of: mArray(i,0) = '2007-05-02" mArray(i,1) = "6:00pm" mArray(i,2) = "TEXT TEXT TEXT" <---------------...more >>

Hi all, I am trying to set this up using asp code and IIS configuration. But it seems not working. Here it is the way I am doing. In IIS I set up a virtual directory with secure communication, I checked require secure channel, require 128-bit encryption. In custom error, instead of using def...more >>

I bet this is a simple one, but I just don't know. www.mydomainname.com/12345 How do I grab the 12345 in my ASP page as the ID#? *** Sent via Developersdex http://www.developersdex.com ***...more >>

Dear All, I am new to ASP , I am using Win XP pro .. I am trying to send mail thru ASP pgm... BW is the coding....... <% Sub send_email(email_from, email_to, email_subject, email_body) Dim Newmail Set Newmail = server.CreateObject ("cdonts.newmail") // (line 12) New...more >>

I am sending an attachment to a user with the following code. This successfully prompts the user to Save or Open, provides the correct file name, and displays "Microsoft Excel Worksheet" as the Type. However, when the user clicks "Save", the "Save As File Type" in the resulting dialog disp...more >>

I have never really understood connection strings. I'm not sure why, as I'm a smart guy otherwise, but I cannot make sense of any of the explanations I have seen out there over the past 7 or so years that I have been doing ASP. I have somehow just managed to get by with copying existing connec...more >>

How can i create a multi tab page in asp.net 2.0? create a frame and a number of page with hyperlink? Would i have some directives? Thanks a lot. tony ...more >>

Please have a look at the image at the URL given below: http://rn5a.brinkster.net/Template.gif I would like to use that image as a template for all the ASP pages in a website. Note that though it looks like a frames page, it's actually not a frames page. Using different images has made it lo...more >>

HI I just want to call two exe files from asp code.Please provide me simple code for me. Thanks & Regards Jitesh ...more >>

How do I get all walues if my querystring is empty? If I have a table with let's say 10 rows/records, (ID 1-10). I then have a recordset with request.querystring("id") and get the record having the id thats shown in the address bar ("..com?id=4" would get the record with the id 4). How do I g...more >>

I am wring asp webservices in managed c++ for IIS 5.1 runing on XP SP2. Even though I set the aplication protection to High (Isolated), each service seems to run in the same process. I wrote a couple of test servies in c# which reurned the process id and got the same results. The process they...more >>

Intranet application. strLogon= Replace(Request.ServerVariables("LOGON_USER"),"DOMAIN\","") The above line is used by several pages on my browser-based app to obtain the Windows login name for the user. Of course, I replaced our domain name with the generic word "DOMAIN" here, but the po...more >>

I have a page that update an Access db. When I operate on this page, randomly the screen is refreshed and I loss the data that I have eventually digited and not saved. Is there anybody that can help me? Thanks in advance. Hi to all. ...more >>

Hi. I need to get in classical ASP page color of < Button Face > object of MS Windows. Is there any standard function in vbscript? Please help. Thanks ...more >>

hello I m vinod I am creating an asp.net application and I want if any body enter any value in a textbox then it should only be appear if entered value is integer other wise it should not be appear. please write full code. i dont know how to use javascript in asp.net. Thanks in Advance ...more >>

Hi, I have a limited number of ad slots on my website, let's say there are 5. I have lots of people wanting to advertise in those slots, let's say there are 100. They each join the queue for an ad slot on a first- come, first-served basis. I have been trying to find a way to determine the act...more >>

Hey guys, I am attempting to use the following example: 'Session("Name")' to maintain a value between moduleA and moduleB. ModuleB captures the Session("Name") to be used by moduleA throughout its life. ModuleB indeed establishes the Session("Name").Value and does a Response.Redirect("ModuleA") ...more >>

When a user posts a HTML Form in an ASP page, the values entered by the user in the Form are mailed to the website owner. Users can also attach a file before posting the Form. To send the e-mail, I am using CDO.MESSAGE. When I tested the app in my local intranet IIS5.1 server, the e-mail part ...more >>

Greetings, I'm using ASP to retrieve from MSSQL and I then populate a table. After several months of successfull retrieves, this same code now bombs out. It turns out that if I clear out from SQL about 10,000 records, the retrieve is then successfull. Reading some of the posts, I believe I...more >>

Development environment: Windows 2003 Server running IIS6 and the same server running as a domain controller, DNS and DHCP servers. Production environment: Windows 2000 Server SP4 running IIS5 and not used to provide domain control or name services. The two environments are on different ne...more >>

I patched lastnight. My cdo send email code worked until this AM. The code has been working for months on my 2003 web server relaying to my exchange 2003 server. I now get error '80040211' /Ricweb/standards/testemail.asp, line 35 Anyone have any information? My code <% ...more >>

I have an asp based site which for various reasons has to go in either Trusted Sites or Intranet under security in IE7. However as soon as I place it in either of these zoneI can no longer use session variables. These session variables work fine when it is in the Internet zone. Any ideas anyone?...more >>

I have a web page programmed in ASP that creates a calling list based on the user's preferences, which queries the information from a SQL 2000 database. I want the user to be able to select whether to create different lists based on time zones or one list with all time zones. The user should be...more >>

I need to create a regular expression for a date field that works only in the following format MM/DD/YYYY with the / in the format. No other format can be inputted into the field. I need 2 numbers for MM 2 Numbers for DD and 4 numbers for YYYY. If the users enter 1 number for month, 1 for day he...more >>

I have designed a masterpage....in this i have 3 content place holder(header,side & maincontent).i want to interact between header and maincontent . i am not getting what code i have to write for it..... In header there is (save,edit,cancel) buttons...and the form which i have to save is in...more >>

I'm trying to only allow password entries that have at least one numeric character, and 7 to 15 characters long. The below script is not filtering it properly, it keeps saying all the entries are bad when i am entering mixed passwords: <%'' ASP validation for password criteria dim strpassword...more >>

Strange thing happening with Windows 2000 to Windows 2003 R2 This ASP script below is sitting on a Windows 2000 IIS Server Box and the fldr was pointing to \\Bradford2\temp which was a Windows 2000 server and worked great, now I changed the fldr to point to \\Bradford7\temp which is a Windo...more >>

Hello, In ASP, VBScript: How can I display the first 20 characters of a long string? How can I insert some character inside of the string on every 5th character? Thank you for help. ...more >>

I am trying to fill out a form from a record set and have a few menu boxes that have a static list of values. I want to fill out the default value with the variable from the recordset. The one solution i thought of is as follows: <td colspan="3"><select name="WorkshopType" id="W...more >>

Hi all, i am a asp programmer and i want to use the session variable to store values. I have one asp page including 5 textboxes and 25 radio buttons. My problem is when i submitting the information at the first time and after filling half of the form if i closed the form then next time when i ag...more >>

A MS-Access DB table has the following 6 columns - TeacherID, ClassID, VenueID, AvailDate, StartTime & EndTime. The data type of the 1st 3 columns is int whereas the data type of the last 3 columns is Date/ Time. The AvailDate column stores only the date (& not the time) where as the last 2 colu...more >>

A MS-Access DB table has 2 columns - StartTime & EndTime. Though the data type of both the columns are Date/Time, the records under these 2 columns stores ONLY the TIME part & NOT the DATE part (for e.g. 7:00:00 AM, 2:00:00 PM, 8:35:00 PM etc.). A Form in a ASP page has 3 dropdown lists. The 1...more >>

A MS-Access DB has 3 tables - Teacher, Class & TeacherClass. The Teacher table has 2 columns - TeacherID & TeacherName (TeacherID being the primary key). The Class table too has 2 columns - ClassID & ClassName (ClassID being the primary key) The TeacherClass table has 3 columns - TCID (AutoNum...more >>