Execute SQL Select Statment Error

I'm getting this useful error '80040e14' when trying to run a select statement in an ASP page. The connection to SQL Server 2000 is ok. The variables in the Select statement, 'area' or 'areaid' are passed through form the previous page ok.The code is below... Any ideas? Is it something obviously dense on my part?? Code:

View Replies


ADVERTISEMENT

Embed A SELECT CASE Statement In An IF Statment

i have a select case statement that checks for a couple of options e.g.

<%select case aParameters(0)
case 0 %>

.. some code

<%case 2 %>

however i would like to test for a certain condition within the select cases statment. To see if a session variable exists before implementing some code:

View Replies View Related

Selecting Multiple Tables Using SELECT Statment Problem

I am Trying to use the SQL SELECT Statment to open records from multiple tables into one recordset.

I know the basic syntax of the Select statment but I wanted to know if its possible to recive the table name from the feild or the record that I am readinf from the recordset in any given moment.

To make things more clear, my example:

-Open a connection

SQL = "SELECT * FROM TABLE1,TABLE2 WHERE TABLE1.UserID=" & uid & " And TABLE2.UserID=" & uid

rs.open sql,conn,3,3

while not rs.EOF

-read from record

rs.movenext
wend
rs.close
conn.close

now, in the part that I read from the record, is their any way I can know if that record is from table1 or table2?

View Replies View Related

Update Statment & Error :: Microsoft JET Database Engine Error '80040e14'

I keep getting an error when I try to run this update statment: [CODE]

INSERT INTO MYPosts ( IEname, country, server_name, LANIPAddy, license_ver, wrkstn1, wrkstn2, wrkstn3, wrkstn4, wrkstn5, notes, status, rdse, esc, eso, parent, , timezone, ) VALUES ( '" & lcIEname & "', '" & lcCountry & "', '" & lcServerName & "', '" & lcLicenseVer & "', '" & lcwrkstn1 & "', '" & lcwrkstn2 & "', '" & lcwrkstn3 & "', '" & lcwrkstn4 & "', '" & lcwrkstn5 & "', '" & lcNotes & "', " & lcStatus & ", " & lnRDSE & ", " & lcESC & ", " & lcESO & ", " & lcParent & ", " & lcTimeZone & ")"


I get the following error:

Microsoft JET Database Engine error '80040e14'

Syntax error (missing operator) in query expression

View Replies View Related

Cmd.execute Select SQL?

What is the proper format for my SQL str using command.execute? Even though
I know I have matching data in my table, I keep coming up with a
..RecordCount of -1. What am I doing wrong? Code:

View Replies View Related

Error With SQL Statment

What is wrong with this statment:

SQL = "SELECT tblEmployee.*, tblDepts.deptdesc, tblEmployee.Inactive FROM tblEmployee INNER JOIN tblDepts ON tblEmployee.DeptID = tblDepts.deptid WHERE " & request.form("txtSearchIn") & " LIKE '%%" & request.form("txtSearch") & "%%'" & " ORDER BY LastName, FirstName"

I am getting a error:

Syntax error (missing operator) in query expression 'LIKE '%%%%''.

View Replies View Related

Sever.Execute Error

Whenever i try to accecc HTML page through server.execute, i got this error.

Server object error 'ASP 0228 : 80004005'

Server.Execute Error

server.execute("/folder1/htmls/" & strfilename & "_1.html")

The call to Server.Execute failed while loading the page.

View Replies View Related

Execute Access Forbidden Error

I am currently running IIS 5.1, Windows XP Pro with service pack 2. When I try to run an ASP page I get an error saying that 403.1 Execut Access Forbidden - IIS. There are no firewalls up and running. I hav given permission and access to everything, every folder that I can thin to give access to. Obviously I must be missing somethin somewhere. anyone have any ideas for me??? The execute permission have been set to scripts only. I have also tried scripts an executables.

I also have a box that I run the same asp pages on and the onl difference that I can find is that I am running Windows XP Pro wit service pack 1. I don't have any problems executing ASP on this box. I have tried to mirror all the setting from box to box and stil nothing.

View Replies View Related

Error-checking And Query-results After Execute

After commands like:

tmpDBconn.Execute("DELETE * FROM mytable WHERE rc_id = 10" )
How do I check for errors?
Is there a way to check the results?

OR:

Set rsCatCount = tmpDBconn.Execute("SELECT COUNT(*) FROM cat WHERE key_id = 10 AND cat_id = 6")

How do I get the count? Do I use rsCatCount(0)?

View Replies View Related

ASP Will Still Execute Code After Run-time Error Has Detected?

The following code has run-time error on "divide by 0" error. I expect
"do the work<br>" will not print in the browser, since it happen after
the code that cause the error. However, this is the output: any ideas why?? Or
this is the nature of ASP scripting language that is being executed in
sequential order? Code:

