On Aug 2, 2:38 pm, Robin <[EMAIL PROTECTED]> wrote: > Regarding the Query of Query Run Time Error I highlighted earlier. > here's how i created the problem. > > I'm using FC 4-0-3 (1673) CFMX7, XP, MySQL5, Apache 2.2.4 and IE6. > > I was following Jeff C's video, where he creates a new HTML page under > the tree root folder after first deleting the existing sample project > pages. All i do is title the new html page, go to Body and into the > Image Library under resources - drag across an image, exit and save. I > don't add content or an image- even if I do add content it still > errors.
Don't have mySQL to hand to test so bear with me. Have a few additional questions. > Query Of Queries runtime error. > Comparison Exception: While executing "=" > Unsupported Type Comparison Exception: Comparator operator "=" does > not support comparison between following types: > Left hand side expression type = "STRING". > Right hand side expression type = "DOUBLE". What is the datatype in the database of the column SEQ for your array table? If its an HTML page you are editing (ie. dmHTML) then the array table will be something like dmHTML_aObjectids. this should be a numeric of some kind. Probably a quick fix by either changing the column datatype and/or casting the field prior to doing a comparison in the QofQ. -- geoff http://www.daemon.com.au/ --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "farcry-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/farcry-dev?hl=en -~----------~----~----~----~------~----~------~--~---
