CodeVerge.Net Beta


   Explore    Item Entry    Members      Register  Login  
NEWSGROUP
.NET
Algorithms-Data Structures
Asp.Net
C Plus Plus
CSharp
Database
HTML
Javascript
Linq
Other
Regular Expressions
VB.Net
XML

Free Download:




Zone: > NEWSGROUP > Asp.Net Forum > starter_kits_and_source_projects.commerce_starter_kit Tags:
Item Type: NewsGroup Date Entered: 2/22/2005 12:41:16 PM Date Modified: Subscribers: 0 Subscribe Alert
Rate It:
(NR, 0)
XPoints: N/A Replies: 5 Views: 15 Favorited: 0 Favorite
Can Reply:  No Members Can Edit: No Online: Yes
6 Items, 1 Pages 1 |< << Go >> >|
ppl1
Asp.Net User
syntax error in store procedure2/22/2005 12:41:16 PM

0/0

why im getting an error when im writing the store proceger "ShoppingCartAddItem"

SELECT [@countItems]=Count([productID])
FROM shoppingCart
WHERE productID=[@productID] And cartID=[@cartID]

IF @CountItems > 0
UPDATE
ShoppingCart
SET
Quantity = (@Quantity + ShoppingCart.Quantity)
WHERE
ProductID = @ProductID
AND
CartID = @CartID
and so on....

???
ppl1
Asp.Net User
Re: syntax error in store procedure2/23/2005 11:09:03 AM

0/0

i forgot to mention that im using access 2000
monu245
Asp.Net User
Re: syntax error in store procedure2/25/2005 3:25:32 AM

0/0

It would give a good idea if u can give which error you are getting.
Monu245
http://www.codaddict.com - A new way to share/store/bookmark your code snippets
ppl1
Asp.Net User
Re: syntax error in store procedure2/25/2005 10:35:17 AM

0/0

the error is-
Syntax error (missing operator) in query expression 'prodictID=[@productID] And cartID=[@cartID] IF @countItems > 0 UPDATE ......and the rest of the sql statement

im using access 2000 and im getting this error only when im adding the IF statement
(without the IF its ok)

thanks
monu245
Asp.Net User
Re: syntax error in store procedure2/26/2005 3:02:22 AM

0/0

I think access is not supporting sql block.
Monu245
http://www.codaddict.com - A new way to share/store/bookmark your code snippets
ppl1
Asp.Net User
Re: syntax error in store procedure2/26/2005 9:29:32 AM

0/0

thanks
6 Items, 1 Pages 1 |< << Go >> >|


Free Download:

Books:
MySQL Stored Procedure Programming: programming Authors: Guy Harrison, Steven Feuerstein, Pages: 609, Published: 2006
SQL Server 2000 Stored Procedure & XML Programming: Stored Procedure & XML Programming Authors: Dejan Sunderic, Pages: 679, Published: 2003
Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET Authors: Dejan Sunderic, Pages: 664, Published: 2006
Writing Stored Procedures with Microsoft SQL Server: The Authoritative Solution Authors: Matthew Shepker, Pages: 450, Published: 2000
SQL Bible Authors: Alex Kriegel, Boris M. Trukhnov, Pages: 857, Published: 2008
MCITP SQL Server 2005 Database Administration Exam Guide: (Exams 70-431, 70-443, And 70-444) Authors: Darril Gibson, Pages: 752, Published: 2007
Microsoft SQL Server 2005 Express Edition For Dummies Authors: Robert Schneider, Stephen Giles, Pages: 408, Published: 2006
ColdFusion MX Developer's Handbook Authors: Raymond Camden, Arman Danesh, Hal Helms, Guy Rish, Emily Kim, Shlomy Gantz, Jen deHaan, Peter deHaan, Selene Bainum, Charles Mohnike, John Colasante, William Baum, Kenneth N. Fricklas, Matt Liotta, Pages: 940, Published: 2003
Beginning Oracle Programming Authors: Sean Dillon, Christopher Beck, Thomas Kyte, Joel Kallman, Howard Rogers, Pages: 1099, Published: 2002
MCSE: SQL Server 2000 Design Study Guide Authors: Marc Israel, J. Steven Jones, Marc Isreal, Pages: 832, Published: 2001

Web:
Syntax error in stored procedure MySQL/PHP Syntax error in phpmyadmin and mysql query browser, and none in console syntax error in stored procedure mysql/php.
Syntax error in stored procedure - ASP.NET Forums Re: Syntax error in stored procedure. 09-16-2008, 9:00 AM. Contact ... Re: Syntax error in stored procedure. 09-16-2008, 9:03 AM. Contact ...
Syntax Error in Stored Procedure - DevX.com Forums Go Back, DevX.com Forums > DevX Developer Forums > Database ยท Reload this Page Syntax Error in Stored Procedure ...
Stored procedure with cursor gives Syntax error converting ... I have built a stored procedure that uses a cursor and when I execute the stored procedure I get the following error: Server: Msg 241, Level 16, State 1, ...
MySQL Bugs: #38532: MySQL Administrator - Stored Procedure dropped ... Description: MySQL Administrator is droping stored procedures alltogether while editing. While trying to save changes with syntax error, ...
SQL Server Forums - Alias stored procedure syntax error Now Im trying to display my stored procedure. However Im getting no syntax error but nothing is showing in my combobox. ...
syntax error in store procedure - ASP.NET Forums syntax error in store procedure. Last post 02-26-2005 4:29 AM by ppl1. 5 replies . Sort Posts:. Oldest to newest, Newest to oldest ...
Strange datetime conversion error in stored procedure. - MS SQL Syntax error converting datetime from character string. Now instead of executing the stored procedure, if I copy and paste the ...
DevCity.NET :: Working with MS Access Stored Procedures in VB.NET ... vb.net but when the storeprocedure have an error, in .net even get into the ... [Microsoft][ODBC Microsoft Access Driver]Syntax error or access violation ...
Stored procedure error [Archive] - dBforums [Archive] Stored procedure error DB2. ... If neither is applicable, you will get a syntax error here. Select E06_services_id, . ...

Videos:
UWTV CSE 142 - Computer Programming I, Lecture 2 In this series of lectures, Martin Dickey, from the University of Washington teaches Computer Programming using the C Language. *Important note: The...
django: Web Development for Perfectionists with Deadlines Google TechTalks April 26, 2006 Jacob Kaplan-Moss ABSTRACT Django is one of the premier web frameworks for Python, and is often compared to Ruby-on...
AutoTest: Push-button testing using contracts Google London Test Automation Conference (LTAC) Google Tech Talks September 7th, 2006 Presenter: Andreas Leitner




Search This Site:










profile update with hyperlink?

authentication cookie

how can i autogenerate the password for the user??

rolling out changes on an active site.

internet explorer webcontrols problem

my shiny new silver plan with tactical systems - dulled by my ignorance...

change default namespaces for new c# class

problem with connection to sql database

genrating menu items dynamically in asp.net 2.0 menu controls

configuration error

new article: debugging 3rd party modules

masterpage having content page in different directory level

please help me with skinning!!

questions for 1and1.com clients only

assigning the encrypted value screws up my string variable....???

whats up?

infragistix controls and other questions

cancel from edit control

website deployment in vs 2005

extend the character limit of news postings

dataproviders...

changepassword control and raising the changepassworderror

styles for menu control

web form designer....object reference not set in inherited ctrl class

using loginview with a checkbox

module dev. - resourcekey issue

sitemappath text

unhandled error loading module

this file failed to load in the worb form designer

when are we going to get final release?

 
All Times Are GMT