when i try to write a procedure in asp file i get error message, Please explain whats wrong in my coding?
<%
CREATE PROCEDURE ProcedureName_1 AS
select * from table1
%>
Error message:-
Microsoft VBScript compilation error '800a0401'
Expected end of statement
/sixsigma/installation_region.asp, line 2
CREATE PROCEDURE ProcedureName_1 AS
I'm looping through the source code of an HTML page, looking for links, grabbing the source of those links and saving each one in turn to an HTML page on disk.
This is working fine about 70% of the time, but sometimes it falls over when I try to write the source code as a text file to disk: Code:
My system is on a NT4 (w/SP6a) running IIS 4. I am developing a page that query one record from my Oracle DB 8.1.6 on a separate machine. I am using the MS ODBC for Oracle drive. In my ASP page I have (Connection object has been crreated.) then..
View Replies View RelatedI'm writing a asp file dynamically. The code works 70% or the time. It pulls info from access and creates the file -- for some reason though some characters (and I see nothing different about these) causes the following error on the line objfile.writeline
What can I do?
error is:
Microsoft VBScript runtime error '800a0005'
Invalid procedure call or argument
I am trying to run an example code from a book. However I am getting the following error message:
Number: -2147217900
Description: Syntax error or access violation
Source: Microsoft OLE DB Provider for SQL Server
SQLState: 42000
NativeError: 0
The following is the code that is being used in the asp page:....
I have a script that opens a file and writes to it using ASP. I've used the script before and it worked fine locally, until recently, after I upgraded my computer to Windows XP Pro SP2. Also, it still works fine when I upload the script to my web host. However, locally on my computer using IIS, I get the error:
Error Type:
Microsoft VBScript runtime (0x800A0046)
Permission denied
This occurs on the line: Set FileTS = FileFSO.OpenTextFile(Server.MapPath(".") & "" & FileName,2,TRUE)
I've searched online for answers and most articles say I have to set read and write access to the containing folder. I have done so for the containing folder and for the entire "wwwroot" folder, but the problem still occurs. I have also allowed anonymous access for my computer IUSR_XXXXX. This doesn't work either.
I have been modifying a forum I found on the web for a web site I am developing. Everythiing has been going great (www.tastytuscany.com/forum) until I yesterday when I hit a brick wall. There seesm to be an issue with the email functionality. The author wrote a "send_email" function that I just can't figure out why I keep getting this error:
Microsoft VBScript runtime error '800a0005'
Invalid procedure call or argument
/forum/admin/functions/functions_send_mail.asp, line 158
In the script for the email function, here is an excerpt of the code (he uses a select statement for various email types...) and a call to the function from a page. Might I just modify that include file with my own CDONT script? I use cdonts on other pages in the site just fine? BUT, I would really like to get this to work.. Code:
I have the following code:
<%
Sub makeSafe(theString)
theString = Replace(theString, "'", "''")
theString = Replace(theString, chr(34), chr(34))
theString = Replace(theString, "=", "-")
theString = Replace(theString, "_", "-")
theString = Replace(theString, "../", "")
theString = Replace(theString, "--", "")
theString = Replace(theString, ";", "")
theString = LCase(theString)
End Sub
%>
I then call it using Code:
thePassword = Trim(request.Form("password"))
thePassword = makeSafe(thePassword)
but i then get an error message saying Quote: Type mismatch: 'makeSafe'
I'd like to write an ASP routine that builds a table and is called when a button is clicked (not a submit button). Is there a way to do this? Everytime the button is clicked, I want to call the procedure so another table is built. Dynamically building a new table. Code:
View Replies View RelatedOk, for my company, we have two current webpages, one for general company info and one specific to a product that we market. On the 2nd page, there is a form that allows users to request a consultation from the company. When it is sent, the information is stored in an Access DB for tracking purposes.
Now, I have been requested to put this same form on the general company website. All works fine, but I can't save to the db that is stroing the info once it is submitted. Boith sites are hosted by the smae company, but they do not have (as far as I know), a shared repository for files where I could put the db.
Does anyone have any suggestions as to how I can get around this issue? What I want to do is to have the form on both sites and have the submitted data saved into the one database.
I'm not getting error messages on this one so I don't know where to start looking. I type in my data in my form and this page should check it, add it then set a flag. Code:
View Replies View RelatedI have to perform a database query and write the results to an XML
file.
I also need to form this XML file with a DTD file.
I'd like to hear some opinions on the best way to do this.
I figured out how to write out just raw XML using adPersistXML. But
that doesn't really help as the XML needs to conform to the DTD.
I also found a way to write out the XML file line by line
using .createNode and .appendChild...but that would take forever as
the database query returns 72 columns.
i need have a problem on line 86 of this code. Could anyone suggest problmes.
The bit in red is where i think the problem is, but may be wrong. it is where it says the problem is in the browser when i go to run it Code:
how to write store procedure in asp?
View Replies View RelatedI'm trying to access a stored procedure on our AS400 that is written in RPG. I know that the stored procedure works (I've called it from an RPG program on the AS400), and I know that the connection to the AS400 is good, because this same ASP page is reading data via SQL. However, when I try to call the stored procedure, I can't tell if anything is actually happening. All that I know is that the end result is not being changed, so I suspect that the procedure isn't being called correctly.
My stored procedure is used to encrypt/decrypt data. It has 3 parameters - a 1 character flag telling it whether to encrypt or decrypt, a 25 character field for the plaintext data, and a 50 character field for the encrypted data. The last two parameters are used for either input or output, depending on the value of the first
flag (if the flag is "E", then the plaintext is used as input and the program fills the encrypted data field. If the flag is "D", then vice - versa).
Here is the code where I call my stored procedure. I'm trying to decrypt data from the queryString and place it in some program variables. I'm new to ASP, and can't find any good examples for my situation, so I pieced this together from what examples I found
online. Can anyone tell me what I'm missing?
I have a problem with input parameter which has Decimal DataType. Stored procedure works but it rounds all
values, i.e 5.555 input becomes 6 and 1.3 input becomes 1.
In table QTY has data type decimal(5) - precision(8) scale(3).
Please, suggest what's wrong with this:
newqty = Request.Form("quantity")
..........
cmd.Parameters.Append(cmd.CreateParameter("qty", adDecimal, adParamInput, 5, newqty))
cmd.Parameters("qty").Precision = 8
cmd.Parameters("qty").NumericScale = 3
I've created a procedure/query in an Access 2000 database using the
following code:
<%
strAppend = "ProcName"
strSQL = "Create Procedure [qry" & strAppend & "] AS Select * From Stories
ORDER BY StoryID DESC;"
cn.execute(strSQL)
%>
I know I have successfully created the procedure/query, because when I run
the code again, it gives me the following error:
Microsoft JET Database Engine (0x80040E14)
Object 'qryProcName' already exists.
I look in the Access database and can't find qryProcName as a query, macro
or any other object.How do I access it?
this question is not about SQL exactly
so, I am asking here.
how to get output from sql procedure ?
my sql p. like below
Code:
if not exists(select .....................)
set @result=0
else
set @result=1
so, how can I get @result in ASP
i am stuck with the following error message
"Application uses a value of the wrong type for the current operation."
did anyone know the reson this occur?
just because of my store procedure....
when do u use property procedure for example
PublicProperty CompanyName() AsString
Get
Return strCompany
EndGet
Set(ByVal Value AsString)
strCompany = Value
EndSet
EndProperty
I am trying to construct a sub procedure that concects to db , executes a stored procedure and returns a recordset. Connection to db and executing the stored procedure works fine.
The problem is that when I call the sub in the asp page to be executed the recordset is refused to be returned from the sub and the recordset itself does not appear to be constructed. or in another words the error displayed is: 'object required' --> refering to my recordset --> 'rs'
I do not know why, can any one tell me the reason, I tried much but with no result.
NOTE: For testing puropses I looped through the recordset isnide the sub itself and it worked fine Code:
I populate my checkboxes in a table written in asp. Each checkbox has the same value but a different name. I want to say for checkbox in the asp table, call a procedure that will do the changes. Code:
View Replies View RelatedI have an ASP page and a Store Procedure but I keep getting this error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Procedure 'sp_searchresultsZIP' expects parameter '@xDateTo', which was not supplied. Code:
how to use LIKE in a Stored Procedure ?I can use it as "where tbl LIKE @string"but it doesn't work truly.how can I use % ' & ?you know, we use LIKE in classic asp and sql as '%"&YYY&"%'.but how can it be used in Stored Procedure ?
View Replies View RelatedWhat I'm looking to doing is having three input boxes on a page. As an example I would like for the user to input a employee ID in the first input box and then wither press enter or onblur it would call a proceedure that would get data from an access DB and display the employees first and last name in the other two input boxes.
I know the code I need to get the data from the DB but I don't know how to call the proceedure. I'm also assuming that the only way to get and display data from the input boxes is to have them in a form. Is it possible to call a asp proceedure by pressing enter or onblur?
Can I create a sub procedure in global.asa file? If YES then Will that be Local to global.asa or Global for website? And can I CALL that Sub from the Session_Onstart ?
View Replies View RelatedI have a stored procedure that I am executing with this SQL
osp_instrument_swap @InstrumentFrom = 'testname', @InstrumentIDTo = 37,
@Schedules = '593, 594, 596, 598, 599, 600, 601, 602, 603, 604, 605, 606,
607, 608, 609, 610, 611, 612, 613, 616'
the @Schedules are ID fields in a table that are integers. I would like to do an Update blah, Where ScheduleID in (@Schedules) instead of looping. How can I do this? I have to sent the values to the sproc as text, right? Where do I covert to the int data type and how?
I have to code a sub procedure to do the further processing. I dont know how to call a VBScript sub procedure on the click event of a button. I tried a lot of thing but it is not working. Can any help me out or give a me tip on how to go to subprocedure on button click on an ASP page.
View Replies View RelatedMy below given code is running 100% but now i have to pass this SQL Query from stored procedures...
I have created the stored procedure in my database and give the parameter to the student_id
can any one temme that how can i implement this stored procedure code in my given code:
why we use Stored procedure in VB/ASP? Why i am asking is we can do the same with SQL Query? What does this do the differnce?I need the main difference bet. these?
View Replies View RelatedI have the following code as a part of authenticating a system.
If Rs.eof Then
Session("Authenticated") = 0
Response.Write "Sorry, your userid or password did not match"
Response.Write "<BR>"
Response.Write "or you have not registered yet. Please register"
Response.Redirect("login.asp")
Else
Session("Authenticated") = 1
Response.Redirect ("Welcome.asp")
End If
In the first if statement, I would like to display the above messages
before forcing the login.asp page to display. Is is possible to do both
message and contents of login.asp in the same page? Thanks
how to write PDF documents from inside
of my ASP application. I understand that there are commerical APIs , SDKs that
I can use. eg. cutePDF.
i am having problems figuring out the syntax used when writing information to a database thru a dropdown.
i have a dropdown w/ all the months listed and i need this recorded into a database where i have already set up a column named "month".
right now all i have is html that says:
Code:
<select name="month">
<option value="January">January</option>
<option value="March">March</option>
<option value="April">April</option>
....... and so on.......
</select>