ASP Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Iron Speed
Go Back   ASP Free Forums > Programming > ASP Development
Reload this Page

Syntax error when inserting a record

Discuss Syntax error when inserting a record in the ASP Development forum on ASP Free.
Syntax error when inserting a record ASP Development forum discussing ASP related topics including coding practices, ASP tips, and more. Active Server Pages (ASP) enables you to empower your HTML pages dynamically with robust scripting options.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Page 1 of 2 1 2 >
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
Save your reputation with your customers. Learn how you can have embedding success with Advantage Database Server (ADS).
  #1  
Old March 26th, 2008, 11:51 AM
Rams_ Rams_ is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Feb 2008
Posts: 114 Rams_ User rank is Corporal (100 - 500 Reputation Level)Rams_ User rank is Corporal (100 - 500 Reputation Level)Rams_ User rank is Corporal (100 - 500 Reputation Level)Rams_ User rank is Corporal (100 - 500 Reputation Level) 
Time spent in forums: 16 h 31 m 31 sec
Reputation Power: 2
Syntax error when inserting a record
I am getting a syntax error although I don't think it's to do with my actual insert code. Error message and the line given has been highlighted:

Quote:
Error Type:
Microsoft VBScript compilation (0x800A03EA)
Syntax error
/style/addnewanimal2.asp, line 161
else


Code:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<head>
<title>Welcome to the Kennels Database System</title>
<link href="external.css" rel="stylesheet" type="text/css" />
</head>
<body>
<center>

<!--			MAIN TABLE	-->

<table border=0 class="tableborder">

<tr>
<td colspan=2 class="bannerborder">
<% Response.Write FormatDateTime(Date, vbShortDate)
struser=session("user")
%>
<img src="images/logo.jpg" alt="banner" class="bannerimage">
</td>
</tr>

<tr>

<td valign="top" width=20%  class="cellborder">
<p class="leftlinks">
<div id="curves">
<%
intlevel=session("level")

If intlevel=1 OR intlevel=2 then %>
Welcome, <%=struser%><br>
<% end if %>
<br>
<b class="top">
<b class="b1"></b>
<b class="b2"></b>
<b class="b3"></b>
<b class="b4"></b>
</b>

<dl id="links">

<dd>
<a href="start.asp">Main Page</a>
</dd>
<dd>
<a href="animals.asp">Animals</a>
</dd>
<dd>
<a href="customers.asp">Customers</a>
</dd>
<dd>
<a href="staff.asp">Staff</a>
</dd>
<dd>
<a href="vets.asp">Vets</a>
</dd>
<dd>
<a href="help.asp">Help</a>
</dd>
<dd>
<a href="default.asp">Logout</a>
</dd>

</dl>

<b class="bottom">
<b class="b4"></b>
<b class="b3"></b>
<b class="b2"></b>
<b class="b1"></b>
</b>

</div>
</p>
</td>
</p>
</td>

<td valign="top"  class="padded-table">
<div class="content">

<!--	84		LOGIN CHECK		-->

<%
intlevel=Session("level")

If intlevel=1 OR intlevel=2 then

Response.CacheControl = "no-cache"
Response.AddHeader "Pragma", "no-cache"
Response.Expires = -1 %>

<!--	95		CONTENT OF TABLE-START	-->

<s2>Add an animal</s2><br>
<br><br>

<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("kennels.mdb"))

' Receiving values from Form

AnimalTypeID = Request.Form("AnimalTypeID")
CustomerID = Request.Form("CustomerID")
VetID = Request.Form("VetID")
AnimalName = Request.Form("AnimalName")
Breed = Request.Form("Breed")
AnimalDescription = Request.Form("AnimalDescription")
Colour = Request.Form("Colour")
gender = Request.Form("gender")
neutered = Request.Form("neutered")
DateOfBirth = Request.Form("DateOfBirth")
LastVaccinationDate = Request.Form("LastVaccinationDate")
FeedingBrand = Request.Form("FeedingBrand")
FeedingRequirements = Request.Form("FeedingRequirements")
DateIn = Request.Form("DateIn")
DateOut = Request.Form("DateOut")
Misc = Request.Form("Misc")

'sql1 adds values in if the date in/out fields have not been completed (they are not compulsory), sql2 adds in the date in/out fields


sql1 = "insert into tblanimals (AnimalTypeID, CustomerID, VetID, AnimalName, Breed, AnimalDescription, Colour, gender, neutered, DateOfBirth, LastVaccinationDate, FeedingBrand, FeedingRequirements, Misc) 

