RE: failure?

[Dunwiddie, Bruce]

in my way of phrasing things, I think the reference is wrong. the value 
on
the left is the string to search, and the value on the right is the
substring to search for.

-Original Message-
From: Brian Scandale [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 2:59 PM
To: CF-Talk
Subject:  failure?


This tag does not seem to work like I would expect. Can anyone shed 
some
light? Very little in the docs about this. I quote the only 
reference...

"CONTAINS determines whether the value on the left is contained in the 
value
on the right. Returns true if it is."




The above example returns true if client.travtype = "REWORK" 
but returns false if it = "REWORK LOOP"

thank you

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: OT: Using CSS to make pretty printouts

[Dunwiddie, Bruce]

try 




then in printer.css, use display:none in the definition of the classes 
being
used on the tables

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 14, 2002 1:11 PM
To: CF-Talk
Subject: RE: OT: Using CSS to make pretty printouts


that's a good idea, BUT,
1. you have to maintain 2 documents whether html or css
2. how will you know which .css to link?  i'm assuming by some kind
 of user
input like clicking on "Printable Version" link or something to that ef
fect
3. if you DO do the "Printable version" thing why not just toggle the

visablity as previously mentioned since you're depending on user input 
to
go to another page, or version of the page, anyway?




"Carlisle, Eric" <[EMAIL PROTECTED]> on 01/14/2002 11:56:58
 AM

Please respond to [EMAIL PROTECTED]

To:   CF-Talk <[EMAIL PROTECTED]>
cc:

Subject:  RE: OT: Using CSS to make pretty printouts


Believe me, I'd prefer to draw print friendly versions from a DB, but
much
of the site is simple HTML. :)

I see what you saying about toggling the visibility.
I was thinking of using 2 stylesheets one for display, one for print).

In
the display stylesheet, I would have that display class visible.  In
the
print stylesheet, I would have it set for invisible.  Any idea if tha
t
would
work?

 thanks :)


-Original Message-
From: [EMAIL PROTECTED] [mailto:savan.thongvanh@seabury
com]
Sent: Monday, January 14, 2002 12:50 PM
To: CF-Talk
Subject: Re: OT: Using CSS to make pretty printouts


if you are pulling ur content from a DB whynot just make a pretty print


template?

but to answer your question, yes, sort of.

you would only really only be able to control the visibility of the men

u
 if the user executed the print command from the page.  That way

, you
could capture and event, call an event handler and use it to set the 
to invisible,  and from within that event handler call the print() meth

od
of the document object.

but if i were to hit [CTRL]+P that would negate that whole thing.




"Carlisle, Eric" <[EMAIL PROTECTED]> on 01/14/2002 11:43:05

 AM

Please respond to [EMAIL PROTECTED]

To:   CF-Talk <[EMAIL PROTECTED]>
cc:

Subject:  OT: Using CSS to make pretty printouts


I'm working with a web site that doesn't print well.  This happens be

cause:

1) The top navigational bar (runs horizontal - all graphical) is too wi

de
to
fit on a 8.5 inch wide paper.
2) The left navigation steals prime real estate away from the display a

rea.

I've been charged with the task of making the site print well.  Can I

 use
CSS classes to toggle the visibility of a  on a print out (so I ca

n
omit some items on a printout)?

If not, any other suggestions would be appreciated!

 Thanks :)





__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: SQL GURUS?

[Dunwiddie, Bruce]

just to keep you from slaughtering a table, I'd make a bet that you're 
also
missing another where clause for which rows should be updated in this
statement. currently, you'll update every row in the table.

