[cfaussie] Safari for Windows
Anyone know of a port of Safari for windows? Or even something that will emulate it? --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
[cfaussie] Re: Safari for Windows
If what you want is the KHTML rendering engine that powers safari, you might be able to get it (Konqueror) running in a virtual linux instance on windows: http://jedisthlm.com/2006/01/04/khtml-on-windows-part-iii/ Or you could try http://sourceforge.net/projects/khtml-win32/ Disclaimer: Not used any of these in person, so if your machine blows up, don't blame me :D aside: Or you could get an Apple, and dual boot OSX and windows. Horse drawing cart? Seems to be that these days there are more horses being carted around by horseless carriages than the other way around. rod higgins wrote: Anyone know of a port of Safari for windows? Or even something that will emulate it? -- Haikal Saadh, Applications Programmer Teaching and Learning Support Services K405, Queensland University of Technology, Kelvin Grove Campus [EMAIL PROTECTED], 3864 8633 CRICOS No. 00213J --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
[cfaussie] Re: Safari for Windows
See also http://sourceforge.net/projects/gtk-webcore Same disclaimers apply. Haikal Saadh wrote: If what you want is the KHTML rendering engine that powers safari, you might be able to get it (Konqueror) running in a virtual linux instance on windows: http://jedisthlm.com/2006/01/04/khtml-on-windows-part-iii/ Or you could try http://sourceforge.net/projects/khtml-win32/ Disclaimer: Not used any of these in person, so if your machine blows up, don't blame me :D aside: Or you could get an Apple, and dual boot OSX and windows. Horse drawing cart? Seems to be that these days there are more horses being carted around by horseless carriages than the other way around. rod higgins wrote: Anyone know of a port of Safari for windows? Or even something that will emulate it? -- Haikal Saadh, Applications Programmer Teaching and Learning Support Services K405, Queensland University of Technology, Kelvin Grove Campus [EMAIL PROTECTED], 3864 8633 CRICOS No. 00213J --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
[cfaussie] Re: How to speed up a Related Select Query?
Can CFAJAX handle big queries?? Are there any limits of how much it can handle?? The examples only show a few records. Thanks Jonas --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
[cfaussie] Re: Quoting - calculate the planning to dev to testing ratio
The wonderful debate over what is known as prop work. How much do you give them before you start charging? This can range from documentation to design. Larger studios have the benefit of developed intelectual property of automated templates and well structured methodology to handle a wide range of projects. If there is doubt as to the scope of the project, be up front about it. Quote what you know, build in boundries and a project schedule that allows for quote review at the milestones. It's all about open communication. As Covey says, Win-Win-No Deal. Either they win and you win, or no deal and that's OK. Chad who says no deal... and that's OK On 4/18/06, Duncan [EMAIL PROTECTED] wrote: We are trying to come up with some sort of rough basis so that we can get a ballpark figure back to the client before launching into the Func spec stage. Some dont even want to progress past intial quote with out knowing how much they are letting themselves in for. This, on smaller projects means its a waste of time (because we dont get paid) to go out and do a func spec only for the client to say no. Someone told me that this stuff exists somewhere, but I havent been able to find it. Probably because I am a developer not a project manager. Lets say we have these categories: Func Spec Tech Spec Development Test Scripts Testing Rework Dev documentation User Documentation Implementation What proportion of your time would you spend on these if say your dev hours for project x were 5 days? On 4/18/06, Chad Renando [EMAIL PROTECTED] wrote: No formula here. Factors to consider include the experience of the programmer, the intellectual property of the studio, the level of customization required (including use of pre-built and pre-tested code), the amount of support available for similar types of application (bleeding edge technology vs. crunch and punch), and the main time delayer... amount of client-supplied content or requirements involved. Or you could just use the factor of 2. How long until you're finished? Oh, a couple of hours When will you deliver? In a couple of days How long for build? 2 weeks When will we get paid? In a couple of months :) Chad who will be done in a couple of hours On 4/18/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: A bit OT I know but does any one work with a formula that takes an estimated number of hours in dev and then calculates (roughly) how much time is required for specs, dev, documentation, testing? -- Duncan I Loxton [EMAIL PROTECTED] --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
[cfaussie] Re: Quoting - calculate the planning to dev to testing ratio
The requirement stage is the most important stage of any projectas the dev and testing stage will refer directly back to the requirement stageI say 30% requirement stage (allowing back and forth crap during dev) 55% dev20% testing (allowing back and forth crap)5% maths classesM@ --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
[cfaussie] Re: Safari for Windows
try this: http://www.danvine.com/icapture/ this guy has a mac running and will screen capture on safari for you site. but very slow. --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
[cfaussie] Re: Safari for Windows
I wish. But the client I'm working for has a general manager that just loves mac's and of course loves safari. kind of a showstopper if the code doesnt work on a mac. Here's an idea. Don't support safari. Catering to such a small minority is a waste of time. Get the mac users to use a different browser. Regards Dale Fraser -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, 19 April 2006 11:54 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Safari for Windows Thanks Scott, but the problem Im having is trying to debug some javascript code that's not behaving on safari. Works fine on mozilla, netscape, ie but not safari. Don't you just love javascript. I'll end up trying to run an osx vm or something like it. I looked and looked for ways to emulate safari on a pc with no success. thanks for all the help guys. try this: http://www.danvine.com/icapture/ this guy has a mac running and will screen capture on safari for you site. but very slow. --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
[cfaussie] Re: Safari for Windows
Yeah, An old mac was my next suggestion, or borrow a Mac laptop from someone. Regards Dale Fraser -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Steve Onnis Sent: Wednesday, 19 April 2006 12:22 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Safari for Windows why dont you just look on ebay for an old imac that can run OSX and run safari on it. That way you have a proper testing environment, not only for web, but if your testing stuff like emails for mac email clients, testing for IE on MAC (i know its not supported but people still use it) and firefox on mac aswell. For the sake of $100 get yourself a cheap arse imac Steve -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Wednesday, April 19, 2006 11:54 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Safari for Windows Thanks Scott, but the problem Im having is trying to debug some javascript code that's not behaving on safari. Works fine on mozilla, netscape, ie but not safari. Don't you just love javascript. I'll end up trying to run an osx vm or something like it. I looked and looked for ways to emulate safari on a pc with no success. thanks for all the help guys. try this: http://www.danvine.com/icapture/ this guy has a mac running and will screen capture on safari for you site. but very slow. --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
[cfaussie] Re: SQL search in CFMX 7
Try this Description LIKE cfqueryparam value=%#ARGUMENTS.searchstring#% cfsqltype=cf_sql_varchar/ Regards Dale Fraser From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of George Sent: Wednesday, 19 April 2006 12:17 PM To: cfaussie@googlegroups.com Subject: [cfaussie] SQL search in CFMX 7 Hi all, I try to search a database using 'like' operator but it's not working in CFMX 7. Can anyone see what's wrong? .. Where Description LIKE '%cfqueryparam value=#ARGUMENTS.searchstring# cfsqltype=cf_sql_varchar/%' Thanks, George --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
[cfaussie] Re: SQL search in CFMX 7
Hi Steve, I think it's a bit hard to do it without CF. I have to pass parameters (e.g. search strings, criterias). See more codes below. CFIF LEN(ARGUMENTS.SearchField) AND LEN(ARGUMENTS.searchstring)WHERE CFSWITCH _expression_=#ARGUMENTS.SearchField#CFCASE value=Requester Requester = cfqueryparam value=#ARGUMENTS.searchstring# cfsqltype=cf_sql_varchar//CFCASECFCASE value=DescriptionDescription = cfqueryparam value=#ARGUMENTS.searchstring# cfsqltype=cf_sql_varchar/ /CFCASECFCASE value=jobStatusjobStatus = cfqueryparam value=#ARGUMENTS.searchstring# cfsqltype=cf_sql_varchar//CFCASE CFDEFAULTCASEReq_id = cfqueryparam value=#ARGUMENTS.searchstring# cfsqltype=cf_sql_integer//CFDEFAULTCASE/CFSWITCH/CFIF George On 19/04/06, Steve Onnis [EMAIL PROTECTED] wrote: how about trying it without the queryparam and see if it works? and then actually output whatt he query is and run it outside of cf directly on the database. Maybe its not CF at allmaybe it the query or the data itself Steve -Original Message-From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com]On Behalf Of George Sent: Wednesday, April 19, 2006 12:44 PMTo: cfaussie@googlegroups.com Subject: [cfaussie] Re: SQL search in CFMX 7 Hi Dale, Thank you for the suggestion. However, it doesn't work :( (it returns nothing). Regards, George On 19/04/06, Dale Fraser [EMAIL PROTECTED] wrote: Try this Description LIKE cfqueryparam value=%#ARGUMENTS.searchstring#% cfsqltype=cf_sql_varchar/ RegardsDale Fraser From: cfaussie@googlegroups.com [mailto: cfaussie@googlegroups.com] On Behalf Of GeorgeSent: Wednesday, 19 April 2006 12:17 PM To: cfaussie@googlegroups.comSubject: [cfaussie] SQL search in CFMX 7 Hi all, I try to search a database using 'like' operator but it's not working in CFMX 7. Can anyone see what's wrong? .. Where Description LIKE '%cfqueryparam value=#ARGUMENTS.searchstring# cfsqltype=cf_sql_varchar/%' Thanks, George --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
[cfaussie] Re: SQL search in CFMX 7
then strip out the cfparam tags CFIF LEN(ARGUMENTS.SearchField) AND LEN(ARGUMENTS.searchstring)WHERE CFSWITCH _expression_="#ARGUMENTS.SearchField#"CFCASE value="Requester"Requester = '#ARGUMENTS.searchstring#' /CFCASECFCASE value="Description"Description = '#ARGUMENTS.searchstring#'/CFCASECFCASE value="jobStatus"jobStatus = '#ARGUMENTS.searchstring#'/CFCASE CFDEFAULTCASEReq_id = '#ARGUMENTS.searchstring#'/CFDEFAULTCASE/CFSWITCH/CFIF populate and run the query and see what it ends up looking like. run it against the database and see if you get anything -Original Message-From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED]On Behalf Of GeorgeSent: Wednesday, April 19, 2006 1:55 PMTo: cfaussie@googlegroups.comSubject: [cfaussie] Re: SQL search in CFMX 7 Hi Steve, I think it's a bit hard to do it without CF. I have to pass parameters (e.g. search strings, criterias). See more codes below. CFIF LEN(ARGUMENTS.SearchField) AND LEN(ARGUMENTS.searchstring)WHERE CFSWITCH _expression_="#ARGUMENTS.SearchField#"CFCASE value="Requester"Requester = cfqueryparam value="#ARGUMENTS.searchstring#" cfsqltype="cf_sql_varchar"//CFCASECFCASE value="Description"Description = cfqueryparam value="#ARGUMENTS.searchstring#" cfsqltype="cf_sql_varchar"/ /CFCASECFCASE value="jobStatus"jobStatus = cfqueryparam value="#ARGUMENTS.searchstring#" cfsqltype="cf_sql_varchar"//CFCASE CFDEFAULTCASEReq_id = cfqueryparam value="#ARGUMENTS.searchstring#" cfsqltype="cf_sql_integer"//CFDEFAULTCASE/CFSWITCH/CFIF George On 19/04/06, Steve Onnis [EMAIL PROTECTED] wrote: how about trying it without the queryparam and see if it works? and then actually output whatt he query is and run it outside of cf directly on the database. Maybe its not CF at allmaybe it the query or the data itself Steve -Original Message-From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com]On Behalf Of George Sent: Wednesday, April 19, 2006 12:44 PMTo: cfaussie@googlegroups.com Subject: [cfaussie] Re: SQL search in CFMX 7 Hi Dale, Thank you for the suggestion. However, it doesn't work :( (it returns nothing). Regards, George On 19/04/06, Dale Fraser [EMAIL PROTECTED] wrote: Try this Description LIKE cfqueryparam value="%#ARGUMENTS.searchstring#%" cfsqltype="cf_sql_varchar"/ RegardsDale Fraser From: cfaussie@googlegroups.com [mailto: cfaussie@googlegroups.com] On Behalf Of GeorgeSent: Wednesday, 19 April 2006 12:17 PMTo: cfaussie@googlegroups.comSubject: [cfaussie] SQL search in CFMX 7 Hi all, I try to search a database using 'like' operator but it's not working in CFMX 7. Can anyone see what's wrong? .. Where Description LIKE '%cfqueryparam value="#ARGUMENTS.searchstring#" cfsqltype="cf_sql_varchar"/%' Thanks, George --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
[cfaussie] Re: SQL search in CFMX 7
Is it possible that you are trying to search a numeric field? E.g. WHERE req_id LIKE '%9%' ? That doesn't sound like it should work. Otherwise, cfparam works fine as Steve noted. To my knowledge it does something like this WHERE [field] LIKE cfparam value="%#myvar#%"type="cf_sql_varchar" = DECLARE @var1 varchar SET @var1 = '%#myvar#%' .. WHERE [field] LIKE @var1 --- this works If you try and think objectively about what you are doing you might find a solution -Original Message-From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED]On Behalf Of GeorgeSent: Wednesday, 19 April 2006 2:11 PMTo: cfaussie@googlegroups.comSubject: [cfaussie] Re: SQL search in CFMX 7It works on this ('=') but not for 'like %'. On 19/04/06, Steve Onnis [EMAIL PROTECTED] wrote: then strip out the cfparam tags CFIF LEN(ARGUMENTS.SearchField) AND LEN(ARGUMENTS.searchstring)WHERE CFSWITCH _expression_="#ARGUMENTS.SearchField#"CFCASE value="Requester" Requester = '#ARGUMENTS.searchstring#' /CFCASECFCASE value="Description"Description = '#ARGUMENTS.searchstring#'/CFCASECFCASE value="jobStatus"jobStatus = '#ARGUMENTS.searchstring#' /CFCASE CFDEFAULTCASEReq_id = '#ARGUMENTS.searchstring#'/CFDEFAULTCASE/CFSWITCH/CFIF populate and run the query and see what it ends up looking like. run it against the database and see if you get anything -Original Message-From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com]On Behalf Of George Sent: Wednesday, April 19, 2006 1:55 PMTo: cfaussie@googlegroups.comSubject: [cfaussie] Re: SQL search in CFMX 7 Hi Steve, I think it's a bit hard to do it without CF. I have to pass parameters (e.g. search strings, criterias). See more codes below. CFIF LEN(ARGUMENTS.SearchField) AND LEN(ARGUMENTS.searchstring)WHERE CFSWITCH _expression_="#ARGUMENTS.SearchField#"CFCASE value="Requester"Requester = cfqueryparam value="#ARGUMENTS.searchstring#" cfsqltype="cf_sql_varchar"//CFCASECFCASE value="Description"Description = cfqueryparam value="#ARGUMENTS.searchstring#" cfsqltype="cf_sql_varchar"/ /CFCASECFCASE value="jobStatus"jobStatus = cfqueryparam value="#ARGUMENTS.searchstring#" cfsqltype="cf_sql_varchar"//CFCASE CFDEFAULTCASEReq_id = cfqueryparam value="#ARGUMENTS.searchstring#" cfsqltype="cf_sql_integer"//CFDEFAULTCASE/CFSWITCH/CFIF George On 19/04/06, Steve Onnis [EMAIL PROTECTED] wrote: how about trying it without the queryparam and see if it works? and then actually output whatt he query is and run it outside of cf directly on the database. Maybe its not CF at allmaybe it the query or the data itself Steve -Original Message-From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com]On Behalf Of George Sent: Wednesday, April 19, 2006 12:44 PMTo: cfaussie@googlegroups.com Subject: [cfaussie] Re: SQL search in CFMX 7 Hi Dale, Thank you for the suggestion. However, it doesn't work :( (it returns nothing). Regards, George On 19/04/06, Dale Fraser [EMAIL PROTECTED] wrote: Try this Description LIKE cfqueryparam value="%#ARGUMENTS.searchstring#%" cfsqltype="cf_sql_varchar"/ RegardsDale Fraser From: cfaussie@googlegroups.com [mailto: cfaussie@googlegroups.com] On Behalf Of GeorgeSent: Wednesday, 19 April 2006 12:17 PMTo: cfaussie@googlegroups.comSubject: [cfaussie] SQL search in CFMX 7 Hi all, I try to search a database using 'like' operator but it's not working in CFMX 7. Can anyone see what's wrong? .. Where Description LIKE '%cfqueryparam value="#ARGUMENTS.searchstring#" cfsqltype="cf_sql_varchar"/%' Thanks, George --~--~-~--~~~---~--~~ 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
[cfaussie] Re: SQL search in CFMX 7
Is it a case problem? try lower(Req_id) = cfqueryparam value="%#Lcase(ARGUMENTS.searchstring)#%" cfsqltype="cf_sql_integer"/ What DB Engine are you using? Cheers Gareth. George wrote: It works on this ('=') but not for 'like %'. On 19/04/06, Steve Onnis [EMAIL PROTECTED] wrote: then strip out the cfparam tags CFIF LEN(ARGUMENTS.SearchField) AND LEN(ARGUMENTS.searchstring) WHERE CFSWITCH _expression_="#ARGUMENTS.SearchField#" CFCASE value="Requester" Requester = '#ARGUMENTS.searchstring#' /CFCASE CFCASE value="Description" Description = '#ARGUMENTS.searchstring#' /CFCASE CFCASE value="jobStatus" jobStatus = '#ARGUMENTS.searchstring#' /CFCASE CFDEFAULTCASE Req_id = '#ARGUMENTS.searchstring#' /CFDEFAULTCASE /CFSWITCH /CFIF populate and run the query and see what it ends up looking like. run it against the database and see if you get anything -Original Message- From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com]On Behalf Of George Sent: Wednesday, April 19, 2006 1:55 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: SQL search in CFMX 7 Hi Steve, I think it's a bit hard to do it without CF. I have to pass parameters (e.g. search strings, criterias). See more codes below. CFIF LEN(ARGUMENTS.SearchField) AND LEN(ARGUMENTS.searchstring) WHERE CFSWITCH _expression_="#ARGUMENTS.SearchField#" CFCASE value="Requester" Requester = cfqueryparam value="#ARGUMENTS.searchstring#" cfsqltype="cf_sql_varchar"/ /CFCASE CFCASE value="Description" Description = cfqueryparam value="#ARGUMENTS.searchstring#" cfsqltype="cf_sql_varchar"/ /CFCASE CFCASE value="jobStatus" jobStatus = cfqueryparam value="#ARGUMENTS.searchstring#" cfsqltype="cf_sql_varchar"/ /CFCASE CFDEFAULTCASE Req_id = cfqueryparam value="#ARGUMENTS.searchstring#" cfsqltype="cf_sql_integer"/ /CFDEFAULTCASE /CFSWITCH /CFIF George On 19/04/06, Steve Onnis [EMAIL PROTECTED] wrote: how about trying it without the queryparam and see if it works? and then actually output whatt he query is and run it outside of cf directly on the database. Maybe its not CF at allmaybe it the query or the data itself Steve -Original Message- From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com]On Behalf Of George Sent: Wednesday, April 19, 2006 12:44 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: SQL search in CFMX 7 Hi Dale, Thank you for the suggestion. However, it doesn't work :( (it returns nothing). Regards, George On 19/04/06, Dale Fraser [EMAIL PROTECTED] wrote: Try this Description LIKE cfqueryparam value="%#ARGUMENTS.searchstring#%" cfsqltype="cf_sql_varchar"/ Regards Dale Fraser From: cfaussie@googlegroups.com [mailto: cfaussie@googlegroups.com] On Behalf Of George Sent: Wednesday, 19 April 2006 12:17 PM To: cfaussie@googlegroups.com Subject: [cfaussie] SQL search in CFMX 7 Hi all, I try to search a database using 'like' operator but it's not working in CFMX 7. Can anyone see what's wrong? .. Where Description LIKE '%cfqueryparam value="#ARGUMENTS.searchstring#" cfsqltype="cf_sql_varchar"/%' Thanks, George --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
[cfaussie] Re: SQL search in CFMX 7
cant use cfqueryparam for LIKE clauses cause the % will just get escaped out so it will end up looking like '%%word%%' here is a work around DECLARE @varName varchar(100);SET @varName = cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#Arguments.Value#" maxlength="100";SELECT ...WHEREcolumn LIKE '%' + @varName + '%' Steve --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
[cfaussie] Re: CFINDEX java.lang.NullPointerException
Hi Joel, I know what you're saying, yes it could be something obvious, but I can't see the obvious if that's the case, I went over the columns one by one. cfquery name=rsResume datasource=#application.datasource#SELECT R.resumeIdentity, R.candidateIdentity, R.resumeAsText, R.uniqueFileName , R.fileExtension, R.originalFileName, R.dateStamp, S.salutationTitle, P.firstName, P.lastName , CONCAT( S.salutationTitle, , P.firstName , , P.lastName ) AS fullNameFROM db_au_com_exclaimit.tbl_resume RLEFT OUTER JOIN db_au_com_exclaimit.tbl_candidate CON R.candidateIdentity = C.candidateIdentityLEFT OUTER JOIN db_au_com_exclaimit.tbl_person P ON C.personIdentity = P.personIdentityLEFT OUTER JOIN db_au_com_exclaimit.tbl_l_salutation SON P.salutationIdentity = S.salutationIdentity;/cfquery!--- update database collection --- cftrycfindexaction="" collection=col_au_com_exclaimit_query_newkey=candidateIdentitytype=customtitle=fullName query=rsResumebody=resumeAsText,fullName,originalFileName custom1=uniqueFileName /cfcatchcfset request.Error.doAppendErrorMessage( There was an error updating the collection ) / /cfcatch/cftry On 4/19/06, Joel Cass [EMAIL PROTECTED] wrote: Are all fields valid? Did you make any changes to the tables/query? Null pointer is usually an undefined or null variable (that's my limited knowledge anyway), so maybe something in the input queryis missing? Usually if you can't find it on google it means it never happened before orthe solutionis so obvious that you'll be kicking yourself later. -Original Message-From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com]On Behalf Of Taco FleurSent: Wednesday, 19 April 2006 1:37 PM To: cfaussie@googlegroups.comSubject: [cfaussie] CFINDEX java.lang.NullPointerException I am getting a java.lang.NullPointerException error when updating a collection that is currently completely empty for some reason, and I cannot get it to populate again. When I run the following cfindex I get a java.lang.NullPointerException error. I've tried everything from restartingthe machine, deleting the collection, renaming it, etc. Can't find any info in Google either. Any help would be much appreciated. cfindexaction="" collection=col_au_com_exclaimit_querykey=candidateIdentitytype=customtitle=fullName query=rsResumebody=resumeAsText custom1=uniqueFileName An error occurred while performing an operation in the Search Engine native library. java.lang.NullPointerException The error occurred in D:\Inetpub\wwwroot\internet\development\au_com_exclaim-it\application\candidate\resume\upload\index.cfm: line 124 Called from D:\Inetpub\wwwroot\internet\development\au_com_exclaim-it\onRequestEnd.cfm: line 40Called from D:\Inetpub\wwwroot\internet\development\au_com_exclaim-it\application\OnRequestEnd.cfm: line 1 122 : query=rsResume 123 : body=resumeAsText 124 : custom1=uniqueFileName 125 : cfset application.information.verity.refresh = false / 126 : cfset request.Message.doAppendMessage( You have successfully updated the collection ) / -- Taco Fleur - http://www.pacificfox.com.au Web Design, Web development, Graphic Design and Complete Internet Solutions an industry leader with commercial IT experience since 1994 … -- Taco Fleur - http://www.pacificfox.com.au Web Design, Web development, Graphic Design and Complete Internet Solutions an industry leader with commercial IT experience since 1994 … --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
[cfaussie] Re: CFINDEX java.lang.NullPointerException
Hmm.. Doesn't seem obvious. I haven't had any issues with verity since MX so I'm a bit in the dark here Perhaps, see if other collections can be indexed, if so create a new, differently named index and run the process on that index. If that fails, there might be something in the data that is upsetting verity. You could go through a process of elimination. Otherwise, if none of the collections can be indexed, check configuration orreinstall server? Someone out there must know what's going on.. Perhaps try the macromedia forums... That's about all I can offer.. back to work Joel -Original Message-From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED]On Behalf Of Taco FleurSent: Wednesday, 19 April 2006 2:31 PMTo: cfaussie@googlegroups.comSubject: [cfaussie] Re: CFINDEX java.lang.NullPointerException Hi Joel, I know what you're saying, yes it could be something obvious, but I can't see the obvious if that's the case, I went over the columns one by one. cfquery name="rsResume" datasource="#application.datasource#"SELECT R.resumeIdentity, R.candidateIdentity, R.resumeAsText, R.uniqueFileName , R.fileExtension, R.originalFileName, R.dateStamp, S.salutationTitle, P.firstName, P.lastName , CONCAT( S.salutationTitle, " ", P.firstName , " ", P.lastName ) AS fullNameFROM db_au_com_exclaimit.tbl_resume RLEFT OUTER JOIN db_au_com_exclaimit.tbl_candidate CON R.candidateIdentity = C.candidateIdentityLEFT OUTER JOIN db_au_com_exclaimit.tbl_person P ON C.personIdentity = P.personIdentityLEFT OUTER JOIN db_au_com_exclaimit.tbl_l_salutation SON P.salutationIdentity = S.salutationIdentity;/cfquery!--- update database collection --- cftrycfindexaction="" collection="col_au_com_exclaimit_query_new"key="candidateIdentity"type="custom"title="fullName" query="rsResume"body="resumeAsText,fullName,originalFileName" custom1="uniqueFileName" /cfcatchcfset request.Error.doAppendErrorMessage( "There was an error updating the collection" ) / /cfcatch/cftry On 4/19/06, Joel Cass [EMAIL PROTECTED] wrote: Are all fields valid? Did you make any changes to the tables/query? Null pointer is usually an undefined or "null" variable (that's my limited knowledge anyway), so maybe something in the input queryis missing? Usually if you can't find it on google it means it never happened before orthe solutionis so obvious that you'll be kicking yourself later. -Original Message-From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com]On Behalf Of Taco FleurSent: Wednesday, 19 April 2006 1:37 PM To: cfaussie@googlegroups.comSubject: [cfaussie] CFINDEX java.lang.NullPointerException I am getting a java.lang.NullPointerException error when updating a collection that is currently completely empty for some reason, and I cannot get it to populate again. When I run the following cfindex I get a java.lang.NullPointerException error. I've tried everything from restartingthe machine, deleting the collection, renaming it, etc. Can't find any info in Google either. Any help would be much appreciated. cfindexaction="" collection="col_au_com_exclaimit_query"key="candidateIdentity"type="custom"title="fullName" query="rsResume"body="resumeAsText" custom1="uniqueFileName" An error occurred while performing an operation in the Search Engine native library. java.lang.NullPointerException The error occurred in D:\Inetpub\wwwroot\internet\development\au_com_exclaim-it\application\candidate\resume\upload\index.cfm: line 124 Called from D:\Inetpub\wwwroot\internet\development\au_com_exclaim-it\onRequestEnd.cfm: line 40Called from D:\Inetpub\wwwroot\internet\development\au_com_exclaim-it\application\OnRequestEnd.cfm: line 1 122 : query="rsResume" 123 : body="resumeAsText" 124 : custom1="uniqueFileName" 125 : cfset application.information.verity.refresh = false / 126 : cfset request.Message.doAppendMessage( "You have successfully updated the collection" ) / -- Taco Fleur - http://www.pacificfox.com.au Web Design, Web development, Graphic Design and Complete Internet Solutions an industry leader with commercial IT experience since 1994 … -- Taco Fleur - http://www.pacificfox.com.au Web Design, Web development, Graphic Design and Complete Internet Solutions an industry leader with commercial IT experience since 1994 … --~--~-~--~~~---~--~~ 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
[cfaussie] Re: SQL search in CFMX 7
Thank you Gareth! It's a case issue. It works like this: lower(Requester) like '%#Lcase(ARGUMENTS.searchstring)#%' I'm using SQL 2000 Engine. I don't know why there is a case sensitive now. I guess it's still CFMX 7 issue cause it used to work. Thanks everyone helping me out. Cheers, George On 19/04/06, Gareth Edwards [EMAIL PROTECTED] wrote: Is it a case problem? try lower(Req_id) = cfqueryparam value=%#Lcase(ARGUMENTS.searchstring)#% cfsqltype=cf_sql_integer/What DB Engine are you using? Cheers Gareth. George wrote: It works on this ('=') but not for 'like %'. On 19/04/06, Steve Onnis [EMAIL PROTECTED] wrote: then strip out the cfparam tags CFIF LEN(ARGUMENTS.SearchField) AND LEN(ARGUMENTS.searchstring)WHERE CFSWITCH _expression_=#ARGUMENTS.SearchField#CFCASE value=Requester Requester = '#ARGUMENTS.searchstring#' /CFCASECFCASE value=DescriptionDescription = '#ARGUMENTS.searchstring#'/CFCASECFCASE value=jobStatusjobStatus = '#ARGUMENTS.searchstring#' /CFCASE CFDEFAULTCASEReq_id = '#ARGUMENTS.searchstring#'/CFDEFAULTCASE/CFSWITCH/CFIF populate and run the query and see what it ends up looking like. run it against the database and see if you get anything -Original Message-From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com]On Behalf Of George Sent: Wednesday, April 19, 2006 1:55 PMTo: cfaussie@googlegroups.com Subject: [cfaussie] Re: SQL search in CFMX 7 Hi Steve, I think it's a bit hard to do it without CF. I have to pass parameters (e.g. search strings, criterias). See more codes below. CFIF LEN(ARGUMENTS.SearchField) AND LEN(ARGUMENTS.searchstring)WHERE CFSWITCH _expression_=#ARGUMENTS.SearchField#CFCASE value=Requester Requester = cfqueryparam value=#ARGUMENTS.searchstring# cfsqltype=cf_sql_varchar//CFCASECFCASE value=DescriptionDescription = cfqueryparam value=#ARGUMENTS.searchstring# cfsqltype=cf_sql_varchar/ /CFCASECFCASE value=jobStatusjobStatus = cfqueryparam value=#ARGUMENTS.searchstring# cfsqltype=cf_sql_varchar//CFCASE CFDEFAULTCASEReq_id = cfqueryparam value=#ARGUMENTS.searchstring# cfsqltype=cf_sql_integer//CFDEFAULTCASE/CFSWITCH/CFIF George On 19/04/06, Steve Onnis [EMAIL PROTECTED] wrote: how about trying it without the queryparam and see if it works? and then actually output whatt he query is and run it outside of cf directly on the database. Maybe its not CF at allmaybe it the query or the data itself Steve -Original Message-From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com]On Behalf Of George Sent: Wednesday, April 19, 2006 12:44 PMTo: cfaussie@googlegroups.com Subject: [cfaussie] Re: SQL search in CFMX 7 Hi Dale, Thank you for the suggestion. However, it doesn't work :( (it returns nothing). Regards, George On 19/04/06, Dale Fraser [EMAIL PROTECTED] wrote: Try this Description LIKE cfqueryparam value=%#ARGUMENTS.searchstring#% cfsqltype=cf_sql_varchar/ RegardsDale Fraser From: cfaussie@googlegroups.com [mailto: cfaussie@googlegroups.com] On Behalf Of GeorgeSent: Wednesday, 19 April 2006 12:17 PM To: cfaussie@googlegroups.comSubject: [cfaussie] SQL search in CFMX 7 Hi all, I try to search a database using 'like' operator but it's not working in CFMX 7. Can anyone see what's wrong? .. Where Description LIKE '%cfqueryparam value=#ARGUMENTS.searchstring# cfsqltype=cf_sql_varchar/%' Thanks, George
[cfaussie] Re: CFINDEX java.lang.NullPointerException
Hi, I tried that, same error. I tried deleting the collection etc. one more thing to try and thats creating a new collection with a different query. An error occurred while performing an operation in the Search Engine native library. java.lang.NullPointerException The error occurred in D:\Inetpub\wwwroot\internet\development\au_com_exclaim-it\application\administration\collection\index.cfm: line 44 42 : title=fullName 43 : query=rsResume 44 : body=resumeAsText,fullName,originalFileName / 45 : 46 : cfset application.information.verity.refresh = false / On 4/19/06, Joel [EMAIL PROTECTED] wrote: Hi, Try… Run a simple query and try and index it and leave out the custom1 field if that works add custom1 field in for the same query as in point 1 I think the "uniqueFileName" is empty/NULL hth Joel From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Taco FleurSent: Wednesday, 19 April 2006 2:31 PMTo: cfaussie@googlegroups.com Subject: [cfaussie] Re: CFINDEX java.lang.NullPointerException Hi Joel, I know what you're saying, yes it could be something obvious, but I can't see the obvious if that's the case, I went over the columns one by one. cfquery name=rsResume datasource=#application.datasource#SELECT R.resumeIdentity, R.candidateIdentity, R.resumeAsText, R.uniqueFileName , R.fileExtension, R.originalFileName, R.dateStamp, S.salutationTitle, P.firstName, P.lastName , CONCAT( S.salutationTitle, , P.firstName , , P.lastName ) AS fullNameFROM db_au_com_exclaimit.tbl_resume RLEFT OUTER JOIN db_au_com_exclaimit.tbl_candidate C ON R.candidateIdentity = C.candidateIdentityLEFT OUTER JOIN db_au_com_exclaimit.tbl_person P ON C.personIdentity = P.personIdentityLEFT OUTER JOIN db_au_com_exclaimit.tbl_l_salutation S ON P.salutationIdentity = S.salutationIdentity;/cfquery!--- update database collection --- cftrycfindexaction="" collection=col_au_com_exclaimit_query_new key=candidateIdentitytype=customtitle=fullName query=rsResumebody=resumeAsText,fullName,originalFileName custom1=uniqueFileName / cfcatchcfset request.Error.doAppendErrorMessage( There was an error updating the collection ) / /cfcatch/cftry On 4/19/06, Joel Cass [EMAIL PROTECTED] wrote: Are all fields valid? Did you make any changes to the tables/query? Null pointer is usually an undefined or null variable (that's my limited knowledge anyway), so maybe something in the input queryis missing? Usually if you can't find it on google it means it never happened before orthe solutionis so obvious that you'll be kicking yourself later. -Original Message-From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com]On Behalf Of Taco FleurSent: Wednesday, 19 April 2006 1:37 PM To: cfaussie@googlegroups.comSubject: [cfaussie] CFINDEX java.lang.NullPointerException I am getting a java.lang.NullPointerException error when updating a collection that is currently completely empty for some reason, and I cannot get it to populate again. When I run the following cfindex I get a java.lang.NullPointerException error. I've tried everything from restartingthe machine, deleting the collection, renaming it, etc. Can't find any info in Google either. Any help would be much appreciated. cfindexaction="" collection=col_au_com_exclaimit_querykey=candidateIdentity type=customtitle=fullName query=rsResumebody=resumeAsText custom1=uniqueFileName An error occurred while performing an operation in the Search Engine native library. java.lang.NullPointerException The error occurred in D:\Inetpub\wwwroot\internet\development\au_com_exclaim-it\application\candidate\resume\upload\index.cfm: line 124 Called from D:\Inetpub\wwwroot\internet\development\au_com_exclaim-it\onRequestEnd.cfm: line 40Called from D:\Inetpub\wwwroot\internet\development\au_com_exclaim-it\application\OnRequestEnd.cfm: line 1 122 : query=rsResume 123 : body=resumeAsText 124 : custom1=uniqueFileName125 : cfset application.information.verity.refresh = false /126 : cfset request.Message.doAppendMessage( You have successfully updated the collection ) / -- Taco Fleur - http://www.pacificfox.com.au Web Design, Web development, Graphic Design and Complete Internet Solutions an industry leader with commercial IT experience since 1994 … -- Taco Fleur - http://www.pacificfox.com.au Web Design, Web development, Graphic Design and Complete Internet Solutions an industry leader with commercial IT experience since 1994 … http://www.pacificfox.com.au Web Design, Web development, Graphic Design and Complete Internet Solutionsan industry leader with commercial IT experience since 1994 … --~--~-~--~~~---~--~~ 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
[cfaussie] Re: Spaces in table names nightmare
Thanks. Working now. On 4/19/06, grant [EMAIL PROTECTED] wrote: isn't it square brackets, i.e. [dbo].[TEST Sydney IVFLimited$Classification Rate] --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---