View Replies View Related

Error Using <select></select>

I have written some code which should dynamically build a table which is then populated with questionas and possible answers. The format of the answers will vary ie they may be in the form of a radio button which will be rated from 1-5, checkbox or a selectbox.

The first problem I have is if I do not comment out <select></select> I get an error message saying the page can not be found. when I do take it out I get asp timeout. Code:

View Replies View Related

Error In Select Statement Using Where And Between

Find below the error I get when the code below is executed

Code:

splitval = split(request.form("start")," ")
dep = splitval(0)

splitval1 = split(request.form("end")," ")
dep1 = splitval1(0)

"SELECT * FROM Info WHERE requestDate BETWEEN dep AND dep1 "

error:
No value given for one or more required parameters.

Can someone help correct the error in the code.

View Replies View Related

Error With SQL SELECT Query

I am trying to run an SQL SELECT query, however, I am experiencing some problems with it.

It is coming up with the error; " Microsoft VBScript compilation error '800a0401'

Expected end of statement "

It is pointing to line 46 which is highlight in bold within my code below; is the error coming up because of the way I have formatted the query?

strSQL = "SELECT * FROM tbl_lunch WHERE (((tbl_lunch.Type)="general")) ORDER BY tbl_lunch.Type;"
Thanks for any help you may be able to give me on this

View Replies View Related

Select Case Error

Using keyword "To" in select case giving error.The following code is got from www.microsrosoft.com itself. What is the wrong with this?.

<%
Dim Number1
Number1 = 7 ' Initialize variable.
Select Case Number1 ' Evaluate Number1.
Case 1 To 5 ' Number1 between 1 and 5, inclusive.
Response.Write( "Between 1 and 5" )
' The following is the only Case clause that evaluates to True.
Case 6, 7, 8 ' Number1 between 6 and 8.
Response.Write( "Between 6 and 8")
Case 9 To 10 ' Number1 is 9 or 10.
Response.Write( "Greater than 8")
Case Else ' Other values.
Response.Write( "Not between 1 and 10")
End Select
%>

View Replies View Related

Select Case Syntax Error

I'm getting a syntax error with a Select Case statement:

Select Case CSng(rs.fields("Field1"))
Case 0
Response.Write "Test1"
Case Is < 0 <<< Syntax Error
Response.Write "Test2"
Case Is > 0 <<< Syntax Error
Response.Write "Test3"
End Select

As far as I can tell the syntax *is* correct. What am I missing?

View Replies View Related

Select Query Database Error

I have created a query and everytime I try to run it I get this error:

Microsoft JET Database Engine error '80004005'
Record is deleted.
/vsadmin/inc/incsearch.asp, line 162

This is the query: Code:

View Replies View Related

Type Mismatch Error With SELECT...FOR UPDATE Statement

ASP error number 13 - Type mismatch with SELECT...FOR UPDATE statement. I got ASP error number 13 when I use the SELECT...FOR UPDATE statement as below. However, if I use SELECT statement without FOR UPDATE, it is fine and no error. I also tried Set objRs = objConn.Execute("SELECT * FROM EMP UPDATE OF EMPNO"), but it still couldn't help.

Here's the code fragment: ....

View Replies View Related

Object Error After "objConn.execute(sql)"

after "objConn.execute(sql)" the page got error how can i show the error? there is an Object error?

View Replies View Related

IF Then Statment

i need help with this simple IF then statment.
i want to do this
Code:

IF
response.write objrs ("ok2show") = y
THEN
<img src="http://auditors.demosales.netauditimages<%Response.Write objRS("cnum") %>.bmp" alt="Demonstrator" width="800" height="600"border="7" >
ELSE
<img src="http://auditors.demosales.netauditimagesdefaultimage.jp g"

it's not working it's getting hung up at the response.write objrs part.

View Replies View Related

Sql In Statment

I have an sql statment with an in statment for ID . I'm trying to get the CompanyID in ( ) but all i get is just the word companyID with no value . i used response.write request.form("companyID") so i know the value is coming to the other page, this is what i have now.

Response.Write ("& CompanyID & ")

and this is what i see
& CompanyID &

how do i get the value of companyID in ().

View Replies View Related

Asp Sql End Of Statment

what is missing fromt his sql statment its for an asp page that displays a list of results?

rs.Open "SELECT * FROM downtime WHERE downtime.Entrydate = #" & mediumdate&"# AND Supervisors_name<>"none"", conn,1

i get a message saying expected end of statment and it worked up until i added the AND Supervisors_name<>"none" in to the statment?

View Replies View Related

Error Server.Transfer / Server.Execute ()