-Original Message-
From: Mark Stewart [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 03, 2002 8:53 AM
To: CF-Talk
Subject: RE: SQL GURUS?


The syntax looks correct but, correct me if I'm wrong here, I don't
think Access will allow that type of query. You shouldn't have a 
problem
with SQL Server though.

Mark

-Original Message-
From: Kris Pilles [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 03, 2002 9:31 AM
To: CF-Talk
Subject: SQL GURUS?


I am having trouble with a query:

Works fine in Oracle...


Update category
set tutorial = (Select max(section.tutorial)
from section, category 
where category.code = section.catalogid)



Anyidea why Access tells me this is an "[Microsoft][ODBC Microsoft
Access
Driver] Operation must use an updateable query."



__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: lock var inside JS script?

[Dunwiddie, Bruce]

I think you guys are all missing the point. The js is running at an entirely
different time than the cf. You would make the lock around the session read
inside the js just exactly the same as if it was inside say a table cell.
You are generating js code, it's not being run at the same time as the cf
code. Cf is being run at the server level and js is being run at the client
level. Changing the scope around and moving the session read to a different
place would be fine, but there is no real problem to begin with. Throw a
cflock around the session read inside the js just like you would anywhere
else in a page. Now if you have several times during the page load that
you're reading from the same session var, then I can see setting a local var
to hold it's value to cut down on the locks and reads, but otherwise, it's a
waste of time/code.

-Original Message-
From: Kola Oyedeji [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 13, 2001 8:36 AM
To: CF-Talk
Subject: RE: lock var inside JS script?


To go one better you could move it to the request scope so that any
custom tags on the page will still have access to it as if it was a session
var.

Kola

Kola Oyedeji |Web Developer |ekeda
elthorne gate |64 high street |pinner |middx |ha55qa
t +44(208)429 7333 f +44(208)429 7339 |www.ekeda.co.uk


> -Original Message-
> From: Chris Bohill [mailto:[EMAIL PROTECTED]]
> Sent: 13 December 2001 14:31
> To: CF-Talk
> Subject: RE: lock var inside JS script?
>
>
> Set the session variable as a local variable at the top of
> the page, and
> lock this cfset.
>
> Then reference the local variable as you would the session, in the
> JavaScript. By doing this you only have to lock it once (at the top).
> Should not have any side-effects.
>
> HTH
>
> Chris Bohill
>
>
> -Original Message-
> From: Chris Norloff [mailto:[EMAIL PROTECTED]]
> Sent: 13 December 2001 14:29
> To: CF-Talk
> Subject: lock var inside JS script?
>
>
> I'm reviewing some code, and found a
> "" inside a javascript function.
>
> I assume this read should be locked, but I'm not sure how to do it
> inside the js function.
>
> I could move session.web_access into another scope before the js
> function, but since it's someone else's code I'm wary of doing that
> because it could have effects I can't see now.
>
> Ideas?
>
> thanks,
> Chris Norloff
>
> 

~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CreateODBCDate

[Dunwiddie, Bruce]

createodbcdate is a function all on it's own. it doesn't get a date. you
would have to use something like createodbcdate(now()) to get a date, and
now() would use the time according to the cf server clock.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 12, 2001 3:06 PM
To: CF-Talk
Subject: CreateODBCDate


Hello -

Can anyone tell me exactly where the createODBCdate function in coldfusion
gets its date from?  The problem we are running into is dateadd function
not working in the UK.  We think we've tracked the problem to the web
server and not necessarily the coldfusion server itself because we have the
same version running in the same enviroment in the US.

Your insight is appreciated!
CC

~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Address Verification

[Dunwiddie, Bruce]

USPS offers it for free from their website but you have to go thru alot of
paperwork to get in to it, but I'd recommend it.

-Original Message-
From: Sam Farmer [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 12, 2001 8:14 AM
To: CF-Talk
Subject: Address Verification


Doing some research on address verification software and was wondering if
anyone had used some in the past?  There seem to be several that provide a
COM interface.

Has anyone used this?
How much did it cost?

Thanks,

Sam

Sam Farmer - Senior Developer
Certified Advanced ColdFusion 5 Developer
[EMAIL PROTECTED]
INTELIX - Intelligent Solutions

12500 Fair Lakes Circle, Suite 150
Fairfax, VA 22033
703-815-2500



~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

recordset sql statement

[Dunwiddie, Bruce]

in the debug window, under recordsets, there's a column that shows the sql
that ran to generate that query. is this an exposed variable that we have
access to on a page? like in the form of something like
#queryname.statement# or is it restricted to only their debug window and
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Form Submittal

[Dunwiddie, Bruce]

can't do it without a page refresh somewhere. you could put the actual form
in a frame and just have that part submit to itself, does the action, and
onload calls a window.open to some page that then displays the results.
we're doing something very similar on an image generation and preview.
orr, you could attempt to have some rather complex java script that
onclick of the submit button, pops open a new window and in the url for that
new window, send the values of each form element as url parameters and have
the action of the update at the top of the page that's being popped open. 

-Original Message-
From: Marcus [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 11, 2001 12:39 PM
To: CF-Talk
Subject: RE: Form Submittal


> if you name the submit buttons, then form.submitbutton1 and
> form.submitbutton2 exist on the recieving end depending on which one was
> pressed, or if you're using type="image" for the submit buttons,
> form.submitbutton1.x and form.submitbutton2.x exist on the recieving to do
> your switch for the action.

Problem is, that does a standard submit. I need the ability to press submit,
and then a new window opens up with results that are different based on the
possible changes he has made on the original form. If he doesn't like the
results, he can close the second window, and change any field on the
original form, and view his changes. Over and over until he is happy with
the results.

Marcus

~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF Evaluate in VB?

[Dunwiddie, Bruce]

I think the reason is that in normal programming, non-web, you would use
function calls as opposed to using just evaluates. I think you need to take
another look at what you're trying to accomplish in a different way.

-Original Message-
From: Shawn Grover [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 11, 2001 11:50 AM
To: CF-Talk
Subject: OT: CF Evaluate in VB?


I'm writing a program in VB and find it would be extremely useful to have a
function similar to to Cold Fusion's Evaluate function.  Does anyone know if
such a function exists in VB?  I've yet to see anything like it in the MSDN.


I have seen third party tools that would handle math, but these don't appear
to handle strings to the extent that CF does.

Thanks for the info.


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Form Submittal

[Dunwiddie, Bruce]

if you name the submit buttons, then form.submitbutton1 and
form.submitbutton2 exist on the recieving end depending on which one was
pressed, or if you're using type="image" for the submit buttons,
form.submitbutton1.x and form.submitbutton2.x exist on the recieving to do
your switch for the action.

-Original Message-
From: Marcus [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 11, 2001 11:50 AM
To: CF-Talk
Subject: Form Submittal


I am going brain dead.

I need to see if it's possible to either,

Store changed fields in a database without doing a standard submit with a
reload.

Or, if I can modify the form action to point to two different actions
depending on which submit is pressed.

Marcus

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Does anyone see a problem with this query?

[Dunwiddie, Bruce]

I have a feeling that this is not the actual query that's running, you're
just assuming it is. I may be wrong, but what is the actual cfquery block
containing this query? don't modify it at all, just show the actual cfm
query...

-Original Message-
From: Douglas Brown [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 11, 2001 10:49 AM
To: CF-Talk
Subject: Re: Does anyone see a problem with this query?


Here is the original post

ODBC Error Code = 37000 (Syntax error or access violation)


[Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax near
'.'.



SELECT   topc.id,
   topc.topics,
   subt.id,
   subt.topic_id,
   subt.s_topics
FROM  topics AS topc
INNER JOIN sub_topics
AS  subt
ON  topc.id = subt.id
WHERE   topc.id = subt.id

- Original Message -
From: "Michael Haggerty" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, December 11, 2001 8:27 AM
Subject: RE: Does anyone see a problem with this query?


> What is the error you are getting?
>
> -Original Message-
> From: Douglas Brown [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, December 11, 2001 11:39 AM
> To: CF-Talk
> Subject: Re: Does anyone see a problem with this query?
>
>
> Absolutely nothing else.
>
>
>
> Doug
>
>
>
> - Original Message -
> From: "Mike Connolly" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, December 11, 2001 2:12 AM
> Subject: RE: Does anyone see a problem with this query?
>
>
> > I don't know if I'm alone in this, but at first, second, and third
glance
> > your query syntax seems fine.
> >
> > Is there anything else to this query?
> >
> > -Original Message-
> > From: Douglas Brown [mailto:[EMAIL PROTECTED]]
> > Sent: 11 December 2001 00:42
> > To: CF-Talk
> > Subject: Does anyone see a problem with this query?
> >
> >
> > I keep getting this error when I run the query. This is a SQL 2K
> > database
> >
> > ODBC Error Code = 37000 (Syntax error or access violation)
> >
> >
> > [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax
> > near '.'.
> >
> >
> >
> > SELECT   topc.id,
> >topc.topics,
> >subt.id,
> >subt.topic_id,
> >subt.s_topics
> > FROM  topics AS topc
> > INNER JOIN sub_topics
> > AS  subt
> > ON  topc.id = subt.id
> > WHERE   topc.id = subt.id
> >
> >
> >
> > Thanks
> >
> >
> >
> > Doug
> >
> >
> >
>
> 

~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Send response to browser, but continue working on request?

[Dunwiddie, Bruce]

you are wanting the browser to make a request for a file but not wait for
the file to be retrieved? if so, I don't think that's feasible. a general
solution for the problem of generating the email would be to have a  that can send out the email and you can show them
whatever message you'd like to show them and the browser waiting for more
should have no effect on the cfm or on the user.

-Original Message-
From: Tony Schreiber [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 11, 2001 9:33 AM
To: CF-Talk
Subject: Re: Send response to browser, but continue working on request?


That let's me get a message to the browser, but the request is still
running and the browser is still waiting...

I want to browser to stop waiting...

> Have you tried cfflush?  I believe this tag will allow you to send partial
> responses to the browser.  I might have spelled it wrong, but I am sure
> there is a function in CF.
>
> David
>
>
> - Original Message -
> From: "Tony Schreiber" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, December 11, 2001 7:17 AM
> Subject: Send response to browser, but continue working on request?
>
>
> > I have a function that allows a user to create a file of available
> > inventory. The problem is that it takes a long time and eventually the
> > browser will timeout, but they haven't gotten their file yet...
> >
> > What I want to do is let the user make the request and then respond with
> > "Thank you for your request. Your file will be created and emailed to
you
> > shortly".
> >
> > How can I "spawn" off the part that will actually create the file and
> > still respond with a finished request to the browser?
> >
> >
> > Tony Schreiber, Senior Partner  Man and Machine, Limited
> > mailto:[EMAIL PROTECTED]   http://www.technocraft.com
> >
> > http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion
> > http://www.is300.net ___The Enthusiast's Home of the Lexus IS300
> > http://www.digitacamera.com __DigitA Camera Scripts and Tips
> > http://www.linklabexchange.com _Miata Link ECU Data Exchange
> >
> 

~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: UPS Prices

[Dunwiddie, Bruce]

well the connection failure was me being short sighted and not realizing
that there was some server setting that has been changed and needed to be
changed back to get cfhttp to work, which I finally figured out and got the
sysadmin to fix, but now that I'm actually connecting, which is always a
good start, I'm getting the message "UPSOnLine5%Missing ActionCode%6837"
when I try to run the tag with one of the example usages. where are you
downloading it from? I'm obviously not looking at the same version you are.

-Original Message-
From: Judith Taylor [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 10, 2001 11:26 AM
To: CF-Talk
Subject: RE: UPS Prices


Well, I've just downloaded a new copy of the tag, and compared it with the
version I've been usingthere are no differences in the tag itself.

How are you calling the tag? That may be where the problem is.what is
the code you're using when you call it?

Trying to help,
Judith

Dunwiddie, Bruce put into words:
>The FileContent is coming back with "Connection Failure" and that's it.
When
>I go to the url in a browser, I get "UPSOnLine5%Missing ActionCode%6837".
In
>the code, there's a line that says "IS "UPSOnLine3">". I'm kind of at a loss if it's something wrong on my end,
>but it really looks to me like this one is on the wrong version by that
>upsonline #, and I tried changing the code to look for upsonline5, and I
>still get the same. Could you fill in on maybe some other processes I need
>to do to use the script. I don't see any login variables or anything...

Judith Taylor
Freelance ColdFusion Developer - Athens, OH
ICQ: 67460562  |  YahooID: lace_n_steel   |   AIM: BlacksmithLace

Friends don't let friends code before coffee.

~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: UPS Prices

[Dunwiddie, Bruce]

The FileContent is coming back with "Connection Failure" and that's it. When
I go to the url in a browser, I get "UPSOnLine5%Missing ActionCode%6837". In
the code, there's a line that says "". I'm kind of at a loss if it's something wrong on my end,
but it really looks to me like this one is on the wrong version by that
upsonline #, and I tried changing the code to look for upsonline5, and I
still get the same. Could you fill in on maybe some other processes I need
to do to use the script. I don't see any login variables or anything...

-Original Message-
From: Judith Taylor [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 10, 2001 9:46 AM
To: CF-Talk
Subject: Re: UPS Prices


What errors are you getting? The site where I'm using Forta's tag is
returning the prices with no problem.

Judith

Dunwiddie, Bruce put into words:
>Does anyone have a page working that gets the online ups shipping cost? We
>looked at this a while back, and Ben Forta's tag UPSPrice.cfm was working
>then, but now that we're ready to put something in place, I'm getting a
>"Connection Failure" error and after looking in to it, it looks like the
tag
>is on version 3 of ups's system, but their system is now on version 5. I
>just went to DevEx and got the latest version of the tag that was modified
>Oct 15th of this year, and it's still the version 3. Any help with what
>small changes I might need to make to this tag to get it to work now or any
>other options that would work would be greatly appreciated and would save
me

Judith Taylor
Freelance ColdFusion Developer - Athens, OH
ICQ: 67460562  |  YahooID: lace_n_steel   |   AIM: BlacksmithLace

Friends don't let friends code before coffee.

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

UPS Prices

[Dunwiddie, Bruce]

Does anyone have a page working that gets the online ups shipping cost? We
looked at this a while back, and Ben Forta's tag UPSPrice.cfm was working
then, but now that we're ready to put something in place, I'm getting a
"Connection Failure" error and after looking in to it, it looks like the tag
is on version 3 of ups's system, but their system is now on version 5. I
just went to DevEx and got the latest version of the tag that was modified
Oct 15th of this year, and it's still the version 3. Any help with what
small changes I might need to make to this tag to get it to work now or any
other options that would work would be greatly appreciated and would save me
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: No within - but I need to

[Dunwiddie, Bruce]

select *
from tblA



select *
from tblB





Member Name: 


Member Level:





#embeddedQuery.fldName#








-Original Message-
From: Paul Sinclair [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 07, 2001 4:18 PM
To: CF-Talk
Subject: No  within  - but I need to


I am setting up a form page that requires a drop down selection box. The
dropdown box is generated dynamically in a  section. But the
dropdown box is itself to be inserted within another 
section of the page.

I've tried using  above the first  section to make a
variable that I can embed with the second  section. The problem
with that is I can't do a  within the  tag to set up the
variable (at least I don't think I can.)

What I want to do is something like this:

=== START CODE SAMPLE ===

select *
from tblA



select *
from tblB





Member Name: 


Member Level:





#fldName#







=== END CODE SAMPLE ===


Any ideas how to cram the dropdown box in there?


~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: ODBC Datasources

[Dunwiddie, Bruce]

select name
from sysobjects
where xtype='U'


-Original Message-
From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 07, 2001 11:18 AM
To: CF-Talk
Subject: RE: ODBC Datasources


  The tables in a datasource are stored in the registry?


At 10:52 AM 12/07/2001 -0600, you wrote:
>you have to read the registry for both. gl.
>
>-Original Message-
>From: tom muck [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, December 06, 2001 11:49 AM
>To: CF-Talk
>Subject: ODBC Datasources
>
>
>Is there an easy way to get a list of ODBC datasources on the server
through
>ColdFusion?  Also, given a datasource, is there a way to get a list of
>tables from that datasource?
>
>tom
>
>
>

~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFFile Replacment

[Dunwiddie, Bruce]

even without trying the code, I'd have to argue. form.myfile is the name of
the file and the path on their computer which you would normally then use in
cffile to upload with if you're using input type="file" to upload with.

-Original Message-
From: Mike Townend [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 07, 2001 11:11 AM
To: CF-Talk
Subject: RE: CFFile Replacment


No this gets replaced with the path and filename of the uploaded file
which is not the name of the original file...

Ie

Orig file = "c:\foo\myfile.gif"
-> Form Posts
FORM.MYFile = "c:\winnt\asdfih.gif"


Ive got a nasty feeling that I will need to hook into IIS or something
like that



-Original Message-
From: Dunwiddie, Bruce [mailto:[EMAIL PROTECTED]] 
Sent: 07 December 2001 16:16
To: CF-Talk
Subject: RE: CFFile Replacment


silly question, but wouldn't the name you're looking for be the value of
the form element you used to upload the file?

-Original Message-
From: Mike Townend [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 06, 2001 12:28 PM
To: CF-Talk
Subject: RE: CFFile Replacment


Yes I have all that code done... The problem is if someone uploads a
file called header.gif I get passed the name of the temporary file that
is create ie c:\winnt\acer33.gif this I can then move etc... But how can
I get hold of header.gif so that when I do the move the destination name
is called header.gif


Thankx in advance

Mike



-Original Message-
From: Robert Everland [mailto:[EMAIL PROTECTED]] 
Sent: 06 December 2001 18:14
To: CF-Talk
Subject: RE: CFFile Replacment


Is it a Windows computer. If so you can use Active X objects to read the
file. 

Robert Everland III
Dixon Ticonderoga
Web Developer Extraordinaire

-Original Message-
From: Mike Townend [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 06, 2001 1:11 PM
To: CF-Talk
Subject: RE: CFFile Replacment


Sorry What im trying to do is allow file uploading when the
administrator has disabled the CFFILE tag... I can get the file to the
destination OK however I cannot find a way of working out what the
original file was called...


So I need to find the Orginal name of the file that is uploaded without
using CFFIle


Thanx in advance




-Original Message-
From: Bryan Love [mailto:[EMAIL PROTECTED]] 
Sent: 05 December 2001 19:24
To: CF-Talk
Subject: RE: CFFile Replacment


after doing the upload:
#file.serverFile# for the whole thing with extension

+






~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Updating only records checked on output page

[Dunwiddie, Bruce]

I'll take a shot here

make radio buttons with yes/no options all named the same thing and a hidden
field with the recordid named recordid






update sometable
set somefield1 = '#listgetat(form.sometext1, counter)#',
somefield2 = '#listgetat(form.sometext2, counter)#'
where someidfield = #current#

 


-Original Message-
From: Paul Sinclair [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 07, 2001 12:17 PM
To: CF-Talk
Subject: RE: Updating only records checked on output page


Bruce,

Thanks for your note on this subject. The "IN" syntax you suggested
doesn't make it work for me. I am probably being thick.

This is the error message I get (simplified):

-
ODBC Error Code = 37000 (Syntax error or access violation) Syntax error
in UPDATE statement.

SQL = "UPDATE tblName SET fld1=1,2,999,999 WHERE recordID in (127,128)"

Data Source = "dsn"
-

This is from a page where I displayed 4 records and selected to edit 2
of them. The action page is taking fld1 from the form page and trying to
put in the ENTIRE LIST OF VALUES FROM THE FORM (1,2,999,999) instead of
just the value for recordid 128. The sql syntax that I need to get out
on the action page for each marked record is like:

UPDATE tblName 
SET fld1=1, fld2=2 
WHERE recordID = 128


So if I marked 3 records to be updated it would be like this on the
action page:


UPDATE tblName 
SET fld1=1, fld2=2 
WHERE recordID = 127



UPDATE tblName 
SET fld1=1, fld2=2 
WHERE recordID = 128



UPDATE tblName 
SET fld1=1, fld2=2 
WHERE recordID = 129



I know this is straightforward and I think I even have some pages where
I have done it but I can't for the life of me remember how to do it!

Thanks for any more help.

Best,
Paul Sinclair




> -Original Message-
> From: Dunwiddie, Bruce [mailto:[EMAIL PROTECTED]]
> Sent: Friday, December 07, 2001 11:40 AM
> To: CF-Talk
> Subject: RE: Updating only records checked on output page
> 
> 
> on form page:
> 
> 
> 
> on action page:
> 
> update tablename
> where someid in (#form.record#)
> 
> 
> -Original Message-
> From: Paul Sinclair [mailto:[EMAIL PROTECTED]]
> Sent: Friday, December 07, 2001 10:10 AM
> To: CF-Talk
> Subject: Updating only records checked on output page
> 
> 
> I have an output page that may have dozens or hundreds of
> records on it. I want to put all the records into a single 
> form with a checkbox by each record so that a user can: edit 
> any or all records on the page; click the checkbox to 
> identify the records modified; and submit the form to a page 
> that will loop through all the checked records and update 
> them. I think this is an easy thing but I have some kind of 
> mental block preventing me from figuring it out!
> 
> The output page is something like this:
> 
> 
> 

~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: ODBC Datasources

[Dunwiddie, Bruce]

you have to read the registry for both. gl.

-Original Message-
From: tom muck [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 06, 2001 11:49 AM
To: CF-Talk
Subject: ODBC Datasources


Is there an easy way to get a list of ODBC datasources on the server through
ColdFusion?  Also, given a datasource, is there a way to get a list of
tables from that datasource?

tom


~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: What the best database structure to do this?

[Dunwiddie, Bruce]

you should be able to cache the query for stuff like that, so as long as you
do, you shouldn't have to worry about it.

-Original Message-
From: Jon Hall [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 06, 2001 7:37 PM
To: CF-Talk
Subject: What the best database structure to do this?


I've been wrestling with this for the last half hour and I can not decide
the best way to structure the database for a function I a programming
related to a shopping cart. It get's kind of crazy...

Each item can have a variable number of sizes.
Each size can have a variable upcharge attached to it.
Each item can have a variables number of price levels for different types of
customers with variable quantity breaks per price level.
All of the above is done. I am now trying to add in the sizes so that I can
set variable size/quantity discounts at different price levels.

If I totally normalize the new size table, given 500 products, 4 quantity
breaks, 4 sizes and 2 pricing levels, I end up with 16000 rows, albeit in a
very nicely indexable table. That's an extreme example for the probable use
of the software, but I want to make sure it doesn't break under load either.
I know 16000 rows is not a big deal for SQL Server, but since the data in
the table will be used for displaying the item, I can see it getting hit
pretty hard.

Should I be worried about this table, or does anyone have any tips?

RDBMS == SQL Server

jon

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Updating only records checked on output page

[Dunwiddie, Bruce]

on form page:



on action page:

update tablename
where someid in (#form.record#)


-Original Message-
From: Paul Sinclair [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 07, 2001 10:10 AM
To: CF-Talk
Subject: Updating only records checked on output page


I have an output page that may have dozens or hundreds of records on it.
I want to put all the records into a single form with a checkbox by each
record so that a user can: edit any or all records on the page; click
the checkbox to identify the records modified; and submit the form to a
page that will loop through all the checked records and update them. I
think this is an easy thing but I have some kind of mental block
preventing me from figuring it out!

The output page is something like this:


~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFFile Replacment

[Dunwiddie, Bruce]

silly question, but wouldn't the name you're looking for be the value of the
form element you used to upload the file?

-Original Message-
From: Mike Townend [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 06, 2001 12:28 PM
To: CF-Talk
Subject: RE: CFFile Replacment


Yes I have all that code done... The problem is if someone uploads a
file called header.gif I get passed the name of the temporary file that
is create ie c:\winnt\acer33.gif this I can then move etc... But how can
I get hold of header.gif so that when I do the move the destination name
is called header.gif


Thankx in advance

Mike



-Original Message-
From: Robert Everland [mailto:[EMAIL PROTECTED]] 
Sent: 06 December 2001 18:14
To: CF-Talk
Subject: RE: CFFile Replacment


Is it a Windows computer. If so you can use Active X objects to read the
file. 

Robert Everland III
Dixon Ticonderoga
Web Developer Extraordinaire

-Original Message-
From: Mike Townend [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 06, 2001 1:11 PM
To: CF-Talk
Subject: RE: CFFile Replacment


Sorry What im trying to do is allow file uploading when the
administrator has disabled the CFFILE tag... I can get the file to the
destination OK however I cannot find a way of working out what the
original file was called...


So I need to find the Orginal name of the file that is uploaded without
using CFFIle


Thanx in advance




-Original Message-
From: Bryan Love [mailto:[EMAIL PROTECTED]] 
Sent: 05 December 2001 19:24
To: CF-Talk
Subject: RE: CFFile Replacment


after doing the upload:
#file.serverFile# for the whole thing with extension

+




~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: How do u prevent pages from caching or how do u auto-refresh pages?

[Dunwiddie, Bruce]

Click here

just add a "?" to the end of the url in either the cflocation or the
hyperlink if you're getting to that page in one of those ways. honestly, the
don't cache stuff doesn't work all that well and this fits situations.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 19, 2001 7:40 PM
To: CF-Talk
Subject: How do u prevent pages from caching or how do u auto-refresh
pages?


Does anyone know how to prevent pages from caching in a browser?

Or how to refresh pages in a manner that works in all the browsers? By
refresh I don't mean you massage the page visualizing a Swedish model, but
rather the page is reloaded along with any new versions of graphic files
that have the same file name.

Ideally a CF solution would be better, since some folks may not have
javascript, but I'm open to anything that works.

Thanks,
Pardeep.

~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: LT Function

[Dunwiddie, Bruce]

q_createRecordSet.INFLOW NEQ ""

dunno about the rest, but this should be NOT q_createRecordSet.INFLOW IS ""

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 30, 2001 12:36 PM
To: CF-Talk
Subject: RE: LT Function


> The values I am checking are int Datatypes,
> 
> this is exactly what I'm doing
> 
> 
>   
>   
>   
>   
>   
>   
>   
>   
>   
> 

Are you sure that rtrim(q_createRecordSet.INFLOW) is numeric? You might want
to wrap it in Val() and see what happens.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496

~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Excel as a datasource .... ?

[Dunwiddie, Bruce]

try caching the tables so the time to pull off the queries goes down
dramatically.

-Original Message-
From: Dan Phillips [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 05, 2001 10:15 AM
To: CF-Talk
Subject: RE: Excel as a datasource  ?


I agree. Down the road it's going to be a nightmare especially if you have
server issues now. Sure for a month or two it would be ok but as that excel
file gets bigger and bigger you will run into trouble. Excel and Access are
just not meant for high traffic web sites. We don't charge people more to
use access but we make them keep the file below 20MB in size and we do not
allow Excel datasources. There is a small memory leak in Access that can
cause long term problems. I've never used Excel myself as a datasource but I
can only assume you would get the same results. IMHO, Access and Excel are
good for desktop apps only. I mean, I could eat of off a frisbee instead of
a plate and it would work but that doesn't mean I should do it.

Just my $0.02

Dan Phillips
CFXHosting.com

-Original Message-
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 05, 2001 10:04 AM
To: CF-Talk
Subject: Re: Excel as a datasource  ?


excel as a datasource would make maintainability, scalability, and
enhancements alot harder and in the long run cost more. Actually, at one
place I worked at we charged more if the client wanted to use Access over
SQLServer (I assume excel as a datasource would cost even more).


On Wed, 5 Sep 2001, Mike Kear wrote:

>
> I have a client who's complaining that the time spent generating a small
app
> using SQL is costing too much and wants to use excel spreadsheets instead.
>
> What's your experience using excel as a datasource?
>
> Just to clarify what the projects do, they don't write to the datasource,
> just look up and filter the data customising tables for the user's needs.
> The volumes aren't great - between a few hundred page views a month to
5000
> or so.
>
> IS there likely to be implications for the usage of RAM and resources on
the
> server?  The System Admin is already complaining that he has to restart
the
> server too often and when the processor usage gets to 100% he panics and
> complains.
>
>
> Cheers,
> Mike Kear
> Windsor, NSW, Australia
> AFP WebWorks
>
>
>
>
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Browser client for upload files?

[Dunwiddie, Bruce]

on submitting page... (make sure to include the enctype)




on the action page







-Original Message-
From: Willy Ray [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 05, 2001 11:49 AM
To: CF-Talk
Subject: Browser client for upload files?


Alright, the client needs to upload a PDF file.  How do I let the user
browse their machine for the file to upload? I'd like to use CFTREE, right?
I'm fuddled.

Willy
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Date as absolute integer?

[Dunwiddie, Bruce]

how about
(year - 1900) * 366 + DayOfYear()


-Original Message-
From: Tristram Charnley [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 07, 2001 8:51 AM
To: CF-Talk
Subject: Date as absolute integer?


Is there a way to return a date as an integer
a bit like DayOfYear returns the day of the year as a
number? I'm sure I've seen it done somewhere.


Tristram Charnley
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: form field parameter not recognized

[Dunwiddie, Bruce]

how about the cf server side validation of 

put that input right below the gname input and let coldfusion server handle
the rest.

-Original Message-
From: Mark [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 02, 2001 2:11 PM
To: CF-Talk
Subject: form field parameter not recognized


We're having a strange problem with form field
parameters not being recognized when being passed to a
second page even though all the code is there and the
form field is present.

Here's the code on the original page:

http://www.fancyblooms.com/test.cfm";
method="post">



... more form fields here




On the second page, test.cfm, there is a check to make
sure that the first form field, gname, is not blank. 


Error

... etc

The error that SOME visitors get is:

"Error resolving parameter FORM.GNAME. The specified
form field cannot be found  "

Now, I know the form field is there, and I can't
duplicate this error under any of the PC based
browsers we use (IE, Netscape, Opera). The only common
thing I do know is that the few people that did get
this error are using AOL 5.0 and are on the MAC
platform. 

I understand that I could use client side validation
with CFFORM to make sure these fields are not empty,
but I'm trying to avoid all the Javascript that goes
along with it. 

Is anyone familiar with this problem? Is it AOL and
MAC related? Any suggestions?

Thanks everyone!

Mark

===
http://www.fancyblooms.com
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Put into Reverse (cf_hinojosa)

[Dunwiddie, Bruce]

#newStr#

that was a fun challenge, I THINK this will work, heh.
-Original Message-
From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 30, 2001 6:04 PM
To: CF-Talk
Subject: Re: Put into Reverse (cf_hinojosa)


Guess my example was wrong, hebrew is more likely to look like this:
".sgod etah I .skrab dna riah tuo evael yehT"

which gives out (using cf_hinojosa)
"They leave out hair and barks. I hate dogs."

And THATS the same problem I get with hebrew.

Michael.

 Original Message -
From: "Hinojosa, Robert A" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, July 30, 2001 11:43 PM
Subject: RE: Put into Reverse


> This should work.
>
> 
> 
> 
> 
> 
> #newStr#
>
>
>
> -Original Message-
> From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 30, 2001 5:25 PM
> To: CF-Talk
> Subject: Put into Reverse
>
>
> I'm having difficulties reversing a long string that was written in
backward
> hebrew.
> which means it was first written from right to left AND opposite (dont
> ask...)
>
> something like:
> skrab dna riah tuo evael yehT. sgod etah I.
>
> I want to get this string back to it's straight form
> ("I hate dogs. They leave out hair and barks.").
>
> Reversing all the string won't help, neither will reversing each word and
> sticking it together (sentences won't be in order). I had limited success
> when
> trying to first split the sentences ("." as the delimter), but no 100%
> solution.
> I know this is doable, because Internet Explorer uses the Visual Encoding,
> which
> acts the same (on the same text).
>
> ! pleH
>
> leahciM
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Opening a new Window

[Dunwiddie, Bruce]

OnClick="window.open('somewhere.cfm', 'edit',
config='height=600,width=800,top=1,left=1,scrollbars=yes')"

-Original Message-
From: ronmyers [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 27, 2001 11:02 AM
To: CF-Talk
Subject: Opening a new Window


HI I am a newbie at Using CF and HTML in general, But I am having fun
learning. My problem is I am opening a new window. I know how to set the
size How do I set the location where it opens. 

Thanks 

Ron
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: annoying whitespace problem

[Dunwiddie, Bruce]

try using Link 1 | Link 2etc

-Original Message-
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 26, 2001 5:45 AM
To: CF-Talk
Subject: annoying whitespace problem


Actually, the annoyance is with CF 4.5's reducing of excess 
whitespace. When I have a block of text inside of cfoutput, it get's 
rid of the space that would be rendered by a carriage return.

As an example, I typically do text links at the bottom of a page 
something like this (sans links):

Link 1 |
Link 2 |
Link 3

Which SHOULD render as such:

Link 1 | Link 2 | Link 3

But inside of a cfoutput with reduce whitespace turned on, I get:

Link 1 |Link 2 |Link 3

Note, no space after the Pipe characters. This is stupid. I would 
think it should reduce the whitespace created by ColdFusion. Not the 
whitespace that's coded into the page.

Sorry. Just a rant. :)
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Making A Local Copy of a CF site...

[Dunwiddie, Bruce]

save the source code for each page as filename.html wherever you want it
saved.

-Original Message-
From: Dasher [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 24, 2001 1:32 PM
To: CF-Talk
Subject: Making A Local Copy of a CF site...


I need to find some way to step through
a Cold Fusion site I have, process the CFM pages,
and then save the result into a seperate folder
so I don't need CF to navigate it anymore.

Any ideas?


-- Dasher 
[EMAIL PROTECTED]
http://www.bentmedia.com/
Bent Media, Inc.
128 South Clark Street
New Orleans, LA 70119-6103
Phone - 504.488.2848 x19
Fax - 504.488.2979
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: date field

[Dunwiddie, Bruce]

cfif's and cfelse's on the 3 string conditions to check for,then on the last
else,change it to dateformat,that way it will only change it if it gets past
the conditional checks for your strings.

-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 24, 2001 1:38 PM
To: CF-Talk
Subject: date field


I have a query that returns a field that is either a date or N/A or No or
Now.  I want it to output the words if there is words and if there isnt then
do a dateformat on the date.  How can I do this?

Joshua Tipton
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Passing String In Form vs. URL

[Dunwiddie, Bruce]

maybe try a select box, that's what we normally use for such situations.

-Original Message-
From: Dave Hannum [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 24, 2001 8:56 AM
To: CF-Talk
Subject: Passing String In Form vs. URL


Hello,
I've got an interesting one.  I have a table with a column of Account Codes
values that are varied like so:

(None)
00 01 3513
09 18 4006
10 20 504618
9410
etc . . .

If I return all of the rows in the database, and make each record a link
with AcctCode=#AcctCode# and then query the database to bring back the
record

ex:  WHERE AcctCode = '#URL.AcctCode#'

it works fine.  However, the table contains about 6400 rows, so I don't want
to return all 6400 to choose from.  Thus, I want to use a form. However, if
I provide a form field where a user can type in a number (e.g. 00 01 3513)
it always returns 0 records:

ex:  WHERE AcctCode = '#FORM.AcctCode#'
OR
ex:  WHERE AcctCode LIKE '%#FORM.AcctCode#%'

Now, if they just put 00 or 01 or just 3513 into the field, it will return
any row with that combination.  So, the problem seems to be the spaces in
the string when passed in a form field.  How do I overcome this, because the
application calls for the user to just be able to enter either the complete
Account Code if they know it or, say the first four digits (i.e. 00 01) if
they know them and get all that match.

Thanks,
Dave


===
David R Hannum
Ohio University
Web Analyst/Programmer
(740) 597-2524
[EMAIL PROTECTED]
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: query headache

[Dunwiddie, Bruce]

select  qryIAPeople.*, 
tblAppIAUsers.AppID, 
tblAppIAUsers.Listing_ID
fromqryIAPeople LEFT JOIN tblAppIAUsers ON
qryIAPeople.LISTING_ID = tblAppIAUsers.Listing_ID
where   (((tblAppIAUsers.AppID) Is Null Or
(tblAppIAUsers.AppID)=#url.aid#) 
AND ((tblAppIAUsers.Listing_ID) Is Null))
AND tblAppIAUsers.AppID <> "office 2000"
ORDER BY qryIAPeople.Last_NM


As far as I understand the question, this works.

-Original Message-
From: Jones, Becky [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 20, 2001 3:42 PM
To: CF-Talk
Subject: query headache


hey,
i am trying to write a query where i would get an output of all employees
except for those that are already assigned to the chosen
application.  this works as far as it doesnt show me the users
assignedbut it doesnt give me a complete listing of everyone else.
for example, say i chose office 2000.  and i have joe and tim assigned to
it.  well, this query doesnt bring up joe or tim.  that's fine.
but it doesnt give me everyone else.  like if say sue is assigned to another
application...she wont show up in this list even though she isnt assigned to
office 2000.  get it?
i should probably post this to a sql or access group...but maybe someone out
here can help.
thanks,
bec.



SELECT qryIAPeople.*, 
tblAppIAUsers.AppID, 
tblAppIAUsers.Listing_ID
FROMqryIAPeople LEFT JOIN tblAppIAUsers ON
qryIAPeople.LISTING_ID = tblAppIAUsers.Listing_ID
WHERE (((tblAppIAUsers.AppID) Is Null Or
(tblAppIAUsers.AppID)=#url.aid#) 
AND ((tblAppIAUsers.Listing_ID) Is Null))
ORDER BY qryIAPeople.Last_NM




*
This e-mail, including any attachments, is intended for the 
receipt and use by the intended addressee(s), and may contain 
confidential and privileged information.  If you are not an intended 
recipient of this e-mail, you are hereby notified that any unauthorized 
use or distribution of this e-mail is strictly prohibited.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

input name=label_required

[Dunwiddie, Bruce]

I'm using the cold fusion error handling for a form submit to make sure the
user has entered values in a couple of the necessary fields, and it's
working well, but I'd like to change the format of the template that
coldfusion sends the user to when an error occurs. I've heard that it will
be a server-wide change,not application specific, which is fine, but where
is it and how do I set it up to get a prettier template there.

for example...


--Select a Mailing--

#name#(#DollarFormat(amt)#)





If the user tries to submit this form without selecting a shipping method,
coldfusion will output my message to them on an error page and it's that
error page that I'd like to make prettier if there's any way.

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Inserting Records

[Dunwiddie, Bruce]

try this type of code, just copied it straight from one of our projects


SET NOCOUNT ON
INSERT 
INTO dbo.T_User
VALUES (
'#CompanySiteID#',
'#form.last_name#',
'#form.first_name#',
'#form.misc_num#', 
'#form.misc_num#', 
'#form.misc_num#', 
null, 
'#form.phone#', 
'#form.fax#', 
'#form.email#', 
'#form.misc_num#', 
'1') 
select @@identity as new_id
SET NOCOUNT OFF



INSERT 
INTO dbo.T_User_Ship_To
VALUES (
'#insert.new_id#',
'#CompanySiteID#',
'#form.first_name#',
'#form.last_name#',
'#form.address1#', 
'#form.address2#', 
'#form.city#', 
'#form.state_id#', 
'#form.zip#', 
'#form.country_id#', 
'1',
'1') 


@@identity is the new id that the server created,works with SQL server

-Original Message-
From: Pooh Bear [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 20, 2001 12:34 PM
To: CF-Talk
Subject: Inserting Records


ok guys, please tell me if there is a better way of doing this.

basically i have 2 tables, the second one having a many to many 
relationship.  What I am trying to do is insert a record into the first 
table, then use the id (it's an identity field) of that row to insert into 
the second table with some other information.

The way I am doing it now is having coldfusion insert the row, then do 
another query to find the id of that row using a criteria such as email 
(which is unique anyways).  After i find the id, I do another insert into 
the second row and enter in that id along with other information.

My goal is to skip that second part, where i have to do another query just 
to get the id.  is there a way to get the id automatically after it's been 
created or something like that?  I might go the route of having the DB 
return the max id created, but I am paranoid that before it even starts to 
get the id, another record has already been inserted, and we lose 
consistency or somethin.  dunno, i know u guys do this every day so how do u

do it?
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists