Re: ListGetAt in a SQL Select Statement... is this possible?
I think you could use pretty much the same thing.. SQLServer has the substring funstion but uses the Charindex (I think) to find the start position.. So you might want to try something like : substring(mycol, charindex(mycol, '~'), len(mycol - charindex(mycol, '~')) this hasnt been tested, so it may need some tweaking On 4/27/05, Aaron Rouse [EMAIL PROTECTED] wrote: I was once told that dealing with a list of data in MSSQL was easier than in Oracle. Perhaps someone well versed in MSSQL could chime in with a solution. It probably is not as hard as you think it will be to get done. On 4/27/05, Che Vilnonis [EMAIL PROTECTED] wrote: Aaron/Greg... I have M$ SQL Server 2000. I understand the premise of what you say... unfortunately, my CF skills are much better than my MS SQL skills. ~| 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:204667 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: ListGetAt in a SQL Select Statement... is this possible?
I think you'll have th reverse the charindex to this..
charindex('~',mycol) not the way I have above.
On 4/27/05, Greg Morphis [EMAIL PROTECTED] wrote:
I think you could use pretty much the same thing.. SQLServer has the
substring funstion but uses the Charindex (I think) to find the start
position..
So you might want to try something like :
substring(mycol, charindex(mycol, '~'), len(mycol - charindex(mycol, '~'))
this hasnt been tested, so it may need some tweaking
On 4/27/05, Aaron Rouse [EMAIL PROTECTED] wrote:
I was once told that dealing with a list of data in MSSQL was easier than in
Oracle. Perhaps someone well versed in MSSQL could chime in with a solution.
It probably is not as hard as you think it will be to get done.
On 4/27/05, Che Vilnonis [EMAIL PROTECTED] wrote:
Aaron/Greg... I have M$ SQL Server 2000. I understand the premise of what
you say... unfortunately, my CF skills are much better than my MS SQL
skills.
~|
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:204668
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: ListGetAt in a SQL Select Statement... is this possible?
No, there shouldnt be. charindex just returns the position of a character.. the name doesnt imply that it works with varchar only. And yes you'd use it within the select statement.. Select name, substring(mycol, charindex( '~',description), len(mycol - charindex( '~',description)) as descr from items something like that would work. Try it and see. On 4/27/05, Che Vilnonis [EMAIL PROTECTED] wrote: would this be done in the select statement? the field type for the column is 'text' and not 'varchar'. i think there would be issues with using charindex on a 'text' field. ugh again... Che -Original Message- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 27, 2005 10:28 AM To: CF-Talk Subject: Re: ListGetAt in a SQL Select Statement... is this possible? I think you could use pretty much the same thing.. SQLServer has the substring funstion but uses the Charindex (I think) to find the start position.. So you might want to try something like : substring(mycol, charindex(mycol, '~'), len(mycol - charindex(mycol, '~')) this hasnt been tested, so it may need some tweaking On 4/27/05, Aaron Rouse [EMAIL PROTECTED] wrote: I was once told that dealing with a list of data in MSSQL was easier than in Oracle. Perhaps someone well versed in MSSQL could chime in with a solution. It probably is not as hard as you think it will be to get done. On 4/27/05, Che Vilnonis [EMAIL PROTECTED] wrote: Aaron/Greg... I have M$ SQL Server 2000. I understand the premise of what you say... unfortunately, my CF skills are much better than my MS SQL skills. ~| 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:204681 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: ListGetAt in a SQL Select Statement... is this possible?
does SQLServer have the aggregate fuction max()? if so.. this will work. select max(len(mycol)) as maxlen from my_table this returns the longest value in that column On 4/27/05, Che Vilnonis [EMAIL PROTECTED] wrote: i agree. while i got ya replying to my emails, what would be the easiest way to find the longest length of characters within this field and then convert the 'text' column to a 'varchar' column with a predetermined max length? -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 27, 2005 10:42 AM To: CF-Talk Subject: RE: ListGetAt in a SQL Select Statement... is this possible? Even so, it is not likely to be over 2 Billion Characters in length is it? ~| 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:204695 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: Convert Milliseconds to Date/Time
if you use Tony's make sure you multiply your milliseconds by 1000 to
get to seconds.
On 4/27/05, Tony Weeg [EMAIL PROTECTED] wrote:
Prolly epoch time, seconds since jan 1 1970?
and sure, you can do that.
cfset myNewDate = dateAdd('s',millisecondsValueHere,'01/01/1970
00:00:00.000')
tw
On 4/27/05, Bryan Stevenson [EMAIL PROTECTED] wrote:
Jim...milliseconds are not a date...just a measure of time.
Now if you have a start date and are adding milliseconds to that date...then
you're making sense ;-)
Let us know what the situation is
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
~|
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:204785
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: Counting c(rows)
You're trying to count the number of rows returned or the total number of rows within the table? #getquestions.recordcount# will give you the number of rows returned from the query. On 4/21/05, Stuart Kidd [EMAIL PROTECTED] wrote: Hi guys, I'm trying to count the number of rows in my select, can anyone help with this please. Does this look right? !-- Retrieve Interview -- cfquery name=GetQuestions datasource=user020 SELECT questionID, question, interviewID FROM tbl_020publicQuestions WHERE interviewID = #CheckInterview.interviewID# COUNT as numberOfQuestions Thanks, Saturday ~| 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:203826 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: OT: low-end web hosting?
might want to look at www.viux.com? It's pretty inexpensive. On Apr 8, 2005 11:21 AM, Damien McKenna [EMAIL PROTECTED] wrote: I'm looking for low-end CFML web hosting. The key features are CFMX 6.1 or 7 and some sort of database (MySQL, PostgreSQL, etc), a small amount of disk space and a sandbox so I can still use e.g. cffile, cfobject, cfcontent, etc for our files. I could probably get my contact to move some of his other sites over if it proves reliable enough. I've looked at CFDynamics, CrystalTech and HostMySite but didn't like the offerings. Any other suggestions? -- Damien McKenna - Web Developer - [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| 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:201996 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: OT: low-end web hosting?
This popped up in gmail.. http://www.anumina.com/webhosting.asp from 4.95 a month On Apr 8, 2005 11:32 AM, Greg Morphis [EMAIL PROTECTED] wrote: might want to look at www.viux.com? It's pretty inexpensive. On Apr 8, 2005 11:21 AM, Damien McKenna [EMAIL PROTECTED] wrote: I'm looking for low-end CFML web hosting. The key features are CFMX 6.1 or 7 and some sort of database (MySQL, PostgreSQL, etc), a small amount of disk space and a sandbox so I can still use e.g. cffile, cfobject, cfcontent, etc for our files. I could probably get my contact to move some of his other sites over if it proves reliable enough. I've looked at CFDynamics, CrystalTech and HostMySite but didn't like the offerings. Any other suggestions? -- Damien McKenna - Web Developer - [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| 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:201998 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: OT: low-end web hosting?
it's for real On Apr 8, 2005 11:51 AM, Damien McKenna [EMAIL PROTECTED] wrote: That looks too good to be true... $4/m for 1gb of space? -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h -Original Message- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Friday, April 08, 2005 12:32 PM To: CF-Talk Subject: Re: OT: low-end web hosting? might want to look at www.viux.com? It's pretty inexpensive. ~| 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:202010 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: Anyone used these tools?
Since is this already off post I'm going to rant...
dave.. STFU.. nobody cares about your hottie, nobody cares what you
drive, and I fully believe you're filling this list full of BS.
Personally I could care less about your life and normally I would just
stay quiet however it seems that almost every day or so you come up
with something (probably a lie) or bragging about some aspect of your
life.. and 95% of it nobody cares about..
If you're going to post please keep it CF related.. I read your posts
and afterwards I feel dumber, like I've lost a couple IQ points... so
I make it a habit to ignore your posts in general.. but this as got
to stop.. dude.. keep your posts CF related and your BS in some other
list.
Thank you,
Greg
On Fri, 11 Mar 2005 14:05:10 -0600, Jared Rypka-Hauer - CMG, LLC
[EMAIL PROTECTED] wrote:
NO way do you drive a lexus! ;)
Send pics... I must see a Lexus. I must have a Lexus.
Actually I have to say that... oops, sorry Michael... {trundles off to
cf-community} :(
Man, this whole sensorship thing is Harsh. hehe...
Kidding! Sheesh... calm down!
J
On Fri, 11 Mar 2005 14:53:10 -0500, dave [EMAIL PROTECTED] wrote:
Well to each his own whether you agree with them or not standards are there
for a reason.
And personally, I believe that when building a new sites its way more
efficient to build it towards the stands then go back and add the ie hacks.
That's IMO way easier then making it for IE and then going back and trying
to make it ok for compliant browsers.
Here in Colorado the speed limit is 75 and I guess thats what the state
feels that the average car can be safely operated at but I drive a lexus
and I feel like I can operate it just as safe at 95 but that doesnt mean i
am right and get special privileges because of my opinion, I have to adhere
to the standards as well.
Not to mention you should now be building in xhtml which is not really
friends with ie but maybe we'll get lucky and they will bring back the
blink tag but this time it will mean that by the time you see it blink it
will have installed some spyware and sent you a bill to remove it. ;)
--
Continuum Media Group LLC
Burnsville, MN 55337
http://www.web-relevant.com
http://cfobjective.neo.servequake.com
~|
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:198504
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 Query Question
try... SELECT TABLE_NAME FROM USER_TABLES WHERE lower(TABLE_NAME) != 'devicestate' our tables are all capitalized. On Mon, 7 Mar 2005 18:03:24 -, Adrian Lynch [EMAIL PROTECTED] wrote: Not being an Oracle man, my first thing to check would be over != Then I'd check whether the values in TABLE_NAME are not padded with white space. Are they? Ade -Original Message- From: Charles Heizer [mailto:[EMAIL PROTECTED] Sent: 07 March 2005 17:53 To: CF-Talk Subject: OT: Oracle Query Question Hello, I have a query that gets all of the tables. CFQUERY NAME=q_Tables DATASOURCE=#settings.GlobalDS# SELECT TABLE_NAME FROM USER_TABLES /CFQUERY Now what I want to do is exclude a few tables from this query. I want to exclude a table called 'devicestate' and 'devicestatus'. I tried to add the following to the statement but it did not exclude. WHERE TABLE_NAME != 'devicestate' Any help would be much appreciated. Thanks, - Charles -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.6.2 - Release Date: 04/03/2005 ~| 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:197886 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
Which is better?
Quick question... I'm wanting to do a keyword search would be it best to A. have one huge text field (varchar2 or clob) and search using like '%keyword%' or B. set up the database where these search-a-ble words are each a row themselves.. with an ID. So you'd have 50+ fields with each searchable word or phrase has it's own row? This is more of a preformance question.. -- Auxilium meum a Domino ~| 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:197293 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: Which is better?
Cool, this was more or less just a preformance (which would you do in this situation) question. Thanks for the responses :) On Thu, 3 Mar 2005 13:09:26 -0500, Douglas Knudsen [EMAIL PROTECTED] wrote: one word...Verity :) DK On Thu, 3 Mar 2005 11:54:38 -0600, Greg Morphis [EMAIL PROTECTED] wrote: Quick question... I'm wanting to do a keyword search would be it best to A. have one huge text field (varchar2 or clob) and search using like '%keyword%' or B. set up the database where these search-a-ble words are each a row themselves.. with an ID. So you'd have 50+ fields with each searchable word or phrase has it's own row? This is more of a preformance question.. -- Auxilium meum a Domino ~| 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:197304 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
CFChart dieing
Has anyone encountered this? On our Dev Server (MX6.1 Win2K), pages with CFChart are not loading.. the call goes to the servlet and just hangs. We're using the trial version of iistracer and we can see the request but the page doesn't load. Some of these requests get up into the 1000s of seconds and it seems the only way to kill them is to restart the CF service. We've checked the mapping of CFIDE and it looks good. Has anyone ran into this? Is there some setting in the config files to cause a servlet to time out after a given period or will they just run forever? Thanks! -- Auxilium meum a Domino ~| 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:197097 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: CFChart dieing
Anyone have any ideas settings or options we can try? We're not having this problem with our prod environment, only dev. On Wed, 2 Mar 2005 08:14:54 -0600, Greg Morphis [EMAIL PROTECTED] wrote: Has anyone encountered this? On our Dev Server (MX6.1 Win2K), pages with CFChart are not loading.. the call goes to the servlet and just hangs. We're using the trial version of iistracer and we can see the request but the page doesn't load. Some of these requests get up into the 1000s of seconds and it seems the only way to kill them is to restart the CF service. We've checked the mapping of CFIDE and it looks good. Has anyone ran into this? Is there some setting in the config files to cause a servlet to time out after a given period or will they just run forever? Thanks! -- Auxilium meum a Domino -- Auxilium meum a Domino ~| 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:197156 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
Dividing output??
Is it possible (I can't see how) to take a big block of text from the database and split it up into 4 columns within a table? -- Auxilium meum a Domino ~| 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:196819 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: Dividing output??
The height of the column at this point. I imagine I could add a special character.. pipe | or something. I think my best option is to tell the biz that this wont work and that those 4 columns will need to be specific to their own column in the DB.. On Mon, 28 Feb 2005 12:34:57 -0500, Michael T. Tangorre [EMAIL PROTECTED] wrote: From: Greg Morphis [mailto:[EMAIL PROTECTED] Is it possible (I can't see how) to take a big block of text from the database and split it up into 4 columns within a table? Yes, it is possible depending upon how you want to split it. What is the criteria that determines the break points? ~| 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:196829 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: Dividing output??
See I know I can do it with a delimiter... the only problem is where to put it.. I dont want one column longer than the others. This data will more than likely be fed into the DB. The delimiter wont normally be there. I know I could use mid but that does by character, not word.. so half of a word could be at the bottom of the first column and the other half at the top of the second. On Mon, 28 Feb 2005 12:41:18 -0500, Umer Farooq [EMAIL PROTECTED] wrote: Mid and Left functions should help out here. Greg Morphis wrote: Is it possible (I can't see how) to take a big block of text from the database and split it up into 4 columns within a table? -- Umer Farooq Octadyne Systems +1 (519) 489-1119 voice +1 (519) 635-2795 mobile +1 (530) 326-3586 fax WEB SOLUTIONS FOR NON-PROFIT ORGANIZATION: http://www.Non-ProfitSites.biz WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. ~| 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:196834 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: Dividing output??
Thats exactly what I was going to do, thanks! On Mon, 28 Feb 2005 17:58:33 -, Adrian Lynch [EMAIL PROTECTED] wrote: You don't have to do that, just do a count on words, use space as a delimiter and then output 1/4 of the text in each column. Ade -Original Message- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: 28 February 2005 17:49 To: CF-Talk Subject: Re: Dividing output?? The height of the column at this point. I imagine I could add a special character.. pipe | or something. I think my best option is to tell the biz that this wont work and that those 4 columns will need to be specific to their own column in the DB.. On Mon, 28 Feb 2005 12:34:57 -0500, Michael T. Tangorre [EMAIL PROTECTED] wrote: From: Greg Morphis [mailto:[EMAIL PROTECTED] Is it possible (I can't see how) to take a big block of text from the database and split it up into 4 columns within a table? Yes, it is possible depending upon how you want to split it. What is the criteria that determines the break points? -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 266.5.1 - Release Date: 27/02/2005 ~| 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:196837 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: CF7 won't run under IIS, wont install - business almost shut down for 2 days now.
I understand the frustration too but I'm tired of the bitching like a little girl. I agree with Sean, don't damn the program, its more than likely a user error. I've installed the trial edition on 3 PCs, 2 are running XP Pro and the other (work) is Win 2k Pro. No problems Mike, not a one.. And they are all 3 multiserver installs. Call Macromedia and get some expert help and please quit the whining! On Wed, 23 Feb 2005 15:48:11 -0500, Douglas Knudsen [EMAIL PROTECTED] wrote: I have C:\CFusionMX7\runtime\lib\wsconfig but no numbered folders at all. In that swconfig folder is only the file jrunwin32.dll IIRC, you stated you were installing the multiserver version. The above does not indicate that. Now, I understand ur frustration and all, but your servers do NOT run win XP, so getting it installed on ur XP system is no real indicative test basis for deciding on installing it on ur server. Maybe try installing it on a win2k pro or server, eh? Doug On Thu, 24 Feb 2005 07:18:21 +1100, Mike Kear [EMAIL PROTECTED] wrote: Thanks for your suggestions Adam. I dont have any servers I administer, except my own dev servers. I resell space on servers that are running perfectly well and are adminstered by someone else. They are running on CFMX6.1. I am now trying to learn about CF7 so I stay up to date, and help decide if we move our servers over to CF7. At the moment, the answer's a resounding NO, because if it doesnt go perfectly, there will be no official help (i wouldn't be buying from Australia because it's not installed in Australia) and if I try to use the principal help, herre on Cf-Talk i'll be criticised by the members of the list for daring to seek help here. Nope. This is a standard WinXPPro/SP2 installation with all the updates. (I always let Microsoft apps pick their own defaults too) The folder structure isnt laid out like that at all. Remember I just allowed the install routine to have all its defaults. The install routine made up its own mind about how to install. (I learned years ago not to try to change default settings on a new product) I have C:\CFusionMX7\runtime\lib\wsconfig but no numbered folders at all. In that swconfig folder is only the file jrunwin32.dll have no jrun folders. IIS won't allow me to add mappings to extensions. The OK button is not enabled. Cheers Mike Kear Windsor, NSW, Australia Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On Wed, 23 Feb 2005 09:58:19 -0500, Adrocknaphobia [EMAIL PROTECTED] wrote: Well 99% of the time you do not have to do this manually. However there are numerous reasons why CF wouldnt be able to perform this automatically. Usually involving how you setup IIS and system privelages. As a professional hosting company, it may we worth learning the ins and outs of the servers you must manage. Located the wsconfig directory. Usually at cf-root/runtime/lib/wsconfig There you should see numbered directories. You want to map a numbered directory to IIS and name the virtual mapping 'JRunScripts'. This directory holds the jrun.dll that you want to associated with cfm templates. Under Application Settings - Configuration in IIS, you should be able to add entries for file extension and link them to the jrun.dll. Under ISAPI Filters you want to add the Filter Name of JRun Connector Filter and link it to the same jrun.dll. -Adam ~| 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:196218 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: Free Coldfusion Devs Tool
Stan, did you not read all of these messages.. the admin, Michael Dinowitz, said the product itself is on topic. And just because one guy is PMSing over the generous offer of free software doesnt mean we all need a few chill pills. Post away! On Tue, 22 Feb 2005 13:58:48 -0400, Stan Winchester [EMAIL PROTECTED] wrote: I was about to invite some members of this list to beta test two applications (products) I've been developing: a photo gallery and a links manager, but after reading this post I don't want to get my head bit off. If this is not an appropriate place to ask for input, sharing, etc... please name an appropriate forum to use? Thank you, Aftershock Web Design, Inc. by: Stan Winchester President/Developer [EMAIL PROTECTED] http://www.aftershockweb.com/ Phone 503-244-3440 Fax 503-244-3454 If I wanted to know about your product I would have read it from a web feed or signed up to know about from an email notification list. ~| 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:195947 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: way to import the C-Sharp code in ColdFusion.
Maybe you should direct this to the Blue Dragon support team? On Thu, 17 Feb 2005 11:21:31 -0500, Asim Manzur [EMAIL PROTECTED] wrote: Thanks guys, atleast I've hope now that it is possible. I setup the trial version of BlueDragon and playing with that now. First I do not have to translate all the C# codes in coldfusion. because I just have a web application. secondly. When I look for the aspx codes I saw that developer is using the parameter Codebehind which confirms that the codes are compiled. Now what i need to do is I need to import those codes somehow in Coldfusion so I can add more functionality in the applicaiton. in the aspx the developer used %@ Page language=c# Codebehind=Login.aspx.cs AutoEventWireup=false Inherits=PFWeb.Login % I was trying cfobject component=TTWeb.Login action=create name=templogin I am using BlueDragon and I got the error A request was made to a resource that could not be located Somehow I can't use the cfinclude page= because it contains all the html as well. ( i think ) when I use include it shows me the login page with all the tables and so on. which is not defined in the aspx file. What I was thinking that if I created the file test2.aspx and put this code in that file in ordre to import the C# codes %@ Page language=c# Codebehind=Login.aspx.cs AutoEventWireup=false Inherits=TTWeb.Login % Then in the .cfm file how can I get the contents. i.e. I can't use cfinclude page= do it? how can I create the cfobject Thanks once agian for your help -- Regards, Asim Manzur ~| 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:195199 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: eggy
Are you all talking about the freaky looking blue baby with the moving eyes? On Wed, 16 Feb 2005 15:00:34 +0100, RADEMAKERS Tanguy [EMAIL PROTECTED] wrote: baaa! (sheepish) I'd never seen it before! -Original Message- From: Stephen Moretti (cfmaster) [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 16, 2005 2:52 PM To: CF-Talk Subject: Re: eggy RADEMAKERS Tanguy wrote: http://www.petefreitag.com/item/90.cfm Heck! Thats like 3 years old! ~| 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:194944 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: Any sites using the new Flash foms?
if you cant see the benefit of flash forms then maybe you need to look at the calendarits 2005 btw Why would you use something just because of the year? Many factors are weighed before a product is using them, I think date should be the very least of concern heh.. On Wed, 16 Feb 2005 09:22:31 -0500, Bryan F. Hogan [EMAIL PROTECTED] wrote: I don't think anyone doesn't see the benefits. It's just that there are some usability issues keeping a lot of from using them. If the loading issue, memory issues (lot of info in dropdown), and loading icon changes to be static, I'll use them right away. I like them, but their too slow. When they load quick, I'll use them. -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 16, 2005 2:29 AM To: CF-Talk Subject: RE: Any sites using the new Flash foms? thats so lame micha! the funny thing is ppl that that talk like that make the UGLIEST web apps!!! sure they may work good but pleazz if you cant see the benefit of flash forms then maybe you need to look at the calendarits 2005 btw ~| 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:194949 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: Any sites using the new Flash foms?
Let me rephrase that.. (it's still early) Why would you use something just because of the year? Many factors are weighed before a product is chosen, I think date should be the very least of concern heh.. On Wed, 16 Feb 2005 08:30:08 -0600, Greg Morphis [EMAIL PROTECTED] wrote: if you cant see the benefit of flash forms then maybe you need to look at the calendarits 2005 btw Why would you use something just because of the year? Many factors are weighed before a product is using them, I think date should be the very least of concern heh.. ~| 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:194950 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: Dave and Source Code Organizer PS
Should this really be posted to CFTalk? It seemed to be a correspondence directed at Dave.. Shouldn't this have been emailed? On Wed, 16 Feb 2005 02:31:02 -0500, dave [EMAIL PROTECTED] wrote: right! i use it for a lot of flash code, java snippets and storing client info such as ftp usernames and passwords, so when i do my monthly reinstall its easy to get everything back up and going. I also like that you can directly back up or restore the info in it, creates an access db which i keep on an external drive From: Dawson, Michael [EMAIL PROTECTED] Sent: Tuesday, February 15, 2005 8:56 PM To: CF-Talk cf-talk@houseoffusion.com Subject: RE: Dave and Source Code Organizer PS Yeah, but application-agnostic is what I'm looking for. I don't want to have to open DW (actually I use Homesite+) to get to snippets. I need to store snippets other than HTML/CFML. There are a few other systems in which I develop, but nothing that would require me to open Homesite+. -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 15, 2005 6:55 PM To: CF-Talk Subject: RE: Dave and Source Code Organizer PS Like the snippet organiser built in to Dreamweaver? -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Wednesday, 16 February 2005 12:47 To: CF-Talk Subject: Dave and Source Code Organizer PS Dave, I'm going to review this application today. While I'm at it, are there any other similar tools that you would have rather used but were more expensive? Or, do you feel this does everything you need? Thanks M!ke -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Friday, February 11, 2005 9:43 PM To: CF-Talk Subject: RE: cfm 7 and remoting check just a program that lets you make categories and store source codes very easily cant even tell you how handy it is! the new version is a bit nicer than the older one. worth the price serveral times over http://www.pindersoft.com/sourcecode.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:194972 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: Regex Question
Tony, if someone entered a 0, wouldnt you want to account for that? Or if you didnt.. why not delete the 0's and then get an average (if they're just place holders)? If a 0 is just a place holder, you wouldnt want to replace it with a previous value. That would mess up your average. On Wed, 16 Feb 2005 10:32:28 -0500, Ben Doom [EMAIL PROTECTED] wrote: S.Isaac pointed out that I'd misread the original post. I thought he wanted to remove them, not replace them. That makes this just a wee bit harder. :-) Since what he's wanting to do is apparently average them, I'd write the summation loop manually and track the last non-zero value to use in case of zeros. I'm not sure what he'd want to do with a leading zero, but that's a whole new bag'o'worms. --Ben Michael Dinowitz wrote: Ben, I've tried this a few ways and I can't find any way to do a single run RegEx which will do the job. Handling a single 0 is child's play. Handling multiple properly is not happening. If this was put in a loop, I can see it but. What do you suggest as a solution that will handle multiple 0 replaces without a loop? Well, you could use listdeleteat() to remove them. That would probably be more human readable later. It would also handle boundary cases (ie the first and last items) easily and cleanly. If, for some reason, you really want to use a regex, it certainly can be done. :-) --Ben Tony Hicks wrote: Does anyone know if there's a way to replace an unkown number of consequitive 0s in a list with the previous number.. For instance... 147,0,119,137,0,0,0,154 would become.. 147,147,119,137,137,137,137,154 Thanks Tony ~| 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:194974 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: 2 to the power of 10
cfoutput#2^10#/cfoutput heh ;) On Wed, 16 Feb 2005 10:48:05 -0500, Tony Weeg [EMAIL PROTECTED] wrote: hola peeps! is there a udf or something else to handle this simple calculation? i can do it myself, with some dumb code, just wondering if there is something already built. later. -- tony Tony Weeg macromedia certified coldfusion mx developer email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ cool tool: http://www.antiwrap.com ~| 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:194979 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: 2 to the power of 10
It's working here Tony.. cfoutput#2^10#/cfoutput gives me 1024 On Wed, 16 Feb 2005 11:05:43 -0500, Tony Weeg [EMAIL PROTECTED] wrote: well, either im NUTS or thats just not working for me on blackstone/cfmx7? tw On Wed, 16 Feb 2005 09:54:58 -0600, Greg Morphis [EMAIL PROTECTED] wrote: cfoutput#2^10#/cfoutput heh ;) On Wed, 16 Feb 2005 10:48:05 -0500, Tony Weeg [EMAIL PROTECTED] wrote: hola peeps! is there a udf or something else to handle this simple calculation? i can do it myself, with some dumb code, just wondering if there is something already built. later. -- tony Tony Weeg macromedia certified coldfusion mx developer email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ cool tool: http://www.antiwrap.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:194989 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: Text Editor for Opening Large Log Files
mTail (tail for windows) craps out on me at above the 500,000 read buffer setting. I use UltraEdit at home. On Mon, 14 Feb 2005 14:00:47 -0500, Rick Root [EMAIL PROTECTED] wrote: Dave Watts wrote: I use tail for these sorts of things. While tail is a common Unix utility, there are free versions for Windows. HOORAY! Tail and grep are absolute essentials IMO. Today, for example, I was doing a BULK INSERT of 3.3 million rows into SQL Server. 2 rows failed... one of which was line 336525 or something like that. tail +336525 TB902.TXT | more showed me that line contained someone whose birthday was in 867 AD. Not valid data for a datetime data type in SQL 2000. Also, tail -1 application.log is handy for viewing the last line in the application log file. I think tail is actually included with Windows Server 2003... http://www.microsoft.com/resources/documentation/WindowsServ/2003/all/techref/en-us/Default.asp?url=/Resources/Documentation/windowsserv/2003/all/techref/en-us/tail.asp ~| 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:194566 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: OT: right click submit options
Doesnt right clicking in Flash bring up the Flash settings and options dropdown (not user defined)? I'm not sure if thats editable. I'd be complicated, building the dropdown and using JS to make it show where you want it to, etc.. You might want to consider other options. On Tue, 8 Feb 2005 18:39:38 -0200, Marco Antonio C. Santos [EMAIL PROTECTED] wrote: I'll suggest to use Flash Forms with CFMX 7. Could be that very very easy. Cheers Marco On Tue, 8 Feb 2005 10:28:56 -0800, Tim Do [EMAIL PROTECTED] wrote: Hi All, I was wondering if its possible to right click a row and have multiple form submit options. I have a form which has many records being outputted. Each record has a radio button and the form has multiple submit buttons. Since the submit buttons are on top and bottom.. users have to scroll down and select the record they want and scroll up or down to submit. Is there a way to right click the row and have the submit options come up? Thanks, Tim ~| 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:193725 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: OT: right click submit options
Start here... this shows you how to make the menu and make it appear where you click.. http://javascript.internet.com/page-details/right-click-menu.html Then it's just a simple JS function to make the form submit... On Tue, 8 Feb 2005 15:22:23 -0600, Greg Morphis [EMAIL PROTECTED] wrote: Doesnt right clicking in Flash bring up the Flash settings and options dropdown (not user defined)? I'm not sure if thats editable. I'd be complicated, building the dropdown and using JS to make it show where you want it to, etc.. You might want to consider other options. On Tue, 8 Feb 2005 18:39:38 -0200, Marco Antonio C. Santos [EMAIL PROTECTED] wrote: I'll suggest to use Flash Forms with CFMX 7. Could be that very very easy. Cheers Marco On Tue, 8 Feb 2005 10:28:56 -0800, Tim Do [EMAIL PROTECTED] wrote: Hi All, I was wondering if its possible to right click a row and have multiple form submit options. I have a form which has many records being outputted. Each record has a radio button and the form has multiple submit buttons. Since the submit buttons are on top and bottom.. users have to scroll down and select the record they want and scroll up or down to submit. Is there a way to right click the row and have the submit options come up? Thanks, Tim ~| 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:193727 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: ORDER BY on a query within a query
Can you show us what Oracle is getting? the query from the debug output? On Thu, 27 Jan 2005 14:27:14 -0400, daniel kessler [EMAIL PROTECTED] wrote: I can't speak for Oracle specifically, but in general, the outer select is not required to return the results in the same order as the subselect. Try moving the ORDER BY to the outer select and see if that works. I'm far from sure this is your problem, but it's certainly something to try. That didn't seem to work. I replaced from the inner ORDER BY on-down with: ORDER BY UPPER(agency) ) WHERE r = cfqueryparam value=#url.begin_num# cfsqltype=cf_sql_integer AND r = cfqueryparam value=#url.end_num# cfsqltype=cf_sql_integer ORDER BY UPPER(agency) I also tried the ORDER BY just on the outside query. Both gave the same results as I had previously. ~| 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:192006 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: display number of pages left
Daniel, It is possible within the same query to return the count of rows within that same query.. SELECT * FROM ( SELECT d.*, ROWNUM r, COUNT(docid) OVER() AS rowcount FROM DOCUMENTS d ORDER BY title ) WHERE r 1 AND r 10 Using count() over () as an analytic function instead of as an aggregate function we can return that value.. This creates a column you can reference 'rowcount' and for every row will have the total count of rows. You can do it this way or run a whole new query. Seeing that you'll only be returning 25-50 rows, using the count() over() shouldnt create too much overhead. Have fun.. GM On Fri, 21 Jan 2005 07:56:59 -0400, daniel kessler [EMAIL PROTECTED] wrote: Does making sure that it's a varchar do the same thing? IOW, is it making sure that it's not some sort of run statement? Yes, it simply tells the database server that the value is just that - a value rather than an SQL command. ah great, thanks for the clarity. I have alot of retro-fitting to do on DBs that I worked on in the past. I haven't seen the original query that you're working with (presumably it's somewhere within a previous message), but all you have to do is replace your literal values with CFQUERYPARAM tags - you shouldn't have to change your conditional logic around to accommodate this, I don't think. yeah, I build the WHERE into a long string cfset the_where = WHERE mycolumn = myvalue cfset the_where = #the_where # AND mycolumn = myvalue etc. The new way, I just CFIF the actual column and values into the SQL statement - like in your example on the MM page. Thanks for the help. Hope you like this weekends snow - looks to be a good one. ~| Logware: 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:191363 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: display number of pages left
Then use what we wrote to build the query, as far as the where clause.. use cfif statements.. select * from table where 1 = 1 cfif isdefined(some.whereclause) and some.whereclause neq and id = cfqueryparam value=#some.whereclause# cfsqltype=cf_sql_varchar /cfif On Thu, 20 Jan 2005 07:49:22 -0400, daniel kessler [EMAIL PROTECTED] wrote: Is there a chance that anyone of these rows will be deleted? If so then you wont want to do a query where id between m and n Say you delete id 250... then run a query for 201-300 expecting to return 100 results, you wont.. you'll return 100 minus the people you deleted.. could mess up your output. Just FYI Yes, records can be deleted and that's why I originally had this concern. I wanted the top 25 of my search results, not the top 25 records. ~| 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:191171 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: display number of pages left
Well good, then use what I wrote.. This is for Oracle. SELECT * FROM ( SELECT ROWNUM rID, d.* FROM DOCUMENTS d ORDER BY docid ) b WHERE b.rID BETWEEN 2 AND 8 On Thu, 20 Jan 2005 08:26:19 -0400, daniel kessler [EMAIL PROTECTED] wrote: When I try to run this SQL, I receive the error FROM keyword not found where expected SELECT TOP 25 t1.* FROM (SELECT TOP 50 service_population,agency,city,state,salary_status,int_agency_id FROM internships) t1 If I remove the TOP 25 and TOP 50 it runs fine, but of course it doesn't do what I need once I remove them. I'm using Oracle and can't find Top in my reference, which isn't the best reference. SELECT TOP 25 t1.* FROM (SELECT TOP 50 service_population,agency,city,state,salary_status,int_agency_id FROM internships #preservesinglequotes(find_text)# ORDER BY agency DESC) t1 ORDER BY t1.agency ASC ~| Logware: 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:191174 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: display number of pages left
Doug that will work for the initial query but he's wanting page progression... to display rownums between 1 and 25 for example.. That example wont work in this case.. SELECT * FROM ( SELECT * FROM DOCUMENTS ORDER BY title ) WHERE ROWNUM 20 AND ROWNUM 30 yields no results.. However if you create the variable with the inner query and pass it to the outer query then it works. IE.. SELECT * FROM ( SELECT d.*, ROWNUM r FROM DOCUMENTS d ORDER BY title ) WHERE r 1 AND r 25 On Thu, 20 Jan 2005 09:24:02 -0500, Douglas Knudsen [EMAIL PROTECTED] wrote: for a TOP N SQL in Oracle... SELECT * FROM ( SELECT * FROM tablename WHERE foo = goo ORDER BY columnname ) WHERE rownum = N Note where the order by appears, its important to sort the results first, then nab the top N. Doug On Thu, 20 Jan 2005 07:31:31 -0600, Greg Morphis [EMAIL PROTECTED] wrote: Well good, then use what I wrote.. This is for Oracle. SELECT * FROM ( SELECT ROWNUM rID, d.* FROM DOCUMENTS d ORDER BY docid ) b WHERE b.rID BETWEEN 2 AND 8 On Thu, 20 Jan 2005 08:26:19 -0400, daniel kessler [EMAIL PROTECTED] wrote: When I try to run this SQL, I receive the error FROM keyword not found where expected SELECT TOP 25 t1.* FROM (SELECT TOP 50 service_population,agency,city,state,salary_status,int_agency_id FROM internships) t1 If I remove the TOP 25 and TOP 50 it runs fine, but of course it doesn't do what I need once I remove them. I'm using Oracle and can't find Top in my reference, which isn't the best reference. SELECT TOP 25 t1.* FROM (SELECT TOP 50 service_population,agency,city,state,salary_status,int_agency_id FROM internships #preservesinglequotes(find_text)# ORDER BY agency DESC) t1 ORDER BY t1.agency ASC ~| Logware: 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:191187 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: display number of pages left
Yeah, for larger results you'd want to limit the results within the query, not the output.. IE. (oracle) SELECT * FROM ( SELECT ROWNUM ID, d.* FROM DOCUMENTS d ORDER BY docid ) WHERE ID BETWEEN 25 AND 49 On Wed, 19 Jan 2005 11:33:22 -0400, daniel kessler [EMAIL PROTECTED] wrote: That isn't really a good idea since you are asking for all your records into CF before you manipulate the results. The result is an app which doesn't scale well and chokes on simple paging query. well that's what I'm trying to avoid, though I thought that with startRow and maxrow, it limited the search to only grab those 25. You're saying it grabs all of them and only shows me the 25 in the delivered recordSet? ~| Logware: 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:191074 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: display number of pages left
Is there a chance that anyone of these rows will be deleted? If so then you wont want to do a query where id between m and n Say you delete id 250... then run a query for 201-300 expecting to return 100 results, you wont.. you'll return 100 minus the people you deleted.. could mess up your output. Just FYI On Wed, 19 Jan 2005 12:29:43 -0500, Dave Watts [EMAIL PROTECTED] wrote: I've not used cfqueryparam before. Can you clarify how I can implement this so that it makes my WHERE more secure? I've never really understood cfqueryparam. You can read all about it here: http://www.macromedia.com/devnet/mx/coldfusion/articles/cfqueryparam.html Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:191083 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: display number of pages left
Do your query and then loop over it.. using cfloop with startrow and maxrow attributes On Tue, 18 Jan 2005 14:19:34 -0500, Daniel Kessler [EMAIL PROTECTED] wrote: I have a search (http://hhp.umd.edu/studentservices/internships.cfm). If I have alot of hits in the search results, want to display the first 25 and then do page 1,2,n after that. Is the idea that I just search for the first 25 with maxrows=25 and then follow a search for the total number to determine the number of additional pages? The maxrows idea wouldn't allow me to do the page two search would it where I want to just return rows 26-50? I've not done this type of search/display before so I'm basically looking to see if I'm on the right path and for pointers. Here's my current search that just returns all results without the pages: cfset find_text = 'WHERE service_population='Social' !--- build a WHERE here--- cfquery name=getSearchItem datasource=dch SELECT service_population,agency,city,state,salary_status,int_agency_id FROM internships #preservesinglequotes(find_text)# ORDER BY agency ASC /cfquery -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 301-405-2545 Phone www.phi.umd.edu ~| Logware: 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:190976 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: Oracle help please
Frank, use something like this UPDATE TEST1 SET CHR = ( SELECT CHR FROM TEST2 WHERE TEST1.num = TEST2.num ) adjust your query to... UPDATE TABLE1 SET TABLE1.FIELD = ( SELECT TABLE2.FIELD FROM TABLE1, TABLE2 WHERE TABLE1.KEY = TABLE2.KEY AND TABLE1.FIELD = 'Y' ) On Mon, 17 Jan 2005 16:42:23 -0500, Frank Mamone [EMAIL PROTECTED] wrote: I am having trouble doing an update with a join in Oracle. I am getting this error: SQL command not properly ended. Here is the generic syntax I am using: UPDATE TABLE1 SET TABLE1.FIELD = TABLE2.FIELD FROM TABLE1, TABLE2 WHERE TABLE1.KEY = TABLE2.KEY AND TABLE1.FIELD = 'Y' Thanks for your help. Frank ~| 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:190846 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: Regex Help.
I think this will work..
^\d{1,2}.\d{1,2}$
(not tested)
On Mon, 10 Jan 2005 14:43:27 -0500, DURETTE, STEVEN J (AIT)
[EMAIL PROTECTED] wrote:
Hi All,
Need some help with a regex. What I'm trying to do is validate and
input in javascript.
The users are allowed to input a number.
It can be in the following formats:
9
9.9
9.99
.99
.9
(9 used inplace of any digit.)
I tried using \b[0-9.]+ and I've tried \b[\d]*([.]?[\d]{0,2})? and I've
tried ([\d]*([.][\d]{1,2})?){1} but I can't seem to get the response
that I want.
The user can still input numbers such as 1.25.25 and it will pass the
regex test.
To be more specific in what I'm looking for, the users are putting in
hours and partial hours.
There can be any amount of hours, but partial hours are limited to .0,
.00,.25, .5, .50, .75 or no decimal part whatsoever. (I've been trying
to do the .25, .5, etc in another part of the javascript, but if I can
do it in the regex even better.)
Anybody got any ideas.
Thanks
Steve
~|
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:189834
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: Regex Help.
^[\d]*([.]?[\d]{1,2})?$
there that will catch 9, 9.9, 9.99, will not catch 9. 9.9.9, etc
On Mon, 10 Jan 2005 13:51:23 -0600, Greg Morphis [EMAIL PROTECTED] wrote:
I think this will work..
^\d{1,2}.\d{1,2}$
(not tested)
On Mon, 10 Jan 2005 14:43:27 -0500, DURETTE, STEVEN J (AIT)
[EMAIL PROTECTED] wrote:
Hi All,
Need some help with a regex. What I'm trying to do is validate and
input in javascript.
The users are allowed to input a number.
It can be in the following formats:
9
9.9
9.99
.99
.9
(9 used inplace of any digit.)
I tried using \b[0-9.]+ and I've tried \b[\d]*([.]?[\d]{0,2})? and I've
tried ([\d]*([.][\d]{1,2})?){1} but I can't seem to get the response
that I want.
The user can still input numbers such as 1.25.25 and it will pass the
regex test.
To be more specific in what I'm looking for, the users are putting in
hours and partial hours.
There can be any amount of hours, but partial hours are limited to .0,
.00,.25, .5, .50, .75 or no decimal part whatsoever. (I've been trying
to do the .25, .5, etc in another part of the javascript, but if I can
do it in the regex even better.)
Anybody got any ideas.
Thanks
Steve
~|
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:189836
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: Regex Help.
cfset datext = D
cfset regex = ^[\d]*([.]?[\d]{1,2})?$
cfset rval = refind(regex,datext)
cfoutput#rval#/cfoutput
yields 0 (did not validate).
On Mon, 10 Jan 2005 15:57:11 -0500, DURETTE, STEVEN J (AIT)
[EMAIL PROTECTED] wrote:
Opps,
That didn't work after all. User puts in D and it evaluates to true
with that reg ex.
Steve
-Original Message-
From: Greg Morphis [mailto:[EMAIL PROTECTED]
Sent: Monday, January 10, 2005 2:57 PM
To: CF-Talk
Subject: Re: Regex Help.
^[\d]*([.]?[\d]{1,2})?$
there that will catch 9, 9.9, 9.99, will not catch 9. 9.9.9, etc
On Mon, 10 Jan 2005 13:51:23 -0600, Greg Morphis [EMAIL PROTECTED]
wrote:
I think this will work..
^\d{1,2}.\d{1,2}$
(not tested)
On Mon, 10 Jan 2005 14:43:27 -0500, DURETTE, STEVEN J (AIT)
[EMAIL PROTECTED] wrote:
Hi All,
Need some help with a regex. What I'm trying to do is validate and
input in javascript.
The users are allowed to input a number.
It can be in the following formats:
9
9.9
9.99
.99
.9
(9 used inplace of any digit.)
I tried using \b[0-9.]+ and I've tried \b[\d]*([.]?[\d]{0,2})? and
I've
tried ([\d]*([.][\d]{1,2})?){1} but I can't seem to get the
response
that I want.
The user can still input numbers such as 1.25.25 and it will pass
the
regex test.
To be more specific in what I'm looking for, the users are putting
in
hours and partial hours.
There can be any amount of hours, but partial hours are limited to
.0,
.00,.25, .5, .50, .75 or no decimal part whatsoever. (I've been
trying
to do the .25, .5, etc in another part of the javascript, but if I
can
do it in the regex even better.)
Anybody got any ideas.
Thanks
Steve
~|
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:189847
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: ASP help
Maybe you should ask these questions on an asp forum? Thanks On Wed, 05 Jan 2005 10:17:21 -0400, Asim Manzur [EMAIL PROTECTED] wrote: could someone please tell me the following code in ASP??? Thanks once again. CFIF IsDefined(pid) do this cfelseif IsDefined(jid) do this cfif ~| 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:189374 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
comma separator
I have a query in which a list (selected from items in a select box) are searched by. My problem stems from the fact that this list contains City, St and these are being counted as 2 enteries, not 1. Is there a way to change the default separator for a select box or does anyone have any other suggestions? Query follows. SELECT b.CONTRACTMARKET,b.CHANNEL,b.AGENTNAME, a.CONTRACTCONTACTNAME, a.CONTRACTADDRESS, a.CONTRACTCITY, a.CONTRACTSTATE, a.CONTRACTZIP, b.COMMISSIONTYPE, b.AGREEMENTNAME, to_char(b.STARTDATE,'mm/dd/') as STARTDATE, c.TERRITORIES, b.ACCOUNTMANAGER from agentinfo a, contractinfo b, TERRITORIES c where a.agentid = b.agentid(+) AND b.contractid = c.contractid(+) cfif arguments.mkt neq all AND lower(contractmarket) in (cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#lcase(arguments.mkt)# list=Yes) /cfif -- Auxilium meum a Domino ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189164 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: comma separator
I added the pipe character at the end of each option value statements. On the processing page I replaced '|,' with '|' and in my cfqueryparam call I added separator='|'. Works great, thanks! On Mon, 3 Jan 2005 13:53:09 -0500, Burns, John D [EMAIL PROTECTED] wrote: When you're looping over the values you could just increment the list by 2 on each so the first and second values go together, etc. John Burns Certified Advanced ColdFusion MX Developer AI-ES Aeronautics, Web Developer -Original Message- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Monday, January 03, 2005 1:45 PM To: CF-Talk Subject: comma separator I have a query in which a list (selected from items in a select box) are searched by. My problem stems from the fact that this list contains City, St and these are being counted as 2 enteries, not 1. Is there a way to change the default separator for a select box or does anyone have any other suggestions? Query follows. SELECT b.CONTRACTMARKET,b.CHANNEL,b.AGENTNAME, a.CONTRACTCONTACTNAME, a.CONTRACTADDRESS, a.CONTRACTCITY, a.CONTRACTSTATE, a.CONTRACTZIP, b.COMMISSIONTYPE, b.AGREEMENTNAME, to_char(b.STARTDATE,'mm/dd/') as STARTDATE, c.TERRITORIES, b.ACCOUNTMANAGER from agentinfo a, contractinfo b, TERRITORIES c where a.agentid = b.agentid(+) AND b.contractid = c.contractid(+) cfif arguments.mkt neq all AND lower(contractmarket) in (cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#lcase(arguments.mkt)# list=Yes) /cfif -- Auxilium meum a Domino ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189167 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: Date Issues
try:
cfdump var=#form#
cfabort
above the code you've written.
Paste the output exactly.
On Tue, 21 Dec 2004 14:04:40 -0500, Burns, John D
[EMAIL PROTECTED] wrote:
Are you sure that's not the date that it's feeding in? Are you positive
your date format is written correctly. I looks like 2012 is coming up
for December which leads me to believe that it's reading in MM/DD/YY and
it thinks it's coming in as YY/MM/DD. Are you sure you're using the
4-digit year and that you've tried it as /MM/DD? That was what had
solved it for me.
John Burns
Certified Advanced ColdFusion MX Developer
AI-ES Aeronautics, Web Developer
-Original Message-
From: Jason Smith [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 21, 2004 1:58 PM
To: CF-Talk
Subject: RE: Date Issues
I tried that in the beginning thinking it might have something to do
with it. But all that does is reverse the date 2012/07/20 what I really
can't figure out is where it could possibly be pulling that date from.
At 11:54 AM 12/21/2004, you wrote:
I know when I was using MySQL, it used the dateformat of /MM/DD
instead of MM/DD/. You may need to fix your dateFormat to display
that correctly.
John Burns
Certified Advanced ColdFusion MX Developer AI-ES Aeronautics, Web
Developer
-Original Message-
From: Jason Smith [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 21, 2004 1:48 PM
To: CF-Talk
Subject: Date Issues
Can anyone narrow down what the problem might be:
The site I'm working on was built for access, I ported it to mysql
after making all the needed changes for date stamps and anything else
incompatible I have a new issue that seems to be random. When updating
an Item via the administration application I have:
*Item Date Received:
cfif isDate('#FORM.itemDateRecieved#')
cfoutputcfset DR = #DateFormat(FORM.itemDateRecieved,
'MM/DD/')#/cfoutput
cfelse
cfoutputcfset DR = #FORM.itemDateRecieved#/cfoutput
/cfif
!---ITEM DATE RECIEVED---
tr
td class=formTitlespan class=votitle*Item Date
Received:/span/td
tdcfif enabledYN eq disabledspan
style=color:gray;cfoutput#DR#/cfoutput/spancfelsecfinput
type=text name=itemDateRecieved class=formBox
value=#DR#/cfif/td /tr tr tdnbsp;/td tdspan
class=smallMM/DD//span/td
/tr
Now when you update an item everything runs fine and seems to update
but on certain items dates are still fouled up. One in particular I'm
working on is always showing date 07/20/2012 and refuses to take
anything else. Now could anyone tell me is this a cf problem or
possibly a problem with the data field?
~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188437
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: JS issue
Yeah it was the missing return in the function call.
I didnt want the onSubmit because this form had 2 submit buttons.
I needed this to be a separate function, however that got it and I
appreciate it!
On Fri, 17 Dec 2004 15:54:57 -0500, Ray Champagne [EMAIL PROTECTED] wrote:
How are you calling the function?
You should be calling it like this:
onSubmit=javascript: return subForm();
and add:
return true;
to the else clause.
This drove me crazy a few weeks ago.
Ray
At 03:52 PM 12/17/2004, you wrote:
I have a button which calls a JS function
I'm checking to see if a date is prior to another.. if not then the
function should alert the user and return out of the function. If it's
prior to the end date then the function should change the action of
the form and then submit the form.
I have this..
function subForm()
{
if (document.siteReferrals.StartDate.value
document.siteReferrals.EndDate.value)
{
alert(Your Start Date must be before your End Date);
return false;
}
else
{
document.siteReferrals.action='Report-SiteReferrals.cfm';
document.siteReferrals.submit();
}
}
No matter what it always submits the page.
Even if it alerts me that the start date is greater then the end date.
--
Auxilium meum a Domino
~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188264
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: Question from a beginner on visible invisible divs
What you want is the display attribute.
Divs display is normally set at inline
IE
div id='divBlock' style=display:block;
You can set this to none using JS.
document.getElementById('divBlock').style.display='none';
and to set it back
document.getElementById('divBlock').style.display='inline';
I use the msdn reference located here..
http://msdn.microsoft.com/library/default.asp?url=/workshop/author/dhtml/reference/objects.asp
On Mon, 20 Dec 2004 09:11:38 -0800, John Munyan [EMAIL PROTECTED] wrote:
Hi, I am hoping someone can point me to a tutorial or link(s) explaining how
I might be able to created visible/invisible divs. My navigation system is
made up a myriad of hikes broken down into categories. I would like to
create functionality that presents the page collapsed showing the categories
and if the user clicks the category expands the hikes in the category.
Anyone know a good source of information on how this is done?
Another example of what I am after is myyahoo where you can expand and
minimize sections of content you have selected.
Any advice appreciated
Thanks,
John
~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188273
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: database query
Try: Select company_ID, company_name, contact_company_FK, contact_name From companies, Contacts Where company_ID(+) = contact_company_FK On Mon, 20 Dec 2004 12:37:24 -0500, Ray Champagne [EMAIL PROTECTED] wrote: Yea, that is what I did, but keep getting an error saying Join not supported Here is a copy of the error message I get: Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Join expression not supported. The error occurred in D:\CFusionMX\wwwroot\Data\CV_ADMIN\pages\view.cfm: line 13 Maybe this is specific to Access? Ray At 12:35 PM 12/20/2004, you wrote: Select company_ID, company_name, contact_company_FK, contact_name From companies LEFT OUTER JOIN Contacts ON company_ID = contact_company_FK Or RIGHT -e -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 12:23 PM To: CF-Talk Subject: database query I have two tables in my DB: Companies: company_ID (PK) company_name etc Contacts: contact_company_FK (FK linked to company_ID) contact_name etc What I need to do is query the DB and get all the companies and all the contacts associated with that company, even if there are no contacts for a particular company. I am passing in the #company_ID# to the page. I think what I am supposed to be doing is a LEFT JOIN, but I can't get the syntax to work correctly. Anybody got any ideas for this? I am using the evil MS Access DB and CFMX 6.1. Thanks! Ray = Ray Champagne - Senior Application Developer CrystalVision Web Site Design and Internet Services 603.433.9559 www.crystalvision.org = The information contained in this transmission (including any attached files) is CONFIDENTIAL and is intended only for the person(s) named above. If you received this transmission in error, please delete it from your system and notify us immediately. If you are not an intended recipient, please note that any use or dissemination of the information contained in this transmission (including any attached files) and the copying, printing, or retransmission of that information is strictly prohibited. You can notify us by return email or by phone at 603.433.9559. Thank you. ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188290 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: JS issue
Not sure but it works just like that, no converting needed. I was thinking that it would have to be date objects myself but hit that submit on accident and it worked so I havent fooled with it. The dates will be in a mm/dd/ or m/d/yy or m/d/yy or mm/dd/yy format, not sure if that helps or not. On Mon, 20 Dec 2004 14:02:17 -0400, Larry White [EMAIL PROTECTED] wrote: Just curious, but don't you have to convert the form fields to date objects before they can be compared like that? Or are they in a format so they can be compared as strings? Yeah it was the missing return in the function call. I didnt want the onSubmit because this form had 2 submit buttons. I needed this to be a separate function, however that got it and I appreciate it! On Fri, 17 Dec 2004 15:54:57 -0500, Ray Champagne [EMAIL PROTECTED] wrote: ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188305 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: JS issue
Doh! good call! I added.. var sDate=new Date(document.siteReferrals.StartDate.value); var eDate=new Date(document.siteReferrals.EndDate.value); and then compared sDate to eDate and this fixed it.. Thanks a bunch! On Mon, 20 Dec 2004 14:21:58 -0400, Larry White [EMAIL PROTECTED] wrote: You may want to try comparing something like 9/10/04 and 11/10/04 and see if it works correctly. Datewise, of course Nov is after Sept, but alphabetically 9 would sort higher than 1. It may be by accident the two strings you submitted worked out OK, but not all of them will. Not sure but it works just like that, no converting needed. I was thinking that it would have to be date objects myself but hit that submit on accident and it worked so I havent fooled with it. The dates will be in a mm/dd/ or m/d/yy or m/d/yy or mm/dd/yy format, not sure if that helps or not. On Mon, 20 Dec 2004 14:02:17 -0400, Larry White [EMAIL PROTECTED] wrote: ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188310 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: record count
what dbms? mysql? mssql? oracle? access? On Fri, 17 Dec 2004 12:28:34 -0500, Tim Laureska [EMAIL PROTECTED] wrote: I'm looking for a way of obtaining a count of records from a query where only one particular field has data... I don't want to create a separate query for this just addressing this field (ie. do recordcount where field NEQ or some variation) but would like to utilize an existing query that includes that particular field already in the select statement (among many others) Is there an easy way to get a count of records obtained by a query where data is in a field I'm interested in Hope that makes sense Tim ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188016 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: record count
you can add a count(field) as field_count however using this analytic function will force you to use a group by in your query, thus possibly messing with output. You'd have to use an aggregate function. Here we use an Oracle database, for this I'd do something like Select npa || nxx npanxx, count(npa) over () as npa_count from phone_numbers You might want to see if you can use an aggregate function like that.. It might actually be best to use a separate query though. Good luck On Fri, 17 Dec 2004 13:05:06 -0500, Tim Laureska [EMAIL PROTECTED] wrote: Thanks Anthony... but where is that any different from just doing another query such as ... cfquery dsn=whatever name=count SELECT field FROM table WHERE Field NEQ OR field NEW NULL /cfquery cfoutput#count.recordcount#/cfoutput maybe just hopeful dreaming... -Original Message- From: Anthony Cooper [mailto:[EMAIL PROTECTED] Sent: Friday, December 17, 2004 12:37 PM To: CF-Talk Subject: Re: record count If I understand you correctly, you have already run the query in a cfquery/ tag and have a recordset, no? If so, you could do a simple Query of Queries on this to further interrogate your results. e.g. cfquery name=rsNew dbtype=query SELECT COUNT( something ) AS somethingCount FROM rsExisting WHERE NOT something IS NULL /cfquery Where 'rsExisting' is the name of your original recordset. HTH, Ant On 17 Dec 2004, at 17:28, Tim Laureska wrote: I'm looking for a way of obtaining a count of records from a query where only one particular field has data... I don't want to create a separate query for this just addressing this field (ie. do recordcount where field NEQ or some variation) but would like to utilize an existing query that includes that particular field already in the select statement (among many others) Is there an easy way to get a count of records obtained by a query where data is in a field I'm interested in Hope that makes sense Tim ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188033 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
JS issue
I have a button which calls a JS function
I'm checking to see if a date is prior to another.. if not then the
function should alert the user and return out of the function. If it's
prior to the end date then the function should change the action of
the form and then submit the form.
I have this..
function subForm()
{
if (document.siteReferrals.StartDate.value
document.siteReferrals.EndDate.value)
{
alert(Your Start Date must be before your End Date);
return false;
}
else
{
document.siteReferrals.action='Report-SiteReferrals.cfm';
document.siteReferrals.submit();
}
}
No matter what it always submits the page.
Even if it alerts me that the start date is greater then the end date.
--
Auxilium meum a Domino
~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188067
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: cfif issues
But the initial time the page loads it will not. Take out that extra /cfif If you're choosing a directory for uploading that may not be the bext method anyways. On Thu, 16 Dec 2004 10:56:31 -0700, Charlie Griefer [EMAIL PROTECTED] wrote: first off...do you have an extraneous /cfif in there? second, your first cfif will fire under both of those scenarios, as URL.directory exists for both. On Thu, 16 Dec 2004 12:47:26 -0500, Phillip Perry [EMAIL PROTECTED] wrote: Hi, assuming all variables are correct what is wrong with this code? cfif IsDefined(url.directory) a href=testftp.cfm?directory=#url.directory#/#ListFiles.name# cfelse a href=testftp.cfm?directory=#ListFiles.name#/cfif#ListFiles.name#/a /cfif When i click on the very first link the path looks similar to this.. testftp.cfm?directory=wwwroot So the next page would have links that should now look similar to this.. testftp.cfm?directory=wwwroot/images however something is failing with the IsDefined statement becauase I'm getting this.. testftp.cfm?directory=images Does anyone have any thoughts? Phil ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187928 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: i need some java
Here's the regex I use for internal emails..
refindnocase([EMAIL PROTECTED],4}$,email)
This basically says the email has to start with an alpha character,
followed by any alphanumeric value or - or _ or .
Then it has the @
followed by and letter, number or underscore
followed by an '.'
and lastly the domain is between 2-4 characters.
You may want to extend this value to 6.
Plug in some test values and have fun.
As far as phone number..
If it can only be 000- value..
Use
^[\d]{3}-[\d]{4}$
This will match any number exactly 3 times, followed by a dash and
then exactly 4 numbers.
If you want to force the area code use
^[\d]{3}-[\d]{3}-[\d]{4}$
Enjoy
On Thu, 16 Dec 2004 04:14:09 -0400, Simon Smith [EMAIL PROTECTED] wrote:
I use this for all my email validation, its not regEx but it works OK for me
function isEmail(str)
{
posAtSign = str.indexOf(@)
posDot =str.lastIndexOf(.)
end = str.length-1
start = 0
missing = -1
if( str.length == 2)
{ return false }
if( posAtSign == missing || posAtSign == start || posAtSign == end )
{ return false }
if ( posDot posAtSign || posDot == missing || posDot == start || posDot ==
end )
{ return false }
return true
}
ok quick ?
gunna quit using extensions to do my form validation
2 things i need
say i have this code
InvalidTag LANGUAGE=JavaScript
!--
function checkForm(){
theform=document.reg_frm
// Check member Number
if (theform.memberN.value==){
alert(Please provide your Membership Number, like
000-.)
theform.memberN.focus()
return false;
}
// Check email
if (theform.email.value==){
alert(Please provide a Email.)
theform.email.focus()
return false;
}
how would i add a reg expression for the email
and how would i have the memberN in format like 000-
sorry, i know i was given the code for the 2nd part but now i cant friggin
find it
tia
~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187868
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: CF vs ASP.NET! GET YOUR FRESH POPCORRRRN!!
Kwang, I think I know why you've had so many jobs.. You send all the damn day goofing off and bitching. I'll be the first just to come out and say STFU. You're preaching to the converted, you're wasting your time. Now please, for the love of God, drop it and move on. On Mon, 13 Dec 2004 15:42:41 -0400, Kwang Suh [EMAIL PROTECTED] wrote: Please don't belittle my comments with such an offhand packaged response. Seriously, I'm not belittling you. I've heard that phrase used so many times for so many situations, it's perhaps an indication to MM that they need to build in some more functionality, especially to keep up with the competition. For instance, there was a post here about how slow string concatenation was in CF. Someone suggested using Java's StringBuilder class. Heck, I wouldn't mind if there was a way to create, say, a superstring in CF that would take care of that for you. What's wrong with that? I am try to respond in a reasonable and considered manner. The least you could do is return the courtesy. What is it that makes you think that it is a crutch? As I have already stated in my response to Ben, createObject is not a panacea. On the one hand you're berating CFML for it's lack of vision, and on the other you seem to be claiming that it's somehow cheating to use some of the very powerful things that CFMX makes available to you. Not everything in Java or COM is usable in CFMX. I for one would be horrified if Macromedia decided to expose full thread management in CFML. Thread programming is relatively complex and you can easily tie the server in knots if you aren't careful. Well, so is SQL, but there it is. There are many ways to kill yourself with CF as it is, and I don't think adding thread capabilities is going to have people up in arms. I don't want a product that requires mittens on my hands just in case I happen to type some code that'll blow up the server, as it were. The point is that all the power you need is available to CF as long as you are prepared to accept that some things will need to be done in Java. Macromedia try pretty hard to make sure that those things are edge cases and don't impact the majority of their customers. I don't really consider some of these things edge cases. Poor Will. All he wanted was a better ColdFusion. If they didn't ColdFusion would have disappeared a long time ago. Why? ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187451 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: Copy Or Transfer Selected Records From One Table To Another Table?
I'm not about other DBs but INSERT INTO TableA SELECT * FROM TableB works fine in Oracle On Mon, 13 Dec 2004 12:36:51 -0600, Nick Baker [EMAIL PROTECTED] wrote: What is the most efficient way to copy or transfer selected records from one table to another table with the same structure?. I.e., all records within a certain date range. Select and Insert seems be a very laborious method. Thanks, Nick ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187415 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: Cannot Update Date/Time field
You could also use a dummy date.. 1/1/ or something. I did that when I ran into a similiar situation. On Fri, 10 Dec 2004 19:06:53 +0100, Pascal Peters [EMAIL PROTECTED] wrote: Use cfqueryparam and set the null attribute dynamically Pascal -Original Message- From: Richard Colman [mailto:[EMAIL PROTECTED] Sent: 10 December 2004 18:45 To: CF-Talk Subject: Cannot Update Date/Time field I cannot update a date/time field within ACCESS when the value of the field is null. The field is marked not required in ACCESS so it should accept nulls. I get a datatype mismatch. Does anyone have a solution for this problem?? Richard Colman ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187051 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: Cannot Update Date/Time field
If you're talking about CF output, use an if statement to check the date for the dummy date.. if it is they display nbsp; or something. On Fri, 10 Dec 2004 10:53:01 -0800, Richard Colman [EMAIL PROTECTED] wrote: Yes, I tried that, but it is ugly. When the user looks at the update, you see a dummy listing that has to be explained (e.g. 1/1/ really means no data ...) If they run a report, etc. with the data, then you end up with a nonsensical date like 1/1/ in the report. Is this an ACCESS thing? Would it happen in SQL-Server. It seems like this is a common situation, and I can't seem to come up with a good solution? -Original Message- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Friday, December 10, 2004 10:16 AM To: CF-Talk Subject: Re: Cannot Update Date/Time field You could also use a dummy date.. 1/1/ or something. I did that when I ran into a similiar situation. On Fri, 10 Dec 2004 19:06:53 +0100, Pascal Peters [EMAIL PROTECTED] wrote: Use cfqueryparam and set the null attribute dynamically Pascal -Original Message- From: Richard Colman [mailto:[EMAIL PROTECTED] Sent: 10 December 2004 18:45 To: CF-Talk Subject: Cannot Update Date/Time field I cannot update a date/time field within ACCESS when the value of the field is null. The field is marked not required in ACCESS so it should accept nulls. I get a datatype mismatch. Does anyone have a solution for this problem?? Richard Colman ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187061 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: Cannot Update Date/Time field
BTW I quick search on google yielded. http://www.experts-exchange.com/Databases/Q_20657164.html apparently it's possible to set date values to null in Access On Fri, 10 Dec 2004 13:21:03 -0600, Greg Morphis [EMAIL PROTECTED] wrote: If you're talking about CF output, use an if statement to check the date for the dummy date.. if it is they display nbsp; or something. On Fri, 10 Dec 2004 10:53:01 -0800, Richard Colman [EMAIL PROTECTED] wrote: Yes, I tried that, but it is ugly. When the user looks at the update, you see a dummy listing that has to be explained (e.g. 1/1/ really means no data ...) If they run a report, etc. with the data, then you end up with a nonsensical date like 1/1/ in the report. Is this an ACCESS thing? Would it happen in SQL-Server. It seems like this is a common situation, and I can't seem to come up with a good solution? -Original Message- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Friday, December 10, 2004 10:16 AM To: CF-Talk Subject: Re: Cannot Update Date/Time field You could also use a dummy date.. 1/1/ or something. I did that when I ran into a similiar situation. On Fri, 10 Dec 2004 19:06:53 +0100, Pascal Peters [EMAIL PROTECTED] wrote: Use cfqueryparam and set the null attribute dynamically Pascal -Original Message- From: Richard Colman [mailto:[EMAIL PROTECTED] Sent: 10 December 2004 18:45 To: CF-Talk Subject: Cannot Update Date/Time field I cannot update a date/time field within ACCESS when the value of the field is null. The field is marked not required in ACCESS so it should accept nulls. I get a datatype mismatch. Does anyone have a solution for this problem?? Richard Colman ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187062 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 and CF
my bad, test should have been qry.. It should have read val = evaluate(qry.agentpw[+ rn +]); Ian Skinner wrote a reply using cfwddx so I'm going to give that a try. I know about the server/client problems with CF and JS. I wish there were simpler ways of making them work together more fluidly. Thanks On Thu, 9 Dec 2004 12:00:33 +, Thomas Chiverton [EMAIL PROTECTED] wrote: On Wednesday 08 Dec 2004 22:24 pm, Greg Morphis wrote: val = evaluate(test.agentpw[+ rn +]); The structure exists, I can get any value manually by #qry.desc[1]#. What's 'test' ? Some sort of Neuromancer webservice object ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44 (0)1749 834900 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834XXX web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186787 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: JavaScript and CF
Ian, thanks for the reply. I'm using script language=Javascript type=text/javascript cfwddx action=cfml2js input=#qry# topLevelVariable=aJSVar /script however I keep getting a JS error : WddxRecordset is Undefined. When I view the source I clearly see the array created, I just keep getting that error message. Any ideas? On Wed, 8 Dec 2004 15:30:57 -0800, Ian Skinner [EMAIL PROTECTED] wrote: One must always remember that server side processing (CF) and client side processing (JS) are different and never the twain shall meet. Ok, ok, yes there are ways to mix the two, but not the way you are talking about. Once the page and all the data has been sent to the client, using CFML is not going to do much good, the Cold Fusion Application server is been there, done that with that page an is on to the next request. What you probably want to do, but this is not the only way to skin this particular piece of code, is to pass the CFML array into the JS creating a JS array out of it. I've done this several time and usually just use the straight forward CFWDDX... tag, which has a built in parameter value cfml2js to do just this in one line I usually just put this in the top of my JS code script type=text/javascript cfwddx action=cfml2js input=#aCFArray# topLevelVariable=aJSVar // other JS code that can now reference the JS array aJSVar /script -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186793 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: JavaScript and CF
Nevermind, I found that I had to include the wddx.js file. Thanks! On Thu, 9 Dec 2004 07:57:43 -0600, Greg Morphis [EMAIL PROTECTED] wrote: Ian, thanks for the reply. I'm using script language=Javascript type=text/javascript cfwddx action=cfml2js input=#qry# topLevelVariable=aJSVar /script however I keep getting a JS error : WddxRecordset is Undefined. When I view the source I clearly see the array created, I just keep getting that error message. Any ideas? On Wed, 8 Dec 2004 15:30:57 -0800, Ian Skinner [EMAIL PROTECTED] wrote: One must always remember that server side processing (CF) and client side processing (JS) are different and never the twain shall meet. Ok, ok, yes there are ways to mix the two, but not the way you are talking about. Once the page and all the data has been sent to the client, using CFML is not going to do much good, the Cold Fusion Application server is been there, done that with that page an is on to the next request. What you probably want to do, but this is not the only way to skin this particular piece of code, is to pass the CFML array into the JS creating a JS array out of it. I've done this several time and usually just use the straight forward CFWDDX... tag, which has a built in parameter value cfml2js to do just this in one line I usually just put this in the top of my JS code script type=text/javascript cfwddx action=cfml2js input=#aCFArray# topLevelVariable=aJSVar // other JS code that can now reference the JS array aJSVar /script -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186795 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
Creating a Calendar
I'm creating a calendar and need to know how to make the days start on the day the month starts one.. IE.. December has 31 days and starts on Wednesday. So for December I have created 35 divs using a cfloop I run a query return days, first day of month, the number of weeks in the month (1-5) In my cfloop I have.. cfloop from=1 to=#cal.maxweek*7# index=i div class=day cfoutput#cal.rn[i]#/cfoutput /div cfif i mod 7 eq 0/br/cfif /cfloop this creates the calendar but it always starts at the first cell. so it looks like 1 2 3 4 5 6 7 8 9 10 11 12 13 14 etc.. but should look like 1 2 3 4 5 6 7 8 9 10 11 etc.. So how do I make this skip the first 3 divs? -- Auxilium meum a Domino ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186850 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: Creating a Calendar
I did Doug.. After I wrote it in CFML.. I looked at the code in there and am now rewriting it in cfscript.. I just wanted to see if I could do it myself without blantant borrowing of someone else's code. Thanks for the samples and examples they were helpful. On Thu, 9 Dec 2004 20:34:22 -0500, Douglas Knudsen [EMAIL PROTECTED] wrote: look at that calendar.cfc you used on that training project. :) Doug On Thu, 9 Dec 2004 16:55:24 -0700, Charlie Griefer [EMAIL PROTECTED] wrote: Greg: Check out http://charlie.griefer.com/code/cfscript_calendar.cfm Just for kicks, wanted to see if i could do a calendar in nothing but cfscript. Not that it's necessarily the best way to do this, but the code/logic is there for the perusing. On Thu, 9 Dec 2004 11:06:23 -0600, Greg Morphis [EMAIL PROTECTED] wrote: I'm creating a calendar and need to know how to make the days start on the day the month starts one.. IE.. December has 31 days and starts on Wednesday. So for December I have created 35 divs using a cfloop I run a query return days, first day of month, the number of weeks in the month (1-5) In my cfloop I have.. cfloop from=1 to=#cal.maxweek*7# index=i div class=day cfoutput#cal.rn[i]#/cfoutput /div cfif i mod 7 eq 0/br/cfif /cfloop this creates the calendar but it always starts at the first cell. so it looks like 1 2 3 4 5 6 7 8 9 10 11 12 13 14 etc.. but should look like 1 2 3 4 5 6 7 8 9 10 11 etc.. So how do I make this skip the first 3 divs? -- Auxilium meum a Domino ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186933 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
Javascript and CF
Say I have a query that returns some values
rownum, id, and desc
11001 ProductA
21002 ProductB
31003 ProductC
41004 ProductD
51005 ProductE
Is it not possible (without opening a new frame) to use Javascript to
get a certain row?
I was thinking something on the lines of
a href=Javascript:getDesc(#qry.rownum#)#qry.id#/a
div id=sDiv
Description
/div
How would I access the value?
I've tried
script language=Javascript
!--
function getDesc(num)
{
var rn = num;
val = evaluate(test.agentpw[+ rn +]);
alert(cfoutput#val#/cfoutput);
}
//--
/script
But I keep getting val is undefined.
The structure exists, I can get any value manually by #qry.desc[1]#.
It sounds fairly simple what am I doing wrong?
--
Auxilium meum a Domino
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186688
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: isdefined function within cfcs?
I dont know about that but I always use params to predefine my
values and set the default to .
Then check to see if the value is .
On Wed, 08 Dec 2004 09:32:42 -0400, Daniel Farmer [EMAIL PROTECTED] wrote:
I'm not sure if being in a cfc has anything to do with it... but why are my
cfc functions trying to evaluate street in this case below.
Element STREET is undefined in ARGUMENTS.
cfif isdefined('arguments.street')'#arguments.street#', /cfif
Since the code between the cfif should only run if the argument is defined..
why is it trying to evalute it?
~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186689
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: Fixed Width variable question.
Use numberformat #numberformat(num1,0)# On Mon, 6 Dec 2004 13:50:01 -0500, Jeff Waris [EMAIL PROTECTED] wrote: Does anyone have a good technique they use to make a fixed width variable to insert into a text file? For example I have an order number, it can be 3,4,5 or 6 characters long Lets say: 123 1234 12345 123456 ...and I need to format them at 9 characters long by inserting 0's in the beginning: 00123 01234 12345 000123456 Thanks, Jeff ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186334 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: cffile read to read JUST the top line of the txt file.
Yeah I would definitely start with a smaller file while testing..
maybe 5-10 rows and make sure things are working before trying it on a
5 million row file.
Also the query idea...
I would use
Select * from table
where rownum 2
I believe using the max rows happens after the query.. So CF loads all
records and then truncates the 1.. so use rownum if possible.
On Fri, 3 Dec 2004 11:21:28 -0500, Dave Carabetta [EMAIL PROTECTED] wrote:
On Fri, 3 Dec 2004 10:37:54 -0500, Joe Rinehart [EMAIL PROTECTED] wrote:
Yep - this should get you started:
cfscript
filename = /path/to/file.csv;
fileReader = createObject(java, java.io.FileReader);
fileReader = fileReader.init(filename);
lineReader = createObject(java,java.io.LineNumberReader);
lineReader = lineReader.init(fileReader);
line = lineReader.readLine();
/* this'd keep reading in lines
while (isDefined(line)) {
lineCount = lineCount + 1;
// do something here with the data in variable line
line = lineReader.readLine();
}
*/
/cfscript
cfoutput#line#/cfoutput
Shouldn't there be a .close() statement in there somewhere at the
bottom? Otherwise you're going to have tons of open files on your
system (I learned this one the hard way!!).
Regards,
Dave.
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186091
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: Best Practice: Import Delimited List to Database
If you're using Oracle and can run sqlldr.exe wouldnt that be your best practice? For an Oracle system? On Wed, 1 Dec 2004 11:11:33 +0100, Massimo Foti [EMAIL PROTECTED] wrote: I wrote a CFC that helps me automating similar tasks: http://www.olimpo.ch/tmt/cfc/tmt_csv.zip Check it out andsee if it may fit your needs Massimo Foti DW tools: http://www.massimocorner.com CF tools: http://www.olimpo.ch/tmt/ ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185787 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: Best Practice: Import Delimited List to Database
I use sqlldr from a cfexecute call in CF. It's remarkably fast. I load some 25,000 rows (some 300 columns in length) from an uploaded txt document. It only takes a few minutes to do so. On Wed, 1 Dec 2004 09:58:09 -0600, Aaron Rouse [EMAIL PROTECTED] wrote: As best I can tell, yes. I use SQLLDR triggered by a nightly windows scheduler for one project and works out great. Though DTS would be so much nicer to use and could even import into a Oracle DB just doubtful one would have access to DTS if in an environment that uses Oracle. I have yet to try and see if I can use SQLLDR via an execution done in CF. Only reason that I may not would be if some sort of security solution was blocking it and of course if the executable itself was missing from that server. -- Aaron Rouse http://www.happyhacker.com/ On Wed, 1 Dec 2004 07:12:47 -0600, Greg Morphis [EMAIL PROTECTED] wrote: If you're using Oracle and can run sqlldr.exe wouldnt that be your best practice? For an Oracle system? ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185807 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 Query question. Please help...
select custid from customers minus select custid from orders On Tue, 30 Nov 2004 11:05:11 -0600, Eric Creese [EMAIL PROTECTED] wrote: Sometimes using NOT can have performance issues You can also do: SELECT a.CustID FROMCustomers a,Orders b WHERE a.CustID = b.CustID -Original Message- From: Adam Haskell [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 30, 2004 11:06 AM To: CF-Talk Subject: Re: SQL Query question. Please help... Multiple ways heres one: SELECT CustID FROMCustomers WHERE CustID NOT IN (Select CustID From Orders) Adam On Tue, 30 Nov 2004 12:01:30 -0500, Che Vilnonis [EMAIL PROTECTED] wrote: Say I have two simple queries: cfquery name=getCustsFromCusts datasource=#DSN# SELECT CustID FROMCustomers /cfquery [and that query returns 700 records.] cfquery name=getCustsFromOrders datasource=#DSN# SELECT CustID FROMOrders /cfquery [and that query returns 500 records.] The first query gets all Customer IDs. The second query gets all Csutomer IDs that have placed orders. Is there some way in SQL, to combine these two queries into one and return only the Customer IDs that are in the 'Customers' table that ARE NOT in the 'Orders' table. Using this example, 200 records would be returned. Any help would be appreciated. Che ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185688 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: get directory name
Use cfdirectory Then cfif dirlist.type eq Dir ... On Wed, 24 Nov 2004 09:52:16 -0500, Robert Orlini [EMAIL PROTECTED] wrote: Using CFFile or another tag, is there a way to get the name of directories? I have a folder with directory names I need to use in a drop-down list. For example, in this directory: d:\wwwroot\trials\science the name I would need to isolate would be science. Thanks. Robert O. HWW ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185294 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: get directory name
Yeah, see my example.. Basically: cfdirectory directory=#GetDirectoryFromPath(GetTemplatePath())# name=myDirectory cfif myDirectory.type eq Dir Directory cfelse File /cfif On Wed, 24 Nov 2004 08:17:38 -0800, Ian Skinner [EMAIL PROTECTED] wrote: Thanks Ben and Greg. I'm using the CFDirectory example on Macromedia's site. It lists the directory name and size of files found. One step further: How can I filter out any files (if #size# = 0 which means it is a directory name and not a file) and then insert the directory names in a table? Robert O. Instead of using size, I would use the type field which equals file for files and dir for directories. cfdirectory directory=#GetDirectoryFromPath(GetTemplatePath())# name=myDirectory cfloop query=myDirectory cfif type EQ dir !--- Do something, I'm a directory --- /cfif /cfloop -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185315 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: Creating zip files on the fly without CreateObject
I use cfexecute and gzip on one of my apps dump the little exe out there and call it.. On Wed, 24 Nov 2004 12:53:16 -0500, Lewis Sellers [EMAIL PROTECTED] wrote: how to create zip files on the fly with CF and without use CreateObject statement? CFX_Zip could be an option but your price is proibitive... what you suggest? Or, seeing as Dan is after giving me a kick and reminding me that there are alternatives, you might want to take a look at CFX_JZip: http://www.cftagstore.com/tags/cfxjzip.cfm K. I have a vauge recollection that one of the java cfx examples included with CFMX might have been a showing how to use java's built in funtion to zip a file. Well. Looked. It only browse them. But you could extension the functionality to zip as well. -- --Lewis Sellers (AKA min) Intrafoundation Software http://www.intrafoundation.com ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185333 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: Queries in CFC, cfoutput has issues
Use the cfinvoke function... or if you're just passing like one variable use cfset ie.. cfset myquery = application.queries.getName(form.emplid) / On Wed, 24 Nov 2004 13:20:40 -0400, Robert Everland III [EMAIL PROTECTED] wrote: I have a CFC that I have put all of my stored procedures into. I then input the CFC into the application scope for use throughout my application. The issue I have is that I can reference the query in a cfdump like this cfdump var=#application.queries.testquery()# and it will dump the query. I can do isquery(application.queries.testquery()) and it returns yes, but when I do cfoutput query=application.queries.testquery() or cfoutput query=#application.queries.testquery()# it throws an error. I can set the method to a local variable and then I'm able to reference the query, but it would be nice to use the method without having to move it to a local variable. Has anyone ran into this issue? Bob ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185338 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: Queries in CFC, cfoutput has issues
but those create local variables so you may not want that.. heh On Wed, 24 Nov 2004 12:25:51 -0600, Greg Morphis [EMAIL PROTECTED] wrote: Use the cfinvoke function... or if you're just passing like one variable use cfset ie.. cfset myquery = application.queries.getName(form.emplid) / On Wed, 24 Nov 2004 13:20:40 -0400, Robert Everland III [EMAIL PROTECTED] wrote: I have a CFC that I have put all of my stored procedures into. I then input the CFC into the application scope for use throughout my application. The issue I have is that I can reference the query in a cfdump like this cfdump var=#application.queries.testquery()# and it will dump the query. I can do isquery(application.queries.testquery()) and it returns yes, but when I do cfoutput query=application.queries.testquery() or cfoutput query=#application.queries.testquery()# it throws an error. I can set the method to a local variable and then I'm able to reference the query, but it would be nice to use the method without having to move it to a local variable. Has anyone ran into this issue? Bob ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185339 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 directory name - one more thing
I use cfoutput query=NameOfDirCall
I suppose you could use cfloop query= too.
On Wed, 24 Nov 2004 13:27:49 -0500, Robert Orlini [EMAIL PROTECTED] wrote:
works fine Ian thank you.
One more thing please: How can I add each directory name into a table using a
cfquery?
I have this:
CFQUERY name=get datasource=marketing
INSERT INTO directories (name)
VALUES ('#mydirectory.name#')
/CFQUERY
But it adds just the first entry. I guess your gonna say use a cfloop, if so
what type?
Robert O.
-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 24, 2004 11:18 AM
To: CF-Talk
Subject: RE: get directory name
Thanks Ben and Greg.
I'm using the CFDirectory example on Macromedia's site. It lists the
directory name and size of files found.
One step further: How can I filter out any files (if #size# = 0 which means
it is a directory name and not a file) and then insert the directory names in
a table?
Robert O.
Instead of using size, I would use the type field which equals file for
files and dir for directories.
cfdirectory
directory=#GetDirectoryFromPath(GetTemplatePath())#
name=myDirectory
cfloop query=myDirectory
cfif type EQ dir
!--- Do something, I'm a directory ---
/cfif
/cfloop
--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
C code. C code run. Run code run. Please!
- Cynthia Dunning
Confidentiality Notice: This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message.
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185343
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: get directory name - one more thing
loop over the directory and use a insert query statement.
cfloop query=dirlist
cfquery ...
insert into table values(#dirlist.name#)
/cfquery
/cfloop
On Wed, 24 Nov 2004 13:41:30 -0500, Robert Orlini [EMAIL PROTECTED] wrote:
Sorry I may have not specified this correctly. I need to put each dir name
into a table
-Original Message-
From: Greg Morphis [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 24, 2004 1:38 PM
To: CF-Talk
Subject: Re: get directory name - one more thing
I use cfoutput query=NameOfDirCall
I suppose you could use cfloop query= too.
On Wed, 24 Nov 2004 13:27:49 -0500, Robert Orlini [EMAIL PROTECTED] wrote:
works fine Ian thank you.
One more thing please: How can I add each directory name into a table using
a cfquery?
I have this:
CFQUERY name=get datasource=marketing
INSERT INTO directories (name)
VALUES ('#mydirectory.name#')
/CFQUERY
But it adds just the first entry. I guess your gonna say use a cfloop, if
so what type?
Robert O.
-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 24, 2004 11:18 AM
To: CF-Talk
Subject: RE: get directory name
Thanks Ben and Greg.
I'm using the CFDirectory example on Macromedia's site. It lists the
directory name and size of files found.
One step further: How can I filter out any files (if #size# = 0 which means
it is a directory name and not a file) and then insert the directory names
in a table?
Robert O.
Instead of using size, I would use the type field which equals file
for files and dir for directories.
cfdirectory
directory=#GetDirectoryFromPath(GetTemplatePath())#
name=myDirectory
cfloop query=myDirectory
cfif type EQ dir
!--- Do something, I'm a directory ---
/cfif
/cfloop
--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
C code. C code run. Run code run. Please!
- Cynthia Dunning
Confidentiality Notice: This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message.
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185347
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: Write large amount of data to text..
Yeah, the DBA and I talked about this some time ago. Writing the file this way is working for now. If this happens again I may have to find out how to do this or hit him up for some help. Thank for all your suggestions. On Tue, 23 Nov 2004 08:46:25 -, Gavin Brook [EMAIL PROTECTED] wrote: Just a suggestion, but could you not just use Oracle to write the text file out? As you already format the text with SQL, this would bypass going to ColdFusion altogether and streamline the process. Gavin -Original Message- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: 22 November 2004 17:56 To: CF-Talk Subject: Write large amount of data to text.. I have a application that writes loads of data to a text file. I use SQL to format the text as I pull the data from the DB. But my problem is that this is loading 11,000+ rows into a text file. I believe this is timing out. I was wondering if there is a better way of putting this into a file than cfsavecontent variable=ecount_file cfloop query=fetchReferrals cfoutput#record_data#/cfoutput /cfloop /cfsavecontent cffile action=WRITE file=#g_EcountFileDirectory#\#eCountFilename# output=#ecount_header##ecount_file##ecount_footer# addnewline=Yes The query takes only around 20 seconds to process but the page is still loading after 15 minutes. So I'm guessing it's timed out already. If I put endrow=5000 in the cfloop tag it completes in a few minutes. Any ideas? -- Auxilium meum a Domino ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185178 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: Session Issue
Could you say (in psuedocode) If cookie.value exists set session.value... Basically when they hit the page check for the cookie values.. If those values exist set the values of the session variables On Mon, 22 Nov 2004 11:16:07 -0500, Phillip Perry [EMAIL PROTECTED] wrote: Hi, I'm using both session vars. and cookies to help with login. Session is used only for people who dont want to stay logged in permanently and the cookie is used only if they want to stay permanently logged in. The problem I'm having is that when the session times out the user has to log in again whether or not they have the cookie. How do I make sure the user can get the content they want if they have the cookie regardless of the session timeing out. Below is my code. Any help is appreciated. Phil !--- my code --- cfif IsDefined(cookie.LoggedIn) EQ Yes cflocation url=#cgi.script_name# ADDTOKEN=No cfabort /cfif cfparam name=form.UserLogin type=string cfparam name=form.Password type=string cfparam name=form.remember_me type=string default=Off cfquery name=GetUser Datasource=#mydbname# SELECT * FROM users WHERE username = '#Form.UserLogin#' AND password = '#Form.password#' /cfquery cfif GetUser.RecordCount EQ 1 cfset session.Auth = StructNew() cfset Session.Auth.IsLoggedIn = Yes cfset Session.Auth.ContactID = GetUser.user_id cfset Session.Auth.UserName = GetUser.username cfif #form.remember_me# IS On CFCOOKIE NAME=LoggedIn VALUE=Yes EXPIRES=NEVER /cfif cflocation url=#cgi.script_name# ADDTOKEN=No cfelse cfset message=We apologize but that username / password does not match our records. Please try again. cflocation url=#cgi.script_name#?message=#message# ADDTOKEN=No /cfif ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185028 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
Write large amount of data to text..
I have a application that writes loads of data to a text file. I use SQL to format the text as I pull the data from the DB. But my problem is that this is loading 11,000+ rows into a text file. I believe this is timing out. I was wondering if there is a better way of putting this into a file than cfsavecontent variable=ecount_file cfloop query=fetchReferrals cfoutput#record_data#/cfoutput /cfloop /cfsavecontent cffile action=WRITE file=#g_EcountFileDirectory#\#eCountFilename# output=#ecount_header##ecount_file##ecount_footer# addnewline=Yes The query takes only around 20 seconds to process but the page is still loading after 15 minutes. So I'm guessing it's timed out already. If I put endrow=5000 in the cfloop tag it completes in a few minutes. Any ideas? -- Auxilium meum a Domino ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185043 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: Write large amount of data to text..
BTW this specific server is CF5.0 with Oracle. On Mon, 22 Nov 2004 11:55:53 -0600, Greg Morphis [EMAIL PROTECTED] wrote: I have a application that writes loads of data to a text file. I use SQL to format the text as I pull the data from the DB. But my problem is that this is loading 11,000+ rows into a text file. I believe this is timing out. I was wondering if there is a better way of putting this into a file than cfsavecontent variable=ecount_file cfloop query=fetchReferrals cfoutput#record_data#/cfoutput /cfloop /cfsavecontent cffile action=WRITE file=#g_EcountFileDirectory#\#eCountFilename# output=#ecount_header##ecount_file##ecount_footer# addnewline=Yes The query takes only around 20 seconds to process but the page is still loading after 15 minutes. So I'm guessing it's timed out already. If I put endrow=5000 in the cfloop tag it completes in a few minutes. Any ideas? -- Auxilium meum a Domino -- Auxilium meum a Domino ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185044 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: Write large amount of data to text..
Thanks guys! I went with cffile action=WRITE file=#g_EcountFileDirectory#\#eCountFilename# output=#ecount_header# addnewline=Yes cfloop query=fetchReferrals cffile action=APPEND file=#g_EcountFileDirectory#\#eCountFilename# output=#record_data# addnewline=Yes /cfloop cffile action=APPEND file=#g_EcountFileDirectory#\#eCountFilename# output=#ecount_footer# addnewline=Yes Still takes a few minutes but it didnt crap out on me this time. Thanks! On Mon, 22 Nov 2004 10:03:29 -0800, Ian Skinner [EMAIL PROTECTED] wrote: This won't help with your timeout issue, but you can see how far you are getting. cfloop query=fetchReferrals cfif fetchReferrals.currentRow EQ 1 cffile action=WRITE file=#g_EcountFileDirectory#\#eCountFilename# output=#ecount_header##ecount_file##ecount_footer# addnewline=Yes cfelse cffile action=APPEND file=#g_EcountFileDirectory#\#eCountFilename# output=#ecount_header##ecount_file##ecount_footer# addnewline=Yes /cfif This would at least write out each row. Give you an idea of how much you need to increase your timeout in the administrator to allow this process to run. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185053 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
line breaks in files..
In my application I've ran into a problem.. cffile action=WRITE file=#g_EcountFileDirectory#\#eCountFilename# output=#ecount_header# addnewline=Yes cfloop query=fetchReferrals cffile action=APPEND file=#g_EcountFileDirectory#\#eCountFilename# output=#record_data# addnewline=Yes /cfloop cffile action=APPEND file=#g_EcountFileDirectory#\#eCountFilename# output=#ecount_footer# addnewline=Yes this is putting an extra line break.. IE.. 05 rec1 07 rec2 09 rec3 I'm needing 05 rec1 07 rec2 09 rec3 I've tried changing the addnewline to 'no' and even tried changing my SQL but this isnt working for me.. -- Auxilium meum a Domino ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185060 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: line breaks in files..
I tried #chr(10)# and #chr(10)##chr(13)# ahvent tried just the chr(13) yet.. will do though, thanks. On Tue, 23 Nov 2004 09:07:19 +1300, Matthew Walker [EMAIL PROTECTED] wrote: Assuming there are no line breaks in your data, could it be that CF is adding a CR + LF pair and these are both appearing individually as line breaks? How about turning off addnewline, and simply adding your own: output=#ecount_header##chr(13)# etc. -- Matthew Walker www.ESWsoftware.com -Original Message- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Tuesday, 23 November 2004 9:01 a.m. To: CF-Talk Subject: line breaks in files.. In my application I've ran into a problem.. cffile action=WRITE file=#g_EcountFileDirectory#\#eCountFilename# output=#ecount_header# addnewline=Yes cfloop query=fetchReferrals cffile action=APPEND file=#g_EcountFileDirectory#\#eCountFilename# output=#record_data# addnewline=Yes /cfloop cffile action=APPEND file=#g_EcountFileDirectory#\#eCountFilename# output=#ecount_footer# addnewline=Yes this is putting an extra line break.. IE.. 05 rec1 07 rec2 09 rec3 I'm needing 05 rec1 07 rec2 09 rec3 I've tried changing the addnewline to 'no' and even tried changing my SQL but this isnt working for me.. -- Auxilium meum a Domino ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185062 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: line breaks in files..
they're suppose to be in the output file.. not in IE.. when using the chr() notation I see the acsii character for where an enter should be, the box but it doesnt create the line break... just shows the character On Mon, 22 Nov 2004 14:12:48 -0800, Ian Skinner [EMAIL PROTECTED] wrote: Are these line breaks in the output file, or are they just when the output file is read into IE? -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185080 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: Write large amount of data to text..
Man this is messed up... the Dev server can create this file load 11,000+ rows (it's a 10 MB text file) in close to 10 seconds. The Prod server takes 30 seconds for the query and 660 for loading the text file.. if it loads it.. Is this possibly due to the load from people/users on the Prod server? On Mon, 22 Nov 2004 12:24:52 -0600, Greg Morphis [EMAIL PROTECTED] wrote: Thanks guys! I went with cffile action=WRITE file=#g_EcountFileDirectory#\#eCountFilename# output=#ecount_header# addnewline=Yes cfloop query=fetchReferrals cffile action=APPEND file=#g_EcountFileDirectory#\#eCountFilename# output=#record_data# addnewline=Yes /cfloop cffile action=APPEND file=#g_EcountFileDirectory#\#eCountFilename# output=#ecount_footer# addnewline=Yes Still takes a few minutes but it didnt crap out on me this time. Thanks! On Mon, 22 Nov 2004 10:03:29 -0800, Ian Skinner [EMAIL PROTECTED] wrote: This won't help with your timeout issue, but you can see how far you are getting. cfloop query=fetchReferrals cfif fetchReferrals.currentRow EQ 1 cffile action=WRITE file=#g_EcountFileDirectory#\#eCountFilename# output=#ecount_header##ecount_file##ecount_footer# addnewline=Yes cfelse cffile action=APPEND file=#g_EcountFileDirectory#\#eCountFilename# output=#ecount_header##ecount_file##ecount_footer# addnewline=Yes /cfif This would at least write out each row. Give you an idea of how much you need to increase your timeout in the administrator to allow this process to run. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185082 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: Write large amount of data to text..
I can understand if it took 600+ seconds.. but it's not even loading.. The cffile works but the output is messed up. It's reversed.. very weird.. On Mon, 22 Nov 2004 16:58:09 -0600, Russell Patterson [EMAIL PROTECTED] wrote: Hello Greg, Don't forget that IIS and most web servers can throttle the output. I worked in an environment where we would have users loading small text files to extremely large ( 300 MB) and it takes time for the web server to upload it. A 10 MB file would take about 600 to 700 seconds for it to load; and this was all on an private internal network with an ATM backbone. On a side note, it was probably one of the largest intranets that I have ever worked on. At last check, it was hosting close to 3.4 million reports that took up about 4.5 Terabytes of storage space. We used an IBM Shark for the SAN. All this thanks to HIPAA and internal company requirements. %^) Russell - Original Message - From: Greg Morphis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, November 22, 2004 4:31 PM Subject: Re: Write large amount of data to text.. Man this is messed up... the Dev server can create this file load 11,000+ rows (it's a 10 MB text file) in close to 10 seconds. The Prod server takes 30 seconds for the query and 660 for loading the text file.. if it loads it.. Is this possibly due to the load from people/users on the Prod server? On Mon, 22 Nov 2004 12:24:52 -0600, Greg Morphis [EMAIL PROTECTED] wrote: Thanks guys! I went with cffile action=WRITE file=#g_EcountFileDirectory#\#eCountFilename# output=#ecount_header# addnewline=Yes cfloop query=fetchReferrals cffile action=APPEND file=#g_EcountFileDirectory#\#eCountFilename# output=#record_data# addnewline=Yes /cfloop cffile action=APPEND file=#g_EcountFileDirectory#\#eCountFilename# output=#ecount_footer# addnewline=Yes Still takes a few minutes but it didnt crap out on me this time. Thanks! On Mon, 22 Nov 2004 10:03:29 -0800, Ian Skinner [EMAIL PROTECTED] wrote: This won't help with your timeout issue, but you can see how far you are getting. cfloop query=fetchReferrals cfif fetchReferrals.currentRow EQ 1 cffile action=WRITE file=#g_EcountFileDirectory#\#eCountFilename# output=#ecount_header##ecount_file##ecount_footer# addnewline=Yes cfelse cffile action=APPEND file=#g_EcountFileDirectory#\#eCountFilename# output=#ecount_header##ecount_file##ecount_footer# addnewline=Yes /cfif This would at least write out each row. Give you an idea of how much you need to increase your timeout in the administrator to allow this process to run. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185085 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: line breaks in files..
I'm not sure if they do or not but I finally got it by using this... I was formatting it using my SQL so at the end of the row I'd add a line break.. || chr(10), anyways I removed that and changed the addnewline argument back to yes. It outputs correctly.. only took me the entire day to fix this.. heh cffile action=WRITE file=#g_EcountFileDirectory#\#eCountFilename# output=#ecount_file_header# addnewline=Yes cffile action=APPEND file=#g_EcountFileDirectory#\#eCountFilename# output=#ecount_batch_header# addnewline=Yes cfloop query=fetchReferrals cffile action=APPEND file=#g_EcountFileDirectory#\#eCountFilename# output=#record_data# addnewline=Yes /cfloop cffile action=APPEND file=#g_EcountFileDirectory#\#eCountFilename# output=#ecount_batch_footer# addnewline=Yes cffile action=APPEND file=#g_EcountFileDirectory#\#eCountFilename# output=#ecount_file_footer# addnewline=Yes On Mon, 22 Nov 2004 15:09:37 -0800, Ian Skinner [EMAIL PROTECTED] wrote: Can you provide an example of a couple of lines of the output? You might try not providing any line breaks in your output to the append line. I have a vague memory that each append call creates it's own line break. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185090 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: line breaks in files..
no I didnt mean IE as in Internet Explorer, I said IE. as in i.e.: latin meaning that is.. It's finally fixed... the order by got me.. The code I had worked in dev but didnt in prod.. the order by was messed up. Same data, same CF code, but in dev the code was outputting correctly, in prod it wasnt. I threw in another variable to order by and that fixed the output from the query. To solve the problem with the server crapping out on me I used the cffile append function. cffile action=WRITE file=#g_EcountFileDirectory#\#eCountFilename# output=#ecount_file_header# addnewline=Yes cffile action=APPEND file=#g_EcountFileDirectory#\#eCountFilename# output=#ecount_batch_header# addnewline=Yes cfloop query=fetchReferrals cffile action=APPEND file=#g_EcountFileDirectory#\#eCountFilename# output=#record_data# addnewline=Yes /cfloop cffile action=APPEND file=#g_EcountFileDirectory#\#eCountFilename# output=#ecount_batch_footer# addnewline=Yes cffile action=APPEND file=#g_EcountFileDirectory#\#eCountFilename# output=#ecount_file_footer# addnewline=Yes In doing so I had to modify my SQL to remove the line break in. Anyways it seems to work just fine.. just took all day On Mon, 22 Nov 2004 18:33:25 -0400, Larry White [EMAIL PROTECTED] wrote: I'm a little confused. Your first post said IE then showed output with extra linefeeds. Did you mean IE as in for example, or IE as in Internet explorer output? You shouldn't see linebreaks in HTML output unless you enclose them in PRE tags, or use some other method. You should see them in notepad or your text editor. Can you provide an example of a couple of lines of the output? You might try not providing any line breaks in your output to the append line. I have a vague memory that each append call creates it's own line break. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185091 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
Oracle SQL date compare question...
I have a piece of a query thats throwing me off.. I've solved the problem but I dont understand the solution. In the SQL I'm comparing dates. I use some pretty fancy SQL to get the startdate of a week and enddate of a week and startdate of a quarter and enddate of a quarter to display a calender in monthly or quarterly view separated by days, weeks, and months. There are tasks that occupy this calendar. So in the SQL I have WHERE t.startdate (+) = p.periodend AND t.finishdate (+) = p.periodstart startdate and finishdate are in a date format with times.. IE. startdate in this one instance = 11/30/2004 8:30:00 AM finishdate in this one instance = 11/30/2004 11:00:00 AM periodend and periodstart are in date format but only have the date part. IE. in the above instance periodend = '11/30/2004' and periodstart = '11/30/2004' so why doesnt WHERE t.startdate (+) = p.periodend AND t.finishdate (+) = p.periodstart pick up that task? But WHERE t.startdate (+) = p.periodend + 1 AND t.finishdate (+) = p.periodstart does and without the joins WHERE trunc(t.startdate) = p.periodend AND trunc(t.finishdate) = p.periodstart works. Can someone explain?.. Thanks! -- Auxilium meum a Domino ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184734 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: Oracle SQL date compare question...
aha... yeah it defaults to midnight, I did some research.. I already had a fix, as noted in my previous message but thanks for the explaniation On Thu, 18 Nov 2004 09:21:45 -0600, Deanna Schneider [EMAIL PROTECTED] wrote: Because there's no such thing in Oracle as a date without a time. It defaults to midnight, I believe, on a standard install. So, while you may not have put a time in - it is in there. You have two options - format the startdate and finishdate to truncate their time portions - so that you're just limiting on date OR add time portions to your periodend (23:59:59) and periodstart (00:00:01). -d in the above instance periodend = '11/30/2004' and periodstart = '11/30/2004' so why doesnt WHERE t.startdate (+) = p.periodend AND t.finishdate (+) = p.periodstart pick up that task? But WHERE t.startdate (+) = p.periodend + 1 AND t.finishdate (+) = p.periodstart does and without the joins WHERE trunc(t.startdate) = p.periodend AND trunc(t.finishdate) = p.periodstart works. Can someone explain?.. Thanks! ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184747 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: Oracle SQL date compare question...
That is just it, I didnt know why I was doing it that way at the time.. I just knew it worked ;) Anyways, Thanks! On Thu, 18 Nov 2004 13:18:16 -0600, Deanna Schneider [EMAIL PROTECTED] wrote: You may want to document why you're doing it that way so that someone following you would know your intent. she who speaks from experience... -d - Original Message - From: Greg Morphis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 18, 2004 9:54 AM Subject: Re: Oracle SQL date compare question... aha... yeah it defaults to midnight, I did some research.. I already had a fix, as noted in my previous message but thanks for the explaniation ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184803 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: loop over form objects - using JavaScript - Client Validation
I dont think you are understanding what I'm trying to do..
I already check for server validation on the processing page.
What I'm trying to prevent is from the user to hit submit without
checking a box using client validation... javascript. If they hit
submit I want to display a message that they havent selected
anything... before it goes to the processing page.
On Tue, 16 Nov 2004 15:57:14 -0500, Ewok [EMAIL PROTECTED] wrote:
Well since checkboxes don't really exist in the scope unless they were
checked... I usually build cfparams for the fields with the same query and
loop I built the form fields with. Then use the query loop again to check
the value of the fields
Basic example
~--- to build the fields (which you already have ) ---
cfloop from=1 to=10 index=i
input type=checkbox value=#i# name=fld_#i#br
/cfloop
!--- then on the action page use the exat same loop that you built the
fields with to make params for the fields (im sure urs is a query loop)
So you don't get an error when you try to referecnce a field that wasn't
checked ---
cfloop from=1 to=10 index=i
cfparam name=form.fld_#i# default=
/cfloop
!--- then loop once more to check the values of the fields ---
cfloop from=1 to=10 index=i
FORM.FLD_#i# = #form['fld_' i]#br
/cfloop
You would just use currentrow or a recordID in your query loop rather than
an index.
-Original Message-
From: Greg Morphis [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 16, 2004 2:34 PM
To: CF-Talk
Subject: loop over form objects
I have a page with X number of check boxes on it.
I have a query which generates these check boxes.
The query also returns the min and max value of the ID for those check
boxes.
Basically creating
r_23
r_24
r_25
r_26
... and so forth.
I'm trying to loop over these fields to check to see if none are checked.
for(i=cfoutput#sweeps.minval#/cfoutput;i
cfoutput#sweeps.maxval#/cfoutput; i++)
{
}
In the above scenerio the for loop would translate to
for(i=23;i=26;i++)
How do I check to see if r_i is checked..
--
Auxilium meum a Domino
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184564
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: loop over form objects - using JavaScript - Client Validation
my elements are named differently.
the first checkbox for example is r_20, next is r_21, r_22, r_23, etc.
Will this work with that in mind?
On Wed, 17 Nov 2004 14:32:35 +0100, Micha Schopman
[EMAIL PROTECTED] wrote:
This line should be different.. made a typo
if(document.forms['formname'].elements['elementname'][i]){
Must be
if(document.forms['formname'].elements['elementname'][i].checked){
You are checking for the bool checked..
Micha Schopman
Software Engineer
Modern Media, Databankweg 12 M, 3821 AL Amersfoort
Tel 033-4535377, Fax 033-4535388
KvK Amersfoort 39081679, Rabo 39.48.05.380
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184567
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: loop over form objects - using JavaScript - Client Validation
I adapted your function to work...
for(i=cfoutput#sweeps.minval#/cfoutput;i =
cfoutput#sweeps.maxval#/cfoutput; i++)
{
if(document.forms['sweeps'].elements['r_'+i].checked)
{
return true;
}
}
alert('you haven\'t selected anything.. ');
return false;
Thanks, I appreciate it.
On Wed, 17 Nov 2004 07:36:30 -0600, Greg Morphis [EMAIL PROTECTED] wrote:
my elements are named differently.
the first checkbox for example is r_20, next is r_21, r_22, r_23, etc.
Will this work with that in mind?
On Wed, 17 Nov 2004 14:32:35 +0100, Micha Schopman
[EMAIL PROTECTED] wrote:
This line should be different.. made a typo
if(document.forms['formname'].elements['elementname'][i]){
Must be
if(document.forms['formname'].elements['elementname'][i].checked){
You are checking for the bool checked..
Micha Schopman
Software Engineer
Modern Media, Databankweg 12 M, 3821 AL Amersfoort
Tel 033-4535377, Fax 033-4535388
KvK Amersfoort 39081679, Rabo 39.48.05.380
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184569
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
