Error Too few parameteres expect 1

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
    - Web Bulletin for ASP 1.0 Released. Sunwest Technologies is pleased to announce the availability of Web Bulletin for ASP, a server-side component for easy creation of bulletin board in a web browser. The bulletin board can be used to display news, events and messages. * The messages can be specified by an XML file or through COM interface * Fading and scrolling effects are provided * All major browsers are supported * Can be used FREELY For more information on Web Bulletion, please visit http://www.SunwestTek.com/wb Sincerely, Sunwest Technologies, http://www.SunwestTek.com Tag: Error Too few parameteres expect 1 Tag: 265480
  - 2
    - POS Cash Drawer with Internet Explorer? Hi, I'm getting tasked with writing an ASP application deployed throughout the company's intranet where all the workstations will be running Internet Explorer 6.0. It's a retail business, and some of the workstations are Point-Of-Sale and will need to have cash drawers and bar-code scanners. The project managers want this as a web-application because of the ease of deployment and updates to the other stores. The problem is, I don't know how to activate the cash drawers from within IE. Is there any kind of ActiveX control which can be plugged into IE to allow control over the cash drawer from within IE? We don't have the cash drawers purchased yet, and are waiting to find out if anyone makes an ActiveX plug-in control and cash drawer which will work from IE. Suggestions and recommendations would be greatly appreciated. Thanks, Scott Tag: Error Too few parameteres expect 1 Tag: 265478
  - 3
    - ASP.NET on a DomainController I'm developing an ASP.NET app that uses ActiveDirectory. To demo this, I've built a notebook as a Win2000 DomainController with IIS. To my pleasant surprise this actually worked - at least until I patched it the other night. Now I get nothing but security violations (access denied), with no usefull indication as to what security I've violated. I'm using 'impersonate' mode and I'm logged in as the admin of the only Domain. I can get this working with .NET 1.0 and an un-patched DC, but I need to upgrade it to .NET 1.1 which requires patches that will introduce the security problems. I've tried modifying the Machine.Config to use 'SYSTEM' rather than 'machine' as the processed, this didn't do it. Does anybody have a hint on what security settings need to be tweeked to get this to work? Thanks, Randy Tag: Error Too few parameteres expect 1 Tag: 265457
  - 4
    - is there anyone from microsoft IIS group, please! Hi i am searching for anyone from IIS /ASP team.please contact me or lave me a message here or email me. Regards Bogomil Tag: Error Too few parameteres expect 1 Tag: 265446
  - 5
    - Help converting short php script to ASP I've got this PHP script working on one of my sites and now need an ASP version for my intranet. I don't know ASP, can anyone help out? Know of anyway to NOT have a blank browser window open when clicking on the link or even a better solution to prevent spam harvesters? <? // email.php // usage: // // <A HREF="email.php?to=me&domain=mydomain.com">E-Mail Me</a>--> // // if (!isset($to)) //if(!isset($_GET['to'])) { // $_GET['to'] = "info"; $to = "info"; } if(!isset($domain)) { //$_GET['domain'] = "mydomain.com"; $domain = "mydomain.com"; } // $to = $_GET['to']; // $domain = $_GET['domain']; $email_address = $to."@".$domain; // send email header to page header ("Location: mailto:$email_address"); ?> Tag: Error Too few parameteres expect 1 Tag: 265445
  - 6
    - Number format problems with SUM and AVG Hie everybody, I have a problem with the following, I have a table with a row containing numbers with 2 decimal places. I want to count the sum of these numbers but my valuw returned is far to high. I think the SUM string doesn't look at the decimal place. The same is with the AVG string Here are the ones I tried : set rs = db.execute("Select SUM(ePrize) from tbleventinfo") if rs.EOF = false then aveprize = Formatnumber(rs.fields.item(0),2) else aveprize = 0 end if set rs = Nothing and set rs = db.execute("Select AVG(ePrize) from tbleventinfo") if rs.EOF = false then aveprize = Formatnumber(rs.fields.item(0),2) else aveprize = 0 end if set rs = Nothing Can anybody help me allong the way?! Thanks in advance, Willem-Jan Selen Tag: Error Too few parameteres expect 1 Tag: 265408
  - 7
    - Auto refresh asp Hi All, I want to refresh a page every 5 mins without the users' intervention. I'm not sure that this is possible at all. Do you? Thanks in advance. Abe. Tag: Error Too few parameteres expect 1 Tag: 265382
  - 8
    - How to display in any lanaguae hi, Guys..... I am Making A website....in asp Now my data is stored in Sql Server.... What i want is to display the Data as per Languaue the user selects.. The data stored in sql server is english if the user selects French in asp site the data from the backend should be displayed in FRench... or based on ip address and location automatically the Data....sholud be Displayed according to The REgional...settings.. ie guy logging on from japan sholud see data in japanense.. can this be done or what? Please help me out... regds, Navin Mahindroo Tag: Error Too few parameteres expect 1 Tag: 265370
  - 9
    - problem with creating a database in win xp hallo i have to do a code in ASP that including this code: set c=server.createobject("adodb.connection") c.open "dsn=MyDSN;" c.execute "create table first_tables(Name char, Tel char)" and i am geting that error: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E09) [Microsoft][ODBC Text Driver] Cannot modify the design of table 'first_tables'. It is in a read-only database. /1.asp, line 4 what can i do? thanks zeev j Tag: Error Too few parameteres expect 1 Tag: 265366
  - 10
    - ASP class-session variable Hiya - Big puzzler for me. Code Below I create a class. I save it to a session variable. Then, I retrieve the session variable back into a new local variable. I am able to use a method which prints the name "Joey." Works great. But if I retrieve the same session variable into a local variable from a different page, I cannot use the method. It fails. Even though the session variable is an object, and the local variable is an object! Why? How can I get to this class from the second page? thanks <% dim oTest set oTest= new clsEmployee oTest.EmployeeName="Joey" set session("sessionTest")= oTest set oTest= nothing 'This section works fine------------------------------ 'But not from another page! dim oNewTest set oNewTest = session("sessionTest") Response.Write "<br>Is oNewTest an object? " & isObject(oNewTest) Response.Write "<Br>" Onewtest.PrintEmployeeName --------------------------------------- Class clsEmployee Private m_strEmployeeName Public Property Get EmployeeName EmployeeName = m_strEmployeeName End Property Public Property Let EmployeeName (strEmployeeName) m_strEmployeeName = strEmployeeName End Property Sub PrintEmployeeName Response.Write EmployeeName End Sub End Class %> Tag: Error Too few parameteres expect 1 Tag: 265358
  - 11
    - clientside events I want to validate client entries into textbox,checkbox controls etc. can u do this with asp. Like, is there onchange and onclick and so on for these controls? is there a reference for this in the sripting help? Tag: Error Too few parameteres expect 1 Tag: 265356
  - 12
    - client-side WSH in ASP Dear all, The following code is used to show installed printers on a computer,it works on server machine,however, if use a client machine to browse, it also shows the intalled printers on the server machine.Actaully, what i want to do is to show what printers installed on your own machine (that means show it on client-side). Do you guys understand my problem?Please help please help, this problem has already existed for a long time, i really need your help! <% Dim WshNetwork, objPrinters, i Set WshNetwork = server.CreateObject("WScript.Network") Set objPrinters = WshNetwork.EnumPrinterConnections For i = 0 to objPrinters.Count - 1 Step 2 response.write objPrinters.Item(i+1) & "<br/>" Next %> Thanks a lot!! Karen Tag: Error Too few parameteres expect 1 Tag: 265350
  - 13
    - string variable - weird error - help me!!!! hi, I have a variable which has lots of text (html code more specifically) assigned to it. What I need to do is to strip away large chunks of it from the beginning and end of it. I need to recognise some div tags as the beginning and end of the string and to throw everything else away. I have no guarantees that the surrounding text will be the same each time it is used. So does anybody know how to seek out and find some characters and strip everything before it and then to find a closing tag and strip everything after it. The problem I am currently having is a puzzling one, if i strip away text from a hard coded variable, everything gets posted to my database just fine, however when i try it on my form retrieved string variable my start position is always '0', indicating that the text i am seeking has not been found. My theory is that the search will not read new lines, and is only reading the very first line of text from the string and nothing else. Does anybody know if this is a correct theory, and if so how I can get my search coding to go onto the next line? any help would be greatly appreciated Tag: Error Too few parameteres expect 1 Tag: 265348
  - 14
    - stopping users registering with the same username? Hi, i've got a asp page to register a user and check that the username has not been previously registered, heres the code i have ... that doesnt work <SCRIPT LANGUAGE=vbscript RUNAT=server> 'Adds a record to the table Dim SQL 'A variable for the SQL statement Dim ObjConn 'A connection varaible Dim ObjRS Set ObjConn = Server.CreateObject("ADODB.Connection") Set ObjRS = Server.CreateObject("ADODB.Recordset") rsSQL = "SELECT * FROM tblUsers WHERE strUser='" & Request.Form("strUser") & "' " SQL = "INSERT INTO tblUsers " SQL = SQL & "(strUser, strPwd, strEmail) " SQL = SQL & "VALUES ('"& Request.Form("strUser") & "', '" & Request.Form("strPwd") & "','" & Request.Form("strEmail") & "')" ObjRS.Open rsSQL, "DSN=Project" If ObjRS.RecordCount > 1 Then Response.Redirect ("retry.html") Else ObjConn.Open "DSN=project" ObjConn.Execute SQL End If ObjConn.Close Set ObjConn = nothing Response.Redirect("ok.html") </script> i am going the right way about it? if so where have i gone wrong? if not could someone please point me in the right direction any help is appeciated Regards Tag: Error Too few parameteres expect 1 Tag: 265344
  - 15
    - string manipulation problem - Replace Hi all, I'm new to ASP so this is probably a problem caused by me.... but here goes. I have been pulling some information from an access database (specifically a postcode) eg. GL3 2SD, I need to swap the space " " for an plus sign "+" and have been trying to use this code - <%Dim ModPostCode If GetPropertiesRecordset.Fields.Item("AddressPostCode").Value <> "" Then ModPostCode=GetPropertiesRecordset.Fields.Item("AddressPostCode").Value Replace(ModPostCode, " " , "+") =ModPostCode%> Some other html........ <%End If%> But I get this Error - Microsoft VBScript compilation (0x800A0414) Cannot use parentheses when calling a Sub /searchresults.asp, line 354, column 31 Replace(ModPostCode, " " , "+") I have tested all the lines to make sure that the data is OK and in the variable 'ModPostCode', I just can't get the Replace command working... Any ideas... anyone... please.... Cheers Coz. Tag: Error Too few parameteres expect 1 Tag: 265341
  - 16
    - ASP.NET hi, i have a datagrid in a page. when i sort by a column, the postback occurs, so i get the old version of the page availbale in the brower back button. I want to hide the page from the back button when it is in the postback status. i want to hide the page from the back button of the browser so when i sort the grid, i want the new result (response) to replace the current link in the browser back button. can this happen? thank you Tag: Error Too few parameteres expect 1 Tag: 265338
  - 17
    - 500 Internal Server Error Hi all, Just wondering if you could possibly check this site for me - www.gtfasteners.co.uk . I am getting a 500 Internal Server Error message every time I try to log in, however I have set all file permissions related to the login as read,write and execute. Username = user Password = fasteners2003 I don't know all that much about ASP yet as I am learning, but I have managed to get the site working fine on my localhost using IIS. But when the site is uploaded to the remote server, 1&1 Microsoft package, I get the errors. Any help is much appreciated. -- Regards, Chris. http://www.chrisf.has.it http://www.lascoronas10.has.it http://www.boro.rules.it http://www.chrisfuni.has.it Tag: Error Too few parameteres expect 1 Tag: 265329
  - 18
    - DateAdd does not work Dear Lord, I'm trying to code a drop down for a date entry that gives the user the option of the current date plus the dates of the last 7 days. <% for i = -7 to -1 Response.write "<option>" & DateAdd(d,i,Date()) & "<option>" next %> Besides this, even the following code generates an error: Today=Date() Response.write DateAdd(d,5,Today) your guidence is sought, oh great one. amen Tag: Error Too few parameteres expect 1 Tag: 265318
  - 19
    - Easy vAlign question Below is my code. It seems that no matter what I do, I cannot get the following list of places to start at the top of the cell. It is always centered in the middle of the cell. Is vAlign the correct command for it to start listing at the top of the cell? Response.Write "<TABLE BORDER=""1"">" Response.Write "<TABLE WIDTH=150>" Response.Write "<TD vAlign=top>" Response.Write "<TR><TD>" & "<FONT face=""Arial"" size=1>"& "<Ahref=DurbanSuburbs.asp>" & "Central Durban" & "</A>" Response.Write "<BR>" & "<FONT face=""Arial"" size=1>" & "La Lucia" Response.Write "<BR>" & "<FONT face=""Arial"" size=1>" & "Umhlanga Rocks" Response.Write "<BR>" & "<FONT face=""Arial"" size=1>" & "<A href=KZNBerea.asp?link=Mount_Edgecombe>" & "Mount Edgecombe" & "</A>" Response.Write "<BR>" & "<FONT face=""Arial"" size=1>" & "Glenashley" Response.Write "<BR>" & "<FONT face=""Arial"" size=1>" & "Durban North" Response.Write "<BR>" & "<FONT face=""Arial"" size=1>" & "North Beach" Response.Write "<BR>" & "<FONT face=""Arial"" size=1>" & "South Beach" Tag: Error Too few parameteres expect 1 Tag: 265315
  - 20
    - Trying to find the author of a script I use a script to force the browser to save instead of displaying a simple text file. I downloaded the script some time ago and I don't remember where I got it from. Does anyone recognize this script and if so, do you know the author of this script: ------------------------------------ <% ' Constants for Reading Text File Const ForAppending = 8 Const ForReading = 1 Const ForWriting = 2 Const TristateFalse = 0 Const TristateMixed = -2 Const TristateTrue = -1 Const TristateUseDefault = -2 ' File System Objects Dim FSO Dim TS ' Server File (this is the REAL name of the file) Dim strFile: strFile = Server.MapPath("mybas1.bas") ' File to Save As (this is the name you want to tell the browser) Dim strFileSave: strFileSave = "mybas2.bas" ' Tell Browser what the file name is, so it doesn't try to save as "default.asp" Call Response.AddHeader("Content-Disposition","attachment; filename=""" & strFileSave & """") ' Write out content-type that will FORCE user to SAVE FILE. ' "image/gif" will display in browser Response.ContentType = "bad/type" ' Initialize File System Object Set FSO = Server.CreateObject("Scripting.FileSystemObject") ' Open TextStream for Reading Set TS = FSO.GetFile(strFile).OpenAsTextStream(ForReading,TristateTrue) ' TS.ReadAll DOES NOT WORK. Every Byte must be read and written individually. ' I think you can read them in Chucks, but this was easier. If you know how to ' Read chunks... go ahead, read chunks ;) Do While Not (TS.AtEndOfStream) ' Output MUST be BinaryWrite Response.BinaryWrite(TS.Read(1)) Loop ' Cleanup, like all good programmers do. TS.Close Set TS = Nothing Set FSO = Nothing ' You don't need this, but I like it. Response.End %> ------------------------------- Many thanks in advance, Arguich811 Arguich811*digitalice*com Tag: Error Too few parameteres expect 1 Tag: 265313
  - 21
    - What is this ?? Hi guys, can anyone explain line number 5 to me. i don't quite understand what is going on there and why. 1 <script language="vbscript" runat="server">sub Application_OnStart 2 getcustomers 3 end subsub getcustomers 4 set conn=Server.CreateObject("ADODB.Connection") 5 conn.Provider="Microsoft.Jet.OLEDB.4.0" 6 conn.Open "c:/webdata/northwind.mdb" 7 set rs=conn.execute("select name from customers") 8 Application("customers")=rs.GetRows 9 rs.Close 10 conn.Close 11 end sub</script> also what is the meaning of the key word set here. is it an array? is it a connection ( i ask this cos it gets "closed" later in line 9) also i presume that customer would need to be declared somewhere as... dim customers(aNumber). am i correct? if so, how would i be sure that the size given to the "customers" array would be big enough? is there such thing as an array that can hold any number of elements in ASP? thanks guys. Liza Tag: Error Too few parameteres expect 1 Tag: 265311
  - 22
    - Cannot connect to WORD and OUTLOOK anymore after upgrade! Please help.. Thanks in advance. When running from a remote machine, I was quite able to server-side create COM connections to WORD and OUTLOOK while using the VB Studio.Net 2002 version using the following style of coding. Dim myObj as New Windows.Application Now, after upgrading to VB Studio.Net 2003, I get a very basic error message "Cannot create ActiveX Object" when trying to access the same application. When accessing it locally, everything runs fine. It MUST be some security/rights thing. I have tried all possible combination of setting the IIS security for the application on the server, but there are so many options, I thing I am running in circles. PLEASE, can anyone give me some advise? What have changed betwen versions 2002 and 2003 and what can I do to correct it? Much appreciated Heinrich Braasch Tag: Error Too few parameteres expect 1 Tag: 265308
  - 23
    - Where can i find images ?? Can anyone tell where i can get very professional and sophisticated images for my web sites ( even if i have to pay for them ) thanks. Liza Tag: Error Too few parameteres expect 1 Tag: 265278
  - 24
    - how to install Asp script on other server Dear sir, My client asked me to write a small ASP application for them. I have finished the job, however, I am now having a problem during the delivery. This application needs to be installed on > 3 servers. My client will do the installation themselves. Inside my application, there is a MS SQL database, I bought a component, this component is used by asp script. To enable schedule, this application requires a task on windows task scheduler as well. So, I have a database, a component, a scheduled taks, how can I combine them into one package and make it very easy for my client to install it?? Any help will be appreciated. -- Met vriendelijke groet, Guoqi Zheng Pampus 120 2036 TC, Haarlem The Netherlands Tel: 0647556397 Tag: Error Too few parameteres expect 1 Tag: 265269
  - 25
    - Beginner question new to the world of asp! I'm trying to define session variables using the following code: Session("Employee")= [value] when i replace the Session with Application, the value is available across all the pages, but the session variables are only available on the page i declare them. Is this a coding or a server issue? Thanks Chris Tag: Error Too few parameteres expect 1 Tag: 265268
