SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 2 of 2
  1. #1
    Junior Member
    Join Date
    Jan 2004
    Location
    Netherlands
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    db_execute_query fails

    I want to get data from a database table, but running the script gives several errors. I suspect I made a fault in the context of the "db_execute_query"-statement


    Script:

    db_connect (Get_Dat,databasename); # This statement gives no problem
    db_execute_query (Get_Dat, SELECT * FROM Comp WHERE Comp.Code=BE, 1); # This statement gives an error on the 2nd argument
    db_get_field_value (Get_Dat, 0,2); # This statement is never reached, expected: Version=11_12
    db_disconnect (Get_Dat);

    The table (Name: Comp) in THe Acces-database looks like this:
    Code NAME
    =====================
    US UNITED STATES
    DE GERMANY
    BE BELGIUM
    FA FRANCE

    I hope to read you from you,
    Jip

  2. #2
    Senior Member
    Join Date
    Feb 2003
    Posts
    141
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: db_execute_query fails

    Try this.
    db_execute_query(Get_Dat, "Select * from comp where Comp.code=BE",var);
    (You have to give quotes for the second argument and variable name as the third argument )

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Search Engine Optimisation provided by DragonByte SEO v2.0.36 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Resources saved on this page: MySQL 11.54%
vBulletin Optimisation provided by vB Optimise v2.6.4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.2.8 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominate (Lite) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 08:06 PM.

Copyright BetaSoft Inc.