Results 1 to 2 of 2
  1. #1

    trying fetch data from sql server

    I am facing problem while trying to fecth data from sql server , the below query doesnot return any rows although the condition is satisfied and same query works in sql server query analyser

    objRecordSet.Open "select menu_uid from ECMMenus where title='dcomUpdated'" ,objConnection, adOpenStatic, adLockOptimistic
    'Msgbox objRecordSet.GetString
    Dim sm1

    objRecordSet.Open "select menu_item_uid from ECMMenuItems where title='UK' and menu_uid=" & Chr(39) & sm1 & Chr(39),objConnection, adOpenStatic, adLockOptimistic

  2. #2
    Senior Member
    Join Date
    May 2004
    Lakeland, FL

    Re: trying fetch data from sql server

    what is the data type for menu_uid? If it is numeric, try the query without the single quote.



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
BetaSoft Inc.
All times are GMT -8. The time now is 05:41 PM.

Copyright BetaSoft Inc.