what about ddp of sql

Posted by: huangbznet on 3 August 2017, 3:22 pm EST

  • Posted 3 August 2017, 3:22 pm EST

    hello all:

    I have ddp of sql problem and who can give me the document of ddp of sql.

    now I have problem of :

    select hrmresource.id,hrmresource.loginid,hrmresource.password,hrmresource.lastname,hrmresource.sex,hrmresource.email, HrmLocations.locationname from hrmresource left join HrmLocations on hrmresource.locationid = HrmLocations.id WHERE (hrmresource.id in (?))





    Thanks all.
    2013/02/sql error.GIF
  • Replied 3 August 2017, 3:22 pm EST

    Hello,

    You are using ? to pass parameters to an Sql query which is not a valid syntax and hence you are getting the above error. The correct syntax to pass the parameterin an SQL query is to use the "@" operator. Here is the modified query:

    select
    hrmresource.id,hrmresource.loginid,hrmresource.password,hrmresource.lastname,hrmresource.sex,hrmresource.email,
    HrmLocations.locationname
    from hrmresource left join HrmLocations on
    hrmresource.locationid = HrmLocations.id
    WHERE (hrmresource.id in (@hrmresource.id))


    Hope it helps. Please let me know if I missed something or if you have any queries further.

    Thanks,
    Manpreet Kaur
  • Replied 3 August 2017, 3:22 pm EST

    HELLO Manpreet Kaur





    I had got it with your mind,thank you very much!!!
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels