SQL question

e-spike · 1 Jun 2006 at 17:30

I'm having some trouble with some simple .net stuff. I'm trying to use visual studio, but with a mysql database rather than an mssql database. I set up the connection etc fine, but when i try and follow a tutorial to use parameters in my querystring when creating a dataset, it says that there was an invalid @ found near the where clause. Is it only msSql querys that support parameters, or is there another way to define them for mysql. I'm trying to follow this tutorial:

http://download.microsoft.com/download/8/5/8/85803fdd-fe9a-4783-ab37-e0c565172ffd/asp_net_atlas.wmv

Haircut · 1 Jun 2006 at 18:44

Never used MySQL, but as far as I know the @ for parameters is a MSSQL thing only.

e-spike · 1 Jun 2006 at 18:54

so what do i use to have parameters in mysql?

.Andy · 1 Jun 2006 at 20:04

you use ? i.e, ?parameterName

e-spike · 1 Jun 2006 at 20:05

.Andy said:
you use ? i.e, ?parameterName

sure thats not querystring stuff?