RE: form validation utilizing database field types/sizes/etc
There may be another way, but I know you can get field types, etc. from the ALL_TAB_COLUMNS table. SELECT column_name,data_length,data_type,nullable FROM ALL_TAB_COLUMNS WHERE TABLE_NAME = 'MYTABLE' You could use that information to build some validation based on the values returned. Dave -Original Message- From: Mike Soultanian [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 14, 2005 12:19 PM To: CF-Talk Subject: form validation utilizing database field types/sizes/etc I was wondering if there is a way to pull column information from oracle to help with form validation. It would be really nice if I could set up my database and then have coldfusion read the setup of my tables and perform its form validation based on that. I did some research on this and it seems like SQL server supports a standard format using INFORMATION_SCHEMA to return the column types and sizes and what not. Is there some way to pull similar information from oracle so I can use that for form validation purposes? Thanks, Mike ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218258 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Do Not Include CFID & CFTOKEN in URL?
> isdefined("cookie.CFTOKEN")>
>
>
>
>
>
This will properly set the cookies to expire when the browser is closed.
That's the default when an EXPIRES attribute is not included in CFCOOKIE.
There are a number of ways to do this, but your code, as written here, should
work and not cause any problem.
Dave
**
The information contained in this message, including attachments, may contain
privileged or confidential information that is intended to be delivered only to
the
person identified above. If you are not the intended recipient, or the person
responsible for delivering this message to the intended recipient, ALLTEL
requests
that you immediately notify the sender and asks that you do not read the
message or its
attachments, and that you delete them without copying or sending them to anyone
else.
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218218
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Replace String
There are probably a number of ways to do this. Here's one: (dbfield is your query results field that has the text in it) ","Phone number changed from ","all") > "," to ","all") > ","","all")> If they are multiple possibilities of case, use replacenocase instead. Dave -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 14, 2005 10:08 AM To: CF-Talk Subject: Replace String I need to be able to search a string and make multiple replacements in it. For example, I have a string that is coming out of the database with weird characters 410-333-1234410-333-4321 I want to replace with "Phone number changed from And I want to replace with "to" And simply delete Any help is much appreciated. Thank you ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218207 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Populating Radio Buttons in CFFORM?
Looks like I should have read further. I stand corrected. It is optional to include true or false values. Dave -Original Message- From: Phillips, Dave Sent: Wednesday, September 14, 2005 9:11 AM To: CF-Talk Subject: RE: Populating Radio Buttons in CFFORM? Ian, Check the docs: http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-p65.htm#wp1100379 docs shows the proper attribute is simply CHECKED. The reason your first thing didn't work is you can't embed a That will do it. Be sure to CFLOCK your session variable. Dave ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218198 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Populating Radio Buttons in CFFORM?
Ian, Check the docs: http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-p65.htm#wp1100379 docs shows the proper attribute is simply CHECKED. The reason your first thing didn't work is you can't embed a That will do it. Be sure to CFLOCK your session variable. Dave -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 14, 2005 8:58 AM To: CF-Talk Subject: RE: Populating Radio Buttons in CFFORM? Just tried the following code Yes No Which returns Error Occurred While Processing Request cannot convert the value "" to a boolean Looks as if you cant use checked="#session.test.applicant#" to pre populate radio buttons, Is it possible to achieve this in Coldfusion ? ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218195 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Storing UDF in application scope
Hi,
I want to store a UDF in the application scope. Anyone know a trick to this
and/or any issues regarding it? Here's what I tried that didn't work:
function MyFunc() { ...function definition... }
I get a "MyFunc" doesn't exist error. I'm sure there's a trick to this, but I
haven't found it yet.
Thanks,
Dave
**
The information contained in this message, including attachments, may contain
privileged or confidential information that is intended to be delivered only to
the
person identified above. If you are not the intended recipient, or the person
responsible for delivering this message to the intended recipient, ALLTEL
requests
that you immediately notify the sender and asks that you do not read the
message or its
attachments, and that you delete them without copying or sending them to anyone
else.
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218040
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Storing UDF in application scope
Ryan,
Thanks. I know that I can do that. I need to find out if there's a way to put
it in the application scope WITHOUT using a component.
Thanks,
Dave
-Original Message-
From: Ryan Guill [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 13, 2005 12:26 PM
To: CF-Talk
Subject: Re: Storing UDF in application scope
put it in a component, and then create an object of the component in
the application scope. It wont be directly in the application scope,
but in a variable in the application scope.
application.myudfs.myudf()
On 9/13/05, Dave Phillips <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I want to store a UDF in the application scope. Anyone know a trick to this
> and/or any issues regarding it? Here's what I tried that didn't work:
>
>
> function MyFunc() { ...function definition... }
>
>
>
>
>
> I get a "MyFunc" doesn't exist error. I'm sure there's a trick to this, but
> I haven't found it yet.
>
> Thanks,
>
> Dave
>
>
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218034
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Expiring time of cookies for session management
Hi, I'm trying to clarify the expiration time for the Cookie.CFID and Cookie.CFTOKEN cookies created when a new session starts. Is it the length of the time that is specified in the sessionmanagement attribute of the cfapplication tag? If so, is this documented anywhere? I did find some documentation (on livedocs) on how to make the cookies automatically expire when the browser is closed, but I need to know what is actually happening when those cookies are created by CF and I need some documentation to back it up if at all possible. Thanks, Dave ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217962 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfapplication
#server.coldfusion.productversion# I believe that will do it. Dave -Original Message- From: daniel kessler [mailto:[EMAIL PROTECTED] Sent: Monday, September 12, 2005 8:06 AM To: CF-Talk Subject: Re: cfapplication I am not sure. I tried to find a function that gives me the version of cold fusion, but I could not. >You using CFMX7? ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217921 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Testing - Not received anything since 7pm Eastern Friday
Anyone out there? Dave ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217875 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: New window in cflocation
Great idea Ian! Dave -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Friday, September 09, 2005 5:09 PM To: CF-Talk Subject: RE: New window in cflocation However, if the page you're trying to open into a new window has too much data to fit into a 'popup' style div block and still maintain some aesthetic integrity, then it may not be an option. Dave Actually, I just recently used this technique combined with named anchors and the overflow: scroll property to create a nice div/CSS based popup that contained a fair amount a data in it. I used a nested div so that the headers of the data stay visible above the scrolling cells. Now, if the data was so massive that it would effect the download time, then I would look for a different solution. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!" - Cynthia Dunning ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217865 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: More RegExp help...
Ben, That's it. Makes pefect sense now. Thanks! Dave -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Friday, September 09, 2005 5:17 PM To: CF-Talk Subject: Re: More RegExp help... rereplace(string, "_[0-9]+x[0-9]+\.png", ""); If the pixel size (I assume that's what the numbers are) is always a square, you might use backreferencing to make it a bit pickier, but it probably isn't necessary. Assume the usual caveats. --Ben [EMAIL PROTECTED] wrote: > Hey folks, > > I have a regular expression I need for the following: > > I have filenames that have the following appended to them: > > filename_100x100.png > filename_640x480.png > filename_86x86.png > and so on > > I need to extract JUST the filename. The kicker is, the filename MAY include > underscores, so I can't just search for that. I know I could do several > finds on the different resolutions, but I also know there's got to be a nifty > way with a RegEx to do it. Anyone want to take a stab at it? > > Thanks, > > Dave > > ** > The information contained in this message, including attachments, may contain > privileged or confidential information that is intended to be delivered only > to the > person identified above. If you are not the intended recipient, or the person > responsible for delivering this message to the intended recipient, ALLTEL > requests > that you immediately notify the sender and asks that you do not read the > message or its > attachments, and that you delete them without copying or sending them to > anyone else. > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217864 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
More RegExp help...
Hey folks, I have a regular expression I need for the following: I have filenames that have the following appended to them: filename_100x100.png filename_640x480.png filename_86x86.png and so on I need to extract JUST the filename. The kicker is, the filename MAY include underscores, so I can't just search for that. I know I could do several finds on the different resolutions, but I also know there's got to be a nifty way with a RegEx to do it. Anyone want to take a stab at it? Thanks, Dave ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217859 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: New window in cflocation
That's a good point Rick.
Robert, if this is a problem, you could always create an absolutely positioned
DIV block, hide it, and then when you're ready to show the information display
it with a higher z-index (so it overlays your existing page). This type of
'pop up' is not blocked by most pop up blockers because it's not actually a
window. However, if the page you're trying to open into a new window has too
much data to fit into a 'popup' style div block and still maintain some
aesthetic integrity, then it may not be an option. Just wanted to mention it
also.
Dave
-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED]
Sent: Friday, September 09, 2005 4:22 PM
To: CF-Talk
Subject: Re: New window in cflocation
Keep in mind that EVERY popup blocker will block it. =)
Rick
Orlini, Robert wrote:
> Good code Dave. Thanks all nonetheless.
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 09, 2005 3:02 PM
> To: CF-Talk
> Subject: RE: New window in cflocation
>
>
> Robert,
>
> Use Javascript:
>
>
>
> window.open('getinventoryprintout.cfm?id=#form.id#','popwin','scrollbars=yes/no...');
>
>
>
> You can add other features if you want. Here's the reference:
>
> http://www.devguru.com/technologies/javascript/10894.asp
>
> Dave
>
> -Original Message-
> From: Orlini, Robert [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 09, 2005 2:45 PM
> To: CF-Talk
> Subject: New window in cflocation
>
>
> How do I embed a popup in the cflocation url command.
>
> I have: and I want
> it to to launch as a new window. Can it be done within ? Or is
> there a better way?
>
> Thanks.
>
> Robert O.
> HWW
>
**
The information contained in this message, including attachments, may contain
privileged or confidential information that is intended to be delivered only to
the
person identified above. If you are not the intended recipient, or the person
responsible for delivering this message to the intended recipient, ALLTEL
requests
that you immediately notify the sender and asks that you do not read the
message or its
attachments, and that you delete them without copying or sending them to anyone
else.
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217857
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Custom Tag question
DUH! My brain isn't functioning today!!! Thanks BB. Dave -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Friday, September 09, 2005 3:49 PM To: CF-Talk Subject: Re: Custom Tag question Use caller.forceLinkTargetBlank from within your tag. cheers, barneyb On 9/9/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hi, > > I have a custom tag. It needs to have access to a UDF that I've created. > The UDF is stored in a file called application_udfs.cfm which is CFINCLUDED > in the application.cfm file of my application. Here's my problem: > > 1. If I run the page as is, my custom tag fails saying that the 'Variable > ForceLinkTargetBlank Is Undefined'. > > 2. If I do a in my custom tag to include that > application_udfs.cfm file (so it can see the UDF), I get this error: > > Routines cannot be declared more than once. > The routine "ForceLinkTargetBlank" has been declared twice in different > templates. > > I'm stumped. I know this is something simple, but I guess it being a Friday > afternoon it's escaping me. Any ideas on how I can debug this thing and > figure out what's going on? > > Dave -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217847 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Custom Tag question
Could the problem be that this custom tag is being imported with CFIMPORT on the page, and then it's being called? When you CFIMPORT would it then define the UDF and then try again when you call the particular custom tag? Dave -Original Message- From: Phillips, Dave Sent: Friday, September 09, 2005 3:45 PM To: CF-Talk Subject: Custom Tag question Hi, I have a custom tag. It needs to have access to a UDF that I've created. The UDF is stored in a file called application_udfs.cfm which is CFINCLUDED in the application.cfm file of my application. Here's my problem: 1. If I run the page as is, my custom tag fails saying that the 'Variable ForceLinkTargetBlank Is Undefined'. 2. If I do a in my custom tag to include that application_udfs.cfm file (so it can see the UDF), I get this error: Routines cannot be declared more than once. The routine "ForceLinkTargetBlank" has been declared twice in different templates. I'm stumped. I know this is something simple, but I guess it being a Friday afternoon it's escaping me. Any ideas on how I can debug this thing and figure out what's going on? Dave ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217844 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFLocation LF and 7
The only thing I can think of is add some code to check for a LF after you've encrypted, and if so, change it to another character, or truncate it. You'd have to pass some sort of additional parameter to the calling page so that before you Decrypt, you add the LF back so that the Decryption works properly. Dave -Original Message- From: JediHomer [mailto:[EMAIL PROTECTED] Sent: Friday, September 09, 2005 11:58 AM To: CF-Talk Subject: CFLocation LF and 7 Hi, We have an app that runs fine on good old MX6.1. Basically a confirmation email is sent out to a user with a click here to update your details. This link has an ID that's encrypted with CF's Encrypt, the result of this is then URLEncoded. All works fine until we upgraded the server to 7. When they click the link, their details are updated and a confirmation page is displayed, the problem we are having is that we are passing the encoded var into a CFLocation tag, the ID in this case after encoding is: %24%28%20%3FGUP%20%20%0A Which for the eagle eyed people contains a LF, although as you can see, its really a %0A the problem we are experiencing is that CFLocation is throwing the following error: Failed to perform redirection. ColdFusion was unable to perform the CFLOCATION operation. Location URL cannot contain (carriage return) CR or (line feed) LF characters Anyone know of a work around, without changing the encrypt / decrypt functions as the site has been live for a while? TIA Jedi ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217842 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Custom Tag question
Hi, I have a custom tag. It needs to have access to a UDF that I've created. The UDF is stored in a file called application_udfs.cfm which is CFINCLUDED in the application.cfm file of my application. Here's my problem: 1. If I run the page as is, my custom tag fails saying that the 'Variable ForceLinkTargetBlank Is Undefined'. 2. If I do a in my custom tag to include that application_udfs.cfm file (so it can see the UDF), I get this error: Routines cannot be declared more than once. The routine "ForceLinkTargetBlank" has been declared twice in different templates. I'm stumped. I know this is something simple, but I guess it being a Friday afternoon it's escaping me. Any ideas on how I can debug this thing and figure out what's going on? Dave ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217840 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: New window in cflocation
Robert,
Use Javascript:
window.open('getinventoryprintout.cfm?id=#form.id#','popwin','scrollbars=yes/no...');
You can add other features if you want. Here's the reference:
http://www.devguru.com/technologies/javascript/10894.asp
Dave
-Original Message-
From: Orlini, Robert [mailto:[EMAIL PROTECTED]
Sent: Friday, September 09, 2005 2:45 PM
To: CF-Talk
Subject: New window in cflocation
How do I embed a popup in the cflocation url command.
I have: and I want it
to to launch as a new window. Can it be done within ? Or is there a
better way?
Thanks.
Robert O.
HWW
--
**
The information contained in this message, including attachments, may contain
privileged or confidential information that is intended to be delivered only to
the
person identified above. If you are not the intended recipient, or the person
responsible for delivering this message to the intended recipient, ALLTEL
requests
that you immediately notify the sender and asks that you do not read the
message or its
attachments, and that you delete them without copying or sending them to anyone
else.
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217834
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Can CSS and Layers Take the Place of Tables for Displaying Dynamic Data?
Must be Friday. Dave -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Friday, September 09, 2005 2:36 PM To: CF-Talk Subject: Re: Can CSS and Layers Take the Place of Tables for Displaying Dynamic Data? your mother uses tables for layout. ; ) On 9/9/05, Bryan Stevenson <[EMAIL PROTECTED]> wrote: > > Actually as wars go on this list this one is pretty tame :) > > > > I have yet to hear anyone's mother mentioned. > > your mother! ;-) > > Bryan Stevenson B.Comm. > VP & Director of E-Commerce Development > Electric Edge Systems Group Inc. > phone: 250.480.0642 > fax: 250.480.1264 > cell: 250.920.8830 > e-mail: [EMAIL PROTECTED] > web: www.electricedgesystems.com > > ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217828 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Simple CFC quesiton
Oh yeah. Now I remember. ;-) Dave -Original Message- From: Brian Kotek [mailto:[EMAIL PROTECTED] Sent: Friday, September 09, 2005 11:31 AM To: CF-Talk Subject: Re: Simple CFC quesiton (Original poster was making a Hitchhiker's Guide to the Galaxy reference.) ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217769 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Simple CFC quesiton
Who the heck is Zarquon? Dave -Original Message- From: Brian Kotek [mailto:[EMAIL PROTECTED] Sent: Friday, September 09, 2005 11:14 AM To: CF-Talk Subject: Re: Simple CFC quesiton Holy Zarquon's singing fish! I absolutely LOVE it when people completely miss the intent of the author, the footnote, and the point! On 9/9/05, Ken Ferguson <[EMAIL PROTECTED]> wrote: > Holy Zarquon's singing fish! I absolutely LOVE it when we get into these > discussions where the "you should never..." starts coming up. ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217766 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Charting Alternatives
And I'm sure NO ONE has ever done THAT before... ;-) Dave -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Friday, September 09, 2005 10:59 AM To: CF-Talk Subject: Re: Charting Alternatives [EMAIL PROTECTED] wrote: > > I found this blog posting that might help: > > http://cfchart.blogspot.com/2005/07/modifying-look-and-feel-of-charts-part.html That's cool and it works great, thanks! I just realized I was looking at the wrong version of the manual on livedocs, or I might've caused less list traffic! Rick ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217759 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Charting Alternatives
Rick, I found this blog posting that might help: http://cfchart.blogspot.com/2005/07/modifying-look-and-feel-of-charts-part.html Here's a quote: "For changing the line width the attribute that is used is "linewidth", in the child tag of the xml document." Hope it helps! Dave -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Friday, September 09, 2005 10:37 AM To: CF-Talk Subject: Re: Charting Alternatives Tom McNeer wrote: > Rick, > > What version of CF? CFMX7 definitely has ways to control the line width. > They're in the associated XML "stylesheet," not in the attributes of the > tag; but they're easily changed. Is that "undocumented"? the "default.xml" doesn't seem to have anything in it relating to line thickness. Are you talking about the WCP files in the charting/gallery/* directories? Rick ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217753 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: JPG-scraping... brainfart
Better yet: http://www.google.co.uk/intl/en_uk/images/logo.gif"; getasbinary="yes" path="C:\DIRECTORYTOSAVEIMAGEIN" > There is also a file attribute if you want to specify the file, but if you just want it to be the same filename as the one you GET, then leave it off (like I did above). Otherwise, specify the file attribute with the new filename. Obviously, you can replace the path above with any path available to your server. Dave -Original Message- From: Kerry [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 07, 2005 12:35 PM To: CF-Talk Subject: RE: JPG-scraping... brainfart http://www.google.co.uk/intl/en_uk/images/logo.gif"; getasbinary="yes"> ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217543 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
FW: Calling remote CFCs
Oops...that was supposed to be: http://someserver.com/test.cfc?method=CallMe"; METHOD="GET" TIMEOUT="5"> ..cfc instead of .cfm Sorry. Dave -Original Message- From: Phillips, Dave Sent: Tuesday, September 06, 2005 2:08 PM To: 'cf-talk@houseoffusion.com' Subject: RE: Calling remote CFCs > I've been searching for the past few days trying to find a > way to call a CFC on a different server. I'd like not to use > a web service. Is it possible? Although this isn't good practice, couldn't you technically do this: http://someserver.com/test.cfm?method=CallMe"; METHOD="GET" TIMEOUT="5"> ??? I haven't tried it, but I seem to remember you can call a .CFC directly through a browser and execute the method like that, so if one didn't want to use http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217474 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Calling remote CFCs
> I've been searching for the past few days trying to find a > way to call a CFC on a different server. I'd like not to use > a web service. Is it possible? Although this isn't good practice, couldn't you technically do this: http://someserver.com/test.cfm?method=CallMe"; METHOD="GET" TIMEOUT="5"> ??? I haven't tried it, but I seem to remember you can call a .CFC directly through a browser and execute the method like that, so if one didn't want to use http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217472 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Trying to ensure links have a target attribute
Thanks!
Dave
-Original Message-
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED]
Sent: Saturday, September 03, 2005 5:10 PM
To: CF-Talk
Subject: RE: Trying to ensure links have a target attribute
Try this. It should take care of all instances you run across. If the raget
attribute is in fact in a valid link, it either ends with a space or a
closing bracket >
http://mysite.com"; target="_blank">1
http://mysite.com"; target="_self" title="something">2
http://mysite.com";>3
http://mysite.com";>4
http://mysite.com"; target='_nada'>5
function targetlinks(str, targ)
{
str = rereplacenocase(str,'( target=.*?)([ |>])',"\2","ALL");
str = replacenocase(thetext, "
#targetlinks(thetext, "_blank")#
The first rereplace strips out all target attributes. The second puts the
attribute back with the value you pass to the function.
It seems to work with everything I've thrown at it thus far.
~Bobby
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Saturday, September 03, 2005 3:57 PM
To: CF-Talk
Subject: RE: Trying to ensure links have a target attribute
Okay, this is what I got, and it works, but I'm wondering if there's a way
to combine all three replaces into one:
|^
]*',"","ALL")>
What do you think? Also, if you see something wrong with these, please let
me know. I've tested and it seems to work right, but I don't know if it
might actually get something I'm not thinking of.
Thanks,
Dave
**
The information contained in this message, including attachments, may
contain
privileged or confidential information that is intended to be delivered only
to the
person identified above. If you are not the intended recipient, or the
person
responsible for delivering this message to the intended recipient, ALLTEL
requests
that you immediately notify the sender and asks that you do not read the
message or its
attachments, and that you delete them without copying or sending them to
anyone else.
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217302
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Trying to ensure links have a target attribute
Okay, this is what I got, and it works, but I'm wondering if there's a way to combine all three replaces into one: |^ ]*',"","ALL")> What do you think? Also, if you see something wrong with these, please let me know. I've tested and it seems to work right, but I don't know if it might actually get something I'm not thinking of. Thanks, Dave ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217299 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Trying to ensure links have a target attribute
Isaac,
First of all, thanks! In my case, we are on MX 6.1 here, so the basic approach
is working. I need to account for target=... and target='...' as well as just
target="...". So, I tried the following, but it's cutting out more than I want
it to:
Thanks for you help.
Dave
-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: Saturday, September 03, 2005 3:43 PM
To: CF-Talk
Subject: Re: Trying to ensure links have a target attribute
> Hi,
> I need to be able to take in a specific body of text,
> search the text for any html links in it, and ensure that
> the html links have a target="_blank" attribute so they
> will all open in a new window, and then output the body of
> text with the newly modified links (or left alone if they
> were okay).
> I know that I will probably need to do this with
> REReplaceNoCase, but I'm not an expert in regular
> expressions by any means. I started by trying to find the
> links with this:
> REFindNoCase("",textbody)
> But that's not working right. If anyone working today is
> familiar with regexps, I could use some help.
If you require the input to be valid xml, then you can also use an XSL
transformation:
Or
_blank
It's more code yes, but if you're requiring XML content, this will be
more bullet-proof than the regular expression solution. On CF7 you can
put the XSL sheet in a separate template and just use the absolute
path to the file in the XMLTransform function, i.e.:
s. isaac dealey 954.522.6080
new epoch : isn't it time for a change?
add features without fixtures with
the onTap open source framework
http://www.fusiontap.com
http://coldfusion.sys-con.com/author/4806Dealey.htm
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217298
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Trying to ensure links have a target attribute
This is my latest concoction:
refindnocase("",bodytext)
It finds the links, but it finds ALL links, regardless of whether they have a
target attribute or not. I need only the ones that DON'T have a target
attribute.
Any help would be greatly apprecaited.
Thanks,
Dave
-Original Message-
From: Phillips, Dave
Sent: Saturday, September 03, 2005 3:18 PM
To: CF-Talk
Subject: Trying to ensure links have a target attribute
Hi,
I need to be able to take in a specific body of text, search the text for any
html links in it, and ensure that the html links have a target="_blank"
attribute so they will all open in a new window, and then output the body of
text with the newly modified links (or left alone if they were okay).
I know that I will probably need to do this with REReplaceNoCase, but I'm not
an expert in regular expressions by any means. I started by trying to find the
links with this:
REFindNoCase("",textbody)
But that's not working right. If anyone working today is familiar with regexps,
I could use some help.
Thanks,
Dave
**
The information contained in this message, including attachments, may contain
privileged or confidential information that is intended to be delivered only to
the
person identified above. If you are not the intended recipient, or the person
responsible for delivering this message to the intended recipient, ALLTEL
requests
that you immediately notify the sender and asks that you do not read the
message or its
attachments, and that you delete them without copying or sending them to anyone
else.
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217295
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Trying to ensure links have a target attribute
Hi,
I need to be able to take in a specific body of text, search the text for any
html links in it, and ensure that the html links have a target="_blank"
attribute so they will all open in a new window, and then output the body of
text with the newly modified links (or left alone if they were okay).
I know that I will probably need to do this with REReplaceNoCase, but I'm not
an expert in regular expressions by any means. I started by trying to find the
links with this:
REFindNoCase("",textbody)
But that's not working right. If anyone working today is familiar with regexps,
I could use some help.
Thanks,
Dave
**
The information contained in this message, including attachments, may contain
privileged or confidential information that is intended to be delivered only to
the
person identified above. If you are not the intended recipient, or the person
responsible for delivering this message to the intended recipient, ALLTEL
requests
that you immediately notify the sender and asks that you do not read the
message or its
attachments, and that you delete them without copying or sending them to anyone
else.
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217294
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Katrina Relief and BlogFusion
Why did you change this to Red Cross? I'm not interested in donating to a now political organization. I recommend Salvation Army or United Way. Dave -Original Message- From: Jake . [mailto:[EMAIL PROTECTED] Sent: Thursday, September 01, 2005 5:20 PM To: CF-Talk Subject: OT: Katrina Relief and BlogFusion In an effort to help out our friends in the South, especially New Orleans, I'd like to do my part. For any donation (via paypal), I'll give a free commercial license of BlogFusion for the next two weeks (or longer if it's needed, but I'm being optimistic and hoping it won't need to be that long). Click on the link in the blog entry referenced below, donate some cash, then drop me an email with your info. I'll send you download instructions as quickly as I can. Donation Link: http://www.blogfusion.com/blog/index.cfm?commentID=29 I'll be sending anything and everything donated under this program to the United Way. If you'd like to see an accounting or a receipt of donation, please email me (jakeATcountersinkdgDOTcom). I'd post it, but I'd rather respect people's privacy. Even if you don't donate through me, please head over to the United Way and help out. Jake --- BlogFusion.com ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217261 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Converting DOCs to PDF with CF
Here's a program that does it: http://www.convertzone.com/doc2pdf/help.htm I've not used, it, just googled for it. You can call it with command line arguments with CFEXECUTE. Dave -Original Message- From: Michel Deloux [mailto:[EMAIL PROTECTED] Sent: Friday, September 02, 2005 12:23 PM To: CF-Talk Subject: Converting DOCs to PDF with CF Hi all it's possible to convert DOC and XLS files to PDF using CF MX? Aaron Johnson talks about Jakarta Project and POI to do that. Anyone have experience about? Cheers MD ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217260 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: numbers with decimal places to the right
If you wanted a true decimal field (not money) then you would specify column type like this: DECIMAL(5,3) Where 5 is how many total digits you want (excluding the decimal) and 3 is how many digits you want to the RIGHT of the decimal. Dave -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Friday, September 02, 2005 2:23 PM To: CF-Talk Subject: Re: numbers with decimal places to the right INT says you want integers: whole numbers without decimal parts. You should change the column to be MONEY, which will allow for fractional amounts (cents). cheers, barneyb ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217254 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: This just seems to fit todays theme.
Sorry, I know this is OT, but I had to say something. These people aren't Christians, but actually a sect. They are not part of any major denomination, even though they use the name Baptist in their church. http://en.wikipedia.org/wiki/Westboro_Baptist_Church_(Topeka) The church is held in the guy's basement. It's David Koresh all over again. I know this belongs in CF-Community, so I won't post to this again. Dave -Original Message- From: Dana [mailto:[EMAIL PROTECTED] Sent: Friday, September 02, 2005 2:22 PM To: CF-Talk Subject: Re: This just seems to fit todays theme. all I can say is... with what is going on elsewhere, this is what they find to do? My sweet Lord. It takes chutzpah to call yourself a Christian in the circumstances. Dana On 9/2/05, Ian Skinner <[EMAIL PROTECTED]> wrote: > > > http://news.yahoo.com/news?tmpl=story&u=/ap/20050828/ap_on_re_us/soldier_funeral_protests > > And a discussion thread on it at another site. > > http://msgboard.snopes.com/message/ultimatebb.php?/ubb/get_topic/f/67/t/001879/p/1.html > > > > ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217253 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Sql Server DECIMAL datatype
Try Price as decimal(9,2). Dave -Original Message- From: Matthew Small [mailto:[EMAIL PROTECTED] Sent: Thursday, September 01, 2005 10:35 AM To: CF-Talk Subject: RE: Sql Server DECIMAL datatype OK, I did this and it still does not help. I don't understand why this is a problem. Could by chance is the decimal datatype in the SP be the problem? I'm going to check into that, but I don't quite know how to fix the problem if it is. It basically looks like: StoredProc TableId as int, Price as decimal, etc Is there a way to define the decimal datatype for Price so it has a scale of 2? Thank you, Matthew Small Web Developer American City Business Journals 704-973-1045 [EMAIL PROTECTED] ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217097 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Sql Server DECIMAL datatype
Your problem is Scale 0. Check out this page: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_da-db_8rc5.asp "Precision is the number of digits in a number. Scale is the number of digits to the right of the decimal point in a number. For example, the number 123.45 has a precision of 5 and a scale of 2." If you have a precision of 18 and a scale of 0, that means you are allowed 18 digits total, but zero can be to the right of the decimal point, which would force your values to be stored as integers. Change the data type to a scale of 2 or 4 or however many digits you want to the right of the decimal point, and adjust your precision if necessary to allow the correct total number of digits. So, for example, if you want a maximum of say nine million nine hundred ninety-nine thousand nine hundred ninety-nine dollars and ninety-nine cents, you would do it like this: 999.99 = precision 9, scale 2 Dave -Original Message- From: Matthew Small [mailto:[EMAIL PROTECTED] Sent: Thursday, September 01, 2005 10:05 AM To: CF-Talk Subject: RE: Sql Server DECIMAL datatype 18. I previously had the datatype as money, but am in the process of trying decimal right now. Scale 0. These are default entries. ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217092 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Sql Server DECIMAL datatype
Do you know what the precision is set to on the column? Dave -Original Message- From: Matthew Small [mailto:[EMAIL PROTECTED] Sent: Thursday, September 01, 2005 9:57 AM To: CF-Talk Subject: OT: Sql Server DECIMAL datatype Hi, I have a strange problem using the decimal datatype in MS SQL 2000. I have a "price" field in a table that is of the decimal datatype. I have a stored procedure that should store a decimal number into the table. However, when the number is stored, it is rounded as if it were an integer. I can't figure out what's going on with it. Does anybody have any pointers on how to use this datatype? BTW, I don't want to change this datatype to anything else just yet. Thank you, Matthew Small ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217088 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Paging through records
Good points. Thanks for your comments. :) Dave -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 31, 2005 3:06 PM To: CF-Talk Subject: RE: Paging through records > I think it applies because the whole discussion was about > what's a 'faster' way to do this... > My point is that the second query is getting the data to > display on the page in question (say records 51 - 100), so > why does the first query need to return all rows of the > data? If the first query is purely to get a count (so you > know what to divide by to split up your pages) then it > seems to me to be unnecessary to return the additional > data that won't even be accessed. The second query (of > the 2 query approach) gets the actual data to display and > (in this scenario) would only contain 50 records. > The example I gave would of course need to have a WHERE > clause limiting to whatever the particular criteria is for > this page display...it wasn't just to get an arbitrary > count of all the records IN ADDITION to the 2 queries in > your approach. > The whole point was to say that using Count(ID) is faster > than using Count(*) or SELECT ID (getting all rows). Okay... Well... I was commenting specifically on the example where an ID column is fetched to filter the results being returned in the 2nd query, but I guess you're right, if you used another method like Oracle's MINUS clause to limit the records in the 2nd query, then you would need another method of getting the total number of records... however... I'm less inclined to think that approach would be faster because then you need all your where clause filters both in the data query and again in the count() query. My suspicion is that the execution plan for the query that uses just the primary key column (which you wouldn't have in this case) would be much more efficient than the execution plan for a query containing multiple references to non-primary columns in the where clause... I could be wrong, it's happened before. :) s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217040 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Paging through records
I think it applies because the whole discussion was about what's a 'faster' way to do this... My point is that the second query is getting the data to display on the page in question (say records 51 - 100), so why does the first query need to return all rows of the data? If the first query is purely to get a count (so you know what to divide by to split up your pages) then it seems to me to be unnecessary to return the additional data that won't even be accessed. The second query (of the 2 query approach) gets the actual data to display and (in this scenario) would only contain 50 records. The example I gave would of course need to have a WHERE clause limiting to whatever the particular criteria is for this page display...it wasn't just to get an arbitrary count of all the records IN ADDITION to the 2 queries in your approach. The whole point was to say that using Count(ID) is faster than using Count(*) or SELECT ID (getting all rows). Dave -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 31, 2005 2:33 PM To: CF-Talk Subject: RE: Paging through records Well I think the count() example is sort of outside of the scope of what was being described... The specific question (as I understood it) was whether a pair of queries could be faster for presenting a sub-set of records in a list page -- the count() query isn't part of the task of fetching and presenting those records, so it's sort of moot. And in that scenario, if you use the 2-query approach, you can use query1.recordcount to get the total number of records (and divide that to get the number of pages), so that eliminates the need to perform a separate count() query if you want to display total # of available records on the page. > I agree with Isaac. The first query could even be: > > select count(id) as TheCount > s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217033 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Paging through records
I agree with Isaac. The first query could even be: select count(id) as TheCount Wouldn't this make the first query even faster as it's not returning x records, it's only returning ONE record and then you can reference TotalCount.TheCount instead of .recordcount the other way? It seems this would make it even more efficient. Yes, it's true that if your table is small, that this could end up taking more time, but the whole idea is to handle tables that are large, not small, so this to me seems the most efficient. Dave -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 31, 2005 1:27 PM To: CF-Talk Subject: RE: Paging through records > Not in this scenario. > You have to select ALL records to extract or output the > ones you want. > So my original example was > 1. query all the required records > 2. output the ones you want > The one your saying is better > 1. query all the required records > 2. query a subset of those records > 3. output the records. > Thus an extra step to produce the same output. Of course > querying the > database a second time is going to take up more memory for > the 2nd query and > take longer to process. If you don't believe me, just try > it for yourself. That's gonna depend on the indexing... the first query returns only the primary key column (which cuts down on time to execute) and the 2nd query has only the one primary key column filter in the where clause, which is presumably faster than searching on other columns (at least, it definately will be if the db's indexing is done properly). So it's possible the 2 query approach in this case could actually be faster... Consider that in the alternative single-query approach, you're returning x number of columns on y number of records that won't be used, which will create drag just like the additional query does -- but this 2 query approach also has advantages which reduce the time to complete each query, so... the end result will vary. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217026 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SOT: Oracle SQL alternative for YesNoFormat() ?
Thanks y'all. I think this will work. Dave -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Monday, August 29, 2005 3:31 PM To: CF-Talk Subject: Re: SOT: Oracle SQL alternative for YesNoFormat() ? SELECT CASE WHEN yourColumn = 1 THEN 'yes' ELSE 'no' END as yesNoFormat FROM yourtable On 8/29/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hi, > > I know this is a bit off topic, but I developing an app in CF accessing an > Oracle DB and I need my query to return the results in the format of 'yes' or > 'no' for 1 or 0 respectively. Anyone know how I can do this within the SQL > select statement? > > Thanks, > > Dave ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217005 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Oracle SQL alternative for YesNoFormat() ?
Bobby, This doesn't work for me because the values in the database are in a numeric column and stored as 1 or 0. I need the query to return 'yes' or 'no'. The query results are used for a CFINDEX, so the only option I can think of at this point is to build a NEW query and transform those values as I loop through the original query recordset. This will add alot of overhead to the process though. I can't do a PL/SQL function either, so that's not an option. Anyone else have any other ideas? Dave -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Monday, August 29, 2005 3:40 PM To: CF-Talk Subject: RE: Oracle SQL alternative for YesNoFormat() ? I haven't messed with Oracle much but if you don't find a better solution, you can hack something up that returns the length of the value minus 2 which will return 1 for yes and 0 for no This should do it... select len(YesNoField)-2 as YesOrNo from MyTable if the values in that field are only yes or no, you will get 1 for yes and 0 for no it's a hack job I know but it works The ideal solution would be to change the field values but I know that isn't always feasible with a client-supplied database. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, August 29, 2005 3:14 PM To: CF-Talk Subject: SOT: Oracle SQL alternative for YesNoFormat() ? Hi, I know this is a bit off topic, but I developing an app in CF accessing an Oracle DB and I need my query to return the results in the format of 'yes' or 'no' for 1 or 0 respectively. Anyone know how I can do this within the SQL select statement? Thanks, Dave ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217002 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
SOT: Oracle SQL alternative for YesNoFormat() ?
Hi, I know this is a bit off topic, but I developing an app in CF accessing an Oracle DB and I need my query to return the results in the format of 'yes' or 'no' for 1 or 0 respectively. Anyone know how I can do this within the SQL select statement? Thanks, Dave ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216684 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
cf-talk@houseoffusion.com
CFMX 6.1 Does the redirect feature of CFHTTP work if the initial url provided is an http:// url and that url redirects to an https:// ? I can't seem to get it to work. Any thoughts? Here's an example: http://www.bizbreeze.com/members"; timeout="5" redirect="yes"> I always get a connection timeout failure, even if I increase the timeout to 60. In my browser, I'm redirected within seconds. (by the way, this redirection is done in a CFM file with ). Dave ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216667 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Count Question...
sorry, typo. I didn't look back to see who wrote what, just remembered it. Dave -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Friday, August 26, 2005 1:14 PM To: CF-Talk Subject: Re: SQL Count Question... Who you talking about "he." I'm a "she." ;) But, I am glad to see you agreeing. I thought for a minute there that I must have been confused if he got it to work with those statements in there. ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216511 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Count Question...
FYI - he's write about the 0 = 0, it's useless to have that with your or's...the or's aren't even being evaluated and ultimately, it's going to keep you from getting the right data. Glad you got the count to work though. :) Dave -Original Message- From: Protoculture [mailto:[EMAIL PROTECTED] Sent: Friday, August 26, 2005 11:39 AM To: CF-Talk Subject: Re: SQL Count Question... thanks RADEMAKERS, that did it... here is the working code.. SELECT COUNT(DISTINCT(opportunity.id)) FROMopportunity, advertiser, location WHERE opportunity.deleted = 'N' AND opportunity.authorised = 'Y' AND opportunity.active = 'Y' AND opportunity.activate <= getdate() AND opportunity.deactivate >= getdate() AND opportunity.advertiser_id = advertiser.id AND advertiser.deleted = 'N' AND advertiser.suspended = 'N' AND ( (0 = 0 OR levels LIKE '%' + ',' + CONVERT(VARCHAR,0) + ',' + '%') OR (0 = 0 OR levels LIKE '%' + ',' + CONVERT(VARCHAR,0) + ',' + '%') ) AND (0 = 0 OR sectors LIKE '%' + ',' + CONVERT(VARCHAR,0) + ',' + '%')AND (0 = 0 OR work_types LIKE '%' + ',' + CONVERT(VARCHAR,0) + ',' + '%') AND ( 0 = 0 OR (0 LIKE '%' + ',' + CONVERT(VARCHAR,0) + ',' + '%' AND 0 LIKE'%' + ',' + CONVERT(VARCHAR,0) + ',' + '%') ) ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216500 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Count Question...
Actually, if you're using SQL server, this might work: select count(*) from (put all your SQL in here without the count(), just the select distinct) that might do it. -Original Message- From: RADEMAKERS Tanguy [mailto:[EMAIL PROTECTED] Sent: Friday, August 26, 2005 11:02 AM To: CF-Talk Subject: RE: SQL Count Question... I don't know about sql server specifically, but you could try syntax like select count(distinct(mycolumn)) from mytable or else you should be able to do select count(*) from (select distinct(mycolumn) from mytable) /t >-Original Message- >Subject: SQL Count Question... >From: <[EMAIL PROTECTED]> >Date: Fri, 26 Aug 2005 07:16:33 -0500 >Thread: >http://www.houseoffusion.com/cf_lists/index.cfm/method=messages >&threadid=41929&forumid=4#216470 > >I don't think you can use DISTINCT with an aggregate function >like count(). Also, you didn't indicate anywhere in this >e-mail which database server you're using. > >Are you doing the query just to get the count, or is it for >some other purpose as well. There's nothing wrong with using >#queryname.recordcount#. You could do the count() without the >DISTINCT, but that may give you more than you are looking for. > >Maybe you could tell us the goal you're trying to accomplish >and there might be another way to approach it. Be sure to >include your SQL database type and version. Also, providing >your error message is very helpful. > >Dave > ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216496 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Indexing question
Yes, sorry, Verity, and using CFMX 6.1 Dave -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Friday, August 26, 2005 10:32 AM To: CF-Talk Subject: RE: Indexing question Hmmm, this is a verity index yeah? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 26 August 2005 15:24 To: CF-Talk Subject: Indexing question Hey folks, Okay, I have a table with fields that I want index, AND one fo the fields is a URL, except I don't want to index the URL itself, I want to index the CONTENTS of the url. So, I thought I could just do a CFHTTP and pull the contents and add them to the cfindex. However, it's not that simple since when I do a cfindex of custom type I have to include the query name and the index only indexes the query fields, but not additional content. Is there any way I can accomplish this? The only thing I have thought of is to build a new Query from the results of the DB query and CFHTTP and then index on that query. That seems like a lot of work for this, so I wanted to see if anyone had any ideas on how to do it? Thanks, Dave ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216493 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Indexing question
This worked by building a query, but I'm still curious if anyone else had any other ideas. Dave -Original Message- From: Phillips, Dave Sent: Friday, August 26, 2005 10:24 AM To: CF-Talk Subject: Indexing question Hey folks, Okay, I have a table with fields that I want index, AND one fo the fields is a URL, except I don't want to index the URL itself, I want to index the CONTENTS of the url. So, I thought I could just do a CFHTTP and pull the contents and add them to the cfindex. However, it's not that simple since when I do a cfindex of custom type I have to include the query name and the index only indexes the query fields, but not additional content. Is there any way I can accomplish this? The only thing I have thought of is to build a new Query from the results of the DB query and CFHTTP and then index on that query. That seems like a lot of work for this, so I wanted to see if anyone had any ideas on how to do it? Thanks, Dave ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216491 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Indexing question
Hey folks, Okay, I have a table with fields that I want index, AND one fo the fields is a URL, except I don't want to index the URL itself, I want to index the CONTENTS of the url. So, I thought I could just do a CFHTTP and pull the contents and add them to the cfindex. However, it's not that simple since when I do a cfindex of custom type I have to include the query name and the index only indexes the query fields, but not additional content. Is there any way I can accomplish this? The only thing I have thought of is to build a new Query from the results of the DB query and CFHTTP and then index on that query. That seems like a lot of work for this, so I wanted to see if anyone had any ideas on how to do it? Thanks, Dave ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216487 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Quick Query Question...[hopefully]
There's probably a number of ways to do it. Mine may or may not be the most efficient, but it gets the job done. do your query here...query name="query" (or whatever) Hour Order Qty #thishour# #query.TotalOrderPerHour[hit]#0 -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Friday, August 26, 2005 9:16 AM To: CF-Talk Subject: RE: Quick Query Question...[hopefully] Yeah... I could use the help. I have an idea... but its probably NOT the best or most efficient way to do it in CF. Enlighten me, por favor! ~Che ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216486 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Quick Query Question...[hopefully]
Che, I agree with Mark. Anything you do in the DB is going to be more complex than in CF in this particular case. I'd just do it in CF. If you need help with that code, let us know. Dave -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Friday, August 26, 2005 9:04 AM To: CF-Talk Subject: RE: Quick Query Question...[hopefully] Huh? Ya got me with that one Mark. Care to explain in detail? Also, would it be easier to use CF to insert the missing hours of the day and values of zero (if yes, what would be the easist)? I hate to use CF when I might be able to use the db... but were only talking about 24 rows of data. ~Che -Original Message- Che, try this, create a table 1 row and the numbers 0 through 23 in them, then do a left join to your group by query :) -Mark -Original Message- SELECT Datepart(hh,OrderDate) AS Hour, Count(OrderDate) AS TotalOrdersPerHour FROMOrders WHERE Status = 'SHIPPED' AND (OrderDate BETWEEN '8/1/2005' AND '8/31/2005 23:59:59') GROUP BY Datepart(hh,OrderDate), Datepart(hh,OrderDate) ORDER BY Datepart(hh,OrderDate) ASC ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216479 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Quick Query Question...[hopefully]
Che, You can use isnull() in SQL Server and nvl() in Oracle. I don't know which DB you're using. Dave -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Thursday, August 25, 2005 4:53 PM To: CF-Talk Subject: Quick Query Question...[hopefully] If have a query that returns a 24 hour breakdown of orders by the hour on a monthly basis. (see below). As you can see, Hour 5 & 6 are missing because there are no values to return. What would be the easiest way to add Hour 5 and Hour 6 to the query's recordset with a corresponding value of zero for each hour? The trick is, from month to month, the hours that have no values might change. Any idee-ers? Thanks, Che. HOURTOTALORDERSPERHOUR 0 5 1 5 2 4 3 2 4 2 7 3 8 2 9 10 10 7 11 7 12 3 13 5 14 11 15 10 16 6 17 13 18 7 19 13 20 9 21 16 22 11 23 14 ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216471 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Count Question...
I don't think you can use DISTINCT with an aggregate function like count().
Also, you didn't indicate anywhere in this e-mail which database server you're
using.
Are you doing the query just to get the count, or is it for some other purpose
as well. There's nothing wrong with using #queryname.recordcount#. You could
do the count() without the DISTINCT, but that may give you more than you are
looking for.
Maybe you could tell us the goal you're trying to accomplish and there might be
another way to approach it. Be sure to include your SQL database type and
version. Also, providing your error message is very helpful.
Dave
-Original Message-
From: Protoculture [mailto:[EMAIL PROTECTED]
Sent: Friday, August 26, 2005 6:47 AM
To: CF-Talk
Subject: SQL Count Question...
I am trying to get a total count of all our records. The query itself is a join
( as you can see below )... however when I make a change between the following
I get a different result set... I want to be able to return the correct number
of records but do it the correct way and not return a list of ids ( then do a
#queryname.recordCount# ), rather I just want a proper count returned as I am
trying to do in query2 below.
The two queries are identical except for the top portion, directly below.
// this returns a listing 3500 records
SELECT DISTINCT 'id' = opportunity.id
// this returns a count of 135,000+ records
SELECT DISTINCT count(opportunity.id) as total_records
/* also tried
count(*),
count(id = opportunity.id),
count('id' = opportunity.id)
*/
**
The information contained in this message, including attachments, may contain
privileged or confidential information that is intended to be delivered only to
the
person identified above. If you are not the intended recipient, or the person
responsible for delivering this message to the intended recipient, ALLTEL
requests
that you immediately notify the sender and asks that you do not read the
message or its
attachments, and that you delete them without copying or sending them to anyone
else.
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216470
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Lowering spam profile of CF generated emails
Thanks Matt! I'll implement some of this and check out your site. Dave -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Thursday, August 25, 2005 1:02 PM To: CF-Talk Subject: Re: Lowering spam profile of CF generated emails On 8/24/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: >What numbers are you using to stay under the radar? x per hour? x per minute? The trickler built into my CMS defaults to 5 messages every 5 seconds. That is a burst of 5. A wait of 5 seconds then another burst of 5. Counting the trip to the client and back to run it you're really looking at about 7 seconds, which is good because... This is optimal for a CF server that is set to flush the mail spool every 5 seconds. Since the mail comes in at a roughly slower rate you never back up mail in the spooler. If you don't tune the CF Admin setting (or optimize to whatever its set to by your mail host) then you aren't getting max bang for your buck. If, for example, CF is set to flush every 30 seconds then at my 5/5 default CF is going to pump out 30 messages from your mailer each time (assuming its not too busy to get everything out... you never know on a shared server). Even so I would still use the 5/5 because it provides continual feedback to the client side. Plus I've found over time that taking it in nibbles is better than bites. The tutorial for building one of these is on my web site. If you look it over, try and use the one that introduces failover, as the original is a real mess if it gets interrupted. For lists in excess of 10k maybe you need to take bites. What I have done is run a fairly complex method of automatically running large mailings directly in a browser window on the server, where nobody cares if the browser window is open for 2 hours. I think I have that written up at the site as well. Never think that this method is efficient. Its way over on the opposite side. But the mail gets delivered. The only way you can get tripped up is if you have a rotten list,with genuinely bad addresses. Your mail server will slowly build up retries on your garbage addresses until you do get noticed. So be sure to pay attention to and scrub your bounces. ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216399 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Large recordsets turned into text file
What format do you want it in? CSV? Have you tried CF_Query2CSV http://www.cfcustomtags.com/goto.cfm?LinkID=334 Dave -Original Message- From: gabriel l smallman [mailto:[EMAIL PROTECTED] Sent: Thursday, August 25, 2005 11:10 AM To: CF-Talk Subject: Large recordsets turned into text file Have an app. That needs to turn a query of about 150,000 records into a text file, zip it, send back to user. Using cf to loop and build the text file just wont work, it takes forever and often crashes. Someone mentioned a way todo it with php, by invoking a function that converts the record set in ram to a text file and then zips and send back. But we are stuck doing it on box with mx 6.0. Looked at having sql generate the file, but trying to avoid mapping drives to move it around. Anyone got an clever ideas? gabe ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216374 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Lowering spam profile of CF generated emails
Matt, What numbers are you using to stay under the radar? x per hour? x per minute? Whatever details you can share I am sure will help win the war on SPALM (Service Providers Attacking Legitimate Mailers). :) Dave -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 24, 2005 5:05 PM To: CF-Talk Subject: Re: Lowering spam profile of CF generated emails A lot of the stuff up above is good advice. Especially the stuff about proper mx records. I have been able to completely eliminate the issue of AOL, MSN Yahoo etc. thinking they see spam coming from my server by throttling all mail that goes out of the box. No clients are allowed to send email blasts. They all run it thru a trickler app and as a result skate safely under the radar of every frequency filter out there to date. I have some clients -- professional associations -- whose memberships are just freakin' loaded with AOL, Hotmail etc. They do mailings in the 5-10,000 piece range with nothing coming back due to a temp block (stuff like "could not deliver because user does not exist" when you know it does in fact exist and later, on retry, the mail goes thru). Same goes for a commercial vendor sending out daily alert-type emails showing product in inventory matching a requested profile. Those are 10-100k html emails... No problems. ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216276 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Lowering spam profile of CF generated emails
Dan, Go to your command prompt and type this nslookup at the nslookup prompt: >set type=ptr >xxx.xxx.xxx.xxx Where xxx's represent your IP address you want to check for a reverse lookup. The results will show whether or not your IP address has a reverse lookup. If it doesn't, contact your DNS provider and request them to add it. Preferably it will resolve to the domain from which you are sending e-mail, but at the very least, it should resolve to something. Dave -Original Message- From: dan martin [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 24, 2005 3:15 PM To: CF-Talk Subject: Re: Lowering spam profile of CF generated emails >Are you sure you have reverse DNS setup for the server sending the mail? How do you do this? Can it be done if your dns is provided by a registrar (like register.com or godaddy.com) vs running your own dns server? ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216256 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Old saw: jrun.exe out of control (found issue)
Could you find them with some java code? I don't have it handy, but I know there's some java code you can use to display all scheduled tasks. Might be worth trying to see if it's showing something that isn't on the administrator page. Maybe someone here knows that code offhand? Dave -Original Message- From: Eric J. Hoffman [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 24, 2005 2:44 PM To: CF-Talk Subject: RE: Old saw: jrun.exe out of control (found issue) I use Fusetalk in other high traffic installations, so I don't think its Fusetalk. CF/JRUN keeps trying to fire off some process that is not even listed in the scheduled tasks...so the issue is some weirdness in there. But I would check to see if you have in your exception log anything about a categories query from the Fusetalk area...thats what tipped me off in that direction. Anyone know how to find hidden automated tasks that CF/JRUN try to fire off, or where the config file for that is? ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216254 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Newsletter Manager Suggestions
Jochem van Dieten wrote: >some recipients will accuse you of spamming for instance >simply because they forgot they subscribed. Not to mention when they decide they don't want it anymore, and from that point on, all future newsletters are considered spam. Like you were supposed to know they didn't want it anymore... I guess read their mind... and automatically unsubscribe them because they "THOUGHT" about not reading it anymore Oh joy. Dave ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216251 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Get fields in an Access table
Maybe this link will help: http://www.databasejournal.com/features/msaccess/article.php/3528491 Dave -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 24, 2005 12:21 PM To: CF-Talk Subject: Re: Get fields in an Access table >>I cant remember exactly step by step but there are hidden system tables in >>access This will give you a list of all tables, but forget about columns and types :-( -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216233 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Lowering spam profile of CF generated emails
Well, in my experience, getting mail into the inbox can be different depending on the service of the receiver of the e-mail. AOL: Sign your server up for whitelisting at http://postmaster.aol.com. If you're on a shared server, you can't do this, though, so you'd need to be on a dedicated server. Once whitelisted, I've not had trouble getting AOL mail through for several months now. MSN & Hotmail: Good luck. I've never had any success getting MSN to offer a whitelisting. Evidently, www.bondedsender.com has some deal with them, but it can be pricy if you get ANY spam complaints at all (even false spam complaints). Yahoo: You can apply for 'delivery to the inbox' instead of in the bulk mail folder, but I've never been successful in getting approved for this. Do some searching in their help section for the application. They 'monitor' your mail for a few days and then tell you what they think about it. Bottom line is if you have a large amount of mail coming out of your server to @yahoo.com addresses, you're giong to end up in the bulk mail folder (unless the receiver has added you to their safe sender list. Other mail servers: You can use the free tool at: http://spamcheck.sitesell.com/ To check and see how many mail server filters generally will receive your content. This will help eliminate some blocking, but ultimately, you will end up in junk mail & bulk mail folders if you're sending a large quantity of mail from your server. ** One thing to keep in mind...most mail servers & providers base whether your mail is classified as bulk mail based on the quantity of mail coming from your SERVER, not your DOMAIN. This is important to understand as if you're on a shared server, or if you share your server with others, you might get classifed as bulk because of their activities. This is by no means an exhaustive list, just what I can come up with from memory. Hope it helps. I'm sure some others will have some comments here for you too. Oh, one more thing...plain text e-mails are most always more likely to be delivered than HTML e-mails. I send all my e-commerce 'receipt' e-mails in plain text and then a 'welcome' e-mail in HTML nicely formatted separately. Dave -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 24, 2005 1:48 PM To: CF-Talk Subject: Lowering spam profile of CF generated emails I have a simple PayPal based registration system for our site: www.sierraOutdoorRecreation.com. Upon completion of the payment process, I send out a standard confirmation e-mail with initial username and password and transaction data. We are having a fairly high incidence of these e-mails being trapped in spam filters and not reaching the intended recipients. What can I do to make these e-mails less spam looking? ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216236 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Newsletter Manager Suggestions
If you want a full-blown web-based contact and e-mail management solution: http://www.bizbreeze.com Dave -Original Message- From: Emmet McGovern [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 24, 2005 1:21 PM To: CF-Talk Subject: Newsletter Manager Suggestions Does anyone have any experiences with the various mailing list managers out there? We need to get one and was hoping for some recommendations. Emmet ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216237 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFINDEX - how to add/update a single record in an existing collection?
As for optimizing, I would consider doing it daily if you're making several updates and/or refreshes throughout the day. If you're only doing a refresh once a day, then I would optimize once a week or no more than once every other day. I think it would be overkill to optimize every day if you're only refreshing once a day. Dave -Original Message- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 24, 2005 12:54 PM To: CF-Talk Subject: Re: CFINDEX - how to add/update a single record in an existing collection? I ended up taking Dave's query for a single record approach because it simplified a number of things. Because of the nature of the app, I update some of the data one column at a time, but it still needs to be indexed immediately. I have a CFC with an updateCollection method that I just pass a collection name and record ID. Followup question. What contributes to the degradation of verity collections? Will updating single records in a collection kill verity search performance? What strategy should I take with repairing/optimizing collections...scheduled task to do it hourly, or would just once a day suffice? Thanks for the help, Pete ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216231 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: DESPERATE!!! Any way to embed SWF within CFDOCUMENT (PREVIOUSLY CFDOCUMENT ERROR)
Andy, I did some googling and I found this for you: http://flirt.sourceforge.net/example.html First paragraph on this page says "Here I'll step through the test.c example code that's in the root of the Flirt source. It's a simple command-line app that takes an SWF file name for an argument, runs it for 100 frames, and then renders out to a PNG file. As usual, we need to include a header:" You may have to write something in another language utilizing something like this Flirt software and then access it as a COM object or with CFEXECUTE or something like that. I don't know if this will do what you want to or not, but I thought it might lead you in the right direction anyway. Also, is the SWF file you are trying to convert to an image a dynamically created SWF file or is it static? If it's dynamically created (like using CFFORM) then I don't think you're going to find a way to do what you want to do. If it's static, you may be able to use some type of utility (like the above) to convert it. Hopefully someone else on this last has already encountered your issue and has a workaround. I wish you the best! I know how frustrating stuff like this can be! Dave -Original Message- From: Andy Mcshane [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 23, 2005 9:50 AM To: CF-Talk Subject: DESPERATE!!! Any way to embed SWF within CFDOCUMENT (PREVIOUSLY CFDOCUMENT ERROR) Can anybody help me, I am at breaking point here. I know now that Live Docs state that CFDOCUMENT does not support embedding SWF files as it cannot render them but I am desperately hoping that someone may have found a clever way to get way around this or anybody know how to output a SWF as an image file on the fly (I am not very savvy with Flash!). I am really desperate for something because if I cannot find a way to make this happen then I will have to abandon all the work that I have done over the last 3 weeks (flash forms, cfdocument, etc), revert back to CFMX and start writing again! The CFDOCUMENT was the main thing that got me to upgrade and now I can't use it! I could just scream!!! Anybody, please? ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216040 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: What does Wait() do?
Thanks for the thoughts...I was just curious. :) Dave -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Monday, August 22, 2005 4:18 PM To: CF-Talk Subject: RE: What does Wait() do? > Hi, > I had already tried executing it to find out, I get this > error when I execute wait() with a numeric value as the > argument: > current thread not owner > Thanks, > Dave Ahh... well that would explain why it's not documented. :) I stand by my original hypothesis that it performs a thread.sleep() but probably can only be executed by certain cf internal processes, such as some of the cf tags which exist as compiled java (instead of cfml tags in the special directory). Although... given that error message, it probably actually accepts a thread as its argument and waits for that thread to complete whatever task its been given. Which would be redundant in cfml anyway, since your cfml code already must wait for the task to complete before continuing if you were to spawn a java thread and task it with something. Or such is my limited understanding... ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216026 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfmail optional attributes
If that doesn't work, maybe someone knows a way to get the default mail server value from the server using Java? If so, then you could do this: In my apps, I've always known what my default mail server was, and had code like this, but I didn't need to use the Java because my default server was static. If you know the default server already, then you could do it this way, but I was assuming that you might not know it (for example if you were in a shared environment). HTH, Dave -Original Message- From: Russ [mailto:[EMAIL PROTECTED] Sent: Monday, August 22, 2005 5:30 PM To: CF-Talk Subject: RE: cfmail optional attributes Just a shot in the dark here, but can you use the iif function? Something like body ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216025 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Is the a wait function in ColdFusion MX 6.1?
So, in a sense, the java method actually makes the thread go to sleep for x milliseconds and stop processing, and then when the time is up, it starts processing again? And doing it the CF way it's processing constantly... Am I getting it right now? If so, wow, that's a big difference, and I appreciate the explanation! Dave -Original Message- From: Russ [mailto:[EMAIL PROTECTED] Sent: Monday, August 22, 2005 2:53 PM To: CF-Talk Subject: RE: Is the a wait function in ColdFusion MX 6.1? Because when you do it in cf, you are forcing it to execute (do math) however long you do the function for. When you are calling the java function, it calls some method that wakes it up after a certain time, but does not use any cpu.. ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215945 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: What does Wait() do?
Hi,
I had already tried executing it to find out, I get this error when I execute
wait() with a numeric value as the argument:
current thread not owner
Thanks,
Dave
-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: Monday, August 22, 2005 1:37 PM
To: CF-Talk
Subject: Re: What does Wait() do?
> Anyone know of an undocumented function in CFMX 6.1 (or
> higher) called Wait()? It's there, but I can't figure out
> what it's for or what it does, nor can I find any
> documentation on it.
> Any ideas?
I would expect CreateObject("java","java.lang.Thread").sleep(x);
Try this:
#getTickCount()#
#getTickCount()#
Granted, if it accepts an argument in seconds (instead of ms), then
you'd be looking at a wait of a little over 16 minutes.
s. isaac dealey 954.522.6080
new epoch : isn't it time for a change?
add features without fixtures with
the onTap open source framework
http://www.fusiontap.com
http://coldfusion.sys-con.com/author/4806Dealey.htm
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215939
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Is the a wait function in ColdFusion MX 6.1?
Out of curiousity, why does this affect the CPU any different than the JAVA
thread? The process still has to wait the same amount of time, doesn't it?
Why call another external process? Wouldn't that be more overhead?
I don't know much about Java, so my questions may sound stupid, but I think an
explanation would be helpful to those on the list who also don't understand why
this is bad. It's not an endless loop and it's controlled by the input. You
could add a max amount in there if you wanted to avoid wait time's longer than
a specified time.
Dave
-Original Message-
From: Nathan Strutz [mailto:[EMAIL PROTECTED]
Sent: Monday, August 22, 2005 1:34 PM
To: CF-Talk
Subject: Re: Is the a wait function in ColdFusion MX 6.1?
Ouch, don't do that. This will spike your CPU, looping frantically
until the given time comes up.
The java thread sleep method is much better.
Here's an already packaged function i pasted together a couple years ago.
www.cflib.org/udf.cfm/sleep
-nathan strutz
[EMAIL PROTECTED] wrote:
> Here's a way as a UDF:
>
>
> function WaitMS(ms) {
> var startms = getTickCount();
> var endms = startms + ms;
> while (endms GT getTickCount());
> }
>
>
> Dave
>
> On 22/08/05, Troy Simpson <[EMAIL PROTECTED]> wrote:
>
>>I know this is not normally needed for a ColdFusion Application
>>because most people want their apps to run fast.
>>
>>But I have a need to put a wait period in my code. If there a
>>function in ColdFusion MX 6.1 to cause the process to wait. For
>>example:
>>
>>doSomething();
>>wait(500); / wait 500 milliseconds.
>>doSomethingElse();
>>
>>Thanks,
>>Troy
>>
>>--
>>Troy Simpson
>> Applications Analyst/Programmer, OCPDBA, MCSE, SCSA
>>North Carolina State University Libraries
>>Campus Box 7111 | Raleigh | North Carolina
>>ph.919.515.3855 | fax.919.513.3330
>>E-mail: [EMAIL PROTECTED]
>
> **
> The information contained in this message, including attachments, may contain
> privileged or confidential information that is intended to be delivered only
> to the
> person identified above. If you are not the intended recipient, or the person
> responsible for delivering this message to the intended recipient, ALLTEL
> requests
> that you immediately notify the sender and asks that you do not read the
> message or its
> attachments, and that you delete them without copying or sending them to
> anyone else.
>
>
>
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215938
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: GoogleBot and URLSessionFormat...
I don't know about your GoogleBot question, but as for when the session starts, I believe there's a default onSessionStart method you can put in an application.cfc and use that to do whatever you want when the session gets started. That method gets executed automatically as soon as a session is created if it exists. HTH, Dave -Original Message- From: Troy Simpson [mailto:[EMAIL PROTECTED] Sent: Monday, August 22, 2005 1:31 PM To: CF-Talk Subject: GoogleBot and URLSessionFormat... GoogleBot is crawling our website and creating a new session with each page request. I realize that this is because GoogleBot does not use cookies to track the session variables. I have J2EE Session Enabled and use jsession as the sessionID. Can I use URLSessionFormat to keep GoogleBot in the same session? Can I redirect GoogleBot to a dedicate GoogleBot Session. For example, if GoogleBot makes a page request and I have a Session already created by the GoogleBot, can I redirect the current request to the other session? When are session created during the process. Before Application.cfm, after application.cfm. Before the cfapplication tag? Or after the cfapplication tag? How does URLSessionFormat know if a client has cookies enabled or not? Is there something in the header that lets URLSessionFormat know? Thanks, Troy ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215937 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
What does Wait() do?
Anyone know of an undocumented function in CFMX 6.1 (or higher) called Wait()? It's there, but I can't figure out what it's for or what it does, nor can I find any documentation on it. Any ideas? Dave ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215910 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Is the a wait function in ColdFusion MX 6.1?
Here's a way as a UDF:
function WaitMS(ms) {
var startms = getTickCount();
var endms = startms + ms;
while (endms GT getTickCount());
}
Dave
On 22/08/05, Troy Simpson <[EMAIL PROTECTED]> wrote:
> I know this is not normally needed for a ColdFusion Application
> because most people want their apps to run fast.
>
> But I have a need to put a wait period in my code. If there a
> function in ColdFusion MX 6.1 to cause the process to wait. For
> example:
>
> doSomething();
> wait(500); / wait 500 milliseconds.
> doSomethingElse();
>
> Thanks,
> Troy
>
> --
> Troy Simpson
> Applications Analyst/Programmer, OCPDBA, MCSE, SCSA
> North Carolina State University Libraries
> Campus Box 7111 | Raleigh | North Carolina
> ph.919.515.3855 | fax.919.513.3330
> E-mail: [EMAIL PROTECTED]
**
The information contained in this message, including attachments, may contain
privileged or confidential information that is intended to be delivered only to
the
person identified above. If you are not the intended recipient, or the person
responsible for delivering this message to the intended recipient, ALLTEL
requests
that you immediately notify the sender and asks that you do not read the
message or its
attachments, and that you delete them without copying or sending them to anyone
else.
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215909
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: webservices and XML
Bryan, Check your docs under the cffunction tab to see what the output attribute actually does. I think you may have it confused with what does. Here's a quote from docs page for output attribute: Specifies under which conditions the function can generate HTML output. yes: The entire function body is processed as if it were within a cfoutput tag. Variables names surrounded by number signs (#) are automatically replaced with their values. no: The function is processed as if it were within a cfsilent tag If you do not specify this attribute, the function body is processed as standard CFML. Any variables must be in cfoutput tags. Dave -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Monday, August 22, 2005 12:26 PM To: CF-Talk Subject: webservices and XML Hey All, OK...from Livedocs at MM: The following list defines the requirements for how to create web services for publication: 1) The value of the access attribute of the cffunction tag must be remote. 2) The cffunction tag must include the returnType attribute to specify a return type. 3) The output attribute of the cffunction tag must be set to No because ColdFusion converts all output to XML to return it to the consumer. 4) The attribute setting required="false" for the cfargument tag is ignored. ColdFusion considers all parameters as required. Number 3 above does not appear to be true (or I'm missing something). For arguments sake let's assume the WS method has output="no" and returntype="query"... Will the query returned by the WS be converted to XML? because it doesn't seem to be. I'm manually converting the query to XML now and it's SLOW when larger recordsets are returned. TIA for any insight Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215903 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFINDEX - how to add/update a single record in an existing collection?
Yes, I agree. I only used this as an example since he said he already had his query info for one record. At least that was my understanding of his dilemma. The main point, Pete, that Ray & I are both trying to make is that your CFINDEX can be exactly the same whether your query has returned 1 record or 1,000. You don't need to add all the pound signs, etc., just simply identify the proper fields in the right places and that's it. The number of records returned in the query is irrelevant. If we haven't answered your question, please let us know! Dave -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Friday, August 19, 2005 3:58 PM To: CF-Talk Subject: Re: CFINDEX - how to add/update a single record in an existing collection? Dave, I'm pretty sure, in MX7 at least, you don't need to make a one record query. You can just pass the values. Of course, if you already have the one record query, that would work. ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215887 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFINDEX - how to add/update a single record in an existing collection?
Pete, Actually, you would just execute a CFQUERY that would return that one record, and as long as your KEY is the same, issue your cfindex just like you would if you were indexing a query with 1,000 records. select [your fields] from [your table] where [your criteria to return just the new record] That's all you need to do. Now, you could also build the query dynamically if you don't want to re-query your databse, using the query functions. HTH, Dave -Original Message- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: Friday, August 19, 2005 2:31 PM To: CF-Talk Subject: CFINDEX - how to add/update a single record in an existing collection? Sometimes, no, make that usually, Macromedia's documentation for CF just barely scratches the surface. I have an existing collection that is populated from a query. The data returned from this query gets updated quite often. In order to allow accurate searches, I would like to add (for new records) or update a record in a collection from query data...actually, I'll be passing the data in via a CFC... Is there a way to do this? Here is the original tag call to populate the collection: So, in order to do this, would I do something like: (note that I omitted the query attribute). Would this update just a single record in the coll_datacards collection? Thanks, Pete PS Is it time to create an "Undocumented CF" web site? If there's enough interest and enough content, I'm willing to start this as a project...I just know that between things like cfcollection (and related tags), cfdocument, cfchart, and more that there's a lot of stuff that Macromedia doesn't cover in their docs. ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215822 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Variable or CFFILE issue
Have you found a limit? I would think it would depend mostly upon how much RAM you have on you server. The more RAM you have, the larger the file you could read in with CFFILE. Maybe someone else can expound more on this? Now you've got me curious. Dave -Original Message- From: David Critchley [mailto:[EMAIL PROTECTED] Sent: Friday, August 19, 2005 2:37 PM To: CF-Talk Subject: Variable or CFFILE issue I've tried to do a little digging, but with little success. Im looking for the Max Size of a file that the CFFILE tag (Or could be the variable) can handle. We regularily parse large files (larger than 10mb some upwards around 100mb). Currently we have been splitting the file into sections using UNIX, however this is tedious, and is a poor fix for the problem. Any info you could provide would probably help, or just point me towards the documentation. Thanks, Dave ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215819 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: YACI - Yet another CFSEARCH issue
Thanks Ray. That was it. Here's an interesting note Almost every time I used this: text* My CF service bombed. Not EVERY time, but most of the times. In any case, I'm leaving off the and using when the are using a * in the search criteria, and that solves my problem. Thanks, yet again, for the help, Mr. Verity. Dave -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Friday, August 19, 2005 1:06 PM To: CF-Talk Subject: Re: YACI - Yet another CFSEARCH issue To return all in an explicit search, you can use * You can also just make your type dynamic, and if the search term is *, switch to a simple search. ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215806 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
YACI - Yet another CFSEARCH issue
Well, although my last problems were figured out, I'm having another issue now. My understanding from the docs is that a 'simple' type search has implicit STEM and MANY operators added to it. So, if I'm doing a simple search and I just put in * as my criteria, I get back ALL records in the index. That works just fine. Now, I have an explicit cfsearch, but I want the 'text' part of my search to function just like the simple parti.e., if I put in * I want to get all records that match that criteria... With this CFSEARCH tag, If I type in an actual word in my search form, and it is contained in the index and at least one of my equations is true, it returns it properly. BUT, if I just type in a *, or even a partial word and * like mik* or cat* it returns ZERO results. If I can get it to return results with an actual word, but not with a *, that doesn't make any sense. Any thoughts or ideas? What am I missing? Thanks, Dave ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215801 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfindex/cfsearch help with dates
Ray, PROBLEM SOLVED Here's how I ended up doing it: First, I had to store my 'modifiedDate' value in custom1 with an identifier (since I was already using custom1 and custom2 for other values), so it looks like this: custom1= "identifier|mm/dd/|" Then, before my CFSEARCH, I created 7 variables with the last 7 days in them respectively formatted like this: Day0 = |08/19/2005| Day1 = |08/18/2005| Day2 = |08/17/2005| and so on... Then, my And finally...it works.. I need no Query of Queries anymore and I avoided creating two separate collections. The keys to this solution were twofold. One, you have to use 'cf_' prefixed to your cfsearch results field (i.e. cf_custom1, cf_title) to search it. I found this FINALLY in the docs, and of course the other was figuring out how to store the date in a field that was already occupied, and by using the pipes, I can properly identify the date now. Dave -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Friday, August 19, 2005 9:46 AM To: CF-Talk Subject: Re: cfindex/cfsearch help with dates Actually, you can use the CUSTOM1 field instead. The only difference is how you run your cfsearch. ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215795 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Javascript form question
Can you store the original value in a global variable and then reset it back to the global value? var gOldRadioValue = "" function... function... set gOldRadioValue = radio.value set radio.value to new value function... function... reset --> radio.value = gOldRadioValue That's some rough Pseudo-code but hopefully it will help. HTH, Dave -Original Message- From: Creese, Eric [mailto:[EMAIL PROTECTED] Sent: Friday, August 19, 2005 12:05 PM To: CF-Talk Subject: Javascript form question Okay I have a form with a series of selection boxes which fill the next selection box. Then I have a radio button choice and depending which radio button is selected a selection box will appear next to the label of the radio button. When I decided to change say the first selection box it at the top fires of a JavaScript on event change and I can get all the selection boxes to hide but I can not get the radio button to reset to the default choice automatically. I am not doing any page refreshes. I can not figure out the JavaScript setting I need to reset the radio button. Can anyone help? ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215789 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Verity document limitations
Ray's right, and actually, what I have found is that the difference (xDiff) is how many duplicate key's you have, but the search results query actually 'lops off' the last xDiff records of the original query. I don't know why CFINDEX does that, but it does. I had this same problem the other day and once I resolved the duplicate key issue, it went away and my query counts matched. Dave -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Friday, August 19, 2005 12:05 PM To: CF-Talk Subject: Re: Verity document limitations Are you use you have unique keys? Verity won't accept 2 records with the same key. ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215788 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfindex/cfsearch help with dates
Is it possible to specify values for the custom1 or custom2 field in my
CFSEARCH tag? I don't find that in the docs.
Can I add this to my criteria?:
custom1 >= #dateadd('d',-7,now())#
or something like that?
I'm going to try something like this. I'll let you know how it works...
Dave
-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]
Sent: Friday, August 19, 2005 9:46 AM
To: CF-Talk
Subject: Re: cfindex/cfsearch help with dates
Actually, you can use the CUSTOM1 field instead. The only difference
is how you run your cfsearch.
**
The information contained in this message, including attachments, may contain
privileged or confidential information that is intended to be delivered only to
the
person identified above. If you are not the intended recipient, or the person
responsible for delivering this message to the intended recipient, ALLTEL
requests
that you immediately notify the sender and asks that you do not read the
message or its
attachments, and that you delete them without copying or sending them to anyone
else.
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215753
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfindex/cfsearch help with dates
Unfortunately we're on MX 6.1 here. I will let you know how the QofQ works. But that's good to know information anyway for other projects I do (I have MX 7 on my own servers). Thanks! Dave -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Friday, August 19, 2005 8:56 AM To: CF-Talk Subject: Re: cfindex/cfsearch help with dates CFMX7 dramatically improved the Verity support within CFMX. One of the new features is categories. So consider the follow example - you index your content daily. For content where the data is older than 7 days, you assign the category Old. For content within 7 days, you assign the category New. On the CFSEARCH side, you can then filter based on category=New, or Old, or don't worry about it. If you go to my blog, you can download the powerpoint and watch the preso I did yesterday on CFMX7 and Verity. (It's a recorded Breeze preso, so you get to hear my lovely voice and see my handsome face. ;) ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215750 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfindex/cfsearch help with dates
Ray, Can you elaborate on that idea? We do index daily. I'm unclear on how you're using the word 'category' but very interested. One thing I don't want to do is add another index based on another query (that limits records to those modified last 7 days) as this would extend the index job time which is already at almost 2 hours. I'll be working on the QofQ today. Thanks, Dave -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Thursday, August 18, 2005 6:12 PM To: CF-Talk Subject: Re: cfindex/cfsearch help with dates How often do you index your data? If you do it daily, you could easily use a category called "Last7Days", then filter on that category. On 8/18/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Well, that sounds good on the QofQ...I know it's faster than re-querying the > database, but sounds pretty quick based on what you said. I'm going to have > to use it anyway, I don't have much of an option. In this case, I need to > search for documents (and query results) modified within the last 7 days, so > I'll just use the QofQ to make it work. ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215744 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfindex/cfsearch help with dates
Well, that sounds good on the QofQ...I know it's faster than re-querying the database, but sounds pretty quick based on what you said. I'm going to have to use it anyway, I don't have much of an option. In this case, I need to search for documents (and query results) modified within the last 7 days, so I'll just use the QofQ to make it work. Thanks! Dave -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Thursday, August 18, 2005 5:35 PM To: CF-Talk Subject: Re: cfindex/cfsearch help with dates Another option you may want to consider. If your date searching can be a bit "loose", you can use categories, with names like May2005, April2005, etc. This would allow you to match eocuments wihin a month. Or even CategoryTree=2005,Category=2004. You couldn't do everything _before_ a day, but, it's an option. Also - I'd reconsider your QofQ. We use it for a large site and it works very quickly. We do an initial CFSEARCH and then 20 QofQs to filter out various parts of the results. ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215709 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfindex/cfsearch help with dates
I was wondering that. It's a bit unclear, but that sort of makes sense. However, it's too bad it can't be done with a custom index. I know I could put a date in the custom1 or custom2 field, but I'm trying to avoid having a QofQ on the client side, just for performance sake. I was trying to figure out if there is a way to do it with the criteria options in the cfsearch tag, but so far, no luck. At this stage, I will probably build a QofQ to do it unless someone else comes up with something. Thanks Ray, Dave -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Thursday, August 18, 2005 5:14 PM To: CF-Talk Subject: Re: cfindex/cfsearch help with dates After rereading your post, I believe the doc is referring to the indexing of files, like Word docs, that have a date property. I don't believe you can do this with custom indexes. ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215702 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
cfindex/cfsearch help with dates
Hi, I found this quote in the docs for MX 6.1 under 'composing search expressions': "if a document field named DATE is defined, you can search for documents dated prior to and including December 31, 1999 by entering DATE <= 12-31-99 in your search." Now, if this is true, theoretically I could return a query with a date I want to search by, and when I do my cfindex, I would specify it like this? Then, when I search on this index, i could say search for: "stuff AND DATE >= 01-01-05" This would return only the documents which have a 'date' greater than Jan. 1 of this year AND have the word 'stuff' in them. Now, here's my problem...it seems that Oracle won't allow me to alias a column in the table I'm getting the query from as 'DATE'. So, I tried this with the actual date field, call it 'DateField' and did my index like this: So, then I tried the query but used DateField >= instead of DATE >= and it still doesn't work. So now I'm beginning to wonder if there is there a way to query a collection by a date field. If so, what am I doing wrong? Thanks, Dave ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215672 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: @@Identity returns excessive records
>If someone edits a record directly on the database, then how would that SP >get executed. Yikes! Someone can edit a record directly in the database? That's scary... Dave -Original Message- From: Russ Michaels [mailto:[EMAIL PROTECTED] Sent: Thursday, August 18, 2005 10:20 AM To: CF-Talk Subject: RE: @@Identity returns excessive records But an SP still has to be triggered by something. And that is really what he is saying, because my example cannot be accomplished just by a SP, unless you implicitly execute that SP every time. Which means your still relying on the ColdFusion code to do so. Russ ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215607 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Triggers (was @@Identity returns excessive records)
I think what Neil is trying to say is that a Trigger would be unnecessary if the resulting events that need to be executed were programmed in the original SP. I tend to agree with NeilsomewhatI wouldn't say Triggers are useless, but it seems to me that if proper planning and design are in place, when you want a certain event to occur when something else happens that you would program it intentionally with the original event. Here's a question on the subject, as I'm not an expert in SQL triggers and SP's by any meansif you execute an SP from CFQUERY does the connection to the database from CF release immediately, even while the SP continues running, or does CF stay connected? If CF stays connected for the entire time an SP is running, then THAT would definitely give a very good reason to use triggersYou set up your primary event in your SP, execute it from CF, and then CF can continue processing doing whatever it needs to do while the trigger takes over. Thoughts? Comments? Corrections? :-) Dave -Original Message- From: Russ Michaels [mailto:[EMAIL PROTECTED] Sent: Thursday, August 18, 2005 10:01 AM To: CF-Talk Subject: RE: @@Identity returns excessive records Neil, You are totally avoiding answering the question. You have stated that an SP can do everything a trigger can do, and you have stated that an SP can automatically be execute when a certain event occurs just like a trigger. So for the 3rd time, please show me how. russ ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215598 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: @@Identity returns excessive records
I haven't used this method in a long time because now I use UUID()s as my unique record identifier and since I create the UUID before I do the Insert, I have access to it. I don't have the syntax handy, but are you using the SET NOCOUNT ON and SET NOCOUNT OFF? That might be it. FWIW, I have read some research that @@IDENTITY will not always provide you with the proper ID, especially in multi-user environments (which the web most certainly is) and leaves the possibility of returning the wrong IDENTITY id. This is why I switched to using UUID's. Dave -Original Message- From: Dan O'Keefe [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 17, 2005 10:12 AM To: CF-Talk Subject: Re: @@Identity returns excessive records If I copy and paste my tSQL into query analyzer: INSERT INTO tblArActivityNote (patientID,UserID,note) VALUES(238,1,'Letter 2 printed & mailed for DOS(s)' + ' 01/19/04') go select @@IDENTITY as ID from tblArActivityNote go My PK-IdentityID column in tblAractivityNote is AractivityNoteID. If the insert created a AractivityNoteID= 295256, the select @@identity returns 295256 rows with the same value, 295256. Weird, huh? ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215415 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL help Query of Queries (SOLVED) was (SQL help)
Jochem, Your method worked, I just had to add commas to the LIKE expression: SELECT * FROM AllResults WHERE ',' & MyColumn & ',' LIKE '%,#idnumber#,%' Thanks very much! Dave -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 16, 2005 4:35 PM To: CF-Talk Subject: Re: SQL help (updated) [EMAIL PROTECTED] wrote: > Okay, I still need help, but I've resolve part of my problem. I'm able now > to have the list of ID numbers in one field by themselves. So, my new field > value (MyColumn) looks like this: > > '5,2,3,4,45,7' > > I still need a way using Query of Queries to extract only the records that > have the 'idnumber' in that list. I've tried: > > SELECT * > FROM AllResults > WHERE #idnumber# in MyColumn SELECT * FROM AllResults WHERE ',' & MyColumn & ',' LIKE '%#idnumber#%' Jochem ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215399 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL help (updated)
This isn't a table. It's a search results query, and there is no other way to provide the information since cfindex only allows two custom fields. I have to pass it back to my search results page as a list. Dave -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 16, 2005 4:37 PM To: CF-Talk Subject: Re: SQL help (updated) You realize that this is essentially a db design issue - right? The table shouldn't be holding lists of numbers - there should be a join table that does that job. Right? On 8/16/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Okay, I still need help, but I've resolve part of my problem. I'm able now > to have the list of ID numbers in one field by themselves. So, my new field > value (MyColumn) looks like this: > > '5,2,3,4,45,7' > ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215395 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL help (updated)
>That probably needs to be > WHERE #idnumber# IN (MyColumn) Ian, Yes, I tried that. I had typoed my e-mail, but in my code I had the parenthesis. That's what give the invalid comparison error. It doesn't seem to recognize the field. Dave ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215394 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL help (updated)
Okay, I still need help, but I've resolve part of my problem. I'm able now to have the list of ID numbers in one field by themselves. So, my new field value (MyColumn) looks like this: '5,2,3,4,45,7' I still need a way using Query of Queries to extract only the records that have the 'idnumber' in that list. I've tried: SELECT * FROM AllResults WHERE #idnumber# in MyColumn I get an error: Query Of Queries syntax error. Encountered "3 in custom2" at line 0, column 0. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition TIA, Dave -Original Message- From: Phillips, Dave Sent: Tuesday, August 16, 2005 2:16 PM To: CF-Talk Subject: SQL help Hi, I'm on Oracle 9i. I have a query (call it AllResults) that is returning a column (call it MyColumn) that's value looks like this: 'identifier|5,2,3,4,45,7' Each row may have a different 'identifier' and a different quantity of numbers. Basically, there are two values in this column. identifier & numberlist separated by a pipe Now, I need to build a query of queries that queries this existing recordset and only returns the records which has a number that I'm comparing against. I know I can do this in CF by looping over the recordset, but I'm trying to avoid that (for processing time sake). Here's the pseudo code of what I'm trying to do: (idnumber is a variable in my code and will be ONE of the numbers listed in the numberlist) select * from AllResults WHERE idnumber is found in the list of numbers located in the MyColumn field I only want the records that have 'idnumber' IN the list of numbers I'm sure this can be done with some SQL code and since I'm not a SQL guru, let alone Oracle, any help or suggestions would be appreciated. Thanks! Dave ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215299 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
SQL help
Hi, I'm on Oracle 9i. I have a query (call it AllResults) that is returning a column (call it MyColumn) that's value looks like this: 'identifier|5,2,3,4,45,7' Each row may have a different 'identifier' and a different quantity of numbers. Basically, there are two values in this column. identifier & numberlist separated by a pipe Now, I need to build a query of queries that queries this existing recordset and only returns the records which has a number that I'm comparing against. I know I can do this in CF by looping over the recordset, but I'm trying to avoid that (for processing time sake). Here's the pseudo code of what I'm trying to do: (idnumber is a variable in my code and will be ONE of the numbers listed in the numberlist) select * from AllResults WHERE idnumber is found in the list of numbers located in the MyColumn field I only want the records that have 'idnumber' IN the list of numbers I'm sure this can be done with some SQL code and since I'm not a SQL guru, let alone Oracle, any help or suggestions would be appreciated. Thanks! Dave ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215286 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfindex issue? (Solved - Possible bug?)
Well, I determined that in my case below, I had 48 records that were duplicate keys. By making all my keys unique, I ended up with the desired result. My concern, and wondering about whether there is a potential bug in CFINDEX or not, is why did CF drop the last 48 records of the original query instead of dropping the 48 duplicate keys? The 48 duplicates were included in my CFSEARCH results, so they were added to the index. I found another instance of this happening to another developer as well. Has anyone else experienced these results, and anyone know why in the world CFINDEX would act this way and is it intentional and, if so, why? Thanks, Dave -Original Message- From: Phillips, Dave Sent: Tuesday, August 16, 2005 9:30 AM To: CF-Talk Subject: cfindex issue? Hi, I have a query that I index. The query returns 2,481 records. When I index it, then do a cfsearch on it with * as my criteria, it only returns 2,433 records in the search results. Several of my 'indexed' records are not in the result set. Specifically, the last 48 records from the original query result set are not found in the search result set. Any ideas as to what might be causing this? This is the first time I've encountered this inconsistency. My query looks like this: select key, body, title, custom1 from table my cfindex looks like this: Dave ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215182 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
cfindex issue?
Hi, I have a query that I index. The query returns 2,481 records. When I index it, then do a cfsearch on it with * as my criteria, it only returns 2,433 records in the search results. Several of my 'indexed' records are not in the result set. Specifically, the last 48 records from the original query result set are not found in the search result set. Any ideas as to what might be causing this? This is the first time I've encountered this inconsistency. My query looks like this: select key, body, title, custom1 from table my cfindex looks like this: Dave ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215176 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
