Running Access Stored Queries with Parameters

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ ASP Server
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Adding Basic User Control, cannot get event to wire I am trying to add a basic user control to a web site; coming from visual studio 2003 this was extremely easy. I would just add the user control and then add the controls that I want on that user control, but I am not able to get a basic link button to click. This seems so ridiculously basic, but I am not able to get this to work. What am I missing? Tag: Running Access Stored Queries with Parameters Tag: 329704
  - 2
    - buy viagra Tag: Running Access Stored Queries with Parameters Tag: 329703
  - 3
    - website issuing multiple ASPSESSIONID to same client..make it stop!!! Hello- For some reason, at a website that has been trouble free for a couple of months, multiple ASPSESSIONID's are now being set by IIS for each client visitor, rather than the one you'd expect. When you first visit the site and hit a page that sets a session, the response.write of the HTTP_COOKIE server variable looks like you'd expect...with just the one IIS-assigned ASPSESSIONID: HTTP_COOKIE= ASPSESSIONIDQSADRADT=DJGKPNMACDAJEPGHHKEPFOEB ...but when you add items to your shopping basket(stored in a db, no persistent cookies being used), then go view your order or continue shopping and view the response.write again, it's now a string of ASPSESSIONID's like: HTTP_COOKIE= ASPSESSIONIDQSADRADT=DJGKPNMACDAJEPGHHKEPFOEB; ASPSESSIONIDQSCCTBDS=NPKKPFKAPCNEEBMEKIDCPNKG; ASPSESSIONIDSSCARBCS=JDCHGKPAOJFMKEAGIIMLGCAD The problem manifests itself in that RANDOMLY, IIS appears to be recognizing the user/client as one or the other of the ASPSESSIONID's in the string...in effect, IIS no longer recognizes the user that added items to their basket a minute ago because it is paying attention to one of the other ASPSESSIONID's in the string which haven't got any session variables defined via scripting....you can refresh your page a few times and it thinks you are a different visitor with no sessions...refresh a few more times and it thinks you're the original person with active sessions...a very frustrating issue. The server is Windows Server 2003 and has IIS 6 on it. I've done a lot of digging on the web for information about this phenomenon, but nothing I've found seemed applicable ...or worked. 1. The website doesn't use frames 2. The problem occurs whether staying in http or https or crossing between the two types of connections 3. The server is not a member of a web farm that utilizes load balancing 4. I've assured that my global.asa file has read and execute permissions for IUSR 5. I've stubbed out everything in the Session_OnStart sub of my global.asa file 6. I've pulled out hand-fulls of hair, cussed and gritted my teeth for several days ..nothing works... Any help making it stop this behavior would be greatly appreciated!!! Thanks, Steve Tag: Running Access Stored Queries with Parameters Tag: 329702
  - 4
    - Error running ASP in IIS I am trying to run an ASP page in IIS 6.0 and I keep getting one of two errors: -2147467259 (0x80004005) The remote procedure call failed and did not execute. I have Win XP. It's been running fine for a long time and then yesterday, for no apparent reason, I get this. I've tried the links to asp.faq that I've seen others post and nothing works. As a test, I created a simple ASP page with just '<% Response.Write("Hello") %>' in it and still the error occurs so it's not a scripting or database problem. DotNet seems to run fine and I can run HTML pages, I also have Apache and can run PHP scripts with no problem ... everything except classic ASP. Any ideas? This is driving me crazy and I need IIS running because I am falling behind in my work. As I mentioned, I've been running ASP scripts on this machine for years and have never seen this problem. Thanks, Steve Tag: Running Access Stored Queries with Parameters Tag: 329701
  - 5
    - Easy question - Trouble with Request.Form I am new to asp and I am having a little trouble with the Request.form option. What I want to do is I have a dropdown box. <select name="selecter" class="text" id="selecter"> <option value="page1.htm" selected>Page 1</option> <option value="page2.htm">Page 2</option> <option value="page3.htm">Page 3</option> </select> and I want to use a button that then will take you to the page you selected so I have been trying codes like this. <a href="<%= Request.Form("selecter") %>" ><img src="submit.jpg" width="45" height="18" border="0"></a> Any idea what I am doing wrong, any help is apprieciated. Thanks, Randy Tag: Running Access Stored Queries with Parameters Tag: 329690
  - 6
    - Large insert string Hi, I have an asp page with a form, which has a lot of fields ........ 30 to 40 ! Is there an easier way to loop through all the fields submitted to the insert page or is the only way to do it using the standard, request.form for each field and then INSERT INTO Reports (ReportID, ReceivedDa .................... very lengthy for this amount of fields. Perhaps there is a way of looping through some sort of collection ??? Thanks David Tag: Running Access Stored Queries with Parameters Tag: 329686
  - 7
    - Creating Project from existing site Hi all, I'm running into some trouble figuring out how to create a 'project' from an existing asp application. The ASP app was written entirely with plain text editors. I would like to set up debugging for it, but it seems that in order to debug, I must have a 'project'. I cannot figure out how one might go about this task. The project is rather large (180K lines, and a few hundred files in many different sub-dirs), and I have been playing & researching for about 4 hours now, and I can't figure it out. Can anyone make a suggestion as to what I must do to get something going (preferably vs2003, but I have VID also) Thanks so much Brian Ackermann Tag: Running Access Stored Queries with Parameters Tag: 329684
  - 8
    - ADO recordset returns UTF8 instead ISO-8859-1 I'm using ADO to read an access database using ASP. My problem is, that i get e.g. =C3=BC instead of =FC Does anyone know y? I am using following doctype: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/ TR/xhtml11/DTD/xhtml11.dtd"> I am using following contenttype: <meta http-equiv=3D"content-type" content=3D"text/html; charset=3Diso-8859-1"> Tag: Running Access Stored Queries with Parameters Tag: 329683
  - 9
    - Insert statement Hi, I have an asp page which runs an update into our mysql database. The only problem I have is that a user selects a customer from a dropdown (this is database fed), and I require the selected item to be loaded into the db. All I can get in the database is the first part of their name upto the first space ? i.e. if the selected item from the dropdown is A B Knowles, the database entry is 'A' cust = request.form("customername") I have tried adding ' " & cust & " ' for the insert statement What do I need to do to fix this minor glitch Thanks David Tag: Running Access Stored Queries with Parameters Tag: 329678
  - 10
    - small dooubt on recordset Hello Friend, I have a doubt. I am connecting to mysql db and there is only one table and i am retrieving the data like city, state, county, etc.. from db to comboboxes. so i am using one recordset for each retrivel and showing into combobox. it is going slowly. SO what happens if i use multiple recordsets in single ASP page? So I think we can use only one recordset for all the data retrievel from the db? waiting for your reply. Gaffar. Thanks Tag: Running Access Stored Queries with Parameters Tag: 329676
  - 11
    - replica watches Tag: Running Access Stored Queries with Parameters Tag: 329674
  - 12
    - "Breaking out" of a Server.Execute call? Greetings, folks. Wondering if someone might be able to shed some light on this without my having to load up 'n test it for myself. I have a page calling another with Server.Execute, but depending on what the outcome of some data checks on that called page is, it may need to "break out" of the call with a Response.Redirect. What I want to know is, will this eventually lead to memory leaks because there's no return to the original calling page? The environment's a "plain vanilla" IIS installation under Windows Server 2003 Web Edition. Ultimately I suppose it's not entirely crucial that I need to use this method; I could always break the original page into two and use Server.Transfer to avoid the possibility of "left-overs," but I hope someone here can state with at least a little authority whether or not this problem might occur. Thanks in advance, -- Bob Milutinovic Cognicom - "Australia's Web Presence Specialists" http://www.cognicom.tk/ telephone (0417) 45-77-66 facsimile (02) 4727-1898 ------------------------------------------------------- To respond by e-mail: <myname>@<mydomain> (work it out) Tag: Running Access Stored Queries with Parameters Tag: 329673
  - 13
    - Save As Dialog Box When users submit a Form with a SQL query, the resultset is retrieved from a MS-Access database table which is then exported to an MS-Excel worksheet. After the records get exported to MS-Excel, I want to give users the option to download the Excel file to their local machine. In other words, when users click a download link, I want the Save As.. dialog box to pop-up so that users can save the Excel file to their local machine (note that I don't want users to view the Excel worksheet in their browser). This is how I tried it: <% Dim strFile 'here strFile is just the file name & does not include it's physical path strFile=Request("file") Response.ContentType="application/octetstream" Response.AddHeader "Content-Disposition","filename=" & strFile Dim objStream strFile=Server.MapPath(strFile) Set objStream=Server.CreateObject("ADODB.STREAM") objStream.Open objStream.Type=1 objStream.LoadFromFile(strFile) Response.BinaryWrite(objStream.Read) objStream.Close Set objStream=Nothing %> The above code doesn't give users the option to save the Excel file in their local machines. Rather the Excel worksheet opens in the browser. What am I doing wrong here? What I find is if I pass the PHYSICAL PATH of the Excel file to the LoadFromFile method, say, something like C:\Inetpub\wwwroot\XL \XLFile.xls & change the above code slightly to look like this: <% Dim strFile,strFileName strFile=Request("file") strFile="C:\Inetpub\wwwroot\XL\" & strFile 'just get the file name; exclude it's path strFileName=Right(strFile,Len(strFile)-InStrRev(strFile,"\")) Response.ContentType="application/octetstream" Response.AddHeader "Content-Disposition","filename=" & strFileName Dim objStream Set objStream=Server.CreateObject("ADODB.STREAM") objStream.Open objStream.Type=1 objStream.LoadFromFile(strFile) Response.BinaryWrite(objStream.Read) objStream.Close Set objStream=Nothing %> In the 2nd code, I am passing the file name as well as it's entire PHYSICAL PATH to the LoadFromFile method & this does pop-up the Save As... dialog box so that users can download the Excel file to their local machines. But in the 1st code, I am passing the file name along with it's VIRTUAL PATH to the LoadFromFile method. Hence to get the PHYSICAL PATH, I am using Server.MapPath but the Excel file opens up in the browser & doesn't pop-up the Save As.. dialog box. Tag: Running Access Stored Queries with Parameters Tag: 329671
  - 14
    - strings with quotes in < input type=text name="PageTitle" id="PageTitle" value="<%=strPageTitle%>" > How do I "escape" any quotes, accidental carriage returns etc that are contained within strPageTitle? Do I have to use a series of replace() functions, or is there a cunning way that makes it OK? (Using escape(strPageTitle) fills the box with % signs...) Thanks in advance Giles Tag: Running Access Stored Queries with Parameters Tag: 329666
  - 15
    - test dropdown value from form Hi, I have an asp page with a simple form. The form has a dropdown which is database fed. Once the user selects a value from the dropdown, I need some code to test the value selected. If the value is 'X' then, make certain other form fields visible, otherwise hide them. Can this be done ? perhaps it needs to be done in clientside javascript (obviously a different group before I get shouted at :-) Thanks David Tag: Running Access Stored Queries with Parameters Tag: 329661
  - 16
    - Removing obscure chars Hi All I have an ASP function in place to strip invalid chars out of a data store before I create an XML file of this data, but my function doesn't work on a certain set of chars. As far as I can see these are the following: a) trademark char b) long hyphen/dash char c) smart/curly quotes (both left and right) Even though my function is set up as follows: Function ReFormatStringForXML(s) IF LEN(s) > 0 AND NOT IsNull(s) THEN s = Replace(s,"™","™") s = Replace(s,"—","-") s = Replace(s,"’",""") s = Replace(s,"'",""") s = Replace(s,"""",""") s = Replace(s,"&","&") s = Replace(s,"<","<") s = Replace(s,">",">") END IF ReFormatStringForXML = s End Function These chars still pass by and foul up my XML file. I have a feeling that its down to the fact that my function is looking for the html equiv rather than the actual char, but I can't possibly get away with simply copy and pasting these friggin(!!) chars into my function. Surely this is bad practise? Does anybody know how I can trap and replace/remove these chars if need be? Thanks Tag: Running Access Stored Queries with Parameters Tag: 329660
  - 17
    - Removing obscure chars Hi All I have an ASP function in place to strip invalid chars out of a data store before I create an XML file of this data, but my function doesn't work on a certain set of chars. As far as I can see these are the following: a) trademark char b) long hyphen/dash char c) smart/curly quotes (both left and right) Even though my function is set up as follows: Function ReFormatStringForXML(s) IF LEN(s) > 0 AND NOT IsNull(s) THEN s = Replace(s,"™","™") s = Replace(s,"—","-") s = Replace(s,"’",""") s = Replace(s,"'",""") s = Replace(s,"""",""") s = Replace(s,"&","&") s = Replace(s,"<","<") s = Replace(s,">",">") END IF ReFormatStringForXML = s End Function These chars still pass by and foul up my XML file. I have a feeling that its down to the fact that my function is looking for the html equiv rather than the actual char, but I can't possibly get away with simply copy and pasting these friggin(!!) chars into my function. Surely this is bad practise? Does anybody know how I can trap and replace/remove these chars if need be? Thanks Tag: Running Access Stored Queries with Parameters Tag: 329658
  - 18
    - Problem repeating a query within an ADO Transaction I have a fairly simple ASP application talking to an Oracle 10g DB using a mixture of ADO (OraOLEDB) and OO4O - the query here concerns some ADO code. One part of the application records PartNo/SerialNo combinations; the user specifies a PartNo, a SerialNo and the parent PartNo - the parent takes the SerialNo from the child object - and the application INSERTs these as records into the DB. Amongst the validation, is a check to confirm that each PartNo/SerialNo combination has not be used before. This code seems to work fine. Clearly, if the user enters the same PartNo for both the child and parent items, the DB would ordinarily complain: "ORA-00001: unique constraint (IFSAPP.PART_SERIAL_CATALOG_PK) violated ORA-06512" However, I'm expecting the validation routines to handle this clash before the INSERT statement is attempted. Unfortunately, in this type of scenario this is not the case - the validation routine responds that the parent PartNo/SerialNo has not been used before, and thus the INSERT is attempted and the unique constraint error occurs. I assume that this is because previous INSERTs were not committed since the whole operation is wrapped up within an ADO transaction. However, I would have expected that the validation code would have taken an changes made within the transaction into account, but it doesn't appear to be the case. Is my logic wrong, or should I be expecting the validation to consider previous statements within the same transaction? If my expectations are correct, where might I be going wrong? Thanks in advance Chris Selected code snippets: - ASP: Function SerialExists (sSerialNo, sPartNo) Dim iResult, bResult With oDB .Parameters.Add "sPartNo", sPartNo, ORAPARM_INPUT, 1 .Parameters.Add "sSerialNo", sSerialNo, ORAPARM_INPUT, 1 .Parameters.Add "iResult", 0, ORAPARM_OUTPUT .Parameters("iResult").serverType = 1 .ExecuteSQL ("declare iResult VARCHAR2(100); Begin :iResult := IFSAPP.PART_SERIAL_CATALOG_API.CHECK_EXIST(:sPartNo, :sSerialNo); end;") SerialExists = .Parameters("iResult").Value .Parameters.Remove "sPartNo" .Parameters.Remove "sSerialNo" .Parameters.Remove "iResult" End With End Function - Oracle: FUNCTION Check_Exist___ ( part_no_ IN VARCHAR2, serial_no_ IN VARCHAR2 ) RETURN BOOLEAN IS dummy_ NUMBER; CURSOR exist_control IS SELECT 1 FROM PART_SERIAL_CATALOG_TAB WHERE part_no = part_no_ AND serial_no = serial_no_; BEGIN OPEN exist_control; FETCH exist_control INTO dummy_; IF (exist_control%FOUND) THEN CLOSE exist_control; RETURN(TRUE); END IF; CLOSE exist_control; RETURN(FALSE); END Check_Exist___; Tag: Running Access Stored Queries with Parameters Tag: 329656
  - 19
    - Pass Parameters to  What is the workaround of passign a parameter to any included asp file:  This obviously does not work:  Thank you Tag: Running Access Stored Queries with Parameters Tag: 329654
  - 20
    - ASP error Server object error 'ASP 0178 : 80070005' Server.CreateObject Access Error /asp/aspincludes/CRFunctions.asp, line 20 The call to Server.CreateObject failed while checking permissions. Access is denied to this object. Tag: Running Access Stored Queries with Parameters Tag: 329653
  - 21
    - ASP error Server object error 'ASP 0178 : 80070005' Server.CreateObject Access Error /asp/aspincludes/CRFunctions.asp, line 20 The call to Server.CreateObject failed while checking permissions. Access is denied to this object. Tag: Running Access Stored Queries with Parameters Tag: 329652
  - 22
    - asynchronous callback component We have an asp.net application that will also use MSMQ. When a client makes a request, we want to check several databases and put each response in MSMQ. We don't want the client to wait for all responses to come back. We were wondering if there is some component that will sit on the client and listen for call backs from the the server. We are also concidering using AJAX to poll MSMQ every 5 seconds and show any new responses. Has anyone had any experience with this? Tag: Running Access Stored Queries with Parameters Tag: 329649
  - 23
    - viagra Tag: Running Access Stored Queries with Parameters Tag: 329647
  - 24
    - HTTP/1.1 New Session Failed I'm on a windows VPS and I run ASP applications with mysql. I have a lot of traffic so I know I use a lot of resources... but here is my problem: The server is running and after some hours I get this error message:HTTP/1.1 New Session Failed I've supposed this is caused by the leak of memory, so I've tried different thing without any improvement.. - create a paging file - set the pool recycling when at a "maximum virtual memory" amount - set the session timout in the webconfig at 5 minutes Nothing has changed. I don't know if I had some little improvements, however nothing that prevent the server from displaying that error after some hours of running properly. Tag: Running Access Stored Queries with Parameters Tag: 329644
  - 25
    - generate PDF files with ASP. Hello, generate PDF files with ASP. i searched in google i found http://www.fpdf.org/ this site which is in PHP. but i want the same thing in ASP. can anybody help me. Thanks Tag: Running Access Stored Queries with Parameters Tag: 329642