Any one has Idea, How to use Server.Transfer and Server.Execute, When I tried to use these methods I got an eror:

Server object error 'ASP 0230 : 80004005'
Server.Transfer Error
/SISWeb/portal_logon.asp, line 40
The call to Server.Transfer failed while loading the page.

anybody is there who can respond to this problem. Do I need to change any setting at IIS?

View Replies View Related

SQL Statment Variables

I am trying to pass a variable from another page to a sql statment. The variable specifies the one of the columns that I want the sql query to return. I also want to display field contents of the column later in my page. I can't seem to get this to work. Can someone give me a hand? Here is my code:

View Replies View Related

Update Statment

i have this variable:

name="Jones, andrew"

when i update the table it gives an error

here is my update code:

str= "UPDATE tblnames SET Name = '" & name & "' WHERE Id ='" & getid & "'"

can someone tell me whats wrong with it because the name variable has a comma in it.

View Replies View Related

Problem Regarding Asp /sql LIKE Statment

I'm not an hardcore programmer but i try to do a simple search in my asp pages.

I've a database .

I've try this code:

rs.Open "SELECT titre , sstitre , carac , gastro , historique , cepage FROM catalogue WHERE titre , sstitre , carac , gastro , historique , cepage LIKE '"&Request.Form("Sstring")&"'" , conn

But i've that's generate an error in my explorer...

View Replies View Related

Reuse Of A SQL Statment

I have a sql statement that pulls up a certain amount of records according to a requirement. Let's say that 20 records show up. I want to get to the 5th one. Well now I know that I can use the move() function to enable that, but it is the same page.

The page executes the sql statement and by default shows the last record in the query. Now when I ask for the 5th record the page is reloaded, the sql statement exectures AGAIN and the 5th record shows up. Is there way to ask for the 5th record without having to re-executing the SQL statement?

View Replies View Related

ASP/Access SQL Statment

Given the following that results from a form which has multiple checkboxes with the same name value, the resulting string when stored into a variable is this - 129,200,323,330 I used the replace function and got this - 129 OR 200 OR 323 OR 330.

I want to somehow use these values (ints) to specify the particular records in an access database and populate a record set.

When I do this, I get nowhere - "Select * From images WHERE id=" & img_ids
Whereas img_ids is the above string...

View Replies View Related

Database Statment

I've got the following statment in my website:

<%
if session("memberId") = objrs.fields("memberId") then
%>Some Id<%
else
%>Different Id<%
end if
%>

The problem is, if boths are the some number it still displaing Different Id.

Is there anyone can tell me what am I doing wrong?

View Replies View Related

Insert Statment

Now here is my insert statment and it is giving me this error message:

Insert Record
'strSQL2 = "INSERT INTO tblCONTENT_Links (LinkID, ContentOwner_UserGroupID, ContentGrouping, LinkHeaderOrder, LinkDescription, LinkName, LinkURL, LinkHeader, LinkHeaderCategory, LinkRefSite, Active, Archive, UpdatedDate, UpdatedBy, PasswordProtected, CommonLibrary) values ( 141, 7,'public', " & Category & " ,'" & DocumentName & "','" & DocumentTitle & "', '" & Document & "', 0 , 28 , 'www.skyclimber.com', -1 , 0 , #8/27/2004# , 0 , 0, -1)"

IE error:

Syntax error in INSERT INTO statement.

View Replies View Related

What Is Wrong With My If Statment

I'm using the following code on my website:

if left(session("lastPage"), 5) <> "admin" then
session("return") = session("lastPage")
else
session("return") = ""
end if

My problem is even the "left(session("lastPage"), 5) is equal to "admin" it still not equal the variable session("return") to "". Can anyone please tell me why or what Im doing wrong?

View Replies View Related

If Statment For A Field

how i would go about using an if statment against a field in a database.

i.e

if id = "fieldname"
then
do this
else
do this
end if

I am still learning asp and would be very greatful if someone could help me.

View Replies View Related

Order By Statment

I am hoping that some one can tell me how to add an ORDER BY statement to the following:

<% set rst = createobject("adodb.recordset")
set rst = conn.execute("select RegClassID, StartDateTime, EndDateTime, Description, Location, SpecialNotes from CAL_EVENTS_REG_CLASSES where RegistrationID = "&RegistrationID)
if not rst.eof then %>

The recordset returns fine, execpt I need to be able to order it ASC

View Replies View Related

Dynamic Sql Statment?

im trying to write a sql statment that will insert a variable number of fields into a database the code below is what i want to do but i know this wont work anyone any ideas?
or even if this can be done?


sSQL = "INSERT INTO sometable("&For Each field In Request.Form ; "&Field&"," next ; &")values"('" "&For Each field In Request.Form ; "&Request.Form(Field) &"','" next ; &""')"

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved