RE: MS SQL 2000 Table Structure Print out

[Robertson-Ravo, Neil (RX)]

This is incorrect use of DESCRIBE.  If you want a table struct you should
use a select query which cross references the sysobjects table.

This should give you what you need.

select syscolumns.name,systypes.name,syscolumns.length from sysobjects
inner join syscolumns on syscolumns.id = sysobjects.id
inner join systypes on systypes.type = syscolumns.type
where sysobjects.type  = 'U'
and sysobjects.name ='yourtablename'








-Original Message-
From: Nick Baker [mailto:[EMAIL PROTECTED] 
Sent: 31 January 2005 06:49
To: CF-Talk
Subject: MS SQL 2000 Table Structure Print out

MS SQL 2000

I want to show a table structure, and tried the following


DESCRIBE  Pumpparts



This only throws an error "Could not find stored procedure 'DESCRIBE'."

What am I missing? Or, am I using the wrong thing here?

DESCRIBE table_name

This command provides information about the columns of the table. It shows 
the column names, the type / size and scale (if applicable) and other 
useful information.

Thanks,

Nick




~|
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:192304
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: MS SQL 2000 Table Structure Print out

[Adam Haskell]

DESCRIBE is an SQL Plus command, if i recall. You could easily enough
make a stored procedure to do it in MS SQL I suppose though...heck
someone may have already done it.  You could just use Neil's SQL
statement he posted and put it into a cursor and output it all nifty
dandy like SQL Plus does, but personally I rather just read it table
format like it is output in query analyzer ;) Oh I also like to use
DBDesigner 4 its nice to use to print off the table info.


Adam H


On Mon, 31 Jan 2005 00:49:00 -0600, Nick Baker <[EMAIL PROTECTED]> wrote:
> MS SQL 2000
> 
> I want to show a table structure, and tried the following
> 
> 
>DESCRIBE  Pumpparts
> 
> 
> This only throws an error "Could not find stored procedure 'DESCRIBE'."
> 
> What am I missing? Or, am I using the wrong thing here?
> 
> DESCRIBE table_name
> 
> This command provides information about the columns of the table. It shows
> the column names, the type / size and scale (if applicable) and other
> useful information.
> 
> Thanks,
> 
> Nick
> 
> 

~|
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:192305
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: eclipse css plugin

[Adam Haskell]

So I asssume the JSeditor works the same way...you have to work in a
.js file for it to kick in?


Adam H 


On Mon, 31 Jan 2005 00:06:41 -0500, Michael T. Tangorre
<[EMAIL PROTECTED]> wrote:
> > From: Nathan Strutz [mailto:[EMAIL PROTECTED]
> > To expand on what Rob said, the CSS Editor plugin doesn't
> > have any views
> > or perspecitves associated with it. However, it does make use of the
> > Outline view, which CFEclipse uses as well to make an outline of your
> > code. The editor kicks in right away when you open a .CSS
> > file, assuming
> > your file associations are hooked up right.
> 
> That's what threw me off... no views or perspectives. Once I opened up a CSS
> file and started defining some styles it worked like a charm.
> Thanks guys.
> 
> Mike
> 
> 

~|
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:192306
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: Creating a MS SQL 2000 Table

[Scott Stroz]

Paul,

You are correct, I guess I should have added a disclaimer that while
it is possible to usse keywords, it is not good practice to do so.


On Sun, 30 Jan 2005 11:35:10 +0700, Paul Hastings
<[EMAIL PROTECTED]> wrote:
> Scott Stroz wrote:
> > You can still use keywords, you just need to put [ ] around them.
> 
> that, i would imagine, is something most sql server developers would
> frown upon.
> 
> 

~|
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:192307
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: Puzzled by cfsavecontent

[Scott Stroz]

OR, you could specify the content in a persistent variable scope (such
as session) and then output th econtent on the printer-friendly
version.
 

On Sat, 29 Jan 2005 19:36:41 -0800, Bob Haroche
<[EMAIL PROTECTED]> wrote:
> > This is exactly what the CFSaveContent tag does.  It saves whatever
> > content is generated inside of it into a variable - you can then
> > display it later by CFOutputting the variable.
> 
> Okay, got it. I wanted to use the tag to save some selected content to use
> again on a "printer friendly" version of the page.  So I guess on the
> original, non-printer friendly page (where I still want the content to
> appear) I'll have to first  my desired text and then
> immediately output the saved variable on the page itself, as well as on the
> intended, print friendly page.
> 
> Thanks.
> 
> -
> Regards,
> Bob Haroche
> O n P o i n t  S o l u t i o n s
> www.OnPointSolutions.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:192308
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: Image popup UDF

[Joe Rinehart]

Yep...if you go under "behaiviors" in the design panel, you'll see a
"Open Browser Window" behaivior (or something like that) where you set
the url, size, options, etc...

-joe


On Sun, 30 Jan 2005 20:17:38 -0400, Will Tomlinson <[EMAIL PROTECTED]> wrote:
> >Will, do you have Dreamweaver MX?
> >
>  Yes Joe, that's pretty much all I use. I hope you're not gonna tell me it 
> already does something like this??
> 
> LoL
> 
> Will
> 
> 

~|
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:192309
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: Image popup UDF

[Massimo Foti]

> Yep...if you go under "behaiviors" in the design panel, you'll see a
> "Open Browser Window" behaivior (or something like that) where you set
> the url, size, options, etc...

And, in case you need more, you can get this:

http://www.massimocorner.com/dw/behaviors/win_suite.mxp


Massimo Foti
DW tools: http://www.massimocorner.com
CF tools:  http://www.olimpo.ch/tmt/




~|
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:192310
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: redirect opinions

[Bert Dawson]

Have you considered using cfinclude rather than cflocation?
eg: 














If all requests come through the index.cfm (as in eg fusebox) then
this works a treat. Otherwise its going to need a bit more thought,
but i'd say its still going to be preferable to doing a cflocation.

Cheers
Bert



On Sat, 29 Jan 2005 12:58:54 -0500, Les Mizzell <[EMAIL PROTECTED]> wrote:
> I've got a client that's decided to host a bunch of different sites
> under one domain. Though the hosting company is suggesting that I use a
> PHP script to handle the domain redirects, I'm a PHP noob, so I'd rather
> go with something I know.
> 
> So, in the root directory I figure I can just add this to the
> Application.cfm file to take care of it:
> 
> 
> 
> 
> 
> Is there a better solution? I've also warned the client that this is
> going to make it darned hard to get the different domains spidered
> correctly by the search engines, but what the heck
> 
> Haven't tried it yet, but maybe include an index file with links
> containing a paragraph or two with proper descriptions and keywords for
> each site it's linking to. Regular users visiting the site wouldn't see
> this because they'd get redirected by the application file. I'm not 100%
> sure if the spiders would see it either but it's worth a try.
> 
> --
> ---
> Les Mizzell
> 
> 

~|
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:192311
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: better way to code?

[kola.oyedeji]

Johnny 

Just to clarify, are you referring to lots of if statements in code in
general or lots of if statements in a fusebox switch file? If you were
referring to the latter then I would agree and say that in fusebox - you
should not have the majority of your logic within the switch file..is that
what you meant?

Kola

-Original Message-
From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] 
Sent: 29 January 2005 03:42
To: CF-Talk
Subject: RE: better way to code?

> From: Johnny Le [mailto:[EMAIL PROTECTED] 
> I shouldn't have given that specific example.  My reason for 
> bringing this whole issue up is that people say beginners' 
> code has a lot of CFIF statements.  I am using Fusebox now.  
> So it elimates a lot of CFIF statement already, but I still 
> feel that I have too many CFIF in my code.  I am just looking 
> for alternative, better, and more efficient methods to handle 
> all of those conditional statements.

Who says beginners code has a lot of cfif statements? Why are they bad if
they are needed. I have worked on a lot of applications where a good number
of if statements were needed all over the place... why is this bad? How does
fusebox eliminate the need for conditional logic? Are you using FB4?
FB4.1?...  =  Sometimes a case/switch
structure is a better choice over cfif/cfelseif/cfelse/cfif; usually when
there would be more than one (1) cfelseif, otherwise they perform the same.

Mike





~|
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:192313
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: WAP Devices

[Douglas Knudsen]

check out google 
http://www.google.com/search?q=wap+simulators&sourceid=mozilla-search&start=0&start=0&ie=utf-8&oe=utf-8&client=firefox-a&rls=org.mozilla:en-US:official
look at developer.openwave.com for an emu.  Some mobile
manufactures/carriers have developer programs too.
http://www.wapemulator.com/index.php  is a web based emulator.

hope this helps.

Oh, how's the Alltel phone? Any issues there I can pass along, I work for them.

Doug


On Sun, 30 Jan 2005 23:05:35 -0600, Tony Hicks <[EMAIL PROTECTED]> wrote:
> I'm trying to do some wap programming, and frankly, all i've got is my
> cell phone, which is fine for using WAPs, but its uncomfortable for
> testing and debugging (small screen, few colors) and I was wondering
> if anyone knew of any wap devices with a qwerty keyboard and a sizable
> screen.
> 
> I live in the sticks and only get coverage from ALLTEL.. Cingular
> gets... some coverage so its a last resort but I'd prefer an alltel
> solution.
> 
> 

~|
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:192312
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: better way to code?

[Calvin Ward]

In light of this discussion, how about lots of cfif statements buried in
html...?

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 31, 2005 8:46 AM
To: CF-Talk
Subject: RE: better way to code?

Johnny 

Just to clarify, are you referring to lots of if statements in code in
general or lots of if statements in a fusebox switch file? If you were
referring to the latter then I would agree and say that in fusebox - you
should not have the majority of your logic within the switch file..is that
what you meant?

Kola

-Original Message-
From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] 
Sent: 29 January 2005 03:42
To: CF-Talk
Subject: RE: better way to code?

