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
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
-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
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
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')
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,
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
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
-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
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
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
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
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
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
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
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
. 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
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
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
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
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
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
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
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
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
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
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
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.
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
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
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
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
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
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
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
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
:
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
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]
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.
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
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
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
^[\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
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
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)
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
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
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
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
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
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
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.
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]
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
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,
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
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?
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
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
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.,
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:
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
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
.
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
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
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
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
, 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
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
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
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
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
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
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
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
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
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
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
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
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
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:
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
:
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
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
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
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
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
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
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
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
?
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
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
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..
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
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
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
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
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
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
;
}
}
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
501 - 600 of 701 matches
Mail list logo
