Hey Geoff, took a look at the table it's data type is Decimal.
Robin On Aug 2, 12:48 am, modius <[EMAIL PROTECTED]> wrote: > 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. > > -- geoffhttp://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 -~----------~----~----~----~------~----~------~--~---
