Not sure if this should go to some beta list?/place?
I am using the same routine in two apps... one built with RB5.5 and
the old MySQL plugin and one with 2007r1 and the new plugin...
The old one returns what I expect (six records) from this join statement
nrs.sqlselect("select * from rundownitems_t left join scripts_T on
rundownitems_t.rdiscriptid=scripts_T.scriptid where
rundownitems_t.rdparentid='4' order by rundownitems_t.rdorder")
The new one returns six records but the joined (scripts_T fields)
info is duplicated (I get the same information twice)
If I use this select statement in MySQL utilities I get the expected
results.
I am going to try and make an isolated example, but has anyone seen
this before or is there something about my syntax that I need to
change with the new plugin?
Thanks,
Todd Fantz
[EMAIL PROTECTED]
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>
