Click here to Skip to main content
15,917,731 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: javascript alert function breaks with linefeed character Pin
Guffa13-Oct-06 16:28
Guffa13-Oct-06 16:28 
QuestionSending Audio content from ASPX page. Pin
hectorpc200613-Oct-06 8:34
hectorpc200613-Oct-06 8:34 
AnswerRe: Sending Audio content from ASPX page. Pin
WillemM13-Oct-06 9:12
WillemM13-Oct-06 9:12 
GeneralRe: Sending Audio content from ASPX page. Pin
hectorpc200613-Oct-06 10:12
hectorpc200613-Oct-06 10:12 
GeneralRe: Sending Audio content from ASPX page. Pin
WillemM13-Oct-06 21:22
WillemM13-Oct-06 21:22 
QuestionDisplay data as table in Crystal Report Pin
bins8813-Oct-06 8:03
bins8813-Oct-06 8:03 
AnswerRe: Grid view paging error Pin
WillemM13-Oct-06 9:14
WillemM13-Oct-06 9:14 
Questionsql delete statement error in asp page Pin
keroed_edmond13-Oct-06 6:29
keroed_edmond13-Oct-06 6:29 
code snippet

dim sCode,sName
dim oCmd, sSqlString
dim oNewConnection, oNewRecordset, sNewSQL

sCode=replace(request.Form("txtCode"),"'","''")
sName=replace(request.Form("txtName"),"'","''")

sSqlString2 ="DELETE * FROM tblcode WHERE (code = " & sCode & " AND codeOwner= '" & sName &"')"
Set oNewConnection = Server.CreateObject("ADODB.Connection")
'open the connection to the database
oNewConnection.Open(sConnString2)
oNewConnection.execute(sSqlString2)

but when i try to excute that i get the following error

Microsoft OLE DB Provider for SQL Server error '80040e14'

Line 1: Incorrect syntax near '*'.

kenny
AnswerRe: sql delete statement error in asp page Pin
Guffa13-Oct-06 7:14
Guffa13-Oct-06 7:14 
GeneralRe: sql delete statement error in asp page Pin
keroed_edmond13-Oct-06 12:36
keroed_edmond13-Oct-06 12:36 
AnswerRe: sql delete statement error in asp page Pin
Guffa13-Oct-06 15:34
Guffa13-Oct-06 15:34 
QuestionUpload large files Pin
felopater13-Oct-06 5:28
felopater13-Oct-06 5:28 
AnswerRe: Upload large files Pin
Sreenath Madyastha13-Oct-06 9:16
Sreenath Madyastha13-Oct-06 9:16 
AnswerRe: Upload large files Pin
WillemM13-Oct-06 9:19
WillemM13-Oct-06 9:19 
AnswerRe: Upload large files Pin
Sushant Duggal13-Oct-06 18:59
Sushant Duggal13-Oct-06 18:59 
QuestionASP.NET 1.1 component for creating pivote tabls with SQL- and MDX-queries Pin
mdrel13-Oct-06 3:42
mdrel13-Oct-06 3:42 
QuestionUpdating records from a detailsview not working asp.net 2 Pin
AdamskiR13-Oct-06 3:40
AdamskiR13-Oct-06 3:40 
AnswerRe: Updating records from a detailsview not working asp.net 2 Pin
kascakm16-Oct-06 4:58
kascakm16-Oct-06 4:58 
QuestionPrinting in asp.net Pin
jolfa200113-Oct-06 3:30
jolfa200113-Oct-06 3:30 
AnswerRe: Printing in asp.net Pin
Sreenath Madyastha13-Oct-06 9:19
Sreenath Madyastha13-Oct-06 9:19 
Questionhow to make use of it Pin
Sandeep Akhare13-Oct-06 2:48
Sandeep Akhare13-Oct-06 2:48 
AnswerRe: how to make use of it Pin
Rama Krishna Vavilala13-Oct-06 9:28
Rama Krishna Vavilala13-Oct-06 9:28 
AnswerRe: how to make use of it Pin
Jerry Hammond13-Oct-06 10:16
Jerry Hammond13-Oct-06 10:16 
QuestionAdding some HTML-Tag between FORM and __VIEWSTATE Pin
A.Kassir13-Oct-06 1:50
A.Kassir13-Oct-06 1:50 
QuestionIP Pin
drc_no113-Oct-06 1:36
drc_no113-Oct-06 1:36 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.