[cfaussie] Re: Clustering - Standard or Enterprise
Hi Scott, if your simply after "failover protection" where a server dies for what ever reason and ya don't want down time and the server isn't getting an intensely massive loan then standard with a hardware (don't go a software) load balancer will do the trick and check if a server has carked it and direct the traffice to the other server/servers M@ --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Which subversion hosting do you use?
Hi guys, Just wondering what external subversion hosts people might recommend. In the past I've used cvsdude, and while I have had absolutely no problems with them I just wanted to see what else is out there. So far I've seen a couple of others including svnrepository.com and devguard.com, the former being extremely cost competitive. Has anyone used either of these or have similar recommendations? Ideally I need at least 5GB space and many (100+) repositories/users, hourly backups etc. As I'm not sure whether we'll be using Trac I don't think that is an essential. Thanks again --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] REMINDER: ColdFusion 8 Launch Party - Tomorrow Night!!! - Melbourne
All! It's a special CF8 Launch party Location: NGA.net, Level 2, 17 Raglan St, South Melbourne Map: http://link.toolbot.com/google.com/73016 When: 8th of August, Meeting starts at 6:30, so get there before hand - ** Please note, we are starting a little bit early this time, due to the crossover between states. Agenda: This is the official ColdFusion 8 Launch Party! We will have presentations from Ben Forta via Connect, crossovers between the launch parties at all the other CFUGs across Australia and New Zealand, and prizes from Adobe for those people that attend! Everyone is welcome, and if you haven't attended a single CFUG meeting yet, now is the time to come down! If you are going to attend, please RSVP to [EMAIL PROTECTED] ** NOTE - there are prize give-aways, that include a licence of ColdFusion 8 Standard. if you don't RSVP by 12pm tomorrow, you aren't included in the prize draw!!! See the CFUG Melbourne Calendar at: http://www.cfcentral.com.au/Events/index.cfm Or add to your Google Calendar - search for 'CFUG Melbourne'. As per usual, we'll grab pizza during the evening, so we have something to scoff down! Look forward to seeing you all there. -- E: [EMAIL PROTECTED] W: www.compoundtheory.com --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Clustering - Standard or Enterprise
So what if you want both failover protection and enterprise application clustering with instances? Does your web server cluster and your cf cluster share the hardware load balancer? >From: "M@ Bourke" <[EMAIL PROTECTED]> >Reply-To: cfaussie@googlegroups.com >To: cfaussie@googlegroups.com >Subject: [cfaussie] Re: Clustering - Standard or Enterprise >Date: Mon, 6 Aug 2007 14:46:39 +0100 > >Hi Scott, > >if your simply after "failover protection" where a server dies for what >ever >reason and ya don't want down time and the server isn't getting an >intensely >massive loan then standard with a hardware (don't go a software) load >balancer will do the trick and check if a server has carked it and direct >the traffice to the other server/servers > >M@ > >> _ Advertisement: SEEK Salary Centre: What are you really worth? Find out. http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fninemsn%2Eseeklearning%2Ecom%2Eau%2F%3Ftracking%3Dsk%3Acon%3Askl%3Anine%3A0%3Ahot%3Acoursetafe&_t=764565661&_r=Seek_learning_AUG07_TAGlines&_m=EXT --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Clustering - Standard or Enterprise
haven't figured that out yet. >>> "Mark Ireland" <[EMAIL PROTECTED]> 07/08/2007 9:18 am >>> So what if you want both failover protection and enterprise application clustering with instances? Does your web server cluster and your cf cluster share the hardware load balancer? >From: "M@ Bourke" <[EMAIL PROTECTED]> >Reply-To: cfaussie@googlegroups.com >To: cfaussie@googlegroups.com >Subject: [cfaussie] Re: Clustering - Standard or Enterprise >Date: Mon, 6 Aug 2007 14:46:39 +0100 > >Hi Scott, > >if your simply after "failover protection" where a server dies for what >ever >reason and ya don't want down time and the server isn't getting an >intensely >massive loan then standard with a hardware (don't go a software) load >balancer will do the trick and check if a server has carked it and direct >the traffice to the other server/servers > >M@ > >> _ Advertisement: SEEK Salary Centre: What are you really worth? Find out. http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fninemsn%2Eseeklearning%2Ecom%2Eau%2F%3Ftracking%3Dsk%3Acon%3Askl%3Anine%3A0%3Ahot%3Acoursetafe&_t=764565661&_r=Seek_learning_AUG07_TAGlines&_m=EXT --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Reminder: NSW CFUG and Sydney Flash Platform Developer Group CF8 Launch Tomorrow
An UPPERCASE reminder to RSVP for tomorrow night's CF8 launch: http://nswcfug.wordpress.com/2007/07/25/special-scorpio-meeting/ The meeting includes a Connect link-up with User Groups across ANZ, a localised version of the Ben Forta features demonstration (kudos to Dave Harris in Auckland) and (awaiting final confirmation) a LIVE TELECONFERENCE with TIM BUNTEL, ColdFusion Product Manager. All this with the usual surfeit of PIZZA and BEER. There are ONLY 17 SPOTS REMAINING so don't delay! The PRIZE DRAW tomorrow includes a copy of COLDFUSION 8 STANDARD and many unique items of SCHWAG never before seen in Australia. Robin Hilliard National User Group Co-ordinator On 25/07/2007, at 5:44 PM, Robin Hilliard wrote: > Just drawing your attention to this post on the NSW CFUG site: > > http://nswcfug.wordpress.com/2007/07/25/special-scorpio-meeting/ > > Robin Hilliard > National User Group Co-ordinator --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Which subversion hosting do you use?
http://www.hosted-projects.com/ MF --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Which subversion hosting do you use?
http://www.wush.net/subversion.php Chris -- Chris Velevitch Manager - Sydney Flash Platform Developers Group m: 0415 469 095 www.flashdev.org.au --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Query Problem against MS Access data source
Hi, Running the following query in MS Access query designer. SELECT [Prostheses List].[Billing Code] AS mbs_item_no, [Prostheses List].MinBenefit AS mbs_item_cost, [Prostheses List].[Benefit Changed] AS mbs_Cost_Start_Date, [Prostheses List].[Product Name] AS desc1, [Prostheses List].[Further Description] AS desc2, [Prostheses List].Size AS desc3 FROM [Prostheses List] WHERE ((([Prostheses List].[Changed?])=Yes)) OR ((([Prostheses List].[New?])=Yes)) ORDER BY [Prostheses List].[Billing Code]; it works fine. When I run it in CF, I get the following error: Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect After some investigation I think the error is related to the question mark character in the where clause. I cannot change the field name in the table, as it is provided by the Federal government. I've tried text quotes around the field name.. but nothing has worked Any idea to get around this? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Query Problem against MS Access data source
Tried two double slashes? [changed\\?] Try two single quotes before the question mark: [changed''?] Scott Thornton wrote: > Hi, > > Running the following query in MS Access query designer. > > SELECT [Prostheses List].[Billing Code] AS mbs_item_no, > [Prostheses List].MinBenefit AS mbs_item_cost, > [Prostheses List].[Benefit Changed] AS mbs_Cost_Start_Date, > [Prostheses List].[Product Name] AS desc1, > [Prostheses List].[Further Description] AS desc2, > [Prostheses List].Size AS desc3 > FROM [Prostheses List] > WHERE > > ((([Prostheses List].[Changed?])=Yes)) OR ((([Prostheses List].[New?])=Yes)) > > ORDER BY [Prostheses List].[Billing Code]; > > it works fine. > > When I run it in CF, I get the following error: > > Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC > Socket][Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect > > After some investigation I think the error is related to the question mark > character in the where clause. > > I cannot change the field name in the table, as it is provided by the Federal > government. > > I've tried text quotes around the field name.. but nothing has worked > > Any idea to get around this? > > > > > > > > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Query Problem against MS Access data source
Another though, does cfqueryparam work for table names? Scott Thornton wrote: > Hi, > > Running the following query in MS Access query designer. > > SELECT [Prostheses List].[Billing Code] AS mbs_item_no, > [Prostheses List].MinBenefit AS mbs_item_cost, > [Prostheses List].[Benefit Changed] AS mbs_Cost_Start_Date, > [Prostheses List].[Product Name] AS desc1, > [Prostheses List].[Further Description] AS desc2, > [Prostheses List].Size AS desc3 > FROM [Prostheses List] > WHERE > > ((([Prostheses List].[Changed?])=Yes)) OR ((([Prostheses List].[New?])=Yes)) > > ORDER BY [Prostheses List].[Billing Code]; > > it works fine. > > When I run it in CF, I get the following error: > > Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC > Socket][Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect > > After some investigation I think the error is related to the question mark > character in the where clause. > > I cannot change the field name in the table, as it is provided by the Federal > government. > > I've tried text quotes around the field name.. but nothing has worked > > Any idea to get around this? > > > > > > > > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Query Problem against MS Access data source
Thanks, no it did not work. >>> Haikal Saadh <[EMAIL PROTECTED]> 07/08/2007 3:00 pm >>> Tried two double slashes? [changed\\?] Try two single quotes before the question mark: [changed''?] Scott Thornton wrote: > Hi, > > Running the following query in MS Access query designer. > > SELECT [Prostheses List].[Billing Code] AS mbs_item_no, > [Prostheses List].MinBenefit AS mbs_item_cost, > [Prostheses List].[Benefit Changed] AS mbs_Cost_Start_Date, > [Prostheses List].[Product Name] AS desc1, > [Prostheses List].[Further Description] AS desc2, > [Prostheses List].Size AS desc3 > FROM [Prostheses List] > WHERE > > ((([Prostheses List].[Changed?])=Yes)) OR ((([Prostheses List].[New?])=Yes)) > > ORDER BY [Prostheses List].[Billing Code]; > > it works fine. > > When I run it in CF, I get the following error: > > Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC > Socket][Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect > > After some investigation I think the error is related to the question mark > character in the where clause. > > I cannot change the field name in the table, as it is provided by the Federal > government. > > I've tried text quotes around the field name.. but nothing has worked > > Any idea to get around this? > > > > > > > > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Query Problem against MS Access data source
Would exporting the data to a real database (with appropriate table names) be too much? SQL Server's DTS should make something like this reasonably painless. I think you can even schedule the process so that it happens periodically? That aside, I'm stumped. (Oh, and just checking, but you did see the second ? [New?] as well, right?) Scott Thornton wrote: > Thanks, > > no it did not work. > > Haikal Saadh <[EMAIL PROTECTED]> 07/08/2007 3:00 pm >>> > > Tried two double slashes? > [changed\\?] > > Try two single quotes before the question mark: > [changed''?] > > > > Scott Thornton wrote: > >> Hi, >> >> Running the following query in MS Access query designer. >> >> SELECT [Prostheses List].[Billing Code] AS mbs_item_no, >> [Prostheses List].MinBenefit AS mbs_item_cost, >> [Prostheses List].[Benefit Changed] AS mbs_Cost_Start_Date, >> [Prostheses List].[Product Name] AS desc1, >> [Prostheses List].[Further Description] AS desc2, >> [Prostheses List].Size AS desc3 >> FROM [Prostheses List] >> WHERE >> >> ((([Prostheses List].[Changed?])=Yes)) OR ((([Prostheses List].[New?])=Yes)) >> >> ORDER BY [Prostheses List].[Billing Code]; >> >> it works fine. >> >> When I run it in CF, I get the following error: >> >> Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC >> Socket][Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect >> >> After some investigation I think the error is related to the question mark >> character in the where clause. >> >> I cannot change the field name in the table, as it is provided by the >> Federal government. >> >> I've tried text quotes around the field name.. but nothing has worked >> >> Any idea to get around this? >> >> >> >> >> >> >> >> > > > > > > > > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Query Problem against MS Access data source
Hi, How do you mean? Also, I tried using select *, and then used a query of query, but it doesn't seem to like square brackets and the question mark in the qoq either. >>> Haikal Saadh <[EMAIL PROTECTED]> 07/08/2007 3:03 pm >>> Another though, does cfqueryparam work for table names? Scott Thornton wrote: > Hi, > > Running the following query in MS Access query designer. > > SELECT [Prostheses List].[Billing Code] AS mbs_item_no, > [Prostheses List].MinBenefit AS mbs_item_cost, > [Prostheses List].[Benefit Changed] AS mbs_Cost_Start_Date, > [Prostheses List].[Product Name] AS desc1, > [Prostheses List].[Further Description] AS desc2, > [Prostheses List].Size AS desc3 > FROM [Prostheses List] > WHERE > > ((([Prostheses List].[Changed?])=Yes)) OR ((([Prostheses List].[New?])=Yes)) > > ORDER BY [Prostheses List].[Billing Code]; > > it works fine. > > When I run it in CF, I get the following error: > > Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC > Socket][Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect > > After some investigation I think the error is related to the question mark > character in the where clause. > > I cannot change the field name in the table, as it is provided by the Federal > government. > > I've tried text quotes around the field name.. but nothing has worked > > Any idea to get around this? > > > > > > > > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Query Problem against MS Access data source
Okay, I can use Select * and the field is returned in the query okay. Next challange, using the field in CF presents a problem as CF chucks an error: Invalid token '?' found on line 64 at column 23. when i use #myquery.changed?# So, If I know the order of the columns of the query, can I refer to it that way? >>> Haikal Saadh <[EMAIL PROTECTED]> 07/08/2007 3:03 pm >>> Another though, does cfqueryparam work for table names? Scott Thornton wrote: > Hi, > > Running the following query in MS Access query designer. > > SELECT [Prostheses List].[Billing Code] AS mbs_item_no, > [Prostheses List].MinBenefit AS mbs_item_cost, > [Prostheses List].[Benefit Changed] AS mbs_Cost_Start_Date, > [Prostheses List].[Product Name] AS desc1, > [Prostheses List].[Further Description] AS desc2, > [Prostheses List].Size AS desc3 > FROM [Prostheses List] > WHERE > > ((([Prostheses List].[Changed?])=Yes)) OR ((([Prostheses List].[New?])=Yes)) > > ORDER BY [Prostheses List].[Billing Code]; > > it works fine. > > When I run it in CF, I get the following error: > > Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC > Socket][Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect > > After some investigation I think the error is related to the question mark > character in the where clause. > > I cannot change the field name in the table, as it is provided by the Federal > government. > > I've tried text quotes around the field name.. but nothing has worked > > Any idea to get around this? > > > > > > > > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Query Problem against MS Access data source
Where does the problem occur? Is it just in the where perhaps Try without the where, but include the field in the select and see if you can dump it. You might then be able to do query of query or loop over the query. If select [Changed?] as Changed works you will have a lot more options. Regards Dale Fraser http://dalefraser.blogspot.com -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Scott Thornton Sent: Tuesday, 7 August 2007 2:32 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Query Problem against MS Access data source Hi, Running the following query in MS Access query designer. SELECT [Prostheses List].[Billing Code] AS mbs_item_no, [Prostheses List].MinBenefit AS mbs_item_cost, [Prostheses List].[Benefit Changed] AS mbs_Cost_Start_Date, [Prostheses List].[Product Name] AS desc1, [Prostheses List].[Further Description] AS desc2, [Prostheses List].Size AS desc3 FROM [Prostheses List] WHERE ((([Prostheses List].[Changed?])=Yes)) OR ((([Prostheses List].[New?])=Yes)) ORDER BY [Prostheses List].[Billing Code]; it works fine. When I run it in CF, I get the following error: Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect After some investigation I think the error is related to the question mark character in the where clause. I cannot change the field name in the table, as it is provided by the Federal government. I've tried text quotes around the field name.. but nothing has worked Any idea to get around this? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Query Problem against MS Access data source
Just select [Changed?] as Changed then query of query it Regards Dale Fraser http://dalefraser.blogspot.com -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Scott Thornton Sent: Tuesday, 7 August 2007 3:30 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Query Problem against MS Access data source Okay, I can use Select * and the field is returned in the query okay. Next challange, using the field in CF presents a problem as CF chucks an error: Invalid token '?' found on line 64 at column 23. when i use #myquery.changed?# So, If I know the order of the columns of the query, can I refer to it that way? >>> Haikal Saadh <[EMAIL PROTECTED]> 07/08/2007 3:03 pm >>> Another though, does cfqueryparam work for table names? Scott Thornton wrote: > Hi, > > Running the following query in MS Access query designer. > > SELECT [Prostheses List].[Billing Code] AS mbs_item_no, > [Prostheses List].MinBenefit AS mbs_item_cost, > [Prostheses List].[Benefit Changed] AS mbs_Cost_Start_Date, > [Prostheses List].[Product Name] AS desc1, > [Prostheses List].[Further Description] AS desc2, > [Prostheses List].Size AS desc3 > FROM [Prostheses List] > WHERE > > ((([Prostheses List].[Changed?])=Yes)) OR ((([Prostheses List].[New?])=Yes)) > > ORDER BY [Prostheses List].[Billing Code]; > > it works fine. > > When I run it in CF, I get the following error: > > Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect > > After some investigation I think the error is related to the question mark character in the where clause. > > I cannot change the field name in the table, as it is provided by the Federal government. > > I've tried text quotes around the field name.. but nothing has worked > > Any idea to get around this? > > > > > > > > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Query Problem against MS Access data source
SELECT ... WHERE = YES ... I'm not sure if cfqueryparam can be used for a table name, so not sure if it'll work, but worth checking out. Scott Thornton wrote: > Hi, > > How do you mean? > > Also, > > I tried using select *, and then used a query of query, but it doesn't seem > to like square brackets and the question mark in the qoq either. > > > > Haikal Saadh <[EMAIL PROTECTED]> 07/08/2007 3:03 pm >>> > > Another though, does cfqueryparam work for table names? > > Scott Thornton wrote: > >> Hi, >> >> Running the following query in MS Access query designer. >> >> SELECT [Prostheses List].[Billing Code] AS mbs_item_no, >> [Prostheses List].MinBenefit AS mbs_item_cost, >> [Prostheses List].[Benefit Changed] AS mbs_Cost_Start_Date, >> [Prostheses List].[Product Name] AS desc1, >> [Prostheses List].[Further Description] AS desc2, >> [Prostheses List].Size AS desc3 >> FROM [Prostheses List] >> WHERE >> >> ((([Prostheses List].[Changed?])=Yes)) OR ((([Prostheses List].[New?])=Yes)) >> >> ORDER BY [Prostheses List].[Billing Code]; >> >> it works fine. >> >> When I run it in CF, I get the following error: >> >> Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC >> Socket][Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect >> >> After some investigation I think the error is related to the question mark >> character in the where clause. >> >> I cannot change the field name in the table, as it is provided by the >> Federal government. >> >> I've tried text quotes around the field name.. but nothing has worked >> >> Any idea to get around this? >> >> >> >> >> >> >> >> > > > > > > > > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Query Problem against MS Access data source
Try '#myquery['changed?']# Regards Dale Fraser http://dalefraser.blogspot.com -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Scott Thornton Sent: Tuesday, 7 August 2007 3:30 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Query Problem against MS Access data source Okay, I can use Select * and the field is returned in the query okay. Next challange, using the field in CF presents a problem as CF chucks an error: Invalid token '?' found on line 64 at column 23. when i use #myquery.changed?# So, If I know the order of the columns of the query, can I refer to it that way? >>> Haikal Saadh <[EMAIL PROTECTED]> 07/08/2007 3:03 pm >>> Another though, does cfqueryparam work for table names? Scott Thornton wrote: > Hi, > > Running the following query in MS Access query designer. > > SELECT [Prostheses List].[Billing Code] AS mbs_item_no, > [Prostheses List].MinBenefit AS mbs_item_cost, > [Prostheses List].[Benefit Changed] AS mbs_Cost_Start_Date, > [Prostheses List].[Product Name] AS desc1, > [Prostheses List].[Further Description] AS desc2, > [Prostheses List].Size AS desc3 > FROM [Prostheses List] > WHERE > > ((([Prostheses List].[Changed?])=Yes)) OR ((([Prostheses List].[New?])=Yes)) > > ORDER BY [Prostheses List].[Billing Code]; > > it works fine. > > When I run it in CF, I get the following error: > > Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect > > After some investigation I think the error is related to the question mark character in the where clause. > > I cannot change the field name in the table, as it is provided by the Federal government. > > I've tried text quotes around the field name.. but nothing has worked > > Any idea to get around this? > > > > > > > > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Query Problem against MS Access data source
Hi Dale, I think my last email crossed over the wires with yours. I can use Select * and the field is returned n the query object. I cannot reference it via coldfusion, or in a query of query by its name. My next question is, can I refer to it by its column number. Am currently scouring the docs for this info. Cheers, >>> "Dale Fraser" <[EMAIL PROTECTED]> 07/08/2007 3:32 pm >>> Where does the problem occur? Is it just in the where perhaps Try without the where, but include the field in the select and see if you can dump it. You might then be able to do query of query or loop over the query. If select [Changed?] as Changed works you will have a lot more options. Regards Dale Fraser http://dalefraser.blogspot.com -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Scott Thornton Sent: Tuesday, 7 August 2007 2:32 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Query Problem against MS Access data source Hi, Running the following query in MS Access query designer. SELECT [Prostheses List].[Billing Code] AS mbs_item_no, [Prostheses List].MinBenefit AS mbs_item_cost, [Prostheses List].[Benefit Changed] AS mbs_Cost_Start_Date, [Prostheses List].[Product Name] AS desc1, [Prostheses List].[Further Description] AS desc2, [Prostheses List].Size AS desc3 FROM [Prostheses List] WHERE ((([Prostheses List].[Changed?])=Yes)) OR ((([Prostheses List].[New?])=Yes)) ORDER BY [Prostheses List].[Billing Code]; it works fine. When I run it in CF, I get the following error: Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect After some investigation I think the error is related to the question mark character in the where clause. I cannot change the field name in the table, as it is provided by the Federal government. I've tried text quotes around the field name.. but nothing has worked Any idea to get around this? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Query Problem against MS Access data source
Doesn't work, Error Message: Complex object types cannot be converted to simple values. The expression has requested a variable or an intermediate expression result as a simple value, however, the result cannot be converted to a simple value. Simple values are strings, numbers, boolean values, and date/time values. Queries, arrays, and COM objects are examples of complex values. The most likely cause of the error is that you are trying to use a complex value as a simple one. For example, you might be trying to use a query variable in a tag. This was possible in ColdFusion 2.0 but creates an error in later versions. The error occurred on line 64. >>> "Dale Fraser" <[EMAIL PROTECTED]> 07/08/2007 3:36 pm >>> Try '#myquery['changed?']# Regards Dale Fraser http://dalefraser.blogspot.com -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Scott Thornton Sent: Tuesday, 7 August 2007 3:30 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Query Problem against MS Access data source Okay, I can use Select * and the field is returned in the query okay. Next challange, using the field in CF presents a problem as CF chucks an error: Invalid token '?' found on line 64 at column 23. when i use #myquery.changed?# So, If I know the order of the columns of the query, can I refer to it that way? >>> Haikal Saadh <[EMAIL PROTECTED]> 07/08/2007 3:03 pm >>> Another though, does cfqueryparam work for table names? Scott Thornton wrote: > Hi, > > Running the following query in MS Access query designer. > > SELECT [Prostheses List].[Billing Code] AS mbs_item_no, > [Prostheses List].MinBenefit AS mbs_item_cost, > [Prostheses List].[Benefit Changed] AS mbs_Cost_Start_Date, > [Prostheses List].[Product Name] AS desc1, > [Prostheses List].[Further Description] AS desc2, > [Prostheses List].Size AS desc3 > FROM [Prostheses List] > WHERE > > ((([Prostheses List].[Changed?])=Yes)) OR ((([Prostheses List].[New?])=Yes)) > > ORDER BY [Prostheses List].[Billing Code]; > > it works fine. > > When I run it in CF, I get the following error: > > Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect > > After some investigation I think the error is related to the question mark character in the where clause. > > I cannot change the field name in the table, as it is provided by the Federal government. > > I've tried text quotes around the field name.. but nothing has worked > > Any idea to get around this? > > > > > > > > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Query Problem against MS Access data source
If I refer to the field in the select clause, an error is thrown. SELECT top 10 [changed?] as changed FROM [Prostheses List] ORDER BY [Prostheses List].[Billing Code]; Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect The error occurred on line 50. >>> "Dale Fraser" <[EMAIL PROTECTED]> 07/08/2007 3:33 pm >>> Just select [Changed?] as Changed then query of query it Regards Dale Fraser http://dalefraser.blogspot.com -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Scott Thornton Sent: Tuesday, 7 August 2007 3:30 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Query Problem against MS Access data source Okay, I can use Select * and the field is returned in the query okay. Next challange, using the field in CF presents a problem as CF chucks an error: Invalid token '?' found on line 64 at column 23. when i use #myquery.changed?# So, If I know the order of the columns of the query, can I refer to it that way? >>> Haikal Saadh <[EMAIL PROTECTED]> 07/08/2007 3:03 pm >>> Another though, does cfqueryparam work for table names? Scott Thornton wrote: > Hi, > > Running the following query in MS Access query designer. > > SELECT [Prostheses List].[Billing Code] AS mbs_item_no, > [Prostheses List].MinBenefit AS mbs_item_cost, > [Prostheses List].[Benefit Changed] AS mbs_Cost_Start_Date, > [Prostheses List].[Product Name] AS desc1, > [Prostheses List].[Further Description] AS desc2, > [Prostheses List].Size AS desc3 > FROM [Prostheses List] > WHERE > > ((([Prostheses List].[Changed?])=Yes)) OR ((([Prostheses List].[New?])=Yes)) > > ORDER BY [Prostheses List].[Billing Code]; > > it works fine. > > When I run it in CF, I get the following error: > > Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect > > After some investigation I think the error is related to the question mark character in the where clause. > > I cannot change the field name in the table, as it is provided by the Federal government. > > I've tried text quotes around the field name.. but nothing has worked > > Any idea to get around this? > > > > > > > > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Query Problem against MS Access data source
If you use #myquery['changed?']# a lot of the time you need to use an index because you cant just output an array like that. If you know there is only one record in the recordset then use #myquery['changed?'][1]# Steve -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Scott Thornton Sent: Tuesday, 7 August 2007 3:45 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Query Problem against MS Access data source Doesn't work, Error Message: Complex object types cannot be converted to simple values. The expression has requested a variable or an intermediate expression result as a simple value, however, the result cannot be converted to a simple value. Simple values are strings, numbers, boolean values, and date/time values. Queries, arrays, and COM objects are examples of complex values. The most likely cause of the error is that you are trying to use a complex value as a simple one. For example, you might be trying to use a query variable in a tag. This was possible in ColdFusion 2.0 but creates an error in later versions. The error occurred on line 64. >>> "Dale Fraser" <[EMAIL PROTECTED]> 07/08/2007 3:36 pm >>> Try '#myquery['changed?']# Regards Dale Fraser http://dalefraser.blogspot.com -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Scott Thornton Sent: Tuesday, 7 August 2007 3:30 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Query Problem against MS Access data source Okay, I can use Select * and the field is returned in the query okay. Next challange, using the field in CF presents a problem as CF chucks an error: Invalid token '?' found on line 64 at column 23. when i use #myquery.changed?# So, If I know the order of the columns of the query, can I refer to it that way? >>> Haikal Saadh <[EMAIL PROTECTED]> 07/08/2007 3:03 pm >>> Another though, does cfqueryparam work for table names? Scott Thornton wrote: > Hi, > > Running the following query in MS Access query designer. > > SELECT [Prostheses List].[Billing Code] AS mbs_item_no, > [Prostheses List].MinBenefit AS mbs_item_cost, > [Prostheses List].[Benefit Changed] AS mbs_Cost_Start_Date, > [Prostheses List].[Product Name] AS desc1, > [Prostheses List].[Further Description] AS desc2, > [Prostheses List].Size AS desc3 > FROM [Prostheses List] > WHERE > > ((([Prostheses List].[Changed?])=Yes)) OR ((([Prostheses List].[New?])=Yes)) > > ORDER BY [Prostheses List].[Billing Code]; > > it works fine. > > When I run it in CF, I get the following error: > > Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect > > After some investigation I think the error is related to the question mark character in the where clause. > > I cannot change the field name in the table, as it is provided by the Federal government. > > I've tried text quotes around the field name.. but nothing has worked > > Any idea to get around this? > > > > > > > > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Query Problem against MS Access data source
HI, I have had success with #prost['changed?'][prost.CurrentRow]# Thanks for all suggestions one and all. >>> "Steve Onnis" <[EMAIL PROTECTED]> 07/08/2007 3:50 pm >>> If you use #myquery['changed?']# a lot of the time you need to use an index because you cant just output an array like that. If you know there is only one record in the recordset then use #myquery['changed?'][1]# Steve -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Scott Thornton Sent: Tuesday, 7 August 2007 3:45 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Query Problem against MS Access data source Doesn't work, Error Message: Complex object types cannot be converted to simple values. The expression has requested a variable or an intermediate expression result as a simple value, however, the result cannot be converted to a simple value. Simple values are strings, numbers, boolean values, and date/time values. Queries, arrays, and COM objects are examples of complex values. The most likely cause of the error is that you are trying to use a complex value as a simple one. For example, you might be trying to use a query variable in a tag. This was possible in ColdFusion 2.0 but creates an error in later versions. The error occurred on line 64. >>> "Dale Fraser" <[EMAIL PROTECTED]> 07/08/2007 3:36 pm >>> Try '#myquery['changed?']# Regards Dale Fraser http://dalefraser.blogspot.com -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Scott Thornton Sent: Tuesday, 7 August 2007 3:30 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Query Problem against MS Access data source Okay, I can use Select * and the field is returned in the query okay. Next challange, using the field in CF presents a problem as CF chucks an error: Invalid token '?' found on line 64 at column 23. when i use #myquery.changed?# So, If I know the order of the columns of the query, can I refer to it that way? >>> Haikal Saadh <[EMAIL PROTECTED]> 07/08/2007 3:03 pm >>> Another though, does cfqueryparam work for table names? Scott Thornton wrote: > Hi, > > Running the following query in MS Access query designer. > > SELECT [Prostheses List].[Billing Code] AS mbs_item_no, > [Prostheses List].MinBenefit AS mbs_item_cost, > [Prostheses List].[Benefit Changed] AS mbs_Cost_Start_Date, > [Prostheses List].[Product Name] AS desc1, > [Prostheses List].[Further Description] AS desc2, > [Prostheses List].Size AS desc3 > FROM [Prostheses List] > WHERE > > ((([Prostheses List].[Changed?])=Yes)) OR ((([Prostheses List].[New?])=Yes)) > > ORDER BY [Prostheses List].[Billing Code]; > > it works fine. > > When I run it in CF, I get the following error: > > Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect > > After some investigation I think the error is related to the question mark character in the where clause. > > I cannot change the field name in the table, as it is provided by the Federal government. > > I've tried text quotes around the field name.. but nothing has worked > > Any idea to get around this? > > > > > > > > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---