My guess is that your database engine is returning the field name as
'newkey' not 'key.newkey' when I have a possibility of naming
conflicts or ambiguity or if I want a pseudo namespace in my db
fields I tend to alias them like
select user.username as user_username, user.userid as user_userid,
key.userid as key_userid, key.keyid as key_keyid, key.newkey as
key_newkey from user,key where
user_username='" + username +"' and user_userid=key_userid
On Apr 6, 2007, at 3:43 AM, Ian Piper wrote:
> rs = db.SQLSelect("select user.username, user.userid,
> key.userid, key.keyid, key.newkey from user,key where
> user.username='" + username +"' and user.userid=key.userid")
> if rs.RecordCount > 0 then
> while not rs.eof
> temp=rs.Field("key.newkey").Value // <-- this is where the
> NilObjectException is raised
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>