- Next
  - 1
    - RichEdit Dear All, How could I Add RichEdit to my Text Area to allow the user to edit his email (Like The Compose Page In HotMail). Thanks alot in advance Shery Tag: Error Too few parameteres expect 1 Tag: 265264
  - 2
    - instantiating the ASP.DLL Is there a way to do a CreateObject("") on the ASP.DLL? TIA Chris Tag: Error Too few parameteres expect 1 Tag: 265260
  - 3
    - ASP pages & possible permissions corruption We're running windows 2000 server with IIS 5.0. We're trying to execute .asp scripts but we keep getting the 500 (internal server) error. It looks like the permissions might be corrupted. When I go to the folder in question, go to properties >> security and look at the user groups, for several seconds they say this: S-1-1-0 S-1-5-18 S-1-5-32-544 Then the above numbers turn into the group names (everyone, administrator, etc.). The end result is that no .asp code can be executed, but other scripts (such as ColdFusion scripts, sorry) are working fine. Our website as a whole is functioning properly. Months ago I applied the IIS Lockdown Tool and ever since I've had to jockey the permissions around. Earlier in the week I had IIS prompt me for username/password to access public pages. When I went to the permissions menu, it hesitated and then opened. When I retried the pages after adjusting the permissions, I was able to access them again. Any suggestions, reference? Thanks. Tag: Error Too few parameteres expect 1 Tag: 265257
  - 4
    - referrer id How can I learn where my visitor came from? I mean which site reffered to my site? (Something called referrer id/ip) Thanks in advance.. Evrim Tag: Error Too few parameteres expect 1 Tag: 265255
  - 5
    - Calendar Control Example Would anyone have an example of using the MS Calendar control (class MSCAL.Calendar.7) and ASP? Help apprecaited. Thanks. Frank *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: Error Too few parameteres expect 1 Tag: 265254
  - 6
    - Insert error :: must be updateable? I am picking up the following error message which is strange as it has only started happening since I have transferred servers: Microsoft JET Database Engine error '80004005' Operation must use an updateable query./admin/news1.asp, line 59 sql1 = "INSERT INTO [News] (strDate,Department,Title,ShortDescription,strContent) VALUES (" & strDate1 & ",'" & strDepartment1 & "','" & strNewsTitle1 & "','" & strShortDescription1 & "','" & strDescription1 & "')" Set rsnews = data.execute(sql1) Set rsnews = Nothing Tag: Error Too few parameteres expect 1 Tag: 265247
  - 7
    - Pass prameter from a page to another Hi, I have a page that calls a multiple frames page (ASP). I need to send parameters from the first to the multi frames page. If sending to a simple page, it works. If sending to multiple frames page, it does not. -- Thank you, Doru Tag: Error Too few parameteres expect 1 Tag: 265235
  - 8
    - HTTP Error 507 I keep getting the following error with my website : ---------------------------------------------------------- HTTP Error 507 507 Unexpected The Web server encountered an unexpected error while communicating with the ASP service. Please contact the server's administrator if this problem persists. ----------------------------------------------------------- I'm using ASP to exchange information with a database. After the above has happened my session variables have all lost their values. It happens at random at different locations in the website, sometimes only seconds after running the site, sometimes I'm good for a few minutes. I have no trouble at home. I've contacted my Host and they say : "I'm not sure why you are getting that error, as I checked the logs and the ASP server has been up and running. One option is I could move you to a different server to see if that helps. I also asked around to see if anyone else had called or emailed in about this and nobody had." - Thanks for nothing http://www.blacksun.ca/ - perhaps they can suggest a more reliable host for me to transfer my business too! Anyone else in here had a similar problem and is there a solution other than changing hosts? Thanks! Tag: Error Too few parameteres expect 1 Tag: 265232
  - 9
    - Removing a period from a string I need to remove a period from a string of data. I have a whole column of numbers that have a period distributed randomly in them, and I need a way to pull the period out. Unfortunatly, the period is not at a fixed interval from the start or from the end. Sometimes it's like this: 08307.33214 and sometimes it's like this: 66543354.2213 At any rate, I have a whole column of these in SQL Server 7.0 and need to use the number as is for some issues, but without the period for others. Can someone please show me how to write a function that will remove the period no matter where it is located in the string? Thanks! Bill Tag: Error Too few parameteres expect 1 Tag: 265230
  - 10
    - What really is ASP? Hi guys, i'm a little bit confused about ASP... am i correct in thinking that a JBScript that uses asp.dll objects is an ASP? what i mean is is an ASP a script written in ASP supported languages such as vbscript, perlscript etc. but that uses ASP.dll ojbects? also, how is the data collected from an ASP accessed? for example if i have an ASp that collects visitors' contact information, how would i access that information in order to use it? for javaScript and VBScripts, which do not make use of any server, how are information collect by the website processed or collected by the owner of the website in order to utilise the information? if i develop an ASP will i need to develop the server as well, or am i correct in thinking that the server is the IIS? (if so, how would i access the IIS database? would i need to create a separate ASP to retrieve collected information?) is there a difference between perl and perlscript? thanks a lot guy !! Liza Tag: Error Too few parameteres expect 1 Tag: 265215
  - 11
    - ColorChooser in HTML Hi! I'm making a web editor in html, an i would like to have a colochooser control, in ActiveX or something similar. Can anybody help me?? Thanks Tag: Error Too few parameteres expect 1 Tag: 265209
  - 12
    - ColorChooser in HTML Hi! I'm making a web editor in html, an i would like to have a colochooser control, in ActiveX or something similar. Can anybody help me?? Thanks Tag: Error Too few parameteres expect 1 Tag: 265208
  - 13
    - embed object and no DL to browser cache i know this can be done, but i just couldn't figure out how. can someone give me a hint or somthing? it's a asp web application, and i need to use html tag "embed" to put a pdf document on a web page. but i don't want the visitor to download the embeded file. visitor can only view it in browser and the embeded file will never sent to visitor's browser cache. so, what's the tricks that i should do at server side to accomplish this? ray Tag: Error Too few parameteres expect 1 Tag: 265207
  - 14
    - Query / mySQL / Access Hi, I've got a query that works fine when used in mySQL but completely fails when I try to apply it to MS Access, weird thing is that it is just a copy of a stored procedure that works fine in the same copy (with the Request.QueryString replaced by a fixed value) ! Any explaination would be great, ID is a number BTW : SELECT page_title,ID,page_content FROM content WHERE ID='" & Request.QueryString("ID") & "' ' Had a look at aspfaq.com but couldn't find anything that applys. Cheers John Tag: Error Too few parameteres expect 1 Tag: 265203
  - 15
    - SQL db doesnt support the Cookie This is a multi-part message in MIME format. ------=_NextPart_000_0011_01C34D50.1C072AA0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I wrote the code for Members of Register. and i use cookie in this = code, My database is SQL server. SQL server dosent support the cookies = in my codes i dont know why this cause but my codes are working without = any cause=20 can anybody advice me thanks=20 ------=_NextPart_000_0011_01C34D50.1C072AA0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2479.6" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>I wrote the code for Members of = Register.=20  and i use cookie in this code, My database is SQL server. SQL = server=20 dosent support the cookies in my codes i dont know why this cause but my = codes=20 are working without any cause </FONT></DIV> <DIV><FONT face=3DArial size=3D2>can anybody advice me thanks=20 </FONT></DIV></BODY></HTML> ------=_NextPart_000_0011_01C34D50.1C072AA0-- Tag: Error Too few parameteres expect 1 Tag: 265195
  - 16
    - Radio button group I have a simple html page with a radio button group on it. I am submitting that page into an asp page. How do I know what button the user has checked? Thanks Tag: Error Too few parameteres expect 1 Tag: 265187
  - 17
    - MSXML : i want to get the resultant HTML in a variable Hi All i m transforming a simple XSL file on Server side using MSXML Parser ... and writting resultant HTML directly on browser .. is there any way to get this HTML in a variable ??? i seen the article on MSDN but it makes my page blank ... plz edit my code to make is work in this manner, if possible Thankx in advance Plz Help 'MY ASP FILE CODE strxml = "<data><name>Asim</name></data>" XSLFilePath = "C:\Emaples\test.xsl" call TransformDocument(strXMl,XSLFilePath) function TransformDocument(srcXML, srcXSL) Dim sourceFile, styleFile, source 'the xsl file path styleFile = srcXSL set source = Server.CreateObject("MSXML2.DOMDocument") source.async = false source.loadXML srcXML 'Get The Style Object set style = Server.CreateObject("MSXML2.DOMDocument") style.async = false style.load styleFile 'Error Handaling if (source.parseError.errorCode <> 0) then 'result = reportParseError(source.parseError) set oerr = source.parseError sErrMsg = "XML Parsing Error. File: " & oErr.url & " Reason : " & oErr.reason & " Line: " & oErr.line & ", Character: " & oErr.linepos & ", Text: " & oErr.srcText Response.Write sErrMsg elseif (style.parseError.errorCode <> 0) then 'result = reportParseError(style.parseError) set oerr = style.parseError sErrMsg = "XML Parsing Error. File: " & oErr.url & " Reason : " & oErr.reason & " Line: " & oErr.line & ", Character: " & oErr.linepos & ", Text: " & oErr.srcText Response.Write sErrMsg else source.transformNodeToObject style,Response end if End Function 'MY XSL FILE CODE <?xml version="1.0" encoding="utf-8"?> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0"> <xsl:output method="html" version="4.0" encoding="utf-8"/> <xsl:variable name="name">??!</xsl:variable> <xsl:template match="data"> <html> <head><META http-equiv="Content-Type" content="text/html; charset=utf-8"/></head> <body> <hr/> Name from XML is : <xsl:value-of select="//name"/> <hr/> Variable/Contant Value from XSL is : <xsl:value-of select="$name"/> </body> </html> </xsl:template> </xsl:stylesheet> Tag: Error Too few parameteres expect 1 Tag: 265186
  - 18
    - Permission denied error Hello I have the following configuration: - Windows 2000 Adv Server - IIS is running on this machine - I have some ASP scripts and a global.asa file In the the global.asa file (in the Application_OnStart section) I create an instance on a COM object (in fact it is a Windows service that has a COM interface (the corresponding Windows service is running)). The code of this section of global.asa: Sub Application_OnStart Set Application("ComObject") = Server.CreateObject("ComObject.Interface") End Sub One of my ASP script is called every second by another application and this ASP script calls one of the COM object's methods. The code of this ASP script is: result = Application("ComObject").Method Most of the time this is working fine, but sometimes this ASP generates an error 500 page and I have the following error in the IIS log files: 800a0046|Permission_denied:_'Application(...).Method' The strange thing is that for a few days this error does not happen and suddenly this error occurs very often (up to every 10 seconds). I have tried several things but this error always occurs. Thanks in advance *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: Error Too few parameteres expect 1 Tag: 265173
  - 19
    - Still problems with my menu... Hi again! now I realy have a problem.. I want om make a menu that expandes like the menu on http://www.eks.as The menu should expand after a sertain ID in the querystring. The page you are on should be bold.. The code works fine exept when I pass a ID that belongs to a "child" in the menu.... Any idea??? here's what I got so far.... <html> <head> <title>default.asp</title> </head> <body> <% ' Connection to the database / Datenbankverbindung Dim ConnectString, conn ConnectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("../../Documents and Settings/All Users/Dokumenter/portal.mdb") Set conn = Server.CreateObject("ADODB.Connection") conn.open ConnectString %> <%DIm ID ID = Request.Querystring("id") %> <% 'Henter kategorier Dim sqlMeny, rsMeny sqlMeny = "SELECT * FROM Meny ORDER BY ID ASC" Set rsMeny = Server.CreateObject("ADODB.Recordset") rsMeny.Open sqlMeny, conn, 3, 3 do until rsMeny.Eof If rsMeny("parent") = 0 Then %> <%= rsMeny("Navn") %><br> <% Else End If If CInt(rsMeny.Fields("ID").Value) = CInt(ID) Then 'Henter kategorier Dim sqlUnder, rsUnder sqlUnder = "SELECT * FROM Meny WHERE Parent = "& rsMeny("id") &" ORDER BY ID ASC" Set rsUnder = Server.CreateObject("ADODB.Recordset") rsUnder.Open sqlUnder, conn, 3, 3 do until rsUnder.Eof %> --<%= rsUnder("Navn") %><br> <% rsUnder.MoveNext Loop Else End If %> <% rsMeny.MoveNext Loop 'disconnect conn.close Set conn = Nothing %> </body> </html> Christopher Brandsdal Norway Tag: Error Too few parameteres expect 1 Tag: 265172
  - 20
    - checkbox I know this is gonna sound silly but when I submit a form with a checkbox html control "mychk", how can I see if that is checked or not ? I have tried : if request.form("mychk") = true then ' code else ' code end if But it always executes the code in the else statement meaning it is never true despite the fact I have given the checkbox a value of true. Tag: Error Too few parameteres expect 1 Tag: 265165
  - 21
    - Authentication with NT Users Hi, Can someone tell me how I create a login page which authenticates users against the servers user manager. I want the login to be a form in my website not a pop up window! I would be grateful for any advice relating to this subject. I am currently running IIS 5 on a windows 2000 member server. Thanks for any help! Tag: Error Too few parameteres expect 1 Tag: 265118
  - 22
    - The Ultimate HTML Search Script. But.......! A year or two back I needed a search script to scan thru HTML files on a client site. Usual sorta thing. A quick search turned up a neat script that provided great search results. It was fast, returned the hyperlinked page title, filename, and the body txt (30 preceding and following words) in context with the search word highlighted. Excellent.! See it working at: http://www.ipt.co.za Just search for "firearm" I now need to use it on a different site but I've run into two limitations which made it unsuitable. It will only search the root folder of a domain and won't cascade the search down through sub- folders. Hmmmm. Pity. Checked the code but couldn't modify it successfully. Aah well, look elsewhere..... After hours and hours of scouring through the script sites I began to realise what a lucky find that original script was. Almost everything new that seemed promising either had major limitations, presented poor results or just would not work properly. And, most importantly, none of them offered that *excellent* feature where the search term was displayed embedded in the context. I now believe that this is a great script that needs two modifications: 1. The ability to be pointed to a sub-folder of a domain as the starting point for the search. But, as a compromise, this could also be achieved as the folder in which the script itself is lying. 2. The ability for the search to cascade on through sub-folders lying below the folder in which the search is initiated. It would also be great if the original casing for the page title and context could be preserved but that really isn't a critical issue. Maybe one could even specify the file extensions for searching to speed things up. Suggestions would be greatfully received.! Please can somebody out there help with some ideas as to where this script can be modified to provide these functions. I'm sure this would an excellent resource for the ASP community and it certainly fits my requirements. Here's hoping ...... code follows below.! TIA .les. Durban South Africa ------------< clip: code to launch results.asp starts >------------ <FORM NAME="frmSearch" METHOD="GET" ACTION="results.asp"> <table border=1 width=175 bordercolor="#336633" cellspacing=0><tr><td align=center background="green.gif" bgcolor="#009900"><div align=center> <font color="#FFFFFF"><b> search IPT </b></font></div></td></tr><tr><td align=center ><div align=center><br><img src="clear.gif" width=1 height=4> <INPUT NAME="boolean" TYPE="hidden" VALUE="AND"> <INPUT NAME="selSearchWhere" TYPE="hidden" value=""> <INPUT NAME="terms" TYPE="TEXT" VALUE=" Search IPT Here" SIZE="14" onFocus=clearfield() TITLE="Enter the keyword to search on here!"> <INPUT TYPE="SUBMIT" VALUE="find"></div><img src="clear.gif" width=1 height=4> </td></tr></table> </FORM> ------------< /clip: code to launch results.asp ends >------------ ------------< file: results.asp starts >------------ <%@ Language=VBScript %> <% Option Explicit %> <html> <head> <TITLE>Search IPT</TITLE> <SCRIPT LANGUAGE="javascript" src="jAvAsCrIpTs.js"></SCRIPT> <link rel="stylesheet" href="ipt.css"> <title>http://www.ipt.co.za</title> </head> <body background="bg.jpg" bgcolor="#FFFFFF" link="#006600" alink="#006600" vlink="#006600" marginwidth=0 marginheight=0 topmargin=0 leftmargin=0 bottommargin=0 rightmargin=0> <% Dim myCounter If Request.QueryString("myCounter") <> "" Then myCounter = Request.QueryString("myCounter") Else myCounter = 1 End If %> <% Function FormatURL(strPath) 'Cut off everything before wwwroot and replace all \ with / Dim iPos iPos = InStr(1,strPath,"wwwroot",1) Dim str str = Mid(strPath,iPos+7,Len(strPath)) FormatURL = Replace(str,"\","/") End Function Function RemoveHTML( strDesc ) Dim RegEx Set RegEx = New RegExp RegEx.Pattern = "<[^>]*>" RegEx.Global = True strDesc = Replace(LCase(strDesc), "<br>", chr(10)) RemoveHTML = RegEx.Replace(strDesc, "") End Function Function GetFiles(objFolder, aLookFor, strLF, bolLFFound,bolAnd, iCount) If Left(objFolder.Name,1) = "_" then exit function Const iListPerPage = 9 if iCount > iListPerPage then Exit Function 'Now, loop through each file Dim objFile, objTextStream, objFSO, strContents, iUBound, iLoop, bolValid Dim strTitle, iPos, strDesc iUBound = UBound(aLookFor) For Each objFile in objFolder.Files on error resume next 'What file to search, if u change the .htm remember to cahange 4 to correpond If (Right(objFile.Name,4)) = ".htm" then 'If Ucase(Right(objFile.Name,6)) = ".SHTML" or Ucase(right(objFile.Name,4)) = ".ASP" then If bolLFFound then if objFile.Size > 0 then Set objFSO = Server.CreateObject("Scripting.FileSystemObject") Set objTextStream = objFSO.OpenTextFile(objFile.Path,1) strContents = objTextStream.ReadAll strContents = LCase(strContents) 'get the page title then remove all HTML tags iPos = InStr(1,strContents,"<title>") Dim iWhere, iLength, DescPosition, DescLast If iPos = 0 then strTitle = "Untitled (" & objFile.Name & ")" Else strTitle = Mid(strContents,iPos+7,InStr(iPos,strContents,"</title>")-iPos-7) End If strContents=RemoveHTML( strContents ) objTextStream.Close Set objFSO = Nothing if bolAnd then bolValid = True else bolValid = False For iLoop = 0 to iUBound If InStr(1,strContents,aLookFor(iLoop),1) then if Not bolAnd then bolValid = True Else If bolAnd then bolValid = False End If Next If bolValid then iWhere = InStr(strContents,strKeywords) iLength = 200 if iWhere > 0 then if iWhere < 200 then iLength = iWhere-1 strDesc = mid(strContents,iWhere-iLength,iLength) & mid(strContents,iWhere,200) 'strDesc = mid(strContents,iWhere-iLength,iLength) & mid(strContents,iWhere,200+len(strKeywords)) strDesc=Replace(strDesc, "<", "<") strDesc=Replace(strDesc, ">", ">") strDesc=Trim(strDesc) strDesc = Mid( strDesc, InStr(strDesc," ") + 1 ) strDesc = Left( strDesc, InStrRev(strDesc," ") - 1 ) strDesc=Replace(strDesc, strKeywords, "<font class=highlight><b>"&strKeywords&"</b></font>") end if Response.Write "<font size=-1><b>" & myCounter & ". <a href=""" & objFile.Name & """>" & _ strTitle & "</b></a><font size=1>  (" & objFile.Name & ")</font><br>" & vbCrLf Response.Write "<div class=results><font size=-1>" & strDesc Response.Write "</font></div><br>" & vbCrLf strDesc = "" strTitle = "" myCounter = myCounter + 1 iCount = iCount + 1 End if If iCount > iListPerPage then strLF = FormatURL(objFile.Path) exit function End If End If Elseif FormatURL(objFile.Path) = strLF then bolLFFound = True End If End if Next 'Dim objSubFolder 'For Each objSubFolder in objFolder.SubFolders ' GetFiles objSubFolder,aLookFor,strLF,bolLFFound,bolAnd,iCount 'Next End Function 'Search the site get keywords and take the first word! Dim strKeywords strKeywords = Request("terms") strKeywords = LCase(strKeywords) strKeywords = trim(strKeywords) do while InStr(1,strKeywords," ") If InStr(1,strKeywords," ") Then strKeywords = Left( strKeywords, InStrRev(strKeywords," ") - 1 ) End If loop 'Split the terms on spaces Dim termsArray termsArray = split(strKeywords," ") 'Set the boolean search option Dim bolAnd If Request("boolean") = "AND" then bolAnd = True else bolAnd = False Dim section section = Request("selSearchWhere") 'Get the dirs to search If section = "ipt" then section = Server.MapPath("/") else section = Server.MapPath("/") end if 'What page are we on? Dim strLastFile strLastFile=Request("lf") Dim objFSO, objFolder Set objFSO = Server.CreateObject("Scripting.FileSystemObject") Set objFolder = objFSO.GetFolder(section) Set objFSO = Nothing %> <blockquote> <table width="550" ><tr><td> <br> <center><font size=+2><b> IPT Search Results For "<% =strKeywords %>" </b></font><br><form name="frmSearch" method="GET" action="results.asp"> New Search: <input name="boolean" type="hidden" size="20" value="AND"> <input name="selSearchWhere" type="hidden" size="20" value=""> <input name="terms" type="text" size="20" title="Enter the keyword to search on here!"> <input name="submit" type="button" value="Search!"> </form> </center> <p> <center> <a href="index.htm" >home</a> | <a href="schools.htm" >schools</a> | <a href="police.htm" >police</a> | <a href="Government.htm" >government</a> | <a href="hiv_aids.htm" >HIV/Aids</a> | <a href="public.htm" >publications</a> | <a href="staff.htm" >staff</a> | <a href="services.htm" >services</a> | <a href="links.htm" >links</a> | <a href="contact.htm" >contact</a> </center> <hr><p> Below are the results of your search in no particular order... <p> <p> <% Dim iResults iResults = 0 'Now, recurse the directories If Len(strLastFile) = 0 then GetFiles objFolder,termsArray,strLastFile,True,bolAnd,iResults Else GetFiles objFolder,termsArray,strLastFile,False,bolAnd,iResults End If Set objFolder = Nothing If iResults = 10 then 'Show next page link %> <center> <p><hr><p><b> <a href="results.asp?terms=<%=Server.URLEncode(strKeywords)%>&boolean=<%=Request("boolean")%>&selSearchWhere=<%=Request("selSearchWhere")%>&lf=<%=Server.URLEncode(strLastFile)%>&myCounter=<%=myCounter%>"> Next 10 results...</b> </a></center> <p> <% Elseif iResults = 0 then %> <b>No results found!</b><br> <% Elseif iResults < 10 then %> <center> <p><hr><p> <b><form name="frmSearch" method="GET" action="results.asp"> New Search: <input name="boolean" type="hidden" size="20" value="AND"> <input name="selSearchWhere" type="hidden" size="20" value=""> <input name="terms" type="text" size="20" title="Enter the keyword to search on here!"> <input name="submit" type="button" value="Search!"> </form> </center> <% End IF %> <hr><p> <center> <a href="index.htm" >home</a> | <a href="schools.htm" >schools</a> | <a href="police.htm" >police</a> | <a href="Government.htm" >government</a> | <a href="hiv_aids.htm" >HIV/Aids</a> | <a href="public.htm" >publications</a> | <a href="staff.htm" >staff</a> | <a href="services.htm" >services</a> | <a href="links.htm" >links</a> | <a href="contact.htm" >contact</a> </center> <div align="right"> <p><font size=1>All material © Copyright Independent Projects Trust 1990-2002</font></p> </div> </tr></td></table> </blockquote> </body> </html> ------------< /file: results.asp ends >------------ =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Les Juby Webpro Internet / Prosoft Microsystems Durban, KwaZulu-Natal, South Africa webpro@webpro.co.za Tel: +27 (31) 563-8344 Fax: +27 (31) 563-1684 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o Les Juby lesjuby@anti-spam.iafrica.com Webpro Internet - - - Prosoft Microsystems Durban, KwaZulu-Natal, South Africa P.O.Box 35243, Northway 4065, South Africa Tel: +27 31 563-8344 Fax: +27 31 564-4928 o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o (you *do* know to take "anti-spam" out the address....? Tag: Error Too few parameteres expect 1 Tag: 265117
  - 23
    - Read PFD file from ASP - Search Engine Can someone tell me how to read the contents of a PDF file from an ASP page? I am trying to create a search engine that displays PDF files and Docs as links in an ASP page once the search request is submitted. Thanks, SV Tag: Error Too few parameteres expect 1 Tag: 265110
  - 24
    - Command.Timeout option All, I am using ADO to connect to a database to get some data that I then display on my web page. I build the entire script in ASP code the finally use response.write to get the web page itself When I create the connection object set objConn = Server.Create.Object("Server.Command) objConn.Timeout = 90 Even thought I set the time out to 90 seconds the time out occurs in 30 seconds. And this is pain as I have some large queries returning some 100K records. Is there any other way of increasing the timeout Is it a Registry setting on IIS? Thanks Jawahar Tag: Error Too few parameteres expect 1 Tag: 265107
  - 25
    - Calling a Visual Basic Component Subroutine from ASP Not sure if this is the right group for this but anyways... I've got an ASP web application that uses a Visual Basic component to do some work. I instantiate the component in asp and then attempt to call the subroutine. The subroutine is actually invoked maybe 2 out of 10 times run. What could possibly be the reason for this?? Why the inconsistency in running the subroutine? Cheers Tag: Error Too few parameteres expect 1 Tag: 265091

Works fine.

Recid = rs("id")
SQLstmt = "SELECT * FROM courses WHERE ID=" &
Request.QueryString("Recid")

When i combine two tables

SQLstmt = "SELECT tblAuthor.employee_code, tblAuthor.name,
Courses.status, Courses.ID, Courses.mdate, Courses.InstructorID, FROM
tblAuthor INNER JOIN Courses ON tblAuthor.employee_code =
Courses.InstructorID WHERE Course.ID=" & Request.QueryString("Recid")

i get Too few parameteres expect 1
is it a syntax error?

Top

Re: Error Too few parameteres expect 1 by Aaron

Aaron
Mon Jul 21 12:55:17 CDT 2003

> i get Too few parameteres expect 1
> is it a syntax error?

Tough to tell. SHow us what

response.write SQLstmt

yields...

Top

Re: Error Too few parameteres expect 1 by Ray

Ray
Mon Jul 21 13:04:05 CDT 2003

Do you have a querystring value for the "recid" key?

Ray at work

"wildt" <wildtfree48@yahoo.com> wrote in message
news:f69f166d.0307210954.4e055ff9@posting.google.com...
> Works fine.
>
> Recid = rs("id")
> SQLstmt = "SELECT * FROM courses WHERE ID=" &
> Request.QueryString("Recid")
>
> When i combine two tables
>
> SQLstmt = "SELECT tblAuthor.employee_code, tblAuthor.name,
> Courses.status, Courses.ID, Courses.mdate, Courses.InstructorID, FROM
> tblAuthor INNER JOIN Courses ON tblAuthor.employee_code =
> Courses.InstructorID WHERE Course.ID=" & Request.QueryString("Recid")
>
> i get Too few parameteres expect 1
> is it a syntax error?

Top

Re: Error Too few parameteres expect 1 by jbongran

jbongran
Thu Jul 24 10:28:56 CDT 2003

"wildt" <wildtfree48@yahoo.com> a écrit dans le message de
news:f69f166d.0307210954.4e055ff9@posting.google.com...
> Works fine.
>
> Recid = rs("id")
> SQLstmt = "SELECT * FROM courses WHERE ID=" &
> Request.QueryString("Recid")
>
> When i combine two tables
>
> SQLstmt = "SELECT tblAuthor.employee_code, tblAuthor.name,
> Courses.status, Courses.ID, Courses.mdate, Courses.InstructorID, FROM
> tblAuthor INNER JOIN Courses ON tblAuthor.employee_code =
> Courses.InstructorID WHERE Course.ID=" & Request.QueryString("Recid")
>
> i get Too few parameteres expect 1
> is it a syntax error?

Is it a typo ?
WHERE Course.ID where it should be WHERE Courses.ID
Are you sure Recid is always populated ?
Do a
Response.Write "<b>SQLstmt :</b>" & SQLstmt & "<br>" & vbCrLf
Response.Flush

Top