We have a table, with the highly original name of "nexts", that has a column
for each and every id field that is used in a database and just a single
row. The data in each columns id the next available integer to use for that
field. We then use a suitably designed custom tag (locking, etc) that you
Use the UUID as a surrogate key. Have some other column that has a unique
number in it.
-Original Message-
From: Eric Hoffman [mailto:[EMAIL PROTECTED]
Sent: November 10, 2003 9:32 PM
To: CF-Talk
Subject: RE: Primary key preference quick poll
But in my instances, a phone rep needs to pu
> Use the UUID as a surrogate key. Have some other column that has a unique
> number in it.
for access thats a sound strategy rather than using the MAX() function or
relying on a UUID for JOINs.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Hi,
We have seen a problem with our new CFMX 6.1 installation (for J2EE) on a
Solaris machine.
The LSIsDate function does not seem to working fine, and it seems like
that is causing the scheduler part of the CF Administrator to fail (we are
unable to add new tasks in the administrator).
It all w
Tony Weeg said:
> yeah, but how often do i manually put an order number in somewhere?
In many places order number etc. has to be a simple sequential number
because of accounting regulations.
> and mikey brought up a good idea on aim with me earlier. the real
> problem with a pk field is that if
JSStringFormat() doesn't fix this problem. It only works for escaping strings for _javascript_, NOT HTML. What you need is HTMLEditFormat(). Or you can just replace <,>," with <,>," using ReplaceList (or write a UDF to do it). HTMLEditFormat will cause trouble with CF5/UTF-8.
In some cases you w
Cohen, Michael said:
> Thanks guys! I was figuring close to a million records potentially.
> I gather from Jochem's question that a million is not "prohibitively
> large?" :) Even to be querying on all the time?
It depends on the query patterns, but on properly sized hardware it
shouldn't be. Pre
not if you "KNEW" what it was supposed to be and it was written somewhere in
a totally separate table...
the uuid could be recreated at that point.
...tony
tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
-Original Message-
From: J
>In many places order number etc. has to be a simple sequential number
>because of accounting regulations.
I do not think you are correct in your comment about order numbers having to
be sequential.
>Why not?
You can not manually set a value in a int field that is an autoincrementing
ident
>and mikey brought up a good idea on aim with me earlier. the real
>problem with a pk field is that if something about that
>table/record/database gets corrupted, you will never be able to
recreate
>that number in the pk field. where a uuid, you could, in theory
>recreate it.
Well you could re
Michael T. Tangorre said:
>> In many places order number etc. has to be a simple sequential
>> number because of accounting regulations.
>
> I do not think you are correct in your comment about order numbers
> having to be sequential.
I only know for sure about certain Dutch regulations regarding
Thanks Jochem, I wasn't aware you could change an identity field.
You can use "set identity_insert tablename on" to manually set an
identity field.
Kevin
_
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 11, 2003 9:00 AM
To: CF-Talk
Subject: RE: Primary ke
Kwang,
On 11/11/2003 at 02:37, you wrote:
KS> Unless you're using an older version of Access, there is
KS> absolutely no reason to be using max to get the last ID.
What is the new method of getting the last ID in Access and in what
version does support for this method start?
~ Ubqtous ~
[Toda
Hi All,
I have a problem that might be easy to solve... might...
I have a function within a component-file.
testcomp.cfc
I also have a cfm file, which invokes the component:
testinvoke.cfm
So far, so good...
but now, when an Error occurs in the function Foo.
>
> So far, so good...
>
> but now, when an Error occurs in the function Foo...
> ColdFusion displays an error message which shows the lines of
> the function Foo (error occurred in line 6, testcomp.cfc).
> But that's not what I want... I want it to show that the
> error occured in testinvoke
That's too bad... and if I use something else then CFTHROW?
I don't want to write all the error-handling myself, because I want the CFC
to work on it's own... I want my collegues to use the CFC aswell, and they
must get the errors they are used to when they use it wrongly...
Beside that, is the
>
> That's too bad... and if I use something else then CFTHROW?
>
> I don't want to write all the error-handling myself, because
> I want the CFC to work on it's own... I want my collegues to
> use the CFC aswell, and they must get the errors they are
> used to when they use it wrongly...
I
> is there anyway to set the shown error message to the caller of the
> function
> instead of the function itself? (and no, I don't want to write my own
> error
> handling...)
>
Sure, just catch the exception and rethrow it in the caller.
Matt Liotta
President & CEO
Montara Software, Inc.
http:/
sorry, I'm not too clear obviously ;-)
to be honest, my collegues aren't too much of coldfusion guru's (even less
then me haha)... I don't want them to see the "error on line x in cfc" line,
to prevent them from messing with the cfc... I only want them to see the
"called by line y in cfm" line..
> sorry, I'm not too clear obviously ;-)
>
> to be honest, my collegues aren't too much of coldfusion
> guru's (even less then me haha)... I don't want them to see
> the "error on line x in cfc" line, to prevent them from
> messing with the cfc... I only want them to see the "called
> by line
okay thanks, think I just have to teach my fellow developers here how it
works...
-Oorspronkelijk bericht-
Van: Raymond Camden [mailto:[EMAIL PROTECTED]
Verzonden: dinsdag 11 november 2003 16:42
Aan: CF-Talk
Onderwerp: RE: error handling in functions / components
> sorry, I'm not too clea
cf-talk,
I was recently told that Novell Web Access email clients won't
recognize HTML emails sent by Cold Fusion (v5, at least) unless the
following CFMAILPARAMs are added:
Are their any other email clients that require this--or similar--code?
Is this approach required in CFMX 6.1 as well?
~
I need to be able to create MS Access databases on the fly and insert
records into them. CF knowledge base has an article on getting data from an
external Access database by setting up a dummy passthrough database and then
referencing the external MDB via an IN clause, as in:
SELECT FirstName
OK,
now this is driving me up the wall.
Can anyone spare 10 secs to look over this source code (I've stripped away
all the unimportant stuff)
The default top bar overwrites everything in the div1_txt.
Any ideas ?
-Darren
#request.topBarHeight#>
#request.bottomBarTop#>
STYLE="position
Make sure you put z-index on all the layers. Higher numbers make the
layer sit on top of layers with a lower z-index.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 11, 2003 12:19 PM
To: CF-Talk
Subject: RE: OT:Transparent Div question.
OK,
n
Simple question (relatively). Is there a way to determine if a specific
scheduled task is running? I'm using CFMX 6.1 on Win2K.
Thanks
Pete
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Why not set an Application variable when it starts and un-set it when it
stops?
The problem with this is if it crashes, then it'll think it's running,
but it isn't
-Original Message-
From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 11, 2003 12:47 PM
To: CF-Talk
Not exactly sure what you're looking for but you can set the task up to
write it's output to a file. For example c:\filename.log
Then all you have to do is watch the file date and time of
c:\filename.log to know if the task ran or not.
-Novak
-Original Message-
From: Pete Ruckelshau
Hello All,
I'm running Coldfusion MX 6.1 on a Redhat Enterprise system and have had the
same issue pop up 2 times now. It seems to only happen after a reboot and
once the system comes back up, I get the "datasource service is not
available" error on any page that calls a datasource. I found what I
For many tasks I just send myself an e-mail once the execution is over. If I don't get a message then I know that it crashed. I also put diagnostic information in that e-mail (like how many records got processed etc.) This is good for tasks that run once a day or less. For tasks that run often I ha
Go to Task Manager...
If you see MSTask.exe running, then a schedule task is running.
If your Schedule Task calls another program, then that program will be
running also.
For instance, to mirror/copy our servers, we use a file sync program. If I
look under Task Manager and see MSTask running
Craig,
how are you databases generally set up? JDBC etc?
-Mark
-Original Message-
From: Craig Zingerline [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 11, 2003 12:04 PM
To: CF-Talk
Subject: The Datasource service is not available error
Hello All,
I'm running Coldfusio
I can't say for sure about any other email clients, but my experience has been that CFMX 6.1 doesn't require the cfmailparam tags.
Robert
>cf-talk,
>
>I was recently told that Novell Web Access email clients won't
>recognize HTML emails sent by Cold Fusion (v5, at least) unless the
>following CFMA
Hey there,
Does anyone know of a good method for backing up a directory of ms
access databases that are used as datasources for CF websites?
I run into the problem where the 'file is in use' and therefore cannot
be moved.
This is on CFMX.
-Gel
[Todays Threads]
[This Message]
[Sub
Be careful relying on CFMAIL to send an email at the end of a completed task.
If your Mail Server is down, you won't know it.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
> Does anyone know of a good method for backing up a directory
> of ms access databases that are used as datasources for CF
> websites?
>
> I run into the problem where the 'file is in use' and therefore
> cannot be moved.
You should be able to use any backup software which handles open files
If you turn off 'Maintain DB Connections' in the CF Admin Panel, you won't
have the lock file problem, or you can run a bogus query on the database
right before you copy the database... should unlock it.
That would apply to moving the file... just running a backup on it shouldn't
be a problem.
Hi all,
I did a CFFILE List of the directory which has my verity collections at my host. In addition to my collections, I noticed 4 other entries. Here is an example of one of the names:
calendarInfusion_C76ABA34-2B3D-1DEE-002F58AB986DCD4E
Unlike mine, they are located in the default collection d
> I did a CFFILE List of the directory which has my verity
> collections at my host. In addition to my collections, I
> noticed 4 other entries. Here is an example of one of the names:
>
> calendarInfusion_C76ABA34-2B3D-1DEE-002F58AB986DCD4E
>
> Unlike mine, they are located in the default coll
Hello all,
I'm trying to view pdf files inside a frame... all I'm getting is a blank
frame in netscape and page can not be displayed in mozilla. Here is what I
have:
src="">
E_200101V.PDF" align="top">
also tried this but no luck..
src="">
V.PDF" align="top">
Both work if I just c
Tim,
On 11/11/2003 at 15:27, you wrote:
TD> I'm trying to view pdf files inside a frame... all I'm getting is
TD> a blank frame in netscape and page can not be displayed in
TD> mozilla. Here is what I have:
I thought IFRAME was an IE-only tag
~ Ubqtous ~
[Todays Threads]
[This Message
Thanks Dave,
I actually did a CFCOLLECTION List, and not a CFFILE. So I assume I could also delete them, which leads me to another question. Can one map CFCOLLECTION "List" to a particular directory based on login info?
This seems like shoddy hosting to me, what do you think?
JM
[Todays Threads]
e-mail message at the end of a task are just a "1st line of defence", if I don't get a message I know I need to investigate, check whatever the process run anyway, and if yes, why there was no e-mail sent to me.
TK
- Original Message -
From: Tim Robins
To: CF-Talk
Sent: Tuesday,
No it's not IE-Only.
Adam Wayne Lehman
Web Systems Developer
Johns Hopkins Bloomberg School of Public Health
Distance Education Division
-Original Message-
From: Ubqtous [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 11, 2003 3:44 PM
To: CF-Talk
Subject: Re: viewing pdf's in mozil
I encountered an issue using ColdFusion 4.0 where the & character was causing problems in cfhttpparam. Basically, the & needs to be encoded or it breaks the field. I am more familiar with ColdFusion 5, which encodes all the form fields before submission. I do not believe the HTML standard imposes a
I want to store a file in an oracle datafield. I don't know how to do
this. The reference book says it will handle any binary data up to
4gig. But I can't find any info on how to insert/retrieve/or edit.
Thanks,
Ray
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[Use
Ummm... wouldn't you know it when you didn't get an email? :-)
-Novak
-Original Message-
From: Tim Robins [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 11, 2003 11:03 AM
To: CF-Talk
Subject: Re:How to determine if a scheduled task is already running?
Be careful relying on CFMAIL t
>I want to store a file in an oracle datafield. I don't know how to do
>this. The reference book says it will handle any binary data up to
>4gig. But I can't find any info on how to insert/retrieve/or edit.
Well, you mention CLOB in your subject line, but then refer to binary data,
which would
Hi all,
Been searching and trying for quite some time and need a pointer or
two...
I've created an XML object from a query (using CFSAVECONTENT) and it
CFDUMPs just fine. Now I simply need to output that as XML to the
browser (or calling application). I keep getting:
The XML page cannot be dis
Hi all,
Been searching and trying for quite some time and need a pointer or
two...
I've created an XML object from a query (using CFSAVECONTENT) and it
CFDUMPs just fine. Now I simply need to output that as XML to the
browser (or calling application). I keep getting:
The XML page cannot be dis
[sorry for the dupe post - the original got chopped off at the line of
dashes]
Hi all,
Been searching and trying for quite some time and need a pointer or
two...
I've created an XML object from a query (using CFSAVECONTENT) and it
CFDUMPs just fine. Now I simply need to output that as XML to th
Shouldn't you be outputting "myXmlObj"?
Jeff Beer wrote:
> [sorry for the dupe post - the original got chopped off at the line of
> dashes]
>
> Hi all,
>
> Been searching and trying for quite some time and need a pointer or
> two...
>
> I've created an XML object from a query (using CFSAVECONTENT
Make sure there are no characters after the cfcontent other than the
generated xml. This means no spaces or line breaks between cfcontent and
cfoutput.
Looks like you may have a space, but it might be the cftalk html formatting.
-Original Message-
From: Jeff Beer [mailto:[EMAIL PROTECTE
I tried that as well - I've been playing with this for about three
hours.. Getting the cfdump to work was easy. Outputting it is becoming
a nightmare :)
> -Original Message-
> From: Marlon Moyer [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 11, 2003 5:12 PM
> To: CF-Talk
> Subject:
> I've created an XML object from a query (using CFSAVECONTENT)
> and it CFDUMPs just fine. Now I simply need to output that
> as XML to the browser (or calling application). I keep getting:
>
> The XML page cannot be displayed
> Cannot view XML input using style sheet. Please correct the erro
Looking at this again,
This works and outputs the xmldoc as a string
-
bar
#xmlDoc#
This breaks while trying to output the xml object
---
bar
#xmlObj#
My earlier comment on spaces/line breaks wasn't right. I was thinking about
outputting binary files such a
Adam,
On 11/11/2003 at 16:13, you wrote:
AWL> No it's not IE-Only.
Good to know... I haven't tried it since N4.x
~ Ubqtous ~
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
I am using the following to get the tablename, column, datatype and length from my SQL Server DB. I only want tables. I am having a brain fart to criteria only tables. Here is my SQL
SELECT
sysobjects.Name as Tablename,
Syscolumns.Name as Fieldname,
Systypes.Name as FieldDataType,
Syscolumns.
I think its tostring(xml) or something like that.
DRE
-Original Message-
From: Jeff Beer [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 11, 2003 3:09 PM
To: CF-Talk
Subject: Outputting an XML Object to browser
[sorry for the dupe post - the original got chopped off at the line of
dash
From Access 2000 on, you can use @@IDENTITY
-Original Message-
From: Ubqtous [mailto:[EMAIL PROTECTED]
Sent: November 11, 2003 7:49 AM
To: CF-Talk
Subject: Re: Primary key preference quick poll
Kwang,
On 11/11/2003 at 02:37, you wrote:
KS> Unless you're using an older version of Access
use information_schema - it's a LOT easier
select table_name
from information_schema.tables
Simple, isn't it?
-Original Message-
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 11, 2003 5:13 PM
To: CF-Talk
Subject: QUERY TABLE DATA INFORMATION
I am using the fo
sp_tables
Returns tables with a qualifier for "user" and "system"... use q of a q to get at the "user" tables.
-Mark
-Original Message-
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 11, 2003 4:13 PM
To: CF-Talk
Subject: QUERY TABLE DATA INFORMATION
I am
Wish this could be done with MS Access :-(
-Gel
-Original Message-
From: Philip Arnold [mailto:[EMAIL PROTECTED]
use information_schema - it's a LOT easier
select table_name
from information_schema.tables
Simple, isn't it?
[Todays Threads]
[This Message]
[Subscription]
[Fa
Ray (Jedi is he) Camden has just posted a link to CFMX 6.1 Known Issues
here:
http://www.macromedia.com/support/coldfusion/ts/documents/cfmx61_issues.htm
Some of the issues have already been hotfixed (the CFFORM issue for
example) see:
http://www.macromedia.com/support/coldfusion/ts/documents/tn
Does the Flash Remoting component that comes with CFMX work for .NET as well? Or do I have to purchase Flash Remoting separately for .NET?
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
This could be a useful "feature addition" to CF to have some sort of
reporting mechanism for this sort of thing. SMS messages for example when a
site dies or serious error occurs.
Peter Tilbrook
Transitional Services - Enterprise eSolutions
Centrelink (http://www.centrelink.gov.au)
2 Faulding Stre
Have to purchase Flash Remoting for .NET.
The Java Flash Remoting is also different from that in CFMX.
Sam
---
Blog: http://www.rewindlife.com
Charts: http://www.blinex.com/products/charting
---
> -Origi
> Does the Flash Remoting component that comes with CFMX work
> for .NET as well?
No.
> Or do I have to purchase Flash Remoting separately for .NET?
Yes.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
[Todays Threads]
[This Message]
[
You have to buy the .Net version.
Clint Tredway
www.digital12studios.com
>Does the Flash Remoting component that comes with CFMX work for .NET as well? Or do I have to purchase Flash Remoting separately for .NET?
>
>
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[Use
Hi,
Does anyone know of any good XML books for a beginner. Looking for something
easy to understand,with good examples to learn from.
Thanks
Mario
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
I really liked this O'Reilly book...
Learning XML by Erik T. Ray
http://www.oreilly.com/catalog/learnxml/index.html
Sam
---
Blog: http://www.rewindlife.com
Charts: http://www.blinex.com/products/charting
--
Thanks guys. Are there any issues with having multiple installations of
flash remoting on the same server?
-Original Message-
From: Samuel R. Neff [mailto:[EMAIL PROTECTED]
Sent: November 11, 2003 8:18 PM
To: CF-Talk
Subject: RE: Flash Remoting question
Have to purchase Flash Remoting f
> Learning XML by Erik T. Ray
> http://www.oreilly.com/catalog/learnxml/index.html
I second that, it's an excellent entry level book that doesn't pretend to
explain every details but provide an overview of all the most important XML
related topic.
The second edition came out a few weeks ago, you
73 matches
Mail list logo