Forum Replies Created

Viewing 6 posts - 1 through 7 (of 7 total)

  • RE: syntax error but where?

    Hello Gail,

    Thanx for your quick reply. Below you can read the error I get:

    There was an error executing the query. Please check the syntax of the command and if present,...

    October 22, 2008 at 3:53 am

    #888007

  • RE: if...then...else...end if

    Ok. that would be nice. Here's my code:

    "

    DeleteCommand="DELETE FROM [tblProjects] WHERE [ProjectId] = @ProjectId"

    InsertCommand="INSERT INTO [tblProjects] ([ProjectName],...

    October 2, 2008 at 11:47 pm

    #880293

  • RE: if...then...else...end if

    GilaMonster (10/2/2008)

    Great

    Do you need help getting it into ASP? Do you want help in turning it into a stored proc? Or is everything sorted now?

    I would like to have some...

    October 2, 2008 at 9:27 am

    #880021

  • RE: if...then...else...end if

    Thanx! Here's my query sofar. This works as far as I can see now.

    SELECT tblProjects.ProjectId, tblProjects.ProjectName, tblProjects.ProjectDescription, tblProjects.Remarks, tblProjects.CompanyId, tblProjects.ContractNummer, tblProjects.DataSupplierId,

    ...

    October 2, 2008 at 9:05 am

    #880007

  • RE: if...then...else...end if

    I use SQL statements, because I'm not that familiar with stored procedures

    October 2, 2008 at 8:22 am

    #879979

  • RE: if...then...else...end if

    This makes a little sense. Where do I put the statement in my Query? I assume PrINT does't mean 'print' as in MS Word?

    October 2, 2008 at 7:19 am

    #879937

Viewing 6 posts - 1 through 7 (of 7 total)