values ("&AnimalTypeID&","&CustomerID&","&VetID&", '" & AnimalName & "', '" & Breed & "', '" & AnimalDescription & "', '" & Colour & "', _'" & gender & "', '" & neutered & "', #" & DateOfBirth & "#, #" & 

LastVaccinationDate & "#, '" & FeedingBrand & "', '" & FeedingRequirements & "', '" & Misc & "')"

sql2 = "insert into tblanimals (AnimalTypeID, CustomerID, VetID, AnimalName, Breed, AnimalDescription, Colour, gender, neutered, DateOfBirth, LastVaccinationDate, FeedingBrand, FeedingRequirements, DateIn, 

DateOut, Misc) values ("&AnimalTypeID&","&CustomerID&","&VetID&", '" & AnimalName & "', '" & Breed & "', '" & AnimalDescription & "', '" & Colour & "', _'" & gender & "', '" & neutered & "', #" & DateOfBirth 

& "#, #" & LastVaccinationDate & "#, '" & FeedingBrand & "', '" & FeedingRequirements & "', #" & DateIn & "#, #" & DateOut & "#, '" & Misc & "')"

'Checks for blank values

If AnimalTypeID="" OR CustomerID="" OR VetID="" OR AnimalName="" OR Breed="" OR AnimalDescription="" OR Colour="" OR gender="" OR neutered="" OR DateOfBirth="" OR LastVaccinationDate="" OR FeedingBrand="" OR 

FeedingRequirements="" OR Misc="" THEN

%> You did not fill in all the fields.<a href="addnewanimal.asp">Click here to go back.</a>

	elseif DateIn="" OR dateout="" THEN

	conn.execute sql1
	%>
	Customer added!<br>
	<br>
	<a href="animals.asp">Back to Animal Section</a>
	<%
		else
		conn.execute sql2
		%>
		Customer added!<br>
		<br>
		<a href="animals.asp">Back to Animal Section</a>
		<%
	end if

end if

conn.Close
Set conn = Nothing
%>
<!--			CONTENT OF TABLE-END	-->

<% else %>
You are not logged in.  Click <a href="default.asp">here</a> to return to the login page.
<% end if %>

</div>
</td>


</tr>

</table>


</body>

</html>
Reply With Quote
  #2  
Old March 26th, 2008, 08:26 PM
icywave icywave is offline
Contributing User
ASP Free Novice (500 - 999 posts)
  
Join Date: Sep 2005
Location: Global Village
Posts: 687 icywave User rank is Sergeant Major (2000 - 5000 Reputation Level)icywave User rank is Sergeant Major (2000 - 5000 Reputation Level)icywave User rank is Sergeant Major (2000 - 5000 Reputation Level)icywave User rank is Sergeant Major (2000 - 5000 Reputation Level)icywave User rank is Sergeant Major (2000 - 5000 Reputation Level)icywave User rank is Sergeant Major (2000 - 5000 Reputation Level) 
Time spent in forums: 4 Days 21 h 31 m 53 sec
Reputation Power: 31
Send a message via MSN to icywave
I don't really understand why you have a "_" before your gender field. Try this.

Code:
sql1 = "insert into tblanimals (AnimalTypeID, CustomerID, VetID, AnimalName, Breed, AnimalDescription, Colour, gender, neutered, DateOfBirth, LastVaccinationDate, FeedingBrand, FeedingRequirements, Misc) 

values ("&AnimalTypeID&","&CustomerID&","&VetID&", '" & AnimalName & "', '" & Breed & "', '" & AnimalDescription & "', '" & Colour & "', '" & gender & "', '" & neutered & "', #" & DateOfBirth & "#, #" & 

LastVaccinationDate & "#, '" & FeedingBrand & "', '" & FeedingRequirements & "', '" & Misc & "')"

sql2 = "insert into tblanimals (AnimalTypeID, CustomerID, VetID, AnimalName, Breed, AnimalDescription, Colour, gender, neutered, DateOfBirth, LastVaccinationDate, FeedingBrand, FeedingRequirements, DateIn, 

DateOut, Misc) values ("&AnimalTypeID&","&CustomerID&","&VetID&", '" & AnimalName & "', '" & Breed & "', '" & AnimalDescription & "', '" & Colour & "', '" & gender & "', '" & neutered & "', #" & DateOfBirth 

& "#, #" & LastVaccinationDate & "#, '" & FeedingBrand & "', '" & FeedingRequirements & "', #" & DateIn & "#, #" & DateOut & "#, '" & Misc & "')"
Reply With Quote
  #3  
Old March 26th, 2008, 09:01 PM
soft903's Avatar
soft903 soft903 is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
  
Join Date: May 2007
Posts: 147 soft903 User rank is Second Lieutenant (5000 - 10000 Reputation Level)soft903 User rank is Second Lieutenant (5000 - 10000 Reputation Level)soft903 User rank is Second Lieutenant (5000 - 10000 Reputation Level)soft903 User rank is Second Lieutenant (5000 - 10000 Reputation Level)soft903 User rank is Second Lieutenant (5000 - 10000 Reputation Level)soft903 User rank is Second Lieutenant (5000 - 10000 Reputation Level)soft903 User rank is Second Lieutenant (5000 - 10000 Reputation Level) 
Time spent in forums: 1 Week 2 Days 18 m 12 sec
Reputation Power: 55
Hi,

May not solve your problem but missing "<%"
Code:
If AnimalTypeID="" OR CustomerID="" OR VetID="" OR AnimalName="" OR Breed="" OR AnimalDescription="" OR Colour="" OR gender="" OR neutered="" OR DateOfBirth="" OR LastVaccinationDate="" OR FeedingBrand="" OR 

FeedingRequirements="" OR Misc="" THEN

%> You did not fill in all the fields.<a href="addnewanimal.asp">Click here to go back.</a>
<%
	elseif DateIn="" OR dateout="" THEN
Reply With Quote
  #4  
Old March 27th, 2008, 06:24 AM
Rams_ Rams_ is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Feb 2008
Posts: 114 Rams_ User rank is Corporal (100 - 500 Reputation Level)Rams_ User rank is Corporal (100 - 500 Reputation Level)Rams_ User rank is Corporal (100 - 500 Reputation Level)Rams_ User rank is Corporal (100 - 500 Reputation Level) 
Time spent in forums: 16 h 31 m 31 sec
Reputation Power: 2
I have removed the underscore and added the <% in, but same error.
Reply With Quote
  #5  
Old March 27th, 2008, 09:53 AM
icywave icywave is offline
Contributing User
ASP Free Novice (500 - 999 posts)
  
Join Date: Sep 2005
Location: Global Village
Posts: 687 icywave User rank is Sergeant Major (2000 - 5000 Reputation Level)icywave User rank is Sergeant Major (2000 - 5000 Reputation Level)icywave User rank is Sergeant Major (2000 - 5000 Reputation Level)icywave User rank is Sergeant Major (2000 - 5000 Reputation Level)icywave User rank is Sergeant Major (2000 - 5000 Reputation Level)icywave User rank is Sergeant Major (2000 - 5000 Reputation Level) 
Time spent in forums: 4 Days 21 h 31 m 53 sec
Reputation Power: 31
Send a message via MSN to icywave
Try replacing the "#"s with " ' "s. It might be a varchar field.
Reply With Quote
  #6  
Old March 27th, 2008, 09:55 AM
Rams_ Rams_ is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Feb 2008
Posts: 114 Rams_ User rank is Corporal (100 - 500 Reputation Level)Rams_ User rank is Corporal (100 - 500 Reputation Level)Rams_ User rank is Corporal (100 - 500 Reputation Level)Rams_ User rank is Corporal (100 - 500 Reputation Level) 
Time spent in forums: 16 h 31 m 31 sec
Reputation Power: 2
Well it's a date/time field and works okay using the "#"'s when updating the records, just can't seem to add new ones for some reason
Reply With Quote
  #7  
Old March 28th, 2008, 02:22 AM
micky's Avatar
micky micky is offline
Couch Potato Wizard
Click here for more information. Click here for more information
 
Join Date: Jan 2005
Location: India
Posts: 9,915 micky User rank is General 4th Grade (Above 100000 Reputation Level)micky User rank is General 4th Grade (Above 100000 Reputation Level)micky User rank is General 4th Grade (Above 100000 Reputation Level)micky User rank is General 4th Grade (Above 100000 Reputation Level)micky User rank is General 4th Grade (Above 100000 Reputation Level)micky User rank is General 4th Grade (Above 100000 Reputation Level)micky User rank is General 4th Grade (Above 100000 Reputation Level)micky User rank is General 4th Grade (Above 100000 Reputation Level)micky User rank is General 4th Grade (Above 100000 Reputation Level)micky User rank is General 4th Grade (Above 100000 Reputation Level)micky User rank is General 4th Grade (Above 100000 Reputation Level)micky User rank is General 4th Grade (Above 100000 Reputation Level)micky User rank is General 4th Grade (Above 100000 Reputation Level)micky User rank is General 4th Grade (Above 100000 Reputation Level)micky User rank is General 4th Grade (Above 100000 Reputation Level)micky User rank is General 4th Grade (Above 100000 Reputation Level)  Folding Points: 1480 Folding Title: Novice Folder
Time spent in forums: 3 Months 2 Weeks 3 Days 16 h 59 m 6 sec
Reputation Power: 1272
which is line 161??
use response.write and post the output of ur query here.
__________________
Laziness is my religion and Sunday is my God

Get the Mantra!
Reply With Quote
  #8  
Old March 28th, 2008, 06:30 AM
Rams_ Rams_ is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Feb 2008
Posts: 114 Rams_ User rank is Corporal (100 - 500 Reputation Level)Rams_ User rank is Corporal (100 - 500 Reputation Level)Rams_ User rank is Corporal (100 - 500 Reputation Level)Rams_ User rank is Corporal (100 - 500 Reputation Level) 
Time spent in forums: 16 h 31 m 31 sec
Reputation Power: 2
I highlighted the line in bold in my original post.

Response.write of both queries:

Code:
insert into tblanimals (AnimalTypeID, CustomerID, VetID, AnimalName, Breed, AnimalDescription, Colour, gender, neutered, DateOfBirth, LastVaccinationDate, FeedingBrand, FeedingRequirements, Misc) values (2,3,1, 'Lassiette', 'Moggy', 'Fiesty Feline', 'Brown', '', '', #15/02/2002#, #30/02/2006#, 'Pedigree Chummy', 'Twice a day', '')

insert into tblanimals (AnimalTypeID, CustomerID, VetID, AnimalName, Breed, AnimalDescription, Colour, gender, neutered, DateOfBirth, LastVaccinationDate, FeedingBrand, FeedingRequirements, DateIn, DateOut, Misc) values (2,3,1, 'Lassiette', 'Moggy', 'Fiesty Feline', 'Brown', '', '', #15/02/2002#, #30/02/2006#, 'Pedigree Chummy', 'Twice a day', ##, ##, '')
Reply With Quote
  #9  
Old March 28th, 2008, 08:41 AM
sync_or_swim's Avatar
sync_or_swim sync_or_swim is offline
Contributing User
ASP Free Novice (500 - 999 posts)
  
Join Date: Mar 2006
Location: South Wales
Posts: 965 sync_or_swim User rank is Colonel (50000 - 60000 Reputation Level)sync_or_swim User rank is Colonel (50000 - 60000 Reputation Level)sync_or_swim User rank is Colonel (50000 - 60000 Reputation Level)sync_or_swim User rank is Colonel (50000 - 60000 Reputation Level)sync_or_swim User rank is Colonel (50000 - 60000 Reputation Level)sync_or_swim User rank is Colonel (50000 - 60000 Reputation Level)sync_or_swim User rank is Colonel (50000 - 60000 Reputation Level)sync_or_swim User rank is Colonel (50000 - 60000 Reputation Level)sync_or_swim User rank is Colonel (50000 - 60000 Reputation Level)sync_or_swim User rank is Colonel (50000 - 60000 Reputation Level)sync_or_swim User rank is Colonel (50000 - 60000 Reputation Level)sync_or_swim User rank is Colonel (50000 - 60000 Reputation Level) 
Time spent in forums: 2 Weeks 5 Days 12 h 2 m 58 sec
Reputation Power: 569
Quote:
Originally Posted by Rams_
I highlighted the line in bold in my original post.

I couldn't see any lines highlighted in your original post, which line is 161?

I dont think the problem is caused by your sql statement, it appears to be a syntax error, post your code again with the error highlighted.
Reply With Quote
  #10  
Old March 28th, 2008, 10:41 AM
Rams_ Rams_ is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Feb 2008
Posts: 114 Rams_ User rank is Corporal (100 - 500 Reputation Level)Rams_ User rank is Corporal (100 - 500 Reputation Level)Rams_ User rank is Corporal (100 - 500 Reputation Level)Rams_ User rank is Corporal (100 - 500 Reputation Level) 
Time spent in forums: 16 h 31 m 31 sec
Reputation Power: 2
It's kind of hard to highlight, it's literally a line with just the word else on. But code again as requested

Code:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<head>
<title>Welcome to the Kennels Database System</title>
<link href="external.css" rel="stylesheet" type="text/css" />
</head>
<body>
<center>

<!--			MAIN TABLE	-->

<table border=0 class="tableborder">

<tr>
<td colspan=2 class="bannerborder">
<% Response.Write FormatDateTime(Date, vbShortDate)
struser=session("user")
%>
<img src="images/logo.jpg" alt="banner" class="bannerimage">
</td>
</tr>

<tr>

<td valign="top" width=20%  class="cellborder">
<p class="leftlinks">
<div id="curves">
<%
intlevel=session("level")

If intlevel=1 OR intlevel=2 then %>
Welcome, <%=struser%><br>
<% end if %>
<br>
<b class="top">
<b class="b1"></b>
<b class="b2"></b>
<b class="b3"></b>
<b class="b4"></b>
</b>

<dl id="links">

<dd>
<a href="start.asp">Main Page</a>
</dd>
<dd>
<a href="animals.asp">Animals</a>
</dd>
<dd>
<a href="customers.asp">Customers</a>
</dd>
<dd>
<a href="staff.asp">Staff</a>
</dd>
<dd>
<a href="vets.asp">Vets</a>
</dd>
<dd>
<a href="help.asp">Help</a>
</dd>
<dd>
<a href="default.asp">Logout</a>
</dd>

</dl>

<b class="bottom">
<b class="b4"></b>
<b class="b3"></b>
<b class="b2"></b>
<b class="b1"></b>
</b>

</div>
</p>
</td>
</p>
</td>

<td valign="top"  class="padded-table">
<div class="content">

<!--	84		LOGIN CHECK		-->

<%
intlevel=Session("level")

If intlevel=1 OR intlevel=2 then

Response.CacheControl = "no-cache"
Response.AddHeader "Pragma", "no-cache"
Response.Expires = -1 %>

<!--	95		CONTENT OF TABLE-START	-->

<s2>Add an animal</s2><br>
<br><br>

<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("kennels.mdb"))

' Receiving values from Form

AnimalTypeID = Request.Form("AnimalTypeID")
CustomerID = Request.Form("CustomerID")
VetID = Request.Form("VetID")
AnimalName = Request.Form("AnimalName")
Breed = Request.Form("Breed")
AnimalDescription = Request.Form("AnimalDescription")
Colour = Request.Form("Colour")
gender = Request.Form("gender")
neutered = Request.Form("neutered")
DateOfBirth = Request.Form("DateOfBirth")
LastVaccinationDate = Request.Form("LastVaccinationDate")
FeedingBrand = Request.Form("FeedingBrand")
FeedingRequirements = Request.Form("FeedingRequirements")
DateIn = Request.Form("DateIn")
DateOut = Request.Form("DateOut")
Misc = Request.Form("Misc")

'sql1 adds values in if the date in/out fields have not been completed (they are not compulsory), sql2 adds in the date in/out fields


sql11 = "insert into tblanimals (AnimalTypeID, CustomerID, VetID, AnimalName, Breed, AnimalDescription, Colour, gender, neutered, DateOfBirth, LastVaccinationDate, FeedingBrand, FeedingRequirements, Misc) values ("&AnimalTypeID&","&CustomerID&","&VetID&", '" & AnimalName & "', '" & Breed & "', '" & AnimalDescription & "', '" & Colour & "', '" & gender & "', '" & neutered & "', #" & DateOfBirth & "#, #" & LastVaccinationDate & "#, '" & FeedingBrand & "', '" & FeedingRequirements & "', '" & Misc & "')"

sql12 = "insert into tblanimals (AnimalTypeID, CustomerID, VetID, AnimalName, Breed, AnimalDescription, Colour, gender, neutered, DateOfBirth, LastVaccinationDate, FeedingBrand, FeedingRequirements, DateIn, DateOut, Misc) values ("&AnimalTypeID&","&CustomerID&","&VetID&", '" & AnimalName & "', '" & Breed & "', '" & AnimalDescription & "', '" & Colour & "', '" & gender & "', '" & neutered & "', #" & DateOfBirth & "#, #" & LastVaccinationDate & "#, '" & FeedingBrand & "', '" & FeedingRequirements & "', #" & DateIn & "#, #" & DateOut & "#, '" & Misc & "')"

sql1 = "insert into tblanimals (AnimalTypeID, CustomerID, VetID, AnimalName, Breed, AnimalDescription, Colour, gender, neutered, DateOfBirth, LastVaccinationDate, FeedingBrand, FeedingRequirements, Misc) values ("&AnimalTypeID&","&CustomerID&","&VetID&", '" & AnimalName & "', '" & Breed & "', '" & AnimalDescription & "', '" & Colour & "', '" & gender & "', '" & neutered & "', #" & DateOfBirth & "#, #" & LastVaccinationDate & "#, '" & FeedingBrand & "', '" & FeedingRequirements & "', '" & Misc & "')"

sql2 = "insert into tblanimals (AnimalTypeID, CustomerID, VetID, AnimalName, Breed, AnimalDescription, Colour, gender, neutered, DateOfBirth, LastVaccinationDate, FeedingBrand, FeedingRequirements, DateIn, DateOut, Misc) values ("&AnimalTypeID&","&CustomerID&","&VetID&", '" & AnimalName & "', '" & Breed & "', '" & AnimalDescription & "', '" & Colour & "', '" & gender & "', '" & neutered & "', #" & DateOfBirth & "#, #" & LastVaccinationDate & "#, '" & FeedingBrand & "', '" & FeedingRequirements & "', #" & DateIn & "#, #" & DateOut & "#, '" & Misc & "')"

'Checks for blank values

If AnimalTypeID="" OR CustomerID="" OR VetID="" OR AnimalName="" OR Breed="" OR AnimalDescription="" OR Colour="" OR gender="" OR neutered="" OR DateOfBirth="" OR LastVaccinationDate="" OR FeedingBrand="" OR FeedingRequirements="" OR Misc="" THEN

%> You did not fill in all the fields.<a href="addnewanimal.asp">Click here to go back.</a>

<%	elseif DateIn="" OR dateout="" THEN

	conn.execute sql1

	%>
	Customer added!<br>
	<br>
	<a href="animals.asp">Back to Animal Section</a>
	<%	
		else
		conn.execute sql2
		%>
		Customer added!<br>
		<br>
		<a href="animals.asp">Back to Animal Section</a>
		<%
	end if

end if

conn.Close
Set conn = Nothing
%>
<!--			CONTENT OF TABLE-END	-->

<% else %>
You are not logged in.  Click <a href="default.asp">here</a> to return to the login page.
<% end if %>

</div>
</td>


</tr>

</table>


</body>

</html>
Reply With Quote
  #11  
Old March 29th, 2008, 02:43 AM
micky's Avatar
micky micky is offline
Couch Potato Wizard
Click here for more information. Click here for more information
 
Join Date: Jan 2005
Location: India
Posts: 9,915 micky User rank is General 4th Grade (Above 100000 Reputation Level)micky User rank is General 4th Grade (Above 100000 Reputation Level)micky User rank is General 4th Grade (Above 100000 Reputation Level)micky User rank is General 4th Grade (Above 100000 Reputation Level)micky User rank is General 4th Grade (Above 100000 Reputation Level)micky User rank is General 4th Grade (Above 100000 Reputation Level)micky User rank is General 4th Grade (Above 100000 Reputation Level)micky User rank is General 4th Grade (Above 100000 Reputation Level)micky User rank is General 4th Grade (Above 100000 Reputation Level)micky User rank is General 4th Grade (Above 100000 Reputation Level)micky User rank is General 4th Grade (Above 100000 Reputation Level)micky User rank is General 4th Grade (Above 100000 Reputation Level)micky User rank is General 4th Grade (Above 100000 Reputation Level)micky User rank is General 4th Grade (Above 100000 Reputation Level)micky User rank is General 4th Grade (Above 100000 Reputation Level)micky User rank is General 4th Grade (Above 100000 Reputation Level)  Folding Points: 1480 Folding Title: Novice Folder
Time spent in forums: 3 Months 2 Weeks 3 Days 16 h 59 m 6 sec
Reputation Power: 1272
ok u did highlight else in first post.
in sql2, u have no date for DateIn and DateOut, may be thats throwing the error as database might not accept null datetime.
Reply With Quote
  #12  
Old April 1st, 2008, 06:01 AM
Rams_ Rams_ is offline
Contributing User