> From: Johnny Le [mailto:[EMAIL PROTECTED] 
> I shouldn't have given that specific example.  My reason for 
> bringing this whole issue up is that people say beginners' 
> code has a lot of CFIF statements.  I am using Fusebox now.  
> So it elimates a lot of CFIF statement already, but I still 
> feel that I have too many CFIF in my code.  I am just looking 
> for alternative, better, and more efficient methods to handle 
> all of those conditional statements.

Who says beginners code has a lot of cfif statements? Why are they bad if
they are needed. I have worked on a lot of applications where a good number
of if statements were needed all over the place... why is this bad? How does
fusebox eliminate the need for conditional logic? Are you using FB4?
FB4.1?...  =  Sometimes a case/switch
structure is a better choice over cfif/cfelseif/cfelse/cfif; usually when
there would be more than one (1) cfelseif, otherwise they perform the same.

Mike







~|
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:192314
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: MS SQL 2000 Table Structure Print out

[Jared Rypka-Hauer - CMG, LLC]

I've written a small app that parses the SQL Server metadata stored
procedures. It will display all the relevant data for any SQL Server
table, view, or sproc, including indexes, columns and datatypes, and
sproc CREATE text.

It also generates lists of columns names in several formats,
CFARGUMENT tags, and CFSTOREDPROC/CFPROCPARAM tags for the relevant DB
object type.

I can set you up with a demo if you'd like...

Let me know,
J


On Mon, 31 Jan 2005 06:58:34 -0500, Adam Haskell <[EMAIL PROTECTED]> wrote:
> DESCRIBE is an SQL Plus command, if i recall. You could easily enough
> make a stored procedure to do it in MS SQL I suppose though...heck
> someone may have already done it.  You could just use Neil's SQL
> statement he posted and put it into a cursor and output it all nifty
> dandy like SQL Plus does, but personally I rather just read it table
> format like it is output in query analyzer ;) Oh I also like to use
> DBDesigner 4 its nice to use to print off the table info.
> 
> Adam H
> 
> 
> On Mon, 31 Jan 2005 00:49:00 -0600, Nick Baker <[EMAIL PROTECTED]> wrote:
> > MS SQL 2000
> >
> > I want to show a table structure, and tried the following
> >
> > 
> >DESCRIBE  Pumpparts
> > 
> >
> > This only throws an error "Could not find stored procedure 'DESCRIBE'."
> >
> > What am I missing? Or, am I using the wrong thing here?
> >
> > DESCRIBE table_name
> >
> > This command provides information about the columns of the table. It shows
> > the column names, the type / size and scale (if applicable) and other
> > useful information.
> >
> > Thanks,
> >
> > Nick
> >
> >
> 
> 

~|
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:192315
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: Using ant 1.6.2 with CFMX

[RADEMAKERS Tanguy]

Look into a sourceforge project called "OneJar" - let's you bundle an
entire application with all required libraries into a single jar using
classloaders. Lets you get around classpath problems, but at the cost of
a significantly larger installation!

/t

>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
>Sent: Sunday, January 30, 2005 5:04 PM
>To: CF-Talk
>Subject: Using ant 1.6.2 with CFMX
>
>  I wonder why the ant classes (Version 1.5) have to be integrated in 
>jrun.jar?
>
>Because of this, we are not able to use ANT version 1.6.2 with CFMX. 
>Adding the ANT 1.6.2 jar to the classpath doesn't help, because of the 
>jrun.jar being loaded before the ant.jar. So we had and have 
>problems if 
>we build applications using ant taskdefs.
> 
>Do you know a workaround for this problem?
>This problem is not only related to ant, what happens if we use 
>different versions of itext, sax ... in custom applications?
> 
>Thanks,
>Florian
>
>

~|
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:192316
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: MS SQL 2000 Table Structure Print out

[Jared Rypka-Hauer - CMG, LLC]

Correction, a demo of the application can be viewed here:
http://w2ksrv1.neo.servequake.com/dbanalyzer/index.cfm

This is using the SQL Server Northwind sample application.

The userID/Password are admin/admin.

Have a good one.

J


On Mon, 31 Jan 2005 08:11:03 -0600, Jared Rypka-Hauer - CMG, LLC
<[EMAIL PROTECTED]> wrote:
> I've written a small app that parses the SQL Server metadata stored
> procedures. It will display all the relevant data for any SQL Server
> table, view, or sproc, including indexes, columns and datatypes, and
> sproc CREATE text.
> 
> It also generates lists of columns names in several formats,
> CFARGUMENT tags, and CFSTOREDPROC/CFPROCPARAM tags for the relevant DB
> object type.
> 
> I can set you up with a demo if you'd like...
> 
> Let me know,
> J
> 
> 


-- 
Continuum Media Group LLC
Burnsville, MN 55337
http://www.web-relevant.com
http://cfobjective.blogspot.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:192317
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: better way to code?

[kola.oyedeji]

Calvin

Depends, In most cases you can do any conditional logic before rendering
your page but obviously there are exceptions such as when the result of the
condition determines what html is being displayed (and not something else
such as if the user should be redirected or a session variable should be
updated etc.) Some frameworks allow you to determine the portions of a page
being rendered before the page is assembled allowing you to decide what
portions are shown before they are rendered. 


Just my 2pence

Kola

> -Original Message-
> From: Calvin Ward [mailto:[EMAIL PROTECTED]
> Sent: 31 January 2005 13:50
> To: CF-Talk
> Subject: RE: better way to code?
> 
> In light of this discussion, how about lots of cfif statements buried in
> html...?
> 
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Monday, January 31, 2005 8:46 AM
> To: CF-Talk
> Subject: RE: better way to code?
> 
> Johnny
> 
> Just to clarify, are you referring to lots of if statements in code in
> general or lots of if statements in a fusebox switch file? If you were
> referring to the latter then I would agree and say that in fusebox - you
> should not have the majority of your logic within the switch file..is that
> what you meant?
> 
> Kola
> 
> -Original Message-
> From: Michael T. Tangorre [mailto:[EMAIL PROTECTED]
> Sent: 29 January 2005 03:42
> To: CF-Talk
> Subject: RE: better way to code?
> 
> > From: Johnny Le [mailto:[EMAIL PROTECTED]
> > I shouldn't have given that specific example.  My reason for
> > bringing this whole issue up is that people say beginners'
> > code has a lot of CFIF statements.  I am using Fusebox now.
> > So it elimates a lot of CFIF statement already, but I still
> > feel that I have too many CFIF in my code.  I am just looking
> > for alternative, better, and more efficient methods to handle
> > all of those conditional statements.
> 
> Who says beginners code has a lot of cfif statements? Why are they bad if
> they are needed. I have worked on a lot of applications where a good
> number
> of if statements were needed all over the place... why is this bad? How
> does
> fusebox eliminate the need for conditional logic? Are you using FB4?
> FB4.1?...  =  Sometimes a
> case/switch
> structure is a better choice over cfif/cfelseif/cfelse/cfif; usually when
> there would be more than one (1) cfelseif, otherwise they perform the
> same.
> 
> Mike
> 
> 
> 
> 
> 
> 
> 
> 

~|
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:192318
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

CFWebstore

[Cutter (CF related)]

Anyone out there with experience with CFWebstore that wouldn't mind 
helping me through an issue (off list)?

Cutter


-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.8.2 - Release Date: 1/28/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:192319
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: CFWebstore

[Alex Sherwood]

Cutter (CF related) wrote:

>Anyone out there with experience with CFWebstore that wouldn't mind 
>helping me through an issue (off list)?
>
>Cutter
>
>
>  
>

Kick ass product.

As I understand it, their support is pretty good, too.

-- 
Alex Sherwood
Director, Internet Services
PHS Collection Agency
Phone: 813-283-4579
Web: www.phs-net.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:192320
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

[SOT] Credit card processing companies

[powell]

I'm hoping that the collective brainpower out there can come to the rescue!  
We've been running into problems with our current processor (Suntrust) with 
terminal-based processing.  We have a terminal on a dedicated analog line that 
works fine, and pulled our spare out of the close to test it out prior to 
taking our bookstore on the road (where we would need both machines in 
operation).  

Life has been He** since then.  The actual processing seems to be done by First 
Data. Their tech support guys have repeatedly downloaded the wrong code into 
both machines, changed our account settings (for a while we couldn't process 
Discover cards, and for a while neither machine worked).  They've sold us a new 
machine because they said that our standby machine was busted, and now they're 
saying that we need new phone lines.   

We've started looking at finding another company to replace SunTrust, but it 
seems like everyone we talk to is using FirstData.  We used to use PaymentTech, 
and were very happy with them, but changed to SunTrust at the recommendation of 
a software vendor that said (prior to my being here) it was necessary to make 
such a change so that their on-line processing software would work (it never 
did). We checked back with PaymentTech this morning, and found out they are now 
using FirstData as well.

Any advice out there, either on dealing with FirstData (maybe some good contact 
info) or another card processor?

Like I had nothing else to do with my time that fight another fire!

Thanks everyone,
-reed 

~|
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:192321
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

Trying to run a batch/cmd file to open iexplore on the server

[Flavio Ishii]

I'm trying to open iexplore in the appserver with a template that contains
the following: 

 
 

run_test.cmd has the following line in it: 

start iexplore.exe 

But I can't get it to open iexplore on the server. I also tried using a
batch file but nothing. Although, both the command and batch files I created
execute successfully when double clicking them on the actual server. 

I also read that programs cannot pop open on the server's desktop unless
they are scheduled. Is this true? If so, would I have to create a schedule
task on the fly to do this? Or is there an easier solution to all this? 


Flavio



~|
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:192322
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

XML/XSLT Line Break

[Mark Leder]

Hi all,
 
I'm using a simple XML doc to populate image captions in a Flash photo
gallery.  One of the  statements in the XML has the need
to display multiple paragraphs.  I don't care about any other formatting
beyond that.  Is there a good/easy way to force line breaks in XML (like a
control character ?) or do I have to build and insert an XSLT doc?
 
Thanks,
Mark




~|
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:192323
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: CFMX and CGLOBAL/CDATA not purging

[Dave Carabetta]

On Sun, 30 Jan 2005 21:43:35 -0400, Terry Ford <[EMAIL PROTECTED]> wrote:
> Hey all,
> 
> In the process of performing a yearly upgrade I was quite surprised to find 
> that my CGLOBAL and CDATA tables contained over 20 million (yes, million) 
> entries each, and the CGLOBAL.MYD file alone had a size of 3.1 gigs.
> 
> Needless to say, I had been operating under the assumption that the tables 
> were purging correctly.  Apparantly I was incorrect.
> 
> Anyway, I've taken a hatchet to the tabbles and whacked them down to size, 
> and have verified that indeed the purge option (30 days) is selected.
> 
> Does anyone have any clue why my tables aren't purging?
> I am running mysql / CFMX6.1 / lotsa mem / dual xeon
> 

Known issue even after the Updater came out:

http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_19590

Regards,
Dave.

~|
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:192325
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Trying to run a batch/cmd file to open iexplore on the server

[Mike Chabot]

As a partial answer, remember that you are executing commands under
the account that the CF Service is logged in as. You may in fact be
launching your program, but nobody can see it because it is opening up
under a different user account. Task Manager should tell you whether
these tasks are running or not.

For your CF Service, it may help to log in using a user account
(instead of the system account), and check the box to "Allow service
to interact with desktop." If you don't check that box, programs
launched by the service will not actually show up in a visible way
that a sys admin can interact with.

You can issue commands to run a program as a different user using
batch files or VB scripts, but you have to deal with the issue of
having a password hard-coded in a text file on you computer.

You might want to check out wget. It is a minimalist Web browser that
is good for executing CF code. I use wget to execute CF code from
inside SQL Server DTS scripts.

Good luck,
Mike Chabot

On Mon, 31 Jan 2005 09:22:11 -0600, Flavio Ishii <[EMAIL PROTECTED]> wrote:
> I'm trying to open iexplore in the appserver with a template that contains
> the following:
> 
> 
> 
> 
> run_test.cmd has the following line in it:
> 
> start iexplore.exe
> 
> But I can't get it to open iexplore on the server. I also tried using a
> batch file but nothing. Although, both the command and batch files I created
> execute successfully when double clicking them on the actual server.
> 
> I also read that programs cannot pop open on the server's desktop unless
> they are scheduled. Is this true? If so, would I have to create a schedule
> task on the fly to do this? Or is there an easier solution to all this?
> 
> Flavio

~|
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:192325
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

CFOBJECTS

[Adam Haskell]

I have only read a little about this but it looks interesting...does
anyone know if this can be used on CF5? We are stuck in CF5 still and
the company wants to move towards RUP, which is strongly tied to OOP,
so there is a need to get OOP kick started now until we can get intoMX
or  Blackstone or whatever comes after that lol.

Adam 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:192326
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: XML/XSLT Line Break

[Alex Sherwood]

Line break as in [br] or linebreak as in CHR10+CHR13?



Mark Leder wrote:

>Hi all,
> 
>I'm using a simple XML doc to populate image captions in a Flash photo
>gallery.  One of the  statements in the XML has the need
>to display multiple paragraphs.  I don't care about any other formatting
>beyond that.  Is there a good/easy way to force line breaks in XML (like a
>control character ?) or do I have to build and insert an XSLT doc?
> 
>Thanks,
>Mark
>
>
>
>
>

~|
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:192327
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: XML/XSLT Line Break

[Mark Leder]

Which ever works, I'm not concerned about HTML display at all here, just
showing a space between a couple lines of text. 

-Original Message-
From: Alex Sherwood [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 31, 2005 10:46 AM
To: CF-Talk
Subject: Re: XML/XSLT Line Break

Line break as in [br] or linebreak as in CHR10+CHR13?



Mark Leder wrote:

>Hi all,
> 
>I'm using a simple XML doc to populate image captions in a Flash photo 
>gallery.  One of the  statements in the XML has the 
>need to display multiple paragraphs.  I don't care about any other 
>formatting beyond that.  Is there a good/easy way to force line breaks 
>in XML (like a control character ?) or do I have to build and insert an
XSLT doc?
> 
>Thanks,
>Mark
>
>
>
>
>



~|
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:192328
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

Too stupid for CF

[Chris Kavanagh]

Dear list,

In my task management system, certain people have access to certain 
projects.

I'd like an admin screen for each project that displays all the people 
with a checkbox beside their name.  The sysad can check or uncheck 
people as necessary.

But I'm a bit confused how best to execute this (using MySQL and CF).

My first thought was that each project would have its own table in the 
backend.  It'd have one column that would contain all the person_ids.

PROJECT IHATECODING
---
01
04
06

So users 01, 04, and 06 would have access to project "ihatecoding".

But of course I can't do this because users can create projects on the 
fly.  So I made a table that combined project_ids and person_ids:

PROJ_ID | PERS_ID
01  | 03
01  | 05
02  | 03

But how the hell do I update this using CF?  Do I CFINSERT or CFUPDATE 
or what?  And how do I tell my app to remove people when they're 
unchecked?  This is killing me.  I feel like I can almost see how this 
is supposed to work but I'm like three IQ points short of getting it.  
:(

Grateful thanks in advance for any help and insights,
CK.


~|
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:192329
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: XML/XSLT Line Break

[Alex Sherwood]

I'm a little confused. Can you post a sample XML document, and mark 
where the line breaks should be?

If I understand, you want to be able to embed line breaks in the caption 
text and then have the line breaks be refelected when the caption text 
is displayed? The front end is Flash, right?


Mark Leder wrote:

>Which ever works, I'm not concerned about HTML display at all here, just
>showing a space between a couple lines of text. 
>
>-Original Message-
>From: Alex Sherwood [mailto:[EMAIL PROTECTED] 
>Sent: Monday, January 31, 2005 10:46 AM
>To: CF-Talk
>Subject: Re: XML/XSLT Line Break
>
>Line break as in [br] or linebreak as in CHR10+CHR13?
>
>
>
>Mark Leder wrote:
>
>  
>
>>Hi all,
>>
>>I'm using a simple XML doc to populate image captions in a Flash photo 
>>gallery.  One of the  statements in the XML has the 
>>need to display multiple paragraphs.  I don't care about any other 
>>formatting beyond that.  Is there a good/easy way to force line breaks 
>>in XML (like a control character ?) or do I have to build and insert an
>>
>>
>XSLT doc?
>  
>
>>Thanks,
>>Mark
>>
>>
>>
>>
>>
>>
>>
>
>
>
>

~|
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:192330
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: MS SQL 2000 Table Structure Print out

[Andy Ousterhout]

Jared,
I can't log in.  Does your app require cookies to be enabled?

Andy

-Original Message-
From: Jared Rypka-Hauer - CMG, LLC [mailto:[EMAIL PROTECTED]
Sent: Monday, January 31, 2005 8:21 AM
To: CF-Talk
Subject: Re: MS SQL 2000 Table Structure Print out


Correction, a demo of the application can be viewed here:
http://w2ksrv1.neo.servequake.com/dbanalyzer/index.cfm

This is using the SQL Server Northwind sample application.

The userID/Password are admin/admin.

Have a good one.

J


On Mon, 31 Jan 2005 08:11:03 -0600, Jared Rypka-Hauer - CMG, LLC
<[EMAIL PROTECTED]> wrote:
> I've written a small app that parses the SQL Server metadata stored
> procedures. It will display all the relevant data for any SQL Server
> table, view, or sproc, including indexes, columns and datatypes, and
> sproc CREATE text.
>
> It also generates lists of columns names in several formats,
> CFARGUMENT tags, and CFSTOREDPROC/CFPROCPARAM tags for the relevant DB
> object type.
>
> I can set you up with a demo if you'd like...
>
> Let me know,
> J
>
>


--
Continuum Media Group LLC
Burnsville, MN 55337
http://www.web-relevant.com
http://cfobjective.blogspot.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:192331
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: Too stupid for CF

[RADEMAKERS Tanguy]

Chris,

1) in the htmp project form, give all the employee checkboxes the same
NAME, but use the employee id as the VALUE. That way, when you submit
the form, you will have one single variable (the NAME) with a list of
employee ids (the VALUES).

2) first delete all the entries for this PROJECT in the link table (use
 and delete where project_id = ...)

3) then loop through the employee ids (use ) and execute one
insert per iteration, (again using  and insert into...) adding
the employee to the project.

/t

>-Original Message-
>From: Chris Kavanagh [mailto:[EMAIL PROTECTED] 
>Sent: Monday, January 31, 2005 4:55 PM
>To: CF-Talk
>Subject: Too stupid for CF
>
>Dear list,
>
>In my task management system, certain people have access to certain 
>projects.
>
>I'd like an admin screen for each project that displays all the people 
>with a checkbox beside their name.  The sysad can check or uncheck 
>people as necessary.
>
>But I'm a bit confused how best to execute this (using MySQL and CF).
>
>My first thought was that each project would have its own table in the 
>backend.  It'd have one column that would contain all the person_ids.
>
>PROJECT IHATECODING
>---
>01
>04
>06
>
>So users 01, 04, and 06 would have access to project "ihatecoding".
>
>But of course I can't do this because users can create projects on the 
>fly.  So I made a table that combined project_ids and person_ids:
>
>PROJ_ID| PERS_ID
>01 | 03
>01 | 05
>02 | 03
>
>But how the hell do I update this using CF?  Do I CFINSERT or CFUPDATE 
>or what?  And how do I tell my app to remove people when they're 
>unchecked?  This is killing me.  I feel like I can almost see how this 
>is supposed to work but I'm like three IQ points short of getting it.  
>:(
>
>Grateful thanks in advance for any help and insights,
>CK.
>
>
>

~|
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:192332
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

grabbing the id of a newly created item..

[Protoculture]

How would I modify an insert query to grab the id ( autonum, primary key ) of 
the item that I just inserted?

~|
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:192333
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: grabbing the id of a newly created item..

[Craig Dudley]

Which DB are you using? 

-Original Message-
From: Protoculture [mailto:[EMAIL PROTECTED] 
Sent: 31 January 2005 15:10
To: CF-Talk
Subject: grabbing the id of a newly created item..

How would I modify an insert query to grab the id ( autonum, primary key
) of the item that I just inserted?



~|
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:192334
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: grabbing the id of a newly created item..

[Protoculture]

ACCESS

~|
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:192335
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: grabbing the id of a newly created item..

[Tony Weeg]

select @@identity from tableName

will return the last inserted id, assuming mssql

tw


On Mon, 31 Jan 2005 16:09:10 -, Craig Dudley <[EMAIL PROTECTED]> wrote:
> Which DB are you using?
> 
> -Original Message-
> From: Protoculture [mailto:[EMAIL PROTECTED]
> Sent: 31 January 2005 15:10
> To: CF-Talk
> Subject: grabbing the id of a newly created item..
> 
> How would I modify an insert query to grab the id ( autonum, primary key
> ) of the item that I just inserted?
> 
> 

~|
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:192336
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: XML/XSLT Line Break

[Mark Leder]

Alex,
Thanks for looking into this with me.
Here's an XML snip, showing two different pic captions.  The second
, I inserted a  to show where I would want a break for a new
paragraph.
To see the actual flash, go to http://www.pearlywhitesmile.com/testimonials/
==





 
http://www.pearlywhitesmile.com/images/photos/testimonials/01.jpg
"I now have a natural looking radiant smile that receives
constant compliments and additionally have no more headaches!"  --
Gina


 
http://www.pearlywhitesmile.com/images/photos/testimonials/02.jpg
Late last year, I was in the process of looking for a new
dentist. As I was contemplating having cosmetic dentistry performed I didn't
feel that my current dentist was qualified to perform the latest cosmetic
techniques. After much research, I decided to make an
appointment with Dr. Barry for a consultation.  -- Patricia

 


==
Thanks,
Mark

-Original Message-
From: Alex Sherwood [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 31, 2005 10:59 AM
To: CF-Talk
Subject: Re: XML/XSLT Line Break

I'm a little confused. Can you post a sample XML document, and mark where
the line breaks should be?

If I understand, you want to be able to embed line breaks in the caption
text and then have the line breaks be refelected when the caption text is
displayed? The front end is Flash, right?




~|
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:192337
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: grabbing the id of a newly created item..

[Jim Campbell]

If you're using SQL Server, you can put the insert in a procedure, wrap 
it in a transaction, and run something like this at the end:

SET @NEWID = SCOPE_IDENTITY()

This will return the most recent primary key created.

- Jim

Protoculture wrote:

>How would I modify an insert query to grab the id ( autonum, primary key ) of 
>the item that I just inserted?
>
>

~|
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:192338
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: grabbing the id of a newly created item..

[Protoculture]

what about using access

~|
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:192339
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: grabbing the id of a newly created item..

[Craig Dudley]

I don't think there's a neat way of doing it for Access, I could be
wrong though.

So, I suggest just doing a select for max(your_autonum_ID) in another
cfquery directly after the insert, probably safer to wrap both the
queries in a cftransaction too.

-Original Message-
From: Protoculture [mailto:[EMAIL PROTECTED] 
Sent: 31 January 2005 15:17
To: CF-Talk
Subject: Re: grabbing the id of a newly created item..

ACCESS



~|
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:192340
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: grabbing the id of a newly created item..

[Protoculture]

Thanks Craig. Just to confirm that code..

Select For Max(ID)

~|
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:192341
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: grabbing the id of a newly created item..

[Craig Dudley]

More like;

 Select Max(ID) as MyNewID FROM yourtablename

-Original Message-
From: Protoculture [mailto:[EMAIL PROTECTED] 
Sent: 31 January 2005 15:34
To: CF-Talk
Subject: Re: grabbing the id of a newly created item..

Thanks Craig. Just to confirm that code..

Select For Max(ID)



~|
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:192342
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: grabbing the id of a newly created item..

[COLLIE David]

> I don't think there's a neat way of doing it for Access, I 
> could be wrong though.

http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=79

Couple of methods ... Could be rewritten in CF if needed

-- 
dc


~|
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:192343
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: MS SQL 2000 Table Structure Print out

[Jared Rypka-Hauer - CMG, LLC]

Hmmm... I'm using cflogin with session storage... it shouldn't.

I'll post the info again...

http://w2ksrv1.neo.servequake.com/dbanalyzer/
userID/pwd is admin/admin

That SHOULD get you in, if it doesn't let me know and I'll try something else...

Laterz,
J

On Mon, 31 Jan 2005 09:58:48 -0600, Andy Ousterhout
<[EMAIL PROTECTED]> wrote:
> Jared,
> I can't log in.  Does your app require cookies to be enabled?
> 
> Andy
> 
> -Original Message-
> From: Jared Rypka-Hauer - CMG, LLC [mailto:[EMAIL PROTECTED]
> Sent: Monday, January 31, 2005 8:21 AM
> To: CF-Talk
> Subject: Re: MS SQL 2000 Table Structure Print out
> 
> Correction, a demo of the application can be viewed here:
> http://w2ksrv1.neo.servequake.com/dbanalyzer/index.cfm
> 
> This is using the SQL Server Northwind sample application.
> 
> The userID/Password are admin/admin.
> 
> Have a good one.
> 
> J
> 
> On Mon, 31 Jan 2005 08:11:03 -0600, Jared Rypka-Hauer - CMG, LLC
> <[EMAIL PROTECTED]> wrote:
> > I've written a small app that parses the SQL Server metadata stored
> > procedures. It will display all the relevant data for any SQL Server
> > table, view, or sproc, including indexes, columns and datatypes, and
> > sproc CREATE text.
> >
> > It also generates lists of columns names in several formats,
> > CFARGUMENT tags, and CFSTOREDPROC/CFPROCPARAM tags for the relevant DB
> > object type.
> >
> > I can set you up with a demo if you'd like...
> >
> > Let me know,
> > J
> >
> >
> 
> --
> Continuum Media Group LLC
> Burnsville, MN 55337
> http://www.web-relevant.com
> http://cfobjective.blogspot.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:192344
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

Debugging twilight zone...

[Jeff Small]

Okay, so I'm running a little cflogin. I run it on localhost, and it works 
fine. In fact, it's calling the right SQL database, and everything's fine.

Now, I move the page over to my development server. Same page, same code, 
same *database*...different results. It doesn't tell me that the data source 
isn't valid, or that my CFC is named wrong, or there's anything else wrong, 
my error page is simply outputting this for #ERROR.diagnostics#:

Diagnostics Message:
null null
The error occurred on line 45.

Okay, so I go to line 45, which is actually in my application.cfm and it's 
one line below my cfloginuser tag. Like so:


  
  

  blah blah blah...


So I start thinking, "did my query not return a record? Did I not pass in 
the right information somehow? So I set up my IP address for Debugging on 
the development server and I look and lo, and behold, the forms are working 
perfectly, they're passing the right info to the query, it's returning only 
one record, and the information's actually correct as I'm expecting it.

So what could be the difference between the two? They're pointing to the 
same datasource, named the same, on the same machine, containing the same 
information, and yet on one machine it works, and on another it doesn't, and 
the error message leaves a lot to the imagination...where would I begin 
looking? 



~|
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:192345
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: MS SQL 2000 Table Structure Print out

[Andy Ousterhout]

Unfortunately, I don't think that CF/MX actually saves a session cookie, but
saves a "permanent" cookie.  Or, perhaps I've got IE set up wrong :-)


-Original Message-
From: Jared Rypka-Hauer

Hmmm... I'm using cflogin with session storage... it shouldn't.

I'll post the info again...

http://w2ksrv1.neo.servequake.com/dbanalyzer/
userID/pwd is admin/admin

That SHOULD get you in, if it doesn't let me know and I'll try something
else...

Laterz,
J




~|
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:192346
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

Restart CFMX with CFML?

[Jon Block]

What's the way in which you can restart CFMX service with CFML code
natively?

Jon


~|
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:192347
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

What's the newest version of Apache supported by CFMX?

[Jon Block]

I've been having trouble with a server where the CFMX process gets hung up
and it logs all kinds of bizarre error messages in the Jrun default log
file. I think its because I was using the newest version of apache 2 which,
I'm assuming, must not be compatible with the newest version of CFMX. Since
I started running apache 1.3.33, everything seems much better.

Jon


~|
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:192348
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: XML/XSLT Line Break

[Alex Sherwood]

I see now.

I have very little experience with Flash as a font end, but it seems to 
me that you would need to have Flash recognize the line break some how. 
I don't know how flash renders text, but if it can render basic HTML, 
then your fine.

Try embedding a CFLF where the  tags are, ala:



These should not be normalized or escaped by your XML parser.

--
Alex

Mark Leder wrote:

>Alex,
>Thanks for looking into this with me.
>Here's an XML snip, showing two different pic captions.  The second
>, I inserted a  to show where I would want a break for a new
>paragraph.
>To see the actual flash, go to http://www.pearlywhitesmile.com/testimonials/
>=
>  
>
-- 
Alex Sherwood
Director, Internet Services
PHS Collection Agency
Phone: 813-283-4579
Web: www.phs-net.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:192349
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: grabbing the id of a newly created item..

[Calvin Ward]

Typically, I would recommend using a UUID for a primary key, have CF
generate it (consider altering the function to do a MS version of a UUID,
since you are using access and will likely go to MSSSQL Server, check
cflib.org for that), and then you can reference it easily without any
question that you are looking at the correct record.

Note, if you need a people friendly ID, then you can still follow the above
solution and use the UUID to get the people friendly ID.

- Calvin

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 31, 2005 11:17 AM
To: CF-Talk
Subject: Re: grabbing the id of a newly created item..

select @@identity from tableName

will return the last inserted id, assuming mssql

tw


On Mon, 31 Jan 2005 16:09:10 -, Craig Dudley <[EMAIL PROTECTED]>
wrote:
> Which DB are you using?
> 
> -Original Message-
> From: Protoculture [mailto:[EMAIL PROTECTED]
> Sent: 31 January 2005 15:10
> To: CF-Talk
> Subject: grabbing the id of a newly created item..
> 
> How would I modify an insert query to grab the id ( autonum, primary key
> ) of the item that I just inserted?
> 
> 



~|
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:192350
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: Restart CFMX with CFML?

[Jordan Michaels]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Jon Block wrote:

|What's the way in which you can restart CFMX service with CFML code
|natively?
|
|Jon
|


Note that you must allow whatever user CFMX/Apache is running as
permissions to execute that command... which opens up a whole new can
of worms

Another way to go about it is to have CFMX write to a shell script and
have that shell script executed by a cron job with the appropriate
permissions.

At any rate, it requires a bit of creative thinking, but should be
possible.

- --
Warm regards,
Jordan Michaels
Vivio Technologies
http://www.viviotech.net/
[EMAIL PROTECTED]
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFB/mX//G4NWP5tBHcRAsHVAKC5A+87BtgB3+KppDkk0OMew9Do1QCeN8Ck
+nYAKY+5hsIM0cscRmfDcHM=
=u6rS
-END PGP SIGNATURE-

~|
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:192351
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: What's the newest version of Apache supported by CFMX?

[Jordan Michaels]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Jon Block wrote:

| I've been having trouble with a server where the CFMX process gets
| hung up and it logs all kinds of bizarre error messages in the Jrun
| default log file. I think its because I was using the newest
| version of apache 2 which, I'm assuming, must not be compatible
| with the newest version of CFMX. Since I started running apache
| 1.3.33, everything seems much better.
|
| Jon
|
Is the version of apache that you were using the latest "stable"
release or one of the betas?

- --
Warm regards,
Jordan Michaels
Vivio Technologies
http://www.viviotech.net/
[EMAIL PROTECTED]
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFB/mY6/G4NWP5tBHcRAoDcAJwONh1SHxhMuW5agzIeeptejDdHYACgu5w5
0kPy5jDXIvh3LW/aT9xrh1E=
=v8NV
-END PGP SIGNATURE-

~|
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:192352
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: grabbing the id of a newly created item..

[kola.oyedeji]

Actually IIRC this is now possible in access (although I haven't tried it
myself)

http://cfmxplus.blogspot.com/2002/08/oh-my-select-identity-works-in-access.h
tml

Kola

> -Original Message-
> From: COLLIE David [mailto:[EMAIL PROTECTED]
> Sent: 31 January 2005 16:37
> To: CF-Talk
> Subject: RE: grabbing the id of a newly created item..
> 
> > I don't think there's a neat way of doing it for Access, I
> > could be wrong though.
> 
> http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=79
> 
> Couple of methods ... Could be rewritten in CF if needed
> 
> --
> dc
> 
> 
> 

~|
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:192353
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: What's the newest version of Apache supported by CFMX?

[Jon Block]

I only download "stable" releases but I downloaded the latest stable release
of apache 2 and I had big time problem swhere the cfmx process would seize,
log errors in the default jrun error log, and I haid to restart the whole
machine to get it to begin to work again. Downgrading to apache 1.3.33 fixed
it.

Jon 

-Original Message-
From: Jordan Michaels [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 31, 2005 12:09 PM
To: CF-Talk
Subject: Re: What's the newest version of Apache supported by CFMX?

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Jon Block wrote:

| I've been having trouble with a server where the CFMX process gets 
| hung up and it logs all kinds of bizarre error messages in the Jrun 
| default log file. I think its because I was using the newest version 
| of apache 2 which, I'm assuming, must not be compatible with the 
| newest version of CFMX. Since I started running apache 1.3.33, 
| everything seems much better.
|
| Jon
|
Is the version of apache that you were using the latest "stable"
release or one of the betas?

- --
Warm regards,
Jordan Michaels
Vivio Technologies
http://www.viviotech.net/
[EMAIL PROTECTED]
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFB/mY6/G4NWP5tBHcRAoDcAJwONh1SHxhMuW5agzIeeptejDdHYACgu5w5
0kPy5jDXIvh3LW/aT9xrh1E=
=v8NV
-END PGP SIGNATURE-



~|
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:192355
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: Using Coldfusion to set scroll to position?

[Charles Heizer]

I thought about this but I don't have a good method of marking rows. I  
have been looking in to javascript but I don't know how to get at js  
vars with coldfusion.

- Charles

On Jan 29, 2005, at 1:35 AM, Martin Parry wrote:

> If you have distinct blocks or rows of a table etc. in the page you
> could use HTML anchors and when you redirect back to the page use
> http://myserver.com/page.cfm#anchor_15
>
> Martin Parry
> Macromedia Certified Developer
> http://www.BeetrootStreet.co.uk
>
> -Original Message-
> From: Charles Heizer [mailto:[EMAIL PROTECTED]
> Sent: 29 January 2005 08:02
> To: CF-Talk
> Subject: Using Coldfusion to set scroll to position?
>
> Hello,
> I was wondering if someone has a good example of setting the scroll
> position of a page using a session variable or a cookie?
>
>
> 

~|
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:192355
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: Too stupid for CF

[G]

You are on the right track having this link table.

I would probably maintain an active flag, a start date, and an end date, in 
my link table. When a person becomes inactive on a project, I'd switch the 
flag and establish the end date. Each reassignment of a person to a project 
would get a new entry in the link table. This helps maintain a history, if 
thats necessary.

You can use the database to ensure that no more than one active link exists 
for each person/project combination.

Removing a link then becomes a simple update of the table (adding an end 
date and switching the active flag), while new additions would simply be 
table inserts.

HTH,

Brian


> Dear list,
>
> In my task management system, certain people have access to certain
> projects.
>
> I'd like an admin screen for each project that displays all the people
> with a checkbox beside their name.  The sysad can check or uncheck
> people as necessary.
>
> But I'm a bit confused how best to execute this (using MySQL and CF).
>
> My first thought was that each project would have its own table in the
> backend.  It'd have one column that would contain all the person_ids.
>
> PROJECT IHATECODING
> ---
> 01
> 04
> 06
>
> So users 01, 04, and 06 would have access to project "ihatecoding".
>
> But of course I can't do this because users can create projects on the
> fly.  So I made a table that combined project_ids and person_ids:
>
> PROJ_ID | PERS_ID
> 01 | 03
> 01 | 05
> 02 | 03
>
> But how the hell do I update this using CF?  Do I CFINSERT or CFUPDATE
> or what?  And how do I tell my app to remove people when they're
> unchecked?  This is killing me.  I feel like I can almost see how this
> is supposed to work but I'm like three IQ points short of getting it.
> :(
>
> Grateful thanks in advance for any help and insights,
> CK.
>
>
> 

~|
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:192356
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: grabbing the id of a newly created item..

[Matthew Small]

That is correct, I used it a few  years ago when Access 2000 came out.

- Matt Small

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 31, 2005 12:03 PM
To: CF-Talk
Subject: RE: grabbing the id of a newly created item..

Actually IIRC this is now possible in access (although I haven't tried it
myself)

http://cfmxplus.blogspot.com/2002/08/oh-my-select-identity-works-in-access.h
tml

Kola

> -Original Message-
> From: COLLIE David [mailto:[EMAIL PROTECTED]
> Sent: 31 January 2005 16:37
> To: CF-Talk
> Subject: RE: grabbing the id of a newly created item..
> 
> > I don't think there's a neat way of doing it for Access, I
> > could be wrong though.
> 
> http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=79
> 
> Couple of methods ... Could be rewritten in CF if needed
> 
> --
> dc
> 
> 
> 



~|
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:192357
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: Using ColdFusion to set scroll to position?

[Ian Skinner]

CS can output JS code just as well as it outputs HTML code.  You just write the 
dynamic JS; this is then sent to the client and acted on.  You are not "getting 
at JS variables;" you are creating dynamic JS code.



 function foobar()
{
var JSvar = #CFvalue#;
}





--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
 
"C code. C code run. Run code run. Please!"
- Cynthia Dunning

...-Original Message-
...From: Charles Heizer [mailto:[EMAIL PROTECTED]
...Sent: Monday, January 31, 2005 9:07 AM
...To: CF-Talk
...Subject: Re: Using Coldfusion to set scroll to position?
...
...I thought about this but I don't have a good method of marking rows. I
...have been looking in to javascript but I don't know how to get at js
...vars with coldfusion.
...
...- Charles
...
...On Jan 29, 2005, at 1:35 AM, Martin Parry wrote:
...
...> If you have distinct blocks or rows of a table etc. in the page you
...> could use HTML anchors and when you redirect back to the page use
...> http://myserver.com/page.cfm#anchor_15
...>
...> Martin Parry
...> Macromedia Certified Developer
...> http://www.BeetrootStreet.co.uk
...>
...> -Original Message-
...> From: Charles Heizer [mailto:[EMAIL PROTECTED]
...> Sent: 29 January 2005 08:02
...> To: CF-Talk
...> Subject: Using Coldfusion to set scroll to position?
...>
...> Hello,
...> I was wondering if someone has a good example of setting the scroll
...> position of a page using a session variable or a cookie?
...>
...>
...>
...
...

~|
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:192358
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: MS SQL 2000 Table Structure Print out

[Dave Watts]

> Unfortunately, I don't think that CF/MX actually saves a 
> session cookie, but saves a "permanent" cookie.

By default, if you're using CF session management, CF will set two
persistent cookies, CFID and CFTOKEN. If you're using J2EE session
management, CF will set a single session cookie, JSESSIONID.

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!


~|
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:192360
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: Trying to run a batch/cmd file to open iexplore on the server

[Dave Watts]

> I'm trying to open iexplore in the appserver with a template 
> that contains the following: 
> 
>   
> 
> run_test.cmd has the following line in it: 
> 
> start iexplore.exe 
> 
> But I can't get it to open iexplore on the server. I also 
> tried using a batch file but nothing. Although, both the 
> command and batch files I created execute successfully when 
> double clicking them on the actual server.

By default, programs run by service processes don't appear on the desktop.
To make them appear, you need to enable the desktop interactivity option for
that service within the Services MMC. However, you might be better served by
describing what you're actually trying to do, as there may well be a better
way.

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!


~|
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:192360
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: MS SQL 2000 Table Structure Print out

[Jared Rypka-Hauer - CMG, LLC]

OK, then...

For purposes of demonstration, I have removed the cflogin restriction
to the application. Since it's just hitting the Northwind datasource,
I'm not terribly concerned.

SO, without further ado, please use this URL:
http://w2ksrv1.neo.servequake.com/dbanalyzer/index.cfm
NO USERNAME, NO PASSWORD... (sheesh... it must be monday! ;) )

To view the demo version of the application.

Yours in patience, hard work, and virtue... (hehe)

J


On Mon, 31 Jan 2005 10:50:16 -0600, Andy Ousterhout
<[EMAIL PROTECTED]> wrote:
> Unfortunately, I don't think that CF/MX actually saves a session cookie, but
> saves a "permanent" cookie.  Or, perhaps I've got IE set up wrong :-)
> 
> 
> -Original Message-
> From: Jared Rypka-Hauer
> 
> Hmmm... I'm using cflogin with session storage... it shouldn't.
> 
> I'll post the info again...
> 
> http://w2ksrv1.neo.servequake.com/dbanalyzer/
> userID/pwd is admin/admin
> 
> That SHOULD get you in, if it doesn't let me know and I'll try something
> else...
> 
> Laterz,
> J
> 
> 
> 

~|
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:192361
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: eclipse css plugin

[Rob]

Yup yup


On Mon, 31 Jan 2005 07:00:56 -0500, Adam Haskell <[EMAIL PROTECTED]> wrote:
> So I asssume the JSeditor works the same way...you have to work in a
> .js file for it to kick in?
> 
> Adam H
> 
> On Mon, 31 Jan 2005 00:06:41 -0500, Michael T. Tangorre
> <[EMAIL PROTECTED]> wrote:
> > > From: Nathan Strutz [mailto:[EMAIL PROTECTED]
> > > To expand on what Rob said, the CSS Editor plugin doesn't
> > > have any views
> > > or perspecitves associated with it. However, it does make use of the
> > > Outline view, which CFEclipse uses as well to make an outline of your
> > > code. The editor kicks in right away when you open a .CSS
> > > file, assuming
> > > your file associations are hooked up right.
> >
> > That's what threw me off... no views or perspectives. Once I opened up a CSS
> > file and started defining some styles it worked like a charm.
> > Thanks guys.
> >
> > Mike
> >
> >
> 
> 

~|
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:192362
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: XML/XSLT Line Break

[Rob]

There are a couple tricks to do this, but I think your best bet would
be to add a cdata section to your xml - I think that will solve your
problem. So:



Will keep the parser from parsing the data and removing the line
breaks - at least it should.

Otherwise you could do it in the xslt by adding

 to get some line breaks in there.

Hope that helps

On Mon, 31 Jan 2005 11:22:54 -0500, Mark Leder <[EMAIL PROTECTED]> wrote:
> Alex,
> Thanks for looking into this with me.
> Here's an XML snip, showing two different pic captions.  The second
> , I inserted a  to show where I would want a break for a new
> paragraph.
> To see the actual flash, go to http://www.pearlywhitesmile.com/testimonials/
> ==
> 
> 
> 
> 
> 
> http://www.pearlywhitesmile.com/images/photos/testimonials/01.jpg age>
> "I now have a natural looking radiant smile that receives
> constant compliments and additionally have no more headaches!"  --
> Gina
> 
> 
> 
> http://www.pearlywhitesmile.com/images/photos/testimonials/02.jpg age>
> Late last year, I was in the process of looking for a new
> dentist. As I was contemplating having cosmetic dentistry performed I didn't
> feel that my current dentist was qualified to perform the latest cosmetic
> techniques. After much research, I decided to make an
> appointment with Dr. Barry for a consultation.  -- Patricia
> 
>  
> 
> ==
> Thanks,
> Mark
> 
> -Original Message-
> From: Alex Sherwood [mailto:[EMAIL PROTECTED] 
> Sent: Monday, January 31, 2005 10:59 AM
> To: CF-Talk
> Subject: Re: XML/XSLT Line Break
> 
> I'm a little confused. Can you post a sample XML document, and mark where
> the line breaks should be?
> 
> If I understand, you want to be able to embed line breaks in the caption
> text and then have the line breaks be refelected when the caption text is
> displayed? The front end is Flash, right?
> 
> 
> 

~|
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:192363
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

pdf to jpg

[Emmet McGovern]

I see plenty of tools to create pdf's with cf but can any tools create a jpg
out of a pdf?

Emmet



~|
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:192364
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

Attribute validation error for tag cfloop

[Chris Kavanagh]

Dear list,

I'm getting this error message:

--
  Attribute validation error for tag cfloop.
  The value of the attribute query, which is currently "insert_people", 
is invalid.
--

I guess there's something wrong with my INSERT statement but I can't 
figure out what it is.  I've tried permutations for the VALUEs with "s, 
's, no quotes, double #s, but it still doesn't seem to work.

Here's my code:

--
Taskomatic

DELETE FROM people_project
WHERE project_id = '#project_id#'



INSERT INTO people_project
VALUES ('#person_id#', '#project_id#')




Access list updated 

#person_id#




~|
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:192365
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: MS SQL 2000 Table Structure Print out

[Andy Ousterhout]

Thanks.  I've got to change my site!

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Monday, January 31, 2005 11:27 AM
To: CF-Talk
Subject: RE: MS SQL 2000 Table Structure Print out


> Unfortunately, I don't think that CF/MX actually saves a
> session cookie, but saves a "permanent" cookie.

By default, if you're using CF session management, CF will set two
persistent cookies, CFID and CFTOKEN. If you're using J2EE session
management, CF will set a single session cookie, JSESSIONID.

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!




~|
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:192366
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: MS SQL 2000 Table Structure Print out

[Andy Ousterhout]

Nice.  Can you email me the code off-line?

Andy

-Original Message-
From: Jared Rypka-Hauer -

OK, then...

For purposes of demonstration, I have removed the cflogin restriction
to the application. Since it's just hitting the Northwind datasource,
I'm not terribly concerned.

SO, without further ado, please use this URL:
http://w2ksrv1.neo.servequake.com/dbanalyzer/index.cfm
NO USERNAME, NO PASSWORD... (sheesh... it must be monday! ;) )

To view the demo version of the application.




~|
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:192367
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

EASY: grabbing the id of a newly created item..

[Richard Colman]

 This is actually pretty easy in ACCESS:

1) put the enire transaction within a CFLOCK block

2) do the insert

3) then select max(id) assuming you have an autonumber field for the id

Which will give you the id of the record just inserted.

This is so easy that even I can do it.

Rick Colman

-Original Message-
From: Protoculture [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 31, 2005 7:10 AM
To: CF-Talk
Subject: grabbing the id of a newly created item..

How would I modify an insert query to grab the id ( autonum, primary key )
of the item that I just inserted?



~|
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:192368
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

Preventing Malicious Sql without cfquery param

[gabriel l smallman]

Hey all, anyone got a simple method to protect a var used in a where clause
where we cannot use cfqueryparam? 

Example: 

OR P.Keywords LIKE '%#Url.SearchString#%'

And search string can be entered by the public

thanks


~|
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:192369
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: Using ColdFusion to set scroll to position?

[Charles Heizer]

Great, I'll try this.

Thanks,
- Charles

On Jan 31, 2005, at 9:16 AM, Ian Skinner wrote:

> CS can output JS code just as well as it outputs HTML code.  You just  
> write the dynamic JS; this is then sent to the client and acted on.   
> You are not "getting at JS variables;" you are creating dynamic JS  
> code.
>
> 
> 
>  function foobar()
> {
>   var JSvar = #CFvalue#;
> }
> 
> 
>
>
>
> --
> Ian Skinner
> Web Programmer
> BloodSource
> www.BloodSource.org
> Sacramento, CA
>
> "C code. C code run. Run code run. Please!"
> - Cynthia Dunning
>
> ...-Original Message-
> ...From: Charles Heizer [mailto:[EMAIL PROTECTED]
> ...Sent: Monday, January 31, 2005 9:07 AM
> ...To: CF-Talk
> ...Subject: Re: Using Coldfusion to set scroll to position?
> ...
> ...I thought about this but I don't have a good method of marking  
> rows. I
> ...have been looking in to javascript but I don't know how to get at js
> ...vars with coldfusion.
> ...
> ...- Charles
> ...
> ...On Jan 29, 2005, at 1:35 AM, Martin Parry wrote:
> ...
> ...> If you have distinct blocks or rows of a table etc. in the page  
> you
> ...> could use HTML anchors and when you redirect back to the page use
> ...> http://myserver.com/page.cfm#anchor_15
> ...>
> ...> Martin Parry
> ...> Macromedia Certified Developer
> ...> http://www.BeetrootStreet.co.uk
> ...>
> ...> -Original Message-
> ...> From: Charles Heizer [mailto:[EMAIL PROTECTED]
> ...> Sent: 29 January 2005 08:02
> ...> To: CF-Talk
> ...> Subject: Using Coldfusion to set scroll to position?
> ...>
> ...> Hello,
> ...> I was wondering if someone has a good example of setting the  
> scroll
> ...> position of a page using a session variable or a cookie?
> ...>
> ...>
> ...>
> ...
> ...
>
> 

~|
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:192370
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: Preventing Malicious Sql without cfquery param

[Jochem van Dieten]

gabriel l smallman wrote:
> Hey all, anyone got a simple method to protect a var used in a where clause
> where we cannot use cfqueryparam? 
> 
> Example: 
> 
> OR P.Keywords LIKE '%#Url.SearchString#%'

Use cfqueryparam:
P.Keywords LIKE 

Jochem

~|
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:192371
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: Attribute validation error for tag cfloop

[Rick Root]

You can't loop over the results of an insert query, because an insert 
query produces no results.

You can only use CFLOOP with select queries.

  - Rick

Chris Kavanagh wrote:
> Dear list,
> 
> I'm getting this error message:
> 
> --
>   Attribute validation error for tag cfloop.
>   The value of the attribute query, which is currently "insert_people", 
> is invalid.
> --
> 
> I guess there's something wrong with my INSERT statement but I can't 
> figure out what it is.  I've tried permutations for the VALUEs with "s, 
> 's, no quotes, double #s, but it still doesn't seem to work.
> 
> Here's my code:
> 
> --
> Taskomatic
> 
>   DELETE FROM people_project
>   WHERE project_id = '#project_id#'
> 
> 
> 
>   INSERT INTO people_project
>   VALUES ('#person_id#', '#project_id#')
> 
> 
> 
> 
> Access list updated 
> 
>   #person_id#
> 
> 
> 
> 
> 

~|
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:192372
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: grabbing the id of a newly created item..

[Bryan Stevenson]

Ummm...don't you mean CFTRANSACTION...and not CFLOCK??

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

~|
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:192373
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

XML Question

[Charles Heizer]

Hello,
I'm new to using XML parsing in coldfusion so I hope I'm phrasing this 
question properly. I was wondering if it's possible to query a xml doc 
and return all of the attribute names (Name, Address, City). I have a 
long list of them and I would like to make my form as dynamic as 
possible.

Thanks,
- Charles


Charles
123 Main St.
Livermore



~|
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:192374
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: Preventing Malicious Sql without cfquery param

[Rick Root]

gabriel l smallman wrote:
> Hey all, anyone got a simple method to protect a var used in a where clause
> where we cannot use cfqueryparam? 

Why can't you use cfqueryparam?


> OR P.Keywords LIKE '%#Url.SearchString#%'

OR P.KEYWORDS LIKE 

  - rick


~|
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:192375
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

query paging UDF or CFC

[xxx xxx]

Hi,

I usually add my custom code to CFML templates that return a lot of
records from a db query to add the paging functionality (next/previous
page buttons).

Is there any UDF or CFC that can be easily plugged into any CFML
template that requires paging functionality?

I checked the cflib.org and cfczone.org web sites, but no luck.

Any hint to write my own code to achieve maximum re-use?

Thanks.

~|
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:192376
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

Query Object coldfusion.sql.QueryTable

[xxx xxx]

Hi,

I found this great article about the undocumented ColdFusion query object:


Does anyone know if the undocumented feature still work with
ColdFusion MX 7 (Blackstone)?

Thanks.

~|
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:192377
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: query paging UDF or CFC

[Deanna Schneider]

I've got one that I use. It's just a UDF. I'll send it to you off-list.

- Original Message - 
From: "xxx xxx" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Monday, January 31, 2005 12:37 PM
Subject: query paging UDF or CFC


> Hi,
>
> I usually add my custom code to CFML templates that return a lot of
> records from a db query to add the paging functionality (next/previous
> page buttons).
>
> Is there any UDF or CFC that can be easily plugged into any CFML
> template that requires paging functionality?
>
> I checked the cflib.org and cfczone.org web sites, but no luck.
>
> Any hint to write my own code to achieve maximum re-use?
>
> Thanks.
>
> 

~|
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:192378
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: query paging UDF or CFC

[gabriel l smallman]

Search for cfpagnation was a custom tag but I suspect with a little
tinkering could be made into udf or cfc. Works quite well and is pretty
flexable


~|
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:192379
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: grabbing the id of a newly created item..

[Matt Robertson]

<[EMAIL PROTECTED]> wrote:
> Ummm...don't you mean CFTRANSACTION...and not CFLOCK??

It should be both if using that kinda dated method.

http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_17000

That article is a golden oldie but it explains the reasons why rather well.

I personally do what Calvin described (create a uuid, store it, query
back for it, take the autoincremented ID and off you go) as it works
on everything, and I very often find other uses for the UUID down the
road once its in there.  Stuff like salt for a hash and whatnot.


-- 
--mattRobertson--
Janitor, MSB Web Systems
mysecretbase.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:192380
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: XML Question

[Qasim Rasheed]

Have you looked into using XMLSearch function?


On Mon, 31 Jan 2005 10:38:16 -0800, Charles Heizer <[EMAIL PROTECTED]> wrote:
> Hello,
> I'm new to using XML parsing in coldfusion so I hope I'm phrasing this
> question properly. I was wondering if it's possible to query a xml doc
> and return all of the attribute names (Name, Address, City). I have a
> long list of them and I would like to make my form as dynamic as
> possible.
> 
> Thanks,
> - Charles
> 
> 
>Charles
>123 Main St.
>Livermore
> 
> 
> 

~|
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:192381
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: EASY: grabbing the id of a newly created item..

[Barney Boisvert]

That's a horrible way to do it.  Quite inefficient.

A better route is to check your DB's docs and see how they expose the
last inserted sequence value.  In MySQL it's LAST_INSERT_ID(), with MS
SQL Server its one of three @IDENTITY variables.  Run your INSERT, and
then select the value back out using this mechanism.  You may or may
not need a transaction, depending on the specifics, and you definitely
won't need CFLOCK.

cheers,
barneyb

On Mon, 31 Jan 2005 10:24:34 -0800, Richard Colman <[EMAIL PROTECTED]> wrote:
>  This is actually pretty easy in ACCESS:
> 
> 1) put the enire transaction within a CFLOCK block
> 
> 2) do the insert
> 
> 3) then select max(id) assuming you have an autonumber field for the id
> 
> Which will give you the id of the record just inserted.
> 
> This is so easy that even I can do it.
> 
> Rick Colman
> 


-- 
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/

Got Gmail? I have 6 invites.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192382
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: XML Question

[Ian Skinner]

Well to start with, in your code example, name, address and city are child 
notes, not attributes.

Charles
123 Main St.
Livermore


If your document was formatted like this, they would be attributes.


So for the former; name, address and city are part of the XMLchildren's array.

#xmlVAR.service.XMLchildren[i].xmlName# = 
#xmlVAR.service.XMLchildren[i].xmlText#


#i# = #xmlVAR.SERVICE.XmlAttributes[i]#



HTH

--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
 
"C code. C code run. Run code run. Please!"
- Cynthia Dunning

...-Original Message-
...From: Charles Heizer [mailto:[EMAIL PROTECTED]
...Sent: Monday, January 31, 2005 10:38 AM
...To: CF-Talk
...Subject: XML Question
...
...Hello,
...I'm new to using XML parsing in coldfusion so I hope I'm phrasing this
...question properly. I was wondering if it's possible to query a xml doc
...and return all of the attribute names (Name, Address, City). I have a
...long list of them and I would like to make my form as dynamic as
...possible.
...
...Thanks,
...- Charles
...
...
... Charles
... 123 Main St.
... Livermore
...
...
...
...

~|
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:192383
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

CFLOOP not looping

[Chris Kavanagh]

Dear list,

My CFLOOP doesn't seem to be looping my INSERTS.

A form passes the variables #person_id# & #project_id# to this page:



SELECT person_id FROM people
WHERE person_id = '#Form.person_id#'






INSERT INTO people_project (person_id, project_id)
VALUES ('#Form.person_id#', '#Form.project_id#')




--

When there are multiple #person_id#s, I was hoping the CFLOOP would 
create multiple rows in the table.  But it doesn't.  :/  What am I 
doing wrong this time?

Many thanks,
CK.


~|
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:192384
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: EASY: grabbing the id of a newly created item..

[Rick Root]

Barney Boisvert wrote:
> That's a horrible way to do it.  Quite inefficient.
> 
> A better route is to check your DB's docs and see how they expose the
> last inserted sequence value.  In MySQL it's LAST_INSERT_ID(), with MS
> SQL Server its one of three @IDENTITY variables.  Run your INSERT, and
> then select the value back out using this mechanism.  You may or may
> not need a transaction, depending on the specifics, and you definitely
> won't need CFLOCK.

That's only reliable inside a transaction.  Don't leave that part out.

  - Rick

~|
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:192385
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: CFLOOP not looping

[Charlie Griefer]

are you sure your query is returning records?  do a
#get_people.recordcount# after your  to
make sure.


On Mon, 31 Jan 2005 19:07:13 +, Chris Kavanagh <[EMAIL PROTECTED]> wrote:
> Dear list,
> 
> My CFLOOP doesn't seem to be looping my INSERTS.
> 
> A form passes the variables #person_id# & #project_id# to this page:
> 
> 
> 
> SELECT person_id FROM people
> WHERE person_id = '#Form.person_id#'
> 
> 
> 
> 
> 
> 
> INSERT INTO people_project (person_id, project_id)
> VALUES ('#Form.person_id#', '#Form.project_id#')
> 
> 
> 
> 
> --
> 
> When there are multiple #person_id#s, I was hoping the CFLOOP would
> create multiple rows in the table.  But it doesn't.  :/  What am I
> doing wrong this time?
> 
> Many thanks,
> CK.
> 
> 

~|
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:192386
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: query paging UDF or CFC

[Cedric Villat]

I made one called CF_PageList which creates the Next/Previous links and the 
pages very much like Google. It'll move the page range as you go through the 
links. Check out www.cornfeed.com for a demo and the download.

Thanks,
Cedric

>Hi,
>
>I usually add my custom code to CFML templates that return a lot of
>records from a db query to add the paging functionality (next/previous
>page buttons).
>
>Is there any UDF or CFC that can be easily plugged into any CFML
>template that requires paging functionality?
>
>I checked the cflib.org and cfczone.org web sites, but no luck.
>
>Any hint to write my own code to achieve maximum re-use?
>
>Thanks.

~|
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:192388
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: XML/XSLT Line Break

[Mark Leder]

Rob and Alex,

The CDATA trick worked well for this application.
Thanks for your help. 

Mark

-Original Message-
From: Rob [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 31, 2005 12:42 PM
To: CF-Talk
Subject: Re: XML/XSLT Line Break

There are a couple tricks to do this, but I think your best bet would be to
add a cdata section to your xml - I think that will solve your problem. So:



Will keep the parser from parsing the data and removing the line breaks - at
least it should.

Otherwise you could do it in the xslt by adding 

to get some line breaks in there.

Hope that helps





~|
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:192387
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: EASY: grabbing the id of a newly created item..

[Jim McAtee]

For a low volume site it works alright, as efficiency probably isn't your 
biggest concern.  If you're using Access it can probably be assumed that 
the application is fairly low volume.

There are some added considerations, though, that make this approach less 
than foolproof:

- You have to make sure that all inserts into the table are locked, not 
just those where you need to retrieve the last id.

- You have to make sure all of inserts use the same lock name.  Using 
name="databasename_tablename" is one approach that will keep you from 
blocking access to other tables.  In a shared environment I'd use 
"myname_databasename_tablename".


- Original Message - 
From: "Barney Boisvert" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Monday, January 31, 2005 12:01 PM
Subject: Re: EASY: grabbing the id of a newly created item..


> That's a horrible way to do it.  Quite inefficient.
>
> A better route is to check your DB's docs and see how they expose the
> last inserted sequence value.  In MySQL it's LAST_INSERT_ID(), with MS
> SQL Server its one of three @IDENTITY variables.  Run your INSERT, and
> then select the value back out using this mechanism.  You may or may
> not need a transaction, depending on the specifics, and you definitely
> won't need CFLOCK.
>
> cheers,
> barneyb
>
> On Mon, 31 Jan 2005 10:24:34 -0800, Richard Colman <[EMAIL PROTECTED]> 
> wrote:
>>  This is actually pretty easy in ACCESS:
>>
>> 1) put the enire transaction within a CFLOCK block
>>
>> 2) do the insert
>>
>> 3) then select max(id) assuming you have an autonumber field for the id
>>
>> Which will give you the id of the record just inserted.
>>
>> This is so easy that even I can do it.
>>
>> Rick Colman


~|
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:192389
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: Preventing Malicious Sql without cfquery param

[Matt Robertson]

> Why can't you use cfqueryparam?

I have actually experienced this myself with the following, and only
on MS SQL Server.  The same statement works great in mySQL, Access and
Oracle.  In the code below, if we are running SQL Server
(localgrid.usedb=2) execution branches to bypass cfqueryparam.

I've seen the same problem with MS Access date fields.  I have yet to
see a cfsqltype that will work with one of those, and working the
problem from the other end have been unable to figure out a config
within access itself that will work with one of the cfsqltypes.


#TempGrid.QueryFieldName# LIKE 



#TempGrid.QueryFieldName# LIKE '%#Evaluate(TempGrid.SearchText)#%'


-- 
--mattRobertson--
Janitor, MSB Web Systems
mysecretbase.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:192390
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: EASY: grabbing the id of a newly created item..

[Barney Boisvert]

Not necessarily.  One of the SQL Server variables is a global
variable, so you can call it anytime for the last ID, with no
knowledge of who inserted it or even what table.  If that's what you
care about, then a transaction is irrelevant.  WIth MySQL's
LAST_INSERT_ID() it's tracked by connection (not globally), and since
CFMX allocates a DB connection per request, you don't really need the
transaction there either, though I would recommend it.

Hence the "depending on specifics" hedge.  ;)

cheers,
barneyb

On Mon, 31 Jan 2005 14:08:24 -0500, Rick Root <[EMAIL PROTECTED]> wrote:
> Barney Boisvert wrote:
> > That's a horrible way to do it.  Quite inefficient.
> >
> > A better route is to check your DB's docs and see how they expose the
> > last inserted sequence value.  In MySQL it's LAST_INSERT_ID(), with MS
> > SQL Server its one of three @IDENTITY variables.  Run your INSERT, and
> > then select the value back out using this mechanism.  You may or may
> > not need a transaction, depending on the specifics, and you definitely
> > won't need CFLOCK.
> 
> That's only reliable inside a transaction.  Don't leave that part out.
> 
>   - Rick
> 
> 


-- 
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/

Got Gmail? I have 6 invites.

~|
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:192393
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: CFLOOP not looping

[Bryan Stevenson]

Your person_IDs var probably holds a list of IDs (or a single ID)so you 
need to use an IN cluse in your first SELECT to get multuple records to then 
use to loop over and do your inserts.

like so:



  SELECT person_id FROM people
  WHERE person_id IN ()






INSERT INTO people_project (person_id, project_id)
VALUES ('#person_id#', '#FORM.project_id#')




Note the FORM scope was removed from Person_ID in the above query as you 
want the individual ID returned from "get_people", and NOT the LIST OF IDs 
that may be in FORM.person_ID

HTH

Cheers

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com 


~|
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:192392
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: EASY: grabbing the id of a newly created item..

[Jeff Garza]

If you are on SQL Server 2000 you can use the SCOPE_IDENTITY() function 
which will work independant of Triggers and other transactions on the same 
table.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sa-ses_6n8p.asp

I've switched all of my code to use this function instead of @@IDENTITY.  Of 
course, this locks me into using SQL Server 2000, but I don't see that 
changing anytime soon...

Cheers,

Jeff Garza

- Original Message - 
From: "Rick Root" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Monday, January 31, 2005 12:08 PM
Subject: Re: EASY: grabbing the id of a newly created item..


> Barney Boisvert wrote:
>> That's a horrible way to do it.  Quite inefficient.
>>
>> A better route is to check your DB's docs and see how they expose the
>> last inserted sequence value.  In MySQL it's LAST_INSERT_ID(), with MS
>> SQL Server its one of three @IDENTITY variables.  Run your INSERT, and
>> then select the value back out using this mechanism.  You may or may
>> not need a transaction, depending on the specifics, and you definitely
>> won't need CFLOCK.
>
> That's only reliable inside a transaction.  Don't leave that part out.
>
>  - Rick
>
> 

~|
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:192392
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: CFLOOP not looping

[Ian Skinner]

SELECT person_id FROM people
WHERE person_id = '#Form.person_id#'


This query is only going to return one record, assuming person_id is an unique 
key.  I suspect what you may be wanting is a IN clause


SELECT person_id FROM people
WHERE person_id IN ()


HTH, otherwise we need to know more about #form.person_ID# and the people table.

--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
 
"C code. C code run. Run code run. Please!"
- Cynthia Dunning

...-Original Message-
...From: Chris Kavanagh [mailto:[EMAIL PROTECTED]
...Sent: Monday, January 31, 2005 11:07 AM
...To: CF-Talk
...Subject: CFLOOP not looping
...
...Dear list,
...
...My CFLOOP doesn't seem to be looping my INSERTS.
...
...A form passes the variables #person_id# & #project_id# to this page:
...
...
...
... SELECT person_id FROM people
... WHERE person_id = '#Form.person_id#'
...
...
...
...
...
... 
... INSERT INTO people_project (person_id, project_id)
... VALUES ('#Form.person_id#', '#Form.project_id#')
... 
...
...
...
...--
...
...When there are multiple #person_id#s, I was hoping the CFLOOP would
...create multiple rows in the table.  But it doesn't.  :/  What am I
...doing wrong this time?
...
...Many thanks,
...CK.
...
...
...

~|
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:192395
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: EASY: grabbing the id of a newly created item..

[Matt Robertson]

> That's only reliable inside a transaction.  Don't leave that part out.

AND a named lock to choke the process down to a single user.  Adding
in all of that overhead makes for a serious potential bottleneck in
performance, imho, so I never do it.  If you can optimize for a single
db platform then do what Barney is saying.  In access that means
@@identity.  I use UUIDs cuz generally I can't count on what db will
be running.


-- 
--mattRobertson--
Janitor, MSB Web Systems
mysecretbase.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:192395
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: grabbing the id of a newly created item..

[Calvin Ward]

In either case, cftransaction isn't guaranteed (it's only a recommendation,
and does it work with Access?) and cflock won't work across multiple servers
in a load balanced environment...

-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 31, 2005 1:38 PM
To: CF-Talk
Subject: Re: grabbing the id of a newly created item..

Ummm...don't you mean CFTRANSACTION...and not CFLOCK??

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:192396
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: CFLOOP not looping

[Chris Kavanagh]

On 31 Jan 2005, at 7:12 pm, Charlie Griefer wrote:

> are you sure your query is returning records?  do a
> #get_people.recordcount# after your  to
> make sure.

Ah!  Now we're getting somewhere.  No: when I check multiple boxes on 
the form that gets me here, it sends one value, like this:

1,7

Which begs the question: how do I make it send separate values?  Then I 
think my CFLOOP might work.

1
7

--



SELECT
projects.name AS projectname,
projects.company AS projectcompany,
people.person_id,
people.name AS personname,
people.company AS personcompany
FROM projects
JOIN people ON projects.company = people.company
WHERE projects.project_id = #project_id#





#personname#




~|
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:192397
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

SOLVED: CFLOOP not looping

[Chris Kavanagh]

:D  it now loops.  The IN clause fixed it.  Thanks everybody.

- ck.


~|
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:192399
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: grabbing the id of a newly created item..

[Joe Rinehart]

> cflock won't work across multiple servers
> in a load balanced environment...

And I hope no one uses Access for that!
-Joe

-- 
For Tabs, Trees, and more, use the jComponents:
http://clearsoftware.net/client/jComponents.cfm

~|
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:192400
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: Preventing Malicious Sql without cfquery param

[Joe Rinehart]

Matt,

I use LIKE all the time in MS SQL with CFQueryParam...just to make
sure my head is screwed on straight, I just ran the following against
an nvarchar column:


where SomeColumn like 


-joe


On Mon, 31 Jan 2005 11:17:27 -0800, Matt Robertson
<[EMAIL PROTECTED]> wrote:
> > Why can't you use cfqueryparam?
> 
> I have actually experienced this myself with the following, and only
> on MS SQL Server.  The same statement works great in mySQL, Access and
> Oracle.  In the code below, if we are running SQL Server
> (localgrid.usedb=2) execution branches to bypass cfqueryparam.
> 
> I've seen the same problem with MS Access date fields.  I have yet to
> see a cfsqltype that will work with one of those, and working the
> problem from the other end have been unable to figure out a config
> within access itself that will work with one of the cfsqltypes.
> 
> 
> #TempGrid.QueryFieldName# LIKE
>  cfsqltype="#TempGrid.SType#"
> value="%#Evaluate(TempGrid.SearchText)#%">
> 
> 
> #TempGrid.QueryFieldName# LIKE '%#Evaluate(TempGrid.SearchText)#%'
> 
> 
> --
> --mattRobertson--
> Janitor, MSB Web Systems
> mysecretbase.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:192399
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: CFLOOP not looping

[Charlie Griefer]

On Mon, 31 Jan 2005 19:25:36 +, Chris Kavanagh <[EMAIL PROTECTED]> wrote:
> On 31 Jan 2005, at 7:12 pm, Charlie Griefer wrote:
> 
> > are you sure your query is returning records?  do a
> > #get_people.recordcount# after your  to
> > make sure.
> 
> Ah!  Now we're getting somewhere.  No: when I check multiple boxes on
> the form that gets me here, it sends one value, like this:
> 
> 1,7
> 
> Which begs the question: how do I make it send separate values?  Then I
> think my CFLOOP might work.

see prior responses re: using IN instead of =

-- 
Charlie Griefer


Marta was watching the football game with me when she said, 
"You know, most of these sports are based on the idea of one group 
protecting its territory from invasion by another group." 
"Yeah," I said, trying not to laugh. Girls are funny.

~|
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:192401
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: CFWebstore

[Mary Jo Sminkey]

>As I understand it, their support is pretty good, too.

I certainly try! IMO, good support is just as important as having a "kick ass" 
product. 

You can email me directly for help, or the CFWebstore email list on Yahoogroups 
is also a great place to get assistance from other developers. 


~|
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:192402
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: CFLOOP not looping

[Bryan Stevenson]

Like I said Chrisyou need the IN clause...will work with single or 
multiple IDs passed in ;-)

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:192403
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