Whats wrong with this SQL statement in vb.net?

[Signo.X]

im trying to run this statement as my command string in my vb.net application :

when i run it, it's saying syntax error ..

[SIZE=2][COLOR=#0000ff]Dim[/COLOR][/SIZE][SIZE=2] cmdString [/SIZE][SIZE=2][COLOR=#0000ff]As[/COLOR][/SIZE][SIZE=2][COLOR=#0000ff]String[/COLOR][/SIZE][SIZE=2] = [/SIZE][SIZE=2][COLOR=#800000]"SELECT ORDERSS.OrderNo, Count(*) AS total_lines, Sum(ORDERLINE.Qty * PART.PartPrice) AS total_amount"[/COLOR][/SIZE][SIZE=2] & _[/SIZE]
[SIZE=2][COLOR=#800000]"FROM ORDERSS, ORDERLINE , PART"[/COLOR][/SIZE][SIZE=2] & _[/SIZE]
[SIZE=2][COLOR=#800000]"WHERE ORDERSS.OrderNo = ORDERLINE.OrderNo AND ORDERLINE.PartCode = PART.PartCode "[/COLOR][/SIZE][SIZE=2] & _[/SIZE]
[SIZE=2][COLOR=#800000]"GROUP BY ORDERSS.OrderNo;"[/COLOR][/SIZE]

any idea???

~signo.X

 

[Arkette]

you need a space between As and String on the first line

 

[Signo.X]

you need a space between As and String on the first line

thanks for the reply..

there is a space ???

[COLOR=#800000]Count(*) AS total_lines, Sum(ORDERLINE.Qty * PART.PartPrice) AS total_amount[/COLOR]
[COLOR=#800000][/COLOR]

 

[Signo.X]

problem solved, i was missing a space at the end of every ""

Thanks
Signo.X