- Next
  - 1
    - Limiting search results to a subdirectory I have a basic ASP / Index Server search page. I have a web site contained in a subdirectory in the root of a main web site. What Iâ??m trying to do is force the search page in the subdirectory, conduct its search ONLY in the subdirectory, and NOT display results from the parent/root. (Note: there is also a similar search page for the main site, in the root, which I am having no problem excluding the subdirectory from its search results.) Hereâ??s what Iâ??ve tried so far: 1. My sys admin created a totally separate catalog to point to for the search 2. Limited the vpath to the subdirectory - (#vpath *\TextOnly*) 3. Tried various combinations of 1 & 2 above 4. Publish the site to another server, then created a redirect in the subdirectory to point to that location The results â?? the search either returns results from the root and subdirectory, or it returns â??No results foundâ??. Is this possible to return results from a subdirectory and exclude everything from the parent/root? Thank you. Tag: Running Access Stored Queries with Parameters Tag: 329639
  - 2
    - How to save byte stream as binary document Hi, A site Im working with has an API that allows one to retrieve files. The file is a Word doc sent as a byte stream. url="blah.asp?fileid=777777" set oXMLHTTP=server.CreateObject("MSXML2.ServerXMLHTTP.4.0") oXMLHTTP.open "POST",url,false oXMLHTTP.send binData=oXMLHTTP.responseText I am trying to save the stream as a file on the Web server. It isn't working. I've tried using FS.OpenTextFile, Stream.Write, etc. Nothing is working. Anyone have any sample code on how to do this? Thanks Tag: Running Access Stored Queries with Parameters Tag: 329638
  - 3
    - RS Loop - Numeric value out of range (null) Hi All, I am getting this error: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver]Numeric value out of range (null) /database/data_entry.asp, line 90 Line 90 is shown below... // count the total records by iterating through the recordset for (rsProducts_total=0; !rsProducts.EOF; rsProducts.MoveNext()) { <---- Line 90 rsProducts_total++; } This is an access database, connected to via a DSN. Any help will be muchly appreciated! I'm stuck on this one! Thanks! Simon. Tag: Running Access Stored Queries with Parameters Tag: 329636
  - 4
    - viagra Tag: Running Access Stored Queries with Parameters Tag: 329635
  - 5
    - how to get the ip address & country of the webpage visitor hi everyone! i want to get the ipaddress,and the country name of a webpage visitor,using asp.Net(C#).if anyone knows about it,plz rply me. thanx in advance. Tag: Running Access Stored Queries with Parameters Tag: 329633
  - 6
    - How do I submit form data and change to a different page? Probably a fairly simple problem but one that's been plaguing me for a couple of days... can anyone help? I have a classic ASP page with a number of text boxes which are updatable. For convenience I want to add 'tabs' at the top of the page (like a card index) as the data to be displayed is split into specific groups (client, company, preferences, events). How do I update any changes to the data and switch to a different page - at the same time? i.e. the user doesn't have to click 'update' (submit button) before changing pages Sample code is below... Thanks in advance Simon Sample code: <table width=785 height="430" border="1" bordercolor="#FFFFCC" style="border-collapse: collapse"><tr> <td height="20">  <a href="contacts.asp?id=<% =request("id") %>" >Client details</a>  ¦  <a href="contacts.asp?page=events&id=<% =request("id") %>" >Event Enquiries</a>  ¦  <a href="contacts.asp?page=mailing&id=<% =request("id") %>" >Mailing Preferences</a>  ¦  <a href="contacts.asp?page=company&id=<% =request("id") %>" >Company Information</a></td></tr><tr> <td height="410" bgcolor="#FFFFCC" valign="top"> <table border="0" width="785" height="410"> <tr> <td valign="top" height="390"> <table border="0" width=785> <tr> <td>  <form action=contacts.asp method=post name=form1> <input type=hidden name=id value=<% =request("id") %>> <input type=hidden name=page value=<% =request("page") %>> <input type=hidden name=show value=<% =Request.Cookies("adminshow") %>> <input type=hidden name=companyid value=<% =oRS("companyid") %>> <div align="center"> <table border=0 width=782 height=395> <tr> <td width="340" valign="top"> <table border="0" width="100%"> <tr> <td width="100" align="right">title</td> <td width="10" align="right"> </td> <td width="230"><select size="1" name="title"> <option>-</option> <option selected><% =oRS("title") %></option> <option>Mr</option> <option>Mrs</option> <option>Miss</option> <option>Ms</option> <option>Dr</option> </select></td> </tr> <tr> <td width="100" align="right">first name</td> <td width="10" align="right"> </td> <td width="230"> <input type="text" name="name" size="25" value='<% =oRS("name") %>'></td> </tr> ...  </table> </td> </tr><tr><td colspan="3" height="195"> <p align="center"> <textarea rows="10" name="callbacknote" cols="92"><% =oRS("callbacknote") %></textarea></td> </td></tr> </table> </div> </tr> </table> </td> </tr> <tr><td> <hr><div align=center> <a href="index.asp?page=callbacks&show=<% =varID %>">back</a>  <input type="submit" value=" update " name="update"> <input type="button" value=" copy " name="B4" onclick="recordcopy()"> <input type="button" value=" delete " name="B5" onclick="recorddelete()"> <input type="button" value=" print " name="B6" onclick="recordprint()"> </div> Tag: Running Access Stored Queries with Parameters Tag: 329628
  - 7
    - replica watches Tag: Running Access Stored Queries with Parameters Tag: 329627
  - 8
    - random numbers and letters hey gang. I have a code to create a random string of letters. The number of them can be whatever I desire. what i would like to do, is have it both letters and integers. how would i modify this code to allow that. '***** make random password ****** Sub StrRandomize(strSeed) Dim i, nSeed nSeed = CLng(0) For i = 1 To Len(strSeed) nSeed = nSeed Xor ((256 * ((i - 1) Mod 4) * AscB(Mid(strSeed, i, 1)))) Next Randomize nSeed End Sub '---------- Function GeneratePassword(nLength) Dim i, bMadeConsonant, c, nRnd Const strDoubleConsonants = "bdfglmnpst" Const strConsonants = "bcdfghklmnpqrstv" Const strVocal = "aeiou" GeneratePassword = "" bMadeConsonant = False For i = 0 To nLength nRnd = Rnd If GeneratePassword <> "" AND _ (bMadeConsonant <> True) AND (nRnd < 0.15) Then c = Mid(strDoubleConsonants, Len(strDoubleConsonants) * Rnd + 1, 1) c = c & c i = i + 1 bMadeConsonant = True Else If (bMadeConsonant <> True) And (nRnd < 0.95) Then c = Mid(strConsonants, Len(strConsonants) * Rnd + 1, 1) bMadeConsonant = True Else c = Mid(strVocal, Len(strVocal) * Rnd + 1, 1) bMadeConsonant = False End If End If GeneratePassword = GeneratePassword & c Next If Len(GeneratePassword > nLength) Then GeneratePassword = Left(GeneratePassword, nLength) End If End Function '---------- StrRandomize CStr(Now) & CStr(Rnd) var_var = GeneratePassword(6) '************************************** this gives me 6 letters at random. for example utjand i would like it to give say 3 letters and 3 numbers. is this possible with the code i have? TIA Bam Tag: Running Access Stored Queries with Parameters Tag: 329622
  - 9
    - Helga Tag: Running Access Stored Queries with Parameters Tag: 329619
  - 10
    - Truncation of Hidden text box values in Classic ASP - freakish. Hi, We have found a very freakish â??truncateâ?? behavior in Classic ASP application (that is called from within a web logic portal). We have an ASP variable, lngOrderId (an oracle sequence number that right now running in 8000+) in our ASP page. The current value of this variable (got from the session) is 8095. In order to pass the value to the next page, we set the variableâ??s value to a Hidden INPUT field and pass it to the next form. Here is the code snippet that does this task: Response.Write "<!â?? Sample debug write " & lngOrderId & " -->" strHTMLString = strHTMLString & "<input type=""hidden"" name=strOrdID value=""" & lngOrderId & """>" Response.Write strHTMLString Now the first line correctly displays 8095 in the ViewSource. But in the same view source I see that the above hidden variable (strOrdID) has a value of 95 ! This happens only with particular variable and does not affect the other variables. We are unable to reason out why this is happening and it looks very very freakish. One weirdness in this scenario is â?? the ASP application is called from within a weblogic portal. Could this be a bug in ASP? Any ideas? Thanks, Raga Tag: Running Access Stored Queries with Parameters Tag: 329616
  - 11
    - WRITE DATA FROM SQL TO LOCAL MACHINE Hi all, have an SQL DB which clients access via asp pages through the internet, in the case of a power outage I need to write that data automatically in the background to a txt file on their local machine, I would imagine it would involve a script of some kind. Can anyone help? Regards -- Simon Gare The Gare Group Limited website: www.thegaregroup.co.uk website: www.privatehiresolutions.co.uk Tag: Running Access Stored Queries with Parameters Tag: 329604
  - 12
    - How to capture browser closing event with Javascript Hi all, Iam trying to capture windows closing event (i.e) when the user clicks on the "X" button i want to capture that event and want to update some values in the database.I tried two methods but iam getting problems with the two methods. First,one i tried with function Unload() { if (window.event.clientX > 0 && window.event.clientY < 0) { //Browser closing } } But this method is called even when the user ic hitting the back button or refreshing the page. Second thing i tried was function Unload() { if (window.screenLeft > screen.width) { //Browser closing } else { //Browser refresh } } This works fine for browser refresh but this method is not called when the user closes the browser. Does any one know how to do this. Any urgent help will be appreciated. Thanks in advance. { Tag: Running Access Stored Queries with Parameters Tag: 329599
  - 13
    - Doubt asp / asp.net Hi everybody, I tried my best to understand asp.net, but I didnt like, I ve been programming classic asp for over 6 years, so I would like to know from you if there is any need to migrate asp pages do asp.net? All what is done with asp.net can be done with classic asp? What do you think about it? Thanks the opinions! Bye Paulo Tag: Running Access Stored Queries with Parameters Tag: 329598
  - 14
    - Dealing with script timeout hi guys, i was wondering how you deal with script timeouts caused by huge file uploads. Lets say I have a script timeout of 2 minutes and the user uploads a file which takes more than this ... Whats the best way to inform the user about this issue rather than throwing the script timeout error. What approaches do you use for this.... Tag: Running Access Stored Queries with Parameters Tag: 329593
  - 15
    - Issue with Greater Than IF Statement When using the following statement, I am encountering a problem: <% If rs.Fields(0) = "Lead 30 Day" THEN %> <% IF rs.Fields(2) > "89" THEN %> Pass <% ELSE %> FAIL <% END IF%> <% End If %> rs.Fields(2) is a numerical value, in this case 100. For some reason, the page is still displaying "Fail" for the record, even though 100 is obviously larger than 89. Any ideas on why it would think 100 is less than 89? Tag: Running Access Stored Queries with Parameters Tag: 329587
  - 16
    - ADODB.Stream 'format error: not a pdf or corrupt' only on large file I use the code below to authorise the download of certain files. Thus, instead of linking to the file in a wwwroot directory, I link to this code with the filename as a parameter, and the script streams the file if the user is authorised. This has worked fine on PDFs, DOCs, XLS, etc. until today, and 18MB file presents the error message 'format error: not a pdf or corrupt'. Is there a file size limit, or a default that needs overridden? Any thoughts? Cheers. The Code: <%@ language="javascript"%> <% if (Session("UserID") == 0) { Response.Redirect("notauthorized.asp"); } else { Response.ContentType = "application/x-unknown"; var fn = Request.QueryString("fn"); // Response.Write(fn); // Response.End(); // fn = "ecpa_efficacy_minutes_08_11_06.pdf" var FPath = "E:\\Inetpub\\irac-online.org\\documents\\" + fn; Response.AddHeader("Content-Disposition","attachment; filename=" + fn); var adoStream = Server.CreateObject("ADODB.Stream"); adoStream.Open(); adoStream.Type = 1; adoStream.LoadFromFile(FPath); Response.BinaryWrite(adoStream.Read()); adoStream.Close(); adoStream = null; Response.End(); } %> Tag: Running Access Stored Queries with Parameters Tag: 329583
  - 17
    - How to calculate web page loading time on client ? Hi All, How to calculate web page loading time on client and send back result to server side ? Urgent ! Thanks alot ! >From Kelvin Tag: Running Access Stored Queries with Parameters Tag: 329581
  - 18
    - Reading dropdown values in ASP Hi all, I have an ASP application where I need to not only read the selected item from a combo box on a web page but also all the options in the combo box. Can someone point me in the right direction. I can obviously use request.querystring() or request.form() to get the selected value but not sure about how to get the options. TIA Martin Tag: Running Access Stored Queries with Parameters Tag: 329580
  - 19
    - numbering with asp i need some one to help me how to do numbering with asp. for example if i want to display 10 titles in a page and the others shown on the next pages.i.e 1.2.3.4.5 etc. thanks for quick response. -- panda_asp ------------------------------------------------------------------------ Posted via http://www.codecomments.com ------------------------------------------------------------------------ Tag: Running Access Stored Queries with Parameters Tag: 329574
  - 20
    - Need Help with CDONTS Here the sample code, it fails on the attachment retrieving the file. The file is located on a remote server. The folder is Shared & Web Shared with EveryOne having Full access to the shared folder. I can pull the file from other ways, dropping the full path in the Run of Windows, Using Outlook to send an e-mail with the file attached I get one of those Unspecified error messages. By the way this code works if the file is local. I need to access the file from the remote location. <script language="VBScript"> public function testMsg() Dim objNewMsg' as Message Dim ObjAttach' as Attachments Dim objOutbox Dim sName Dim sPath sName = "220010.PDF" sPath = "\\NTGDOCPP04\wwwroot\dcv2_reports\temp\dmadmin_28-MAR-2007\220010.PDF" Dim objSession Set objSession = CreateObject ("CDONTS.Session") objSession.LogonSMTP "Lopes,James", "james.m.lopes@accenture.com" Set objOutbox = objSession.GetDefaultFolder(2) ' CdoDefaultFolderOutbox Set objNewMsg = objOutbox.Messages.Add("The Send Message" ) Set ObjAttach = objNewMsg.Attachments.Add(sName, 1, sPath) 'logText_js("Passed testMsg function ") end function </script> Tag: Running Access Stored Queries with Parameters Tag: 329570
  - 21
    - What is the problem actually? Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. /PROJECT/edit.asp, line 39 <%@ LANGUAGE="JAVASCRIPT" %> <% var refer = String(Request.ServerVariables("QUERY_STRING")); var Item2 = refer.substring(3); var MM_connInviTT_STRING; MM_connInviTT_STRING = "Provider=Microsoft.JET.OLEDB.4.0;Data Source=C:/Inetpub/wwwroot/PROJECT/Record.mdb" var Conn = Server.CreateObject("ADODB.Connection"); Conn.Open(MM_connInviTT_STRING); var sql="SELECT * FROM aktiviti WHERE activity = '" + Item2 + "'"; var rs=Server.CreateObject("ADODB.Recordset"); rs.Open(sql, Conn); if (Request("btnEdit") == "Update") { var prog= Request.Form("prog"); var bulan=Request.Form("bulan"); sql_update="UPDATE aktiviti SET bulan='"+bulan+"', activity='"+ prog +"' WHERE refer='"+Item2+"'"; Conn.Execute(sql_update); rs.Close(); rs = null; Conn.Close(); Conn = null; Response.Redirect("editNdelete.asp"); } %> <html><head><title>Update Detail</title></head> <body background="pics/red.bmp"> <br><br><br> <FORM METHOD="POST" ACTION="editNdelete.asp"> <table border=12 align="center" cellpadding=20 bgcolor="#ffcccc"> <tr><td colspan=2><p><b><font color="#0000FF"><h2><center>MAKLUMAT</center></h2></font></b></p> </td></tr> <tr><td> <table align="center" cellspacing=15 bgcolor="#ffcccc"> <tr><td>KOD</td><td>: <% Response.Write(rs.fields.item("refer"))%> </td></tr> <tr><td>BULAN</td><td>: <input type="text" name="bulan" size="2" VALUE="<% =rs.fields.item("bulan")%>"> </td></tr> <tr><td>PROGRAM</td><td>: <input type="text" name="prog" size="20" VALUE="<% =rs.fields.item("activity")%>"> </td></tr><tr><td colspan=2 align="center"><INPUT TYPE="Submit" NAME="btnEdit" VALUE="Update"></td></tr> </td></tr></table> </td></tr></table> </FORM> </body> </html> Tag: Running Access Stored Queries with Parameters Tag: 329563
  - 22
    - replica watches Tag: Running Access Stored Queries with Parameters Tag: 329557
  - 23
    - VERY odd classic ASP problem on 2005 upgrade I'm seeing a VERY odd issue after moving my data from a SQL2000 DB to a SQL2005 DB. About half the time, when I request a value (using ors.fields("pagedata") for instance), I get nothing returned. I know there's data in the field, and I'm on the correct RS object. Sometimes, when I move the call to another portion of the page, I get the data (while on the same RS object). I need to move to a new server running 2005, and folks are starting to chomp at me. Help! I've never seen anything vaguely like this. Thanks, Elliott Roberts Tag: Running Access Stored Queries with Parameters Tag: 329554
  - 24
    - checkboxes and other form inserts into a database Hello experts, I need a hand. On my asp submit page I have the following code: [code] for i = 1 to 5 ' 5 question form' Question = Request.Form("Q" & i) Answer = Request.Form("A" & i) Comment = Request.Form("C" & i ) ValComment = Replace(Comment, "'", "''") ValAnswer = Replace(Answer, "'", "''") checkbox = Request.Form("check") checkbox = Split(checkbox,", ") ----------------------------------------------------------------------------------------- Set oConn = Server.CreateObject("ADODB.Connection") oConn.Open "removed for security reasons" set sSQL = server.CreateObject ("ADODB.Recordset") set sSQL1 = server.CreateObject ("ADODB.Recordset") -------------------------------------------------------------------------------------------- IF........somthing here in the checkbox = STRUGGLING HERE please help sSQL = "INSERT into Table (ID, Question, Answer, Comments, TimeStamp, UserID)" sSQL = sSQL & "VALUES (Test_seq.nextval, '" & Question &"', '" & checkbox &"', '" & ValComment &"', sysdate, '"& User & "')" Else sSQL1 = "INSERT into table (ID, Question, Answer, Comments, TimeStamp, UserID)" sSQL1 = sSQL1 & "VALUES (Test_seq.nextval, '" & Question &"', '" & ValAnswer &"', '" & ValComment &"', sysdate, '"& User & "')" response.write ssql1 & "<BR>" End IF Next response.end [/code] Note: just the bulk of the code has been added so that you get an idea of what it is that I am talking about. On my html form I have a combination of dropdownlists and combo boxes. The checkboxes all have the same name. It is basically 1 question checkbox with the ability to choose 5 answers. I have a total of 5 questions(1 checkbox question and 3 drop downs and 1 textbox. What I am struggling with is how do I get the answers from the checkboxes into the database as well as the other form elements. If it is much easier to not parse the comma separated list then so be it:) Thanks everyone. Tag: Running Access Stored Queries with Parameters Tag: 329549
  - 25
    - how to read cell data line by line from excel using vb script in macro? I had created a macro to read data from an excel sheet and write the values to a text file. I had used "ActiveSheet.Range("GB" & k).Value" command to read the values from the excel. The issue is: some cells in the excel sheet is having two lines value and four lines data, the text file is generating that value in a single line. (Ex. the cell value in address column is in four lines and should display in four lines in the text file generated from the macro) Can i do something in the excel sheet or in vb script to read the address value line by line and write line by line in text file??? Please help me........ Regards, Ashok Tag: Running Access Stored Queries with Parameters Tag: 329546

Hi. I am working with classic ASP. I'd like to transfer al my hard coded sql
queries to access stored queries and use them with parameters. Actually, I
did not find any strong information how to do that. Please, provide me
official information, or give me at least one example of using it(with
Select statement or other). Thanks a lot in advance .
Michael

Top

Re: Running Access Stored Queries with Parameters by Bob

Bob
Thu Apr 05 05:57:32 CDT 2007

Michael wrote:
> Hi. I am working with classic ASP. I'd like to transfer al my hard
> coded sql queries to access stored queries and use them with
> parameters. Actually, I did not find any strong information how to do
> that. Please, provide me official information, or give me at least
> one example of using it(with Select statement or other). Thanks a lot
> in advance . Michael
http://groups.google.com/group/microsoft.public.inetserver.asp.db/msg/b3d322b882a604bd

http://groups.google.com/group/microsoft.public.inetserver.asp.db/msg/7d6e8544e2fd6889?oe=UTF-8

http://groups.google.com/group/microsoft.public.inetserver.asp.db/msg/c966c9c8eb98f331?hl=en&lr=&ie=UTF-8&c2coff=1

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Top