CF-Wap
The CF-Wap list ran into a small problem today and had to be fixed. Its working now. And future problems with the list can be sent to: Dylan Bromby ([EMAIL PROTECTED]) Michael Dinowitz Publisher: Fusion Authority weekly news alert (www.fusionauthority.com/alert) Listmaster: CF-Talk, CF-Jobs, Spectra-Talk, Jrun-Talk, etc. (www.houseoffusion.com) __ 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: Help - MS Word outputfrom CF?
A word of warning if you go this path - if you type CF statements into
your word doc, sometimes word picks up on these and inserts them into
the document summary which then is written into the header. This can
cause CF errors when the file is created by cfcontent, and it's really
frustrating because it's hard to debug.
I've found that WordPad generates much nicer (cleaner) rtf code - like
less than a fifth of the junk I found... But it doesn't support images
in as nice a way as Word does. Someone suggested using WordPerfect but I
don't have a copy so I've never tested it.
Kay.
"Steve Oliver" <[EMAIL PROTECTED]> wrote in message
news:<01c1aae2$a97df6a0$[EMAIL PROTECTED]>...
> If you create a word document, and save it as an rtf file, then open
> it up in notepad, you'll see all the garbled junk like:
>
> {\rtf1\ansi\ansicpg1252\uc1\deff0\stshfdbch0\stshfloch0\stshfhich0\sts
> hf
>
bi0\deflang1033\deflangfe1033{\fonttbl{\f0\froman\fcharset0\fprq2{\*\pan
> ose 02020603050405020304}Times New Roman;}
>
> Using that, you could make a template file, save it as an rtf, then
> paste it into your template, and then place your cfoutputs where you
> need to put your data. Once that is done, just output it as a doc file
> using cfcontent.
>
>
>
> {\rtf1\ansi\ansicpg1252\uc1\ blah blah blah
>
> #myparagraph#
>
> {\fs20\insrsid6363204 \tab \tab \tab
> }{\fs20\insrsid6363204\charrsid6363204
> \par }}
>
> __
> steve oliver
> atnet solutions, inc.
> http://www.atnetsolutions.com
>
>
> -Original Message-
> From: Ed Gordon [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 01, 2002 12:30 AM
> To: CF-Talk
> Subject: Help - MS Word outputfrom CF?
>
>
> After the users put in parameters to generate a "quote" and the
> customer says 'yes', I need to generate a whole big document,
> including standard paragraphs,
> and other sections of text inserted based on various aspects of the
> sale.
>
> This is now all done by hand in MS Word. I can get all the parts (text
> paragraphs), but how do I then have CF spit out a nicely-formatted
> text document?
>
> In general, what DO people do about printed reports???!?!?! I have so
> far only
> put a printer-friendly web page out and the user prints it in his
> browser.
>
> This is supposed to be a nicely formatted printed document, an actual
> legal contract for the customer to sign. Anyone do this type of thing
> before?
>
> Thanks!
>
> Ed Gordon
> CF Developer
> [EMAIL PROTECTED]
>
>
__
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: cfselect and required=yes
One Gotcha to look out for is Netscape *does not* select an option by default in a dropdown. Kola Oyedeji Web developer Macromedia Certified Advanced ColdFusion 5 Developer ekeda ltd http://www.ekeda.co.uk (+44)020-8429-7300 > -Original Message- > From: Dave Watts [mailto:[EMAIL PROTECTED]] > Sent: 04 February 2002 19:03 > To: CF-Talk > Subject: RE: cfselect and required=yes > > > > I can never get the required attribute to work on cfselect > > is there a trick? > > Unless you create a multi-select box, any HTML SELECT, including one > generated with CFSELECT, will always have an item selected. > The REQUIRED > attribute only affects multi-select boxes. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > phone: 202-797-5496 > fax: 202-797-5444 > __ Get Your Own Dedicated Windows 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=coldfusionb 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
Neo Beta program
Anyone having difficulty logging in? __ Dedicated Windows 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=coldfusiona 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: Neo Beta program
Nope, but should be/you be discussing this - check the NDA. __ Get Your Own Dedicated Windows 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=coldfusionb 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: Neo Beta program
What NDA is that then? I haven't signed or agreed to anything YET (if I could logon to the site that would be another matter...). Bimal -Original Message- From: Neil Clark [mailto:[EMAIL PROTECTED]] Sent: 05 February 2002 10:45 To: CF-Talk Subject: RE: Neo Beta program Nope, but should be/you be discussing this - check the NDA. __ 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: Neo Beta program
:-) If you were on the alpha prog, you would have signed one... maybe your account has not been activated yet? N __ Get Your Own Dedicated Windows 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=coldfusionb 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: help! cant use multiple transaction
Oh no.. seems like no one had such an encounter before sigh... - Original Message - From: "han peng" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, February 05, 2002 9:24 AM Subject: help! cant use multiple transaction > hihi... funny things happening... > this query works fine for past few days.. > but yesterday suddenly wanted to take a break... > anyone know wats the cause..?? > hmm.. i can insert the values successfully.. but cant retrieve the new > ID inserted.. > > Error msg saying this #INSERTNEWCUSTOMER.intCustomerID#> > not found. > > > > > INSERT INTO tblCustomer > Values > ( > '#session.prospect.strTitle#', > '#session.prospect.strCustomerName#', > '#session.prospect.strStreetName#', > '#session.prospect.strFloorNumber#', > '#session.prospect.strUnitNumber#', > '#session.prospect.strBlockNumber#', > '#session.prospect.strBuildingName#', > '#session.prospect.strPostalName#', > '#session.prospect.strNRICNo#', > '#session.prospect.strHomeNo#', > '#session.prospect.strMobileNo#', > '#session.prospect.strPagerNo#', > '#session.prospect.strOfficeNo#', > '#session.prospect.strEmail#', > 'P', > '#session.prospect.strAddressType#', > NULL > ); > SELECT @@IDENTITY as intCustomerID; > SET nocount off; > > #INSERTNEWCUSTOMER.intCustomerID#> > > > __ Get Your Own Dedicated Windows 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=coldfusionb 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
Possible bug in StructFindKey() in CF Ent 4.5.1 SP-2 on Win NT4/2000 Server?
Hi folks,
Before I start, sorry the length of this post, but I'm at the end of
my tether with this one...
I've been ripping chunks of hair out over the past two days trying
to diagnose a problem with one out of two near identical blocks of
code in an application I am working on.
The code forms a small part of the set-up routine to export content
from one server for staging/syndication to another - it's essentially
an early prototype for a larger system.
The code that is troubling me basically does this:
- extracts one or more records from a content database
- loops over each record in the query result set, and
+ deserialises the WDDX-encoded structure
stored in szContent
+ searches for a particular key ("filename" in
this structure
+ adds the value contained in the filename element
to a list created outwith the loop
- loop ends
Sample (slightly simplified) structures are shown below:
IMAGE ASSET ALIGN
CAPTION
FILENAME
HEIGHT
WIDTH
FEATURE BODY
TEASER
TEASER IMAGE (embed the "IMAGE ASSET" struct above)
TITLE
Okay, looking at the simplified psuedo-code above, here's what
works:
- the database query is fine
- the loop kicks off great
+ the WDDX is deserialised back into a struct
+ an error is thrown, on the SECOND LOOP ITERATION
when StructFindKey is called and...
+ .. we don't get here
- loop crashes out
The error message is: "Cannot assign result to symbol
Variables.stAssetVersion"
where Variables.stAssetVersion is the name of the structure recreated each
time in the loop I call CFWDDX on szContent.
This is accompanied by an "error has occurred while processing the
expression
Variables.stAssetVersion=CFTempOnlyForSetVariableNeverUseThisNameInYourCFMLC
ode
1223335654321" which we all know and love...
I know it's not CFWDDX which is causing it (despite the error message above)
because I can remove all the code following it, replace it with a CF_DUMP (a
custom tag we use for CF 4.5 based on CFA_DUMP in Spectra) and it shows me
a struct - not WDDX.
The error is only introduced when I call StructFindKey. Bizarrely though, it
works the first time round throwing the error on the second loop iteration.
Is StructFindKey somehow locking the struct it searches through and not
releasing.
I have replaced the call to StructFindKey with a collection loop which
basically
does the same job and even creates the same array/struct combo such that the
code
below the (replaced) call to StructFindKey works as expected.
Now for the real killer, this loop is performed twice - once for the
"content
created" query and the second time for the "content modified" query. The
loop
including StructFindKey _always_ works for the modified content, but it
_always_ fails for the created content.
I've tried swapping the loops around (doing the created loop before and
after
the modified loop but to no avail); I've stripped all the code right back
removing all but the call to CFWDDX and StructFindKey; I've tried locking
the
code obsessively; I've switched CF to "Single Threaded Sessions" and that
made
no difference; I've removed the "modified" loop so it's only the "created"
loop which runs; I've serialised the query results into WDDX, stored them in
files and read these in before the loop in case the query was somehow
affecting
it. The final straw - I moved the test files (which use the WDDX queries,
not the database) to a different dev location with a new Application.cfm to
ensure that the app was not somehow affecting the loops and that still
didn't
work.
I moved my test package to a different server I had access to (WinNT Server,
same version of CF) and it failed there too...
I've got a workaround for the problem using my manual "struct find key" but
that
limits its flexibility as it only handles one nested struct level - I don't
want to write a recursive custom tag (or UDF for CF5 which I've not
installed
yet) for something that looks like a bug in CF 4.5.1 SP-2.
I've searched Macromedia, the Knowledge Base, the Forums, the CF-Talk
archive
and Google Groups but I seem to be pretty much alone in this one.
Would anyone (a) have any ideas on what is going on and how to fix it and/or
(b) be prepared to take a look at my test package (which I can supply if
needed) to see if it affects you too?
Thanks in advance,
Colin
P.S. Sorry again for the length of this post!
__
Get Your Own Dedicated Windows 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=co
ColdFusion 5 Studio Release Candidate x Actual Version
Does anyone of you who had participated the ColdFusion Studio 5 Beta Program know if there are (and what are) any differences between the ColdFusion Studio 5 Release Candidate and the actual version ? Thanks. Waldemiro Junior __ 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: Deleting entries from database
Hi,
I have the following code that inserts fields into my database.
Delete into profile
(profile_ID, env_var, destination)
VALUES
('#FORM.profile_ID#', '#FORM.env_var#', '#FORM.destination#')
I would also like to delete entries. Whats the syntax to do so?
__
Dedicated Windows 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=coldfusiona
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: Deleting entries from database
The syntax is incorrect: INSERT INTO ...
For DELETE:
DELETE FROM table
WHERE your filters
PS don't forget the filters or you delete every record in the table
-Original Message-
From: phumes1 [mailto:[EMAIL PROTECTED]]
Sent: dinsdag 5 februari 2002 14:05
To: CF-Talk
Subject: re: Deleting entries from database
Hi,
I have the following code that inserts fields into my database.
Delete into profile
(profile_ID, env_var, destination)
VALUES
('#FORM.profile_ID#', '#FORM.env_var#', '#FORM.destination#')
I would also like to delete entries. Whats the syntax to do so?
__
Dedicated Windows 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=coldfusiona
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: ColdFusion 5 Studio Release Candidate x Actual Version
Well, for starters, I could set a RDS directory as a favorite and have it work properly in the RC, but in final it won't go to that specific directory, just the root. A right pissah, that. Pete __ Get Your Own Dedicated Windows 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=coldfusionb 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: Deleting entries from database
OK..so I have a anchor from my index.cfm file which does a listing of all
the fields from the database.
[Delete]
By clicking on the "Delete" link the variables are passed to another form
that I want to perform the delete function.
I'm stuck in the WHERE ... I don't want to delete every record!
Delete from profile
(profile_ID, env_var, destination)
WHERE ???
At 02:05 PM 2/5/2002 +0100, you wrote:
>The syntax is incorrect: INSERT INTO ...
>
>For DELETE:
>DELETE FROM table
>WHERE your filters
>
>PS don't forget the filters or you delete every record in the table
>
>-Original Message-
>From: phumes1 [mailto:[EMAIL PROTECTED]]
>Sent: dinsdag 5 februari 2002 14:05
>To: CF-Talk
>Subject: re: Deleting entries from database
>
>
>Hi,
>
>I have the following code that inserts fields into my database.
>
>
> Delete into profile
> (profile_ID, env_var, destination)
> VALUES
> ('#FORM.profile_ID#', '#FORM.env_var#', '#FORM.destination#')
>
>
>
>I would also like to delete entries. Whats the syntax to do so?
>
>
__
Get Your Own Dedicated Windows 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=coldfusionb
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: Groove
Groove ROCKS. I have done a bunch of projects using Groove as the main contact medium, and it works great. Sure, it's not perfect, but it's better than building your own tool. Loads of really useful functionality, esp. the document sharing, shared browing, and threaded discussion. If you're working on a project that has people with dissimilar schedules on it, you should try it. Pete __ Get Your Own Dedicated Windows 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=coldfusionb 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: Deleting entries from database
You are passing URL.PID to the page. SO:
DELETE FROM profile
WHERE profile_ID =
This assuming profile_ID is a VARCHAR
-Original Message-
From: phumes1 [mailto:[EMAIL PROTECTED]]
Sent: dinsdag 5 februari 2002 14:23
To: CF-Talk
Subject: RE: Deleting entries from database
OK..so I have a anchor from my index.cfm file which does a listing of
all
the fields from the database.
[Delete]
By clicking on the "Delete" link the variables are passed to another
form
that I want to perform the delete function.
I'm stuck in the WHERE ... I don't want to delete every record!
Delete from profile
(profile_ID, env_var, destination)
WHERE ???
At 02:05 PM 2/5/2002 +0100, you wrote:
>The syntax is incorrect: INSERT INTO ...
>
>For DELETE:
>DELETE FROM table
>WHERE your filters
>
>PS don't forget the filters or you delete every record in the table
>
>-Original Message-
>From: phumes1 [mailto:[EMAIL PROTECTED]]
>Sent: dinsdag 5 februari 2002 14:05
>To: CF-Talk
>Subject: re: Deleting entries from database
>
>
>Hi,
>
>I have the following code that inserts fields into my database.
>
>
> Delete into profile
> (profile_ID, env_var, destination)
> VALUES
> ('#FORM.profile_ID#', '#FORM.env_var#', '#FORM.destination#')
>
>
>
>I would also like to delete entries. Whats the syntax to do so?
>
>
__
Dedicated Windows 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=coldfusiona
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: Groove
Sounds interesting, got a URL? -Original Message- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]] Sent: 05 February 2002 13:25 To: CF-Talk Subject: Re: Groove Groove ROCKS. I have done a bunch of projects using Groove as the main contact medium, and it works great. Sure, it's not perfect, but it's better than building your own tool. Loads of really useful functionality, esp. the document sharing, shared browing, and threaded discussion. If you're working on a project that has people with dissimilar schedules on it, you should try it. Pete __ Dedicated Windows 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=coldfusiona 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: Groove
http://www.groove.net -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 05, 2002 8:19 AM To: CF-Talk Subject: RE: Groove Sounds interesting, got a URL? -Original Message- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]] Sent: 05 February 2002 13:25 To: CF-Talk Subject: Re: Groove Groove ROCKS. I have done a bunch of projects using Groove as the main contact medium, and it works great. Sure, it's not perfect, but it's better than building your own tool. Loads of really useful functionality, esp. the document sharing, shared browing, and threaded discussion. If you're working on a project that has people with dissimilar schedules on it, you should try it. Pete __ Get Your Own Dedicated Windows 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=coldfusionb 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: ColdFusion 5 Studio Release Candidate x Actual Version
Bets to speak to one of the Engineers. That would be your best bet I think. Neil __ Dedicated Windows 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=coldfusiona 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
OT: Anybody heard of this?
I has some spam in my email this morning. It immediately popped me to a porn site. What it did though, was reset my start page through their server, and I now, cannot reset my start page. It's greyed out. The URL of this scum company is: http://www.duolaimi.net (don't click on the URL) My start page URL now looks like http://www.duolaimi.net/d.asp?http://myURLhere.com If I go into Internet Options, it does not allow me to change the Start Page settings. What's the fix for this? Anybody know? Thanks, Dave === David R Hannum Ohio University Web Analyst/Programmer (740) 597-2524 [EMAIL PROTECTED] "If your wife is having fun and you're not, you're still having a lot more fun than if you're having fun and she's not!' - Red Green __ Get Your Own Dedicated Windows 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=coldfusionb 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: Anybody heard of this?
oi Dave!! can you not change it thru the registry? -- Critter, MMCP Certified ColdFusion Developer Crit[s2k] - - Tuesday, February 5, 2002, 8:41:46 AM, you wrote: DH> I has some spam in my email this morning. It immediately popped me to a DH> porn site. What it did though, was reset my start page through their DH> server, and I now, cannot reset my start page. It's greyed out. The URL of DH> this scum company is: DH> http://www.duolaimi.net (don't click on the URL) DH> My start page URL now looks like DH> http://www.duolaimi.net/d.asp?http://myURLhere.com DH> If I go into Internet Options, it does not allow me to change the Start Page DH> settings. What's the fix for this? Anybody know? DH> Thanks, DH> Dave DH> === DH> David R Hannum DH> Ohio University DH> Web Analyst/Programmer DH> (740) 597-2524 DH> [EMAIL PROTECTED] DH> "If your wife is having fun and you're not, DH> you're still having a lot more fun than if you're DH> having fun and she's not!' - Red Green DH> __ Get Your Own Dedicated Windows 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=coldfusionb 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: Anybody heard of this?
Dave, Found this on Google, though I didn't have the key (probably a different version of IE): [HKEY_CURRENT_USER\Software\Policies\Microsoft\Internet Explorer\Control Panel] Double-click the "HomePage" value and change it to "00 00 00 00" Also, you can manually change the start page back via the reg by going to HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\Main and changing the value of "Start Page" to whatever you want it to be. HTH, JC -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 05, 2002 8:42 AM To: CF-Talk Subject: OT: Anybody heard of this? I has some spam in my email this morning. It immediately popped me to a porn site. What it did though, was reset my start page through their server, and I now, cannot reset my start page. It's greyed out. The URL of this scum company is: http://www.duolaimi.net (don't click on the URL) My start page URL now looks like http://www.duolaimi.net/d.asp?http://myURLhere.com If I go into Internet Options, it does not allow me to change the Start Page settings. What's the fix for this? Anybody know? Thanks, Dave === David R Hannum Ohio University Web Analyst/Programmer (740) 597-2524 [EMAIL PROTECTED] "If your wife is having fun and you're not, you're still having a lot more fun than if you're having fun and she's not!' - Red Green __ Dedicated Windows 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=coldfusiona 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: Deleting entries from database
Thanks...its works. Problem I'm having now is duplicate entires with the
same ID in my database if I add 2-3 identical entries.
I was having trouble adding entries before when the Profile_ID was set to
No duplicates.
At 02:25 PM 2/5/2002 +0100, you wrote:
>You are passing URL.PID to the page. SO:
>
>DELETE FROM profile
>WHERE profile_ID = value="#URL.PID#">
>
>This assuming profile_ID is a VARCHAR
>
>-Original Message-
>From: phumes1 [mailto:[EMAIL PROTECTED]]
>Sent: dinsdag 5 februari 2002 14:23
>To: CF-Talk
>Subject: RE: Deleting entries from database
>
>
>OK..so I have a anchor from my index.cfm file which does a listing of
>all
>the fields from the database.
>
>HREF="env_delete_action.cfm?PID=#GetEnv.Profile_ID#&DID=#GetEnv.env
>_va
>r#&DEST=#GetEnv.destination#">[Delete]
>
>
>By clicking on the "Delete" link the variables are passed to another
>form
>that I want to perform the delete function.
>I'm stuck in the WHERE ... I don't want to delete every record!
>
>
> Delete from profile
> (profile_ID, env_var, destination)
> WHERE ???
>
>
>At 02:05 PM 2/5/2002 +0100, you wrote:
> >The syntax is incorrect: INSERT INTO ...
> >
> >For DELETE:
> >DELETE FROM table
> >WHERE your filters
> >
> >PS don't forget the filters or you delete every record in the table
> >
> >-Original Message-
> >From: phumes1 [mailto:[EMAIL PROTECTED]]
> >Sent: dinsdag 5 februari 2002 14:05
> >To: CF-Talk
> >Subject: re: Deleting entries from database
> >
> >
> >Hi,
> >
> >I have the following code that inserts fields into my database.
> >
> >
> > Delete into profile
> > (profile_ID, env_var, destination)
> > VALUES
> > ('#FORM.profile_ID#', '#FORM.env_var#', '#FORM.destination#')
> >
> >
> >
> >I would also like to delete entries. Whats the syntax to do so?
> >
> >
>
>
__
Get Your Own Dedicated Windows 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=coldfusionb
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: Possible bug in StructFindKey() in CF Ent 4.5.1 SP-2 on Win NT4/2000 Server?
> The error message is: "Cannot assign result to symbol > Variables.stAssetVersion" > where Variables.stAssetVersion is the name of the structure > recreated each > time in the loop I call CFWDDX on szContent. Can you show us the code please? > I know it's not CFWDDX which is causing it (despite the error > message above) > because I can remove all the code following it, replace it > with a CF_DUMP (a > custom tag we use for CF 4.5 based on CFA_DUMP in Spectra) > and it shows me > a struct - not WDDX. That's because cfa_dump is smart enough to detect wddx and auto-deserialize it. So when you dump wddx, you will see the 'real' form of it. Please share the code - what you can anyway! === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda __ Dedicated Windows 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=coldfusiona 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: Anybody heard of this?
Dave Hannum wrote: > > If I go into Internet Options, it does not allow me to change the Start Page > settings. What's the fix for this? Anybody know? http://ftp.mozilla.org/pub/mozilla/releases/mozilla0.9.8/mozilla-win32-0.9.8-installer.exe Or just search for it in the registry and change it there. Jochem __ Get Your Own Dedicated Windows 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=coldfusionb 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: Anybody heard of this?
Do a search on google groups and you'll see a few other people have the same problem: http://groups.google.com/groups?q=duolaimi.net/d.asp%3Fhttp&hl=en&selm=122d501c1ad32%24a35ebeb0%2435ef2ecf%40TKMSFTNGXA11&rnum=1 I'd run regedit and search for that string in your registry... be interesting to see what pops up... jim On Tuesday, February 05, 2002, Dave wrote: DH> server, and I now, cannot reset my start page. It's greyed out. The URL of DH> this scum company is: DH> http://www.duolaimi.net (don't click on the URL) DH> My start page URL now looks like DH> http://www.duolaimi.net/d.asp?http://myURLhere.com __ Get Your Own Dedicated Windows 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=coldfusionb 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: Using CFTRY - CFCATCH to rollback database tranaction
The 4.5.2 documentation has an example of what you want to do, by using cft ransaction with cftry/catch Look at the usage example in the tag descripti on for cftransaction. Chris Norloff -- Original Message -- from: "mark kecko" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] date: Mon, 4 Feb 2002 14:40:41 -0500 >Is there a way to use CFTRY - CFCATCH to rollback all database tranactions >within given block? In otherwords, If I'm running 4 update queries and th e >first three are ok but the last one fails I want to roll them all back. I s >there a better way to do this than usign CFTRY - CFCATCH? > >Mark Kecko >Technology Director >MediaPost Communications >[EMAIL PROTECTED] >http://www.mediapost.com >(203)222-0330 ext309 > __ Dedicated Windows 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=coldfusiona 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: Using CFTRY - CFCATCH to rollback database tranaction
The 4.5.2 documentation has an example of what you want to do, by using cft ransaction with cftry/catch Look at the usage example in the tag descripti on for cftransaction. Chris Norloff -- Original Message -- from: "mark kecko" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] date: Mon, 4 Feb 2002 14:40:41 -0500 >Is there a way to use CFTRY - CFCATCH to rollback all database tranactions >within given block? In otherwords, If I'm running 4 update queries and th e >first three are ok but the last one fails I want to roll them all back. I s >there a better way to do this than usign CFTRY - CFCATCH? > >Mark Kecko >Technology Director >MediaPost Communications >[EMAIL PROTECTED] >http://www.mediapost.com >(203)222-0330 ext309 > __ Get Your Own Dedicated Windows 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=coldfusionb 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
Access stored procedure
I remember there be an article before where someone used Access view and used the cfstoredproc tag, anyone know where that article is? Robert Everland III Dixon Ticonderoga __ Get Your Own Dedicated Windows 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=coldfusionb 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
date format
Hello, I know this is an easy one, but I can't get it to work. How can I have the current date display as Month, Day, Year? The DateFormat parameter doesn't accept a mask as one CF book reads: #DateFormat(Now," dd, ")# Any help appreciated. Thanks. Robert O. __ Get Your Own Dedicated Windows 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=coldfusionb 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
Updating Database Date using Coldfusion
Hi
I am trying to update records in my oracle database table and am receiving
the following error
Error Occurred While Processing Request
Error Diagnostic Information
Oracle Error Code = 1747
ORA-01747: invalid user.table.column, table.column, or column
specification
The error occurred while processing an element with a general
identifier of (CFQUERY), occupying document position (33:1) to (33:60).
Any ideas on what is causing this from the code below which I am using to
update the data...
UPDATE whatson
SET storydate = TO_DATE ('#formatted_date#', 'MM/DD/'),
eventexpires = TO_DATE ('#format_date#', 'MM/DD/'),
location ='#form.location#',
longtitle ='#form.longtitle#',
telephone ='#form.telephone#',
email ='#form.email#',
url ='#form.url#',
eventsummary ='#form.eventsummary#',
'#file.serverFile#'NULL
WHERE eventid = #form.eventid#
DECLARE new_text LONG;
BEGIN
new_text := '#content#';
UPDATE whatson
SET description = new_text
WHERE eventid = #eventid# and location = '#location#' and homepagetitle =
'#homepagetitle#' and telephone = '#telephone#' and email = '#email#' and
longtitle = '#longtitle#' and url = '#url#' and imgsrc = '#imgsrc#' and
eventsummary = '#eventsummary#' and eventexpires =
TO_DATE('#format_date#', 'MM/DD/') and eventdate =
TO_DATE('#formatted_date#', 'MM/DD/');
END;
Ian
__
Get Your Own Dedicated Windows 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=coldfusionb
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: Deleting entries from database
You have to define Profile_ID as Primary Key.
-Original Message-
From: phumes1 [mailto:[EMAIL PROTECTED]]
Sent: dinsdag 5 februari 2002 14:54
To: CF-Talk
Subject: RE: Deleting entries from database
Thanks...its works. Problem I'm having now is duplicate entires with the
same ID in my database if I add 2-3 identical entries.
I was having trouble adding entries before when the Profile_ID was set
to
No duplicates.
At 02:25 PM 2/5/2002 +0100, you wrote:
>You are passing URL.PID to the page. SO:
>
>DELETE FROM profile
>WHERE profile_ID = value="#URL.PID#">
>
>This assuming profile_ID is a VARCHAR
>
>-Original Message-
>From: phumes1 [mailto:[EMAIL PROTECTED]]
>Sent: dinsdag 5 februari 2002 14:23
>To: CF-Talk
>Subject: RE: Deleting entries from database
>
>
>OK..so I have a anchor from my index.cfm file which does a listing of
>all
>the fields from the database.
>
>HREF="env_delete_action.cfm?PID=#GetEnv.Profile_ID#&DID=#GetEnv.en
v
>_va
>r#&DEST=#GetEnv.destination#">[Delete]
>
>
>By clicking on the "Delete" link the variables are passed to another
>form
>that I want to perform the delete function.
>I'm stuck in the WHERE ... I don't want to delete every record!
>
>
> Delete from profile
> (profile_ID, env_var, destination)
> WHERE ???
>
>
>At 02:05 PM 2/5/2002 +0100, you wrote:
> >The syntax is incorrect: INSERT INTO ...
> >
> >For DELETE:
> >DELETE FROM table
> >WHERE your filters
> >
> >PS don't forget the filters or you delete every record in the table
> >
> >-Original Message-
> >From: phumes1 [mailto:[EMAIL PROTECTED]]
> >Sent: dinsdag 5 februari 2002 14:05
> >To: CF-Talk
> >Subject: re: Deleting entries from database
> >
> >
> >Hi,
> >
> >I have the following code that inserts fields into my database.
> >
> >
> > Delete into profile
> > (profile_ID, env_var, destination)
> > VALUES
> > ('#FORM.profile_ID#', '#FORM.env_var#',
'#FORM.destination#')
> >
> >
> >
> >I would also like to delete entries. Whats the syntax to do so?
> >
> >
>
>
__
Dedicated Windows 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=coldfusiona
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 format
#dateformat(now(), " dd, ")# -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 05, 2002 9:03 AM To: CF-Talk Subject: date format Hello, I know this is an easy one, but I can't get it to work. How can I have the current date display as Month, Day, Year? The DateFormat parameter doesn't accept a mask as one CF book reads: #DateFormat(Now," dd, ")# Any help appreciated. Thanks. Robert O. __ Get Your Own Dedicated Windows 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=coldfusionb 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 format
#dateformat(now()," dd, ")# -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED]] Sent: dinsdag 5 februari 2002 15:03 To: CF-Talk Subject: date format Hello, I know this is an easy one, but I can't get it to work. How can I have the current date display as Month, Day, Year? The DateFormat parameter doesn't accept a mask as one CF book reads: #DateFormat(Now," dd, ")# Any help appreciated. Thanks. Robert O. __ Get Your Own Dedicated Windows 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=coldfusionb 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: Help - MS Word outputfrom CF?
Yes, that's one way of doing things, but if you just generate a HTML doc
for later printing by word, then you can format it any way you want -
images, colors, tables - as much information as you want and without
having to jump through hoops to make it look right. But your needs may
be different than mine. :-)
- Matt Small
-Original Message-
From: Kay Smoljak [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 05, 2002 4:12 AM
To: CF-Talk
Subject: Re: Help - MS Word outputfrom CF?
A word of warning if you go this path - if you type CF statements into
your word doc, sometimes word picks up on these and inserts them into
the document summary which then is written into the header. This can
cause CF errors when the file is created by cfcontent, and it's really
frustrating because it's hard to debug.
I've found that WordPad generates much nicer (cleaner) rtf code - like
less than a fifth of the junk I found... But it doesn't support images
in as nice a way as Word does. Someone suggested using WordPerfect but I
don't have a copy so I've never tested it.
Kay.
"Steve Oliver" <[EMAIL PROTECTED]> wrote in message
news:<01c1aae2$a97df6a0$[EMAIL PROTECTED]>...
> If you create a word document, and save it as an rtf file, then open
> it up in notepad, you'll see all the garbled junk like:
>
> {\rtf1\ansi\ansicpg1252\uc1\deff0\stshfdbch0\stshfloch0\stshfhich0\sts
> hf
>
bi0\deflang1033\deflangfe1033{\fonttbl{\f0\froman\fcharset0\fprq2{\*\pan
> ose 02020603050405020304}Times New Roman;}
>
> Using that, you could make a template file, save it as an rtf, then
> paste it into your template, and then place your cfoutputs where you
> need to put your data. Once that is done, just output it as a doc file
> using cfcontent.
>
>
>
> {\rtf1\ansi\ansicpg1252\uc1\ blah blah blah
>
> #myparagraph#
>
> {\fs20\insrsid6363204 \tab \tab \tab
> }{\fs20\insrsid6363204\charrsid6363204
> \par }}
>
> __
> steve oliver
> atnet solutions, inc.
> http://www.atnetsolutions.com
>
>
> -Original Message-
> From: Ed Gordon [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 01, 2002 12:30 AM
> To: CF-Talk
> Subject: Help - MS Word outputfrom CF?
>
>
> After the users put in parameters to generate a "quote" and the
> customer says 'yes', I need to generate a whole big document,
> including standard paragraphs,
> and other sections of text inserted based on various aspects of the
> sale.
>
> This is now all done by hand in MS Word. I can get all the parts (text
> paragraphs), but how do I then have CF spit out a nicely-formatted
> text document?
>
> In general, what DO people do about printed reports???!?!?! I have so
> far only
> put a printer-friendly web page out and the user prints it in his
> browser.
>
> This is supposed to be a nicely formatted printed document, an actual
> legal contract for the customer to sign. Anyone do this type of thing
> before?
>
> Thanks!
>
> Ed Gordon
> CF Developer
> [EMAIL PROTECTED]
>
>
__
Get Your Own Dedicated Windows 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=coldfusionb
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 format
DateFormat(Now(), ",dd,") -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED]] Sent: 05 February 2002 14:03 To: CF-Talk Subject: date format Hello, I know this is an easy one, but I can't get it to work. How can I have the current date display as Month, Day, Year? The DateFormat parameter doesn't accept a mask as one CF book reads: #DateFormat(Now," dd, ")# Any help appreciated. Thanks. Robert O. __ Get Your Own Dedicated Windows 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=coldfusionb 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 format
This should do the trick! #DateFormat(Now(), " dd, ")# Good Luck Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder - Original Message - From: "Robert Orlini" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, February 05, 2002 8:03 AM Subject: date format > Hello, > > I know this is an easy one, but I can't get it to work. How can I have > the current date display as Month, Day, Year? The DateFormat parameter > doesn't accept a mask as one CF book reads: #DateFormat(Now," dd, > ")# > > Any help appreciated. Thanks. > > Robert O. > __ Get Your Own Dedicated Windows 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=coldfusionb 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 format
clarification: Now() is a function. Now is a variable. In the case of your error -- the variable the parser was looking for, 'Now' did not exist. > -Original Message- > From: Martin Sutton [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, February 05, 2002 06:13 > To: CF-Talk > Subject: RE: date format > > > DateFormat(Now(), ",dd,") > > -Original Message- > From: Robert Orlini [mailto:[EMAIL PROTECTED]] > Sent: 05 February 2002 14:03 > To: CF-Talk > Subject: date format > > > Hello, > > I know this is an easy one, but I can't get it to work. How can I have > the current date display as Month, Day, Year? The DateFormat parameter > doesn't accept a mask as one CF book reads: #DateFormat(Now," dd, > ")# > > Any help appreciated. Thanks. > > Robert O. > > __ Dedicated Windows 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=coldfusiona 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 Database Date using Coldfusion
Could it be the ' around the the formatted date in your update?
SET storydate = TO_DATE ('#formatted_date#', 'MM/DD/'),
Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector - Commerce Builder
> Hi
>
> I am trying to update records in my oracle database table and am receiving
> the following error
>
> Error Occurred While Processing Request
> Error Diagnostic Information
> Oracle Error Code = 1747
>
> ORA-01747: invalid user.table.column, table.column, or column
> specification
>
>
>
>
> The error occurred while processing an element with a general
> identifier of (CFQUERY), occupying document position (33:1) to (33:60).
>
>
>
>
>
> Any ideas on what is causing this from the code below which I am using to
> update the data...
>
>
>
>
> UPDATE whatson
>
> SET storydate = TO_DATE ('#formatted_date#', 'MM/DD/'),
> eventexpires = TO_DATE ('#format_date#', 'MM/DD/'),
>
> location ='#form.location#',
>
> longtitle ='#form.longtitle#',
> telephone ='#form.telephone#',
> email ='#form.email#',
> url ='#form.url#',
> eventsummary ='#form.eventsummary#',
>
>
> '#file.serverFile#'NULL
>
>
> WHERE eventid = #form.eventid#
>
>
>
>
> DECLARE new_text LONG;
> BEGIN
> new_text := '#content#';
> UPDATE whatson
> SET description = new_text
> WHERE eventid = #eventid# and location = '#location#' and homepagetitle =
> '#homepagetitle#' and telephone = '#telephone#' and email = '#email#' and
> longtitle = '#longtitle#' and url = '#url#' and imgsrc = '#imgsrc#' and
> eventsummary = '#eventsummary#' and eventexpires =
> TO_DATE('#format_date#', 'MM/DD/') and eventdate =
> TO_DATE('#formatted_date#', 'MM/DD/');
> END;
>
>
>
>
> Ian
>
>
__
Get Your Own Dedicated Windows 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=coldfusionb
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
Content Management
Anyone out there use special software for production-cycle and source-code-management other than Visual Source Safe? I've only taken a peek at MM's SiteSpring. Has anyone built a custom system for doing this? Is anyone interested in building one as a team? Just curious. Oh and also I found a pretty cool program for ~$30 bucks that's really useful for mapping out your program architecture (variables and logic branches and stuff) http://www.visual-mind.com/ ; it's kind of like natrificial software's "the brain" but it has far superior import/export capability. Just FYI -- I thought my fellow developers could get some use out of it. brendan avery 2.0 - [EMAIL PROTECTED] 310.779.2211 - santa monica, california __ Get Your Own Dedicated Windows 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=coldfusionb 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 Database Date using Coldfusion
Are you sure the problem is with the date? Do "formatted_date" and
"format_date" have a proper format? I would make sure the CF debugging
is
on, then you can see the SQL being sent and try in in SQL Plus or TOAD.
(If
you don't have TOAD go to www.quest.com. It compares to SQL+ like CF
Studio
to Notepad.)
-Original Message-
From: Ian Vaughan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 05, 2002 9:04 AM
To: CF-Talk
Subject: Updating Database Date using Coldfusion
Hi
I am trying to update records in my oracle database table and am
receiving
the following error
Error Occurred While Processing Request
Error Diagnostic Information
Oracle Error Code = 1747
ORA-01747: invalid user.table.column, table.column, or column
specification
The error occurred while processing an element with a general
identifier of (CFQUERY), occupying document position (33:1) to (33:60).
Any ideas on what is causing this from the code below which I am using
to
update the data...
UPDATE whatson
SET storydate = TO_DATE ('#formatted_date#', 'MM/DD/'),
eventexpires = TO_DATE ('#format_date#', 'MM/DD/'),
location ='#form.location#',
longtitle ='#form.longtitle#',
telephone ='#form.telephone#',
email ='#form.email#',
url ='#form.url#',
eventsummary ='#form.eventsummary#',
'#file.serverFile#'NULL
WHERE eventid = #form.eventid#
DECLARE new_text LONG;
BEGIN
new_text := '#content#';
UPDATE whatson
SET description = new_text
WHERE eventid = #eventid# and location = '#location#' and homepagetitle=
'#homepagetitle#' and telephone = '#telephone#' and email =
'#email#' and
longtitle = '#longtitle#' and url = '#url#' and imgsrc =
'#imgsrc#' andeventsummary = '#eventsummary#' and
eventexpires=TO_DATE('#format_date#', 'MM/DD/') and eventdate=
TO_DATE('#formatted_date#', 'MM/DD/');
END;
Ian
__
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: Anybody heard of this?
Thanks John. When these scum bags hit, it makes me wish I could send about 10K volts through the net to their servers! LOL POW! Blast 'em into a billion pieces!8-) Dave - Original Message - From: "John Cummings" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, February 05, 2002 8:51 AM Subject: RE: Anybody heard of this? Dave, Found this on Google, though I didn't have the key (probably a different version of IE): [HKEY_CURRENT_USER\Software\Policies\Microsoft\Internet Explorer\Control Panel] Double-click the "HomePage" value and change it to "00 00 00 00" Also, you can manually change the start page back via the reg by going to HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\Main and changing the value of "Start Page" to whatever you want it to be. HTH, JC -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 05, 2002 8:42 AM To: CF-Talk Subject: OT: Anybody heard of this? I has some spam in my email this morning. It immediately popped me to a porn site. What it did though, was reset my start page through their server, and I now, cannot reset my start page. It's greyed out. The URL of this scum company is: http://www.duolaimi.net (don't click on the URL) My start page URL now looks like http://www.duolaimi.net/d.asp?http://myURLhere.com If I go into Internet Options, it does not allow me to change the Start Page settings. What's the fix for this? Anybody know? Thanks, Dave = David R Hannum Ohio University Web Analyst/Programmer (740) 597-2524 [EMAIL PROTECTED] "If your wife is having fun and you're not, you're still having a lot more fun than if you're having fun and she's not!' - Red Green __ Dedicated Windows 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=coldfusiona 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: Deleting entries from database
I have but then when I try to save the database it won't let me. Keeps
saying "Changes to the table you requested were not successful because they
would create duplicate values in the index, primary key or relationship.
Change the data in the firld or fields that contain duplicate data, remove
the index, or redefine the index to permit duplicate entries and try again"
The only way I can get it to save is to remove the Primary Key.
Field Name Data Type
--
profile_ID Text
env_var Text
destination Text
At 03:08 PM 2/5/2002 +0100, you wrote:
>You have to define Profile_ID as Primary Key.
>
>-Original Message-
>From: phumes1 [mailto:[EMAIL PROTECTED]]
>Sent: dinsdag 5 februari 2002 14:54
>To: CF-Talk
>Subject: RE: Deleting entries from database
>
>
>Thanks...its works. Problem I'm having now is duplicate entires with the
>
>same ID in my database if I add 2-3 identical entries.
>
>I was having trouble adding entries before when the Profile_ID was set
>to
>No duplicates.
>
>
>
>At 02:25 PM 2/5/2002 +0100, you wrote:
> >You are passing URL.PID to the page. SO:
> >
> >DELETE FROM profile
> >WHERE profile_ID = >value="#URL.PID#">
> >
> >This assuming profile_ID is a VARCHAR
> >
> >-Original Message-
> >From: phumes1 [mailto:[EMAIL PROTECTED]]
> >Sent: dinsdag 5 februari 2002 14:23
> >To: CF-Talk
> >Subject: RE: Deleting entries from database
> >
> >
> >OK..so I have a anchor from my index.cfm file which does a listing of
> >all
> >the fields from the database.
> >
> > >HREF="env_delete_action.cfm?PID=#GetEnv.Profile_ID#&DID=#GetEnv.en
>v
> >_va
> >r#&DEST=#GetEnv.destination#">[Delete]
> >
> >
> >By clicking on the "Delete" link the variables are passed to another
> >form
> >that I want to perform the delete function.
> >I'm stuck in the WHERE ... I don't want to delete every record!
> >
> >
> > Delete from profile
> > (profile_ID, env_var, destination)
> > WHERE ???
> >
> >
> >At 02:05 PM 2/5/2002 +0100, you wrote:
> > >The syntax is incorrect: INSERT INTO ...
> > >
> > >For DELETE:
> > >DELETE FROM table
> > >WHERE your filters
> > >
> > >PS don't forget the filters or you delete every record in the table
> > >
> > >-Original Message-
> > >From: phumes1 [mailto:[EMAIL PROTECTED]]
> > >Sent: dinsdag 5 februari 2002 14:05
> > >To: CF-Talk
> > >Subject: re: Deleting entries from database
> > >
> > >
> > >Hi,
> > >
> > >I have the following code that inserts fields into my database.
> > >
> > >
> > > Delete into profile
> > > (profile_ID, env_var, destination)
> > > VALUES
> > > ('#FORM.profile_ID#', '#FORM.env_var#',
>'#FORM.destination#')
> > >
> > >
> > >
> > >I would also like to delete entries. Whats the syntax to do so?
> > >
> > >
> >
> >
>
>
__
Dedicated Windows 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=coldfusiona
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: Access stored procedure
> I remember there be an article before where someone > used Access view and used the cfstoredproc tag, anyone > know where that article is? I don't know where the article is, but this was covered at a DC CFUG quite a while back, so you might look here: http://www.figleaf.com/figleafhome/cfug/cfugfeb99.zip There isn't too much to it, though - simply create your Access parameter queries, then call them using CFSTOREDPROC as if they were stored procedures, and don't use the RETURNCODE attribute of CFSTOREDPROC. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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: Content Management
> Anyone out there use special software for production-cycle > and source-code-management other than Visual Source Safe? > I've only taken a peek at MM's SiteSpring. I've looked at Sitespring too, and while I think it's pretty interesting, I don't think it's there yet as what you'd call a "production cycle" tool - the way it handles version control is automatic (which is nice) but it doesn't handle the concept of builds. > Has anyone built a custom system for doing this? Is anyone > interested in building one as a team? Rather than reinventing the wheel, you might just take a look at CVS, which is what I'm doing right now. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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: Deleting entries from database
By setting the Profile_ID to Primary Key and can still update and delete entries but when I try to add a new entry I keep getting this error. Error Occurred While Processing Request Error Diagnostic InformationODBC Error Code = 23000 (Integrity constraint violation) [Microsoft][ODBC Microsoft Access Driver] The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (1:1) to (1:49).Date/Time: 02/05/02 09:42:59 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; msnca3; Q312461) Remote Address: 192.139.241.145 HTTP Referrer: http://127.0.0.1/test/admin/profiles/env_Add_Form.cfm __ Get Your Own Dedicated Windows 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=coldfusionb 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: Deleting entries from database
That is because you want to insert a duplicate profile_ID. This should
not be possible in your application. You will have to re-think the way
you create your PK values.
-Original Message-
From: phumes1 [mailto:[EMAIL PROTECTED]]
Sent: dinsdag 5 februari 2002 15:32
To: CF-Talk
Subject: RE: Deleting entries from database
I have but then when I try to save the database it won't let me. Keeps
saying "Changes to the table you requested were not successful because
they
would create duplicate values in the index, primary key or relationship.
Change the data in the firld or fields that contain duplicate data,
remove
the index, or redefine the index to permit duplicate entries and try
again"
The only way I can get it to save is to remove the Primary Key.
Field Name Data Type
--
profile_ID Text
env_var Text
destination Text
At 03:08 PM 2/5/2002 +0100, you wrote:
>You have to define Profile_ID as Primary Key.
>
>-Original Message-
>From: phumes1 [mailto:[EMAIL PROTECTED]]
>Sent: dinsdag 5 februari 2002 14:54
>To: CF-Talk
>Subject: RE: Deleting entries from database
>
>
>Thanks...its works. Problem I'm having now is duplicate entires with
the
>
>same ID in my database if I add 2-3 identical entries.
>
>I was having trouble adding entries before when the Profile_ID was set
>to
>No duplicates.
>
>
>
>At 02:25 PM 2/5/2002 +0100, you wrote:
> >You are passing URL.PID to the page. SO:
> >
> >DELETE FROM profile
> >WHERE profile_ID = >value="#URL.PID#">
> >
> >This assuming profile_ID is a VARCHAR
> >
> >-Original Message-
> >From: phumes1 [mailto:[EMAIL PROTECTED]]
> >Sent: dinsdag 5 februari 2002 14:23
> >To: CF-Talk
> >Subject: RE: Deleting entries from database
> >
> >
> >OK..so I have a anchor from my index.cfm file which does a listing of
> >all
> >the fields from the database.
> >
> >
>HREF="env_delete_action.cfm?PID=#GetEnv.Profile_ID#&DID=#GetEnv.en
>v
> >_va
> >r#&DEST=#GetEnv.destination#">[Delete]
> >
> >
> >By clicking on the "Delete" link the variables are passed to another
> >form
> >that I want to perform the delete function.
> >I'm stuck in the WHERE ... I don't want to delete every record!
> >
> >
> > Delete from profile
> > (profile_ID, env_var, destination)
> > WHERE ???
> >
> >
> >At 02:05 PM 2/5/2002 +0100, you wrote:
> > >The syntax is incorrect: INSERT INTO ...
> > >
> > >For DELETE:
> > >DELETE FROM table
> > >WHERE your filters
> > >
> > >PS don't forget the filters or you delete every record in the table
> > >
> > >-Original Message-
> > >From: phumes1 [mailto:[EMAIL PROTECTED]]
> > >Sent: dinsdag 5 februari 2002 14:05
> > >To: CF-Talk
> > >Subject: re: Deleting entries from database
> > >
> > >
> > >Hi,
> > >
> > >I have the following code that inserts fields into my database.
> > >
> > >
> > > Delete into profile
> > > (profile_ID, env_var, destination)
> > > VALUES
> > > ('#FORM.profile_ID#', '#FORM.env_var#',
>'#FORM.destination#')
> > >
> > >
> > >
> > >I would also like to delete entries. Whats the syntax to do so?
> > >
> > >
> >
> >
>
>
__
Get Your Own Dedicated Windows 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=coldfusionb
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
OT: mySQL obtaining primary key fieldname at run-time.
Dear all,
I am trying to find a way of obtaining the primary key field name on a mySQL
db. I wish to perform an operation at run-time which necessitates the use
of the PK field name.
The operation is as follows. The purpose of this code is to create a log of
user activity on the database as a whole. I want to store the record they
altered/added in the log. form.userid has been hard coded. it should
contain "form.whatever the primary key for the active table is". Active
table being defined in another variable "auditQueryTable".
INSERT INTO applicationaudit
(username,action,querytype,querytable,recordid,datetime)
VALUES
('#session.username#','#auditAction#','#auditQueryType#','#auditQueryTable#'
,
#IIF(auditQueryType EQ "update", DE("form.userid"),
DE("LAST_INSERT_ID()"))#,
#CreateODBCDateTime(Now())#)
What I need to know is, is there a way of obtaining the name of the PK
field. Also, does SHOW return a usable result set? It has been suggested
this might be a valid support case, so if you guys don't know, I'll put it
to the programming team at mySQL.com and post the results here for your
reference.
Kind regards,
Martin.
__
Get Your Own Dedicated Windows 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=coldfusionb
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: cfselect and required=yes
um...yes it does. christopher olive, cto, vp of web development atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 05, 2002 4:59 AM To: CF-Talk Subject: RE: cfselect and required=yes One Gotcha to look out for is Netscape *does not* select an option by default in a dropdown. Kola Oyedeji Web developer Macromedia Certified Advanced ColdFusion 5 Developer ekeda ltd http://www.ekeda.co.uk (+44)020-8429-7300 > -Original Message- > From: Dave Watts [mailto:[EMAIL PROTECTED]] > Sent: 04 February 2002 19:03 > To: CF-Talk > Subject: RE: cfselect and required=yes > > > > I can never get the required attribute to work on cfselect > > is there a trick? > > Unless you create a multi-select box, any HTML SELECT, including one > generated with CFSELECT, will always have an item selected. > The REQUIRED > attribute only affects multi-select boxes. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > phone: 202-797-5496 > fax: 202-797-5444 > __ Get Your Own Dedicated Windows 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=coldfusionb 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: CGI variables
But isn't cgi.http_referer, for example, exist only if the page is called f rom a form? So it wouldn't exist if you came from a link? Chris Norloff -- Original Message -- from: "Kreig Zimmerman" <[EMAIL PROTECTED]> >True. > >- Original Message - >From: "Jamie Jackson" <[EMAIL PROTECTED]> >Subject: CGI variables > >> True or False? >> >> ALL CGI variables are ALWAYS "defined" within CF, so you test for them >> using len() instead of isdefined(). >> > > > __ Dedicated Windows 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=coldfusiona 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: cfselect and required=yes
You can "require" a select in a drop down to be selected by either
validating the field with javascript, if you want to use a title option
like "select an option" as the first item, or by creating the select wi
th
no blank values and setting a default option by using the keyword selec
ted
as follows for EITHER NS or IE
function validate(myForm){
if(myForm.mySelect.indexOf==0){
itsSelected=false;
}
return itsSelected;
}
Select an option
Option 1
Option 2
Option 3
//or to do it without javascript
Option 1
Option 2
Option 3
//
"Christopher Olive" <[EMAIL PROTECTED]> on 02/05/2002 08:42:3
5 AM
Please respond to [EMAIL PROTECTED]
To: CF-Talk <[EMAIL PROTECTED]>
cc:
Subject: RE: cfselect and required=yes
um...yes it does.
christopher olive, cto, vp of web development
atnet solutions, inc.
410.931.4092
http://www.atnetsolutions.com
-Original Message-
From: Kola Oyedeji [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 05, 2002 4:59 AM
To: CF-Talk
Subject: RE: cfselect and required=yes
One Gotcha to look out for is Netscape *does not* select an option by
default in a dropdown.
Kola Oyedeji
Web developer
Macromedia Certified Advanced ColdFusion 5 Developer
ekeda ltd
http://www.ekeda.co.uk
(+44)020-8429-7300
> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]]
> Sent: 04 February 2002 19:03
> To: CF-Talk
> Subject: RE: cfselect and required=yes
>
>
> > I can never get the required attribute to work on cfselect
> > is there a trick?
>
> Unless you create a multi-select box, any HTML SELECT, including one
> generated with CFSELECT, will always have an item selected.
> The REQUIRED
> attribute only affects multi-select boxes.
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> phone: 202-797-5496
> fax: 202-797-5444
>
__
Get Your Own Dedicated Windows 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=coldfusionb
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: Anybody heard of this?
> > I has some spam in my email this morning. It immediately > > popped me to a porn site. What it did though, was reset > > my start page through their server, and I now, cannot > > reset my start page. > > > > If I go into Internet Options, it does not allow me to > > change the Start Page settings. What's the fix for this? > > http://ftp.mozilla.org/pub/mozilla/releases/mozilla0.9.8/mozil > la-win32-0.9.8-installer.exe If that's the fix, I'd stick with the porn home page myself. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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: Using CFTRY - CFCATCH to rollback database tranaction
> The 4.5.2 documentation has an example of what you want to > do, by using cftransaction with cftry/catch Look at the usage > example in the tag description for cftransaction. Unfortunately, that "example" is probably the worst instance of poor coding you're going to find within the documentation. It uses CFTRY/CFCATCH unnecessarily, and won't even work if you run it, if I recall correctly. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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: CGI variables
> > ALL CGI variables are ALWAYS "defined" within CF, so you > > test for them using len() instead of isdefined(). > > But isn't cgi.http_referer, for example, exist only if the > page is called from a form? So it wouldn't exist if you came > from a link? The CGI variable itself may not exist, in the sense that the browser didn't create a Referer header, but CF doesn't care. If you run this: CGI variable detection is crap! you'll see what I mean. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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: Anybody heard of this?
haha, cute trick huh? at least in IE it asks you if you want to set it or not. Dave Watts <[EMAIL PROTECTED]> on 02/05/2002 09:03:01 AM Please respond to [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> cc: Subject: RE: OT: Anybody heard of this? > > I has some spam in my email this morning. It immediately > > popped me to a porn site. What it did though, was reset > > my start page through their server, and I now, cannot > > reset my start page. > > > > If I go into Internet Options, it does not allow me to > > change the Start Page settings. What's the fix for this? > > http://ftp.mozilla.org/pub/mozilla/releases/mozilla0.9.8/mozi l > la-win32-0.9.8-installer.exe If that's the fix, I'd stick with the porn home page myself. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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: Content Management
> Rather than reinventing the wheel, you might just take a > look at CVS, which is what I'm doing right now. Have you looked at many of the alternatives for implementing source-control in a webdev environment? Any opinions/feedback you might be able to offer on them would be of great value. The topic came up on one the CF lists recently but no one that spoke up was using anything other than VSS. Ken __ Dedicated Windows 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=coldfusiona 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
cfscript vs markup...
Hello list,
I have two pieces of code and I can't figure out why one works and the other
does not. The regular markup works perfect, so I thought I would move it to
CFSCRIPT, which is normally not a problem, but on barely 3 hours of sleep
it's one today... anyway here they both are followed by the error:
THIS WORKS:
THIS BLOWS:
loopCnt = arraylen(holderary);
for (i = 1; i lte loopCnt; i = i + 1){
if (dateformat(createodbcdate(now()) ,"m/dd/yy") lte
dateformat(holderary[i][1] ,"m/dd/yy")){
if (dateformat(createodbcdate(now()) ,"m/dd/yy") eq
dateformat(holderary[i][1] ,"m/dd/yy")){
loopto = (holderary[i][2]-1) +
listlen(holderary[i][3],"|");
loopst = holderary[i][2];
cnt = 1;
for (ii = loopst; ii lte loopto; ii + 1){
if (newtime lte listgetat(holderary[i][3],
cnt, "|")){
cnt = cnt + 1;
asxnum = ii-1;
break;
} else {
cnt = cnt + 1;
asxnum = ii;
}
}
}
}
}
THIS IS THE ERROR:
In function ListGetAt(list, index [, delimiters]) the value of index, which
is 4, is not a valid index for the list given as a the first argument (this
list has 3 elements). Valid indexes are in the range 1 through the number of
elements in the list
Any idea what gives?
Thanks,
Bill K.
__
Get Your Own Dedicated Windows 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=coldfusionb
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
Easy way to loop over first x items of long list
If I have a list of 10 items or so (0,1,2,3,4,5,6,7,8,9) and want to loop over just the first 3 items (for example), what's the easiest way? I can't find a List function that selects just the first x items of a list. I can use ListGetAt to select the 1st one, then the 2nd, then the 3rd, but if I wanted to loop through a large number of items in a long list, that gets tedious. I guess there is probably some List function that does this that I have just overlooked? Thanks, Paul __ 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: CGI variables
> > CGI variable detection is crap! > what about cgi.http_accept_language, my most favorite cgi var of them all? i seem to turn it up as not defined from older and/or whacko browsers. also most __ 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: Anybody heard of this?
It didn't ask me nothing! It just did it. Dave - Original Message - From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, February 05, 2002 10:05 AM Subject: RE: OT: Anybody heard of this? haha, cute trick huh? at least in IE it asks you if you want to set it or not. Dave Watts <[EMAIL PROTECTED]> on 02/05/2002 09:03:01 AM Please respond to [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> cc: Subject: RE: OT: Anybody heard of this? > > I has some spam in my email this morning. It immediately > > popped me to a porn site. What it did though, was reset > > my start page through their server, and I now, cannot > > reset my start page. > > > > If I go into Internet Options, it does not allow me to > > change the Start Page settings. What's the fix for this? > > http://ftp.mozilla.org/pub/mozilla/releases/mozilla0.9.8/mozi l > la-win32-0.9.8-installer.exe If that's the fix, I'd stick with the porn home page myself. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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: Possible bug in StructFindKey() in CF Ent 4.5.1 SP-2 on Win NT4/2000 Server?
Hi Raymond, > Can you show us the code please? I've uploaded my test stubs in a zip file which includes the two serialised queries at the following URL: http://www.networkbuild.com/temp/struct_find_key_test.zip The code is simple, and pretty raw too. To simulate the database queries, I've provided the result sets for both queries in WDDX files. An Application.cfm is provided which loads in the WDDX files and converts the contents back into queries. Three templates are provided - one which does not search the struct, one which searches using StructFindKey and one which searches manually. I've also included the two WDDX files suffixed with "_CS" which are the same WDDX packets after being fed through code sweeper. >> [CF_DUMP] shows me a struct - not WDDX. > That's because cfa_dump is smart enough to detect wddx and > auto-deserialize it. So when you dump wddx, you will see the > 'real' form of it. No I realise that - I meant to say it really shows it as a struct without a border, whereas WDDX packets are shown as structs with a solid black border. So it _is_ deserialising it successfully. I should add that some of the many test iterations added in calls to Len( szContent ) and IsWDDX( Trim( szContent )) before attempting to deserialise it. Any insight you can provide will be most appreciated, Colin __ Get Your Own Dedicated Windows 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=coldfusionb 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: Easy way to loop over first x items of long list
Why not CFLOOP? #myListItem# -Original Message- From: Paul Sinclair [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 05, 2002 9:16 AM To: CF-Talk Subject: Easy way to loop over first x items of long list If I have a list of 10 items or so (0,1,2,3,4,5,6,7,8,9) and want to loop over just the first 3 items (for example), what's the easiest way? I can't find a List function that selects just the first x items of a list. I can use ListGetAt to select the 1st one, then the 2nd, then the 3rd, but if I wanted to loop through a large number of items in a long list, that gets tedious. I guess there is probably some List function that does this that I have just overlooked? Thanks, Paul __ Dedicated Windows 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=coldfusiona 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: Anybody heard of this?
ns will do it no ?'s asked. if ie does it you may have your security settings set to extra super duper low :) "Dave Hannum" <[EMAIL PROTECTED]> on 02/05/2002 09:25:10 AM Please respond to [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> cc: Subject: Re: OT: Anybody heard of this? It didn't ask me nothing! It just did it. Dave - Original Message - From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, February 05, 2002 10:05 AM Subject: RE: OT: Anybody heard of this? haha, cute trick huh? at least in IE it asks you if you want to set it or not. Dave Watts <[EMAIL PROTECTED]> on 02/05/2002 09:03:01 AM Please respond to [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> cc: Subject: RE: OT: Anybody heard of this? > > I has some spam in my email this morning. It immediately > > popped me to a porn site. What it did though, was reset > > my start page through their server, and I now, cannot > > reset my start page. > > > > If I go into Internet Options, it does not allow me to > > change the Start Page settings. What's the fix for this? > > http://ftp.mozilla.org/pub/mozilla/releases/mozilla0.9.8/mozi l > la-win32-0.9.8-installer.exe If that's the fix, I'd stick with the porn home page myself. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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: Easy way to loop over first x items of long list
#listgetat(variables.list,i)# -Original Message- From: Paul Sinclair [mailto:[EMAIL PROTECTED]] Sent: 05 February 2002 15:16 To: CF-Talk Subject: Easy way to loop over first x items of long list If I have a list of 10 items or so (0,1,2,3,4,5,6,7,8,9) and want to loop over just the first 3 items (for example), what's the easiest way? I can't find a List function that selects just the first x items of a list. I can use ListGetAt to select the 1st one, then the 2nd, then the 3rd, but if I wanted to loop through a large number of items in a long list, that gets tedious. I guess there is probably some List function that does this that I have just overlooked? Thanks, Paul __ Dedicated Windows 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=coldfusiona 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 format
Thanks all for the quikkk..replies! -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 05, 2002 9:15 AM To: CF-Talk Subject: Re: date format This should do the trick! #DateFormat(Now(), " dd, ")# Good Luck Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder - Original Message - From: "Robert Orlini" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, February 05, 2002 8:03 AM Subject: date format > Hello, > > I know this is an easy one, but I can't get it to work. How can I have > the current date display as Month, Day, Year? The DateFormat parameter > doesn't accept a mask as one CF book reads: #DateFormat(Now," dd, > ")# > > Any help appreciated. Thanks. > > Robert O. > __ Dedicated Windows 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=coldfusiona 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
Write flat files based on HUGE query
I have a huge query that takes about 15 minutes to run. I'm a small college, and I'm pulling data on my faculty and their class schedules, office hours for posting on the web site. My legacy administrative database was never designed for servicing the web, and it is just a terribly long request to get all of this data. Currently, I'm caching the query for a week, and that seems to work pretty well. However, I'm getting requests for changes to this application, and I'm considering a re-write. One of the ways I'm thinking about doing this is to run my mongo-query, and then loop through the results writing html, or cfm, files as I go. It would probably be about 300 pages. Is it like this:
RE: Content Management
CVS is a great tool; Most if not all Open Source projects use CVS (ie. Sourceforge, etc.). There are some GUI apps for CVS, and some IDE's have "built in" access such as Forte. Having never used VSS, I can't comment on it. But knowing who produces it would lead me to believe it probably has some "features" that I wouldn't find appropriate. ;-) -Original Message- From: Ken Wilson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 05, 2002 10:12 AM To: CF-Talk Subject: RE: Content Management > Rather than reinventing the wheel, you might just take a > look at CVS, which is what I'm doing right now. Have you looked at many of the alternatives for implementing source-control in a webdev environment? Any opinions/feedback you might be able to offer on them would be of great value. The topic came up on one the CF lists recently but no one that spoke up was using anything other than VSS. Ken __ Dedicated Windows 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=coldfusiona 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
Selecting many records at once
Afternoon fellow CF'ers around the globe... I have an app that retrieves thousands of records from a database, looping thru them to display to screen. The query takes forever and the page times out. Can anyone suggest a way to prevent this by outputting the data in manageable chunks or is "paging" preferable? TIA. Nick -Original Message- From: Willy Ray [mailto:[EMAIL PROTECTED]] Sent: 05 February 2002 15:38 To: CF-Talk Subject: Write flat files based on HUGE query I have a huge query that takes about 15 minutes to run. I'm a small college, and I'm pulling data on my faculty and their class schedules, office hours for posting on the web site. My legacy administrative database was never designed for servicing the web, and it is just a terribly long request to get all of this data. Currently, I'm caching the query for a week, and that seems to work pretty well. However, I'm getting requests for changes to this application, and I'm considering a re-write. One of the ways I'm thinking about doing this is to run my mongo-query, and then loop through the results writing html, or cfm, files as I go. It would probably be about 300 pages. Is it like this:
RE: Easy way to loop over first x items of long list
And if you expect your list to ever be shorter than your desired subset, you could dynamically set your "to" attribute using the iif function so you don't error out: #listgetat(variables.list,i)# Although that might be overkill for your situation. You will probably want to verify my syntax as well, it's probably wrong. Adam. > -Original Message- > From: Craig Dudley [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, February 05, 2002 9:22 AM > To: CF-Talk > Subject: RE: Easy way to loop over first x items of long list > > > > > > #listgetat(variables.list,i)# > > > -Original Message- > From: Paul Sinclair [mailto:[EMAIL PROTECTED]] > Sent: 05 February 2002 15:16 > To: CF-Talk > Subject: Easy way to loop over first x items of long list > > > If I have a list of 10 items or so (0,1,2,3,4,5,6,7,8,9) and want to > loop over just the first 3 items (for example), what's the > easiest way? > I can't find a List function that selects just the first x items of a > list. I can use ListGetAt to select the 1st one, then the > 2nd, then the > 3rd, but if I wanted to loop through a large number of items in a long > list, that gets tedious. > > I guess there is probably some List function that does this > that I have > just overlooked? > > Thanks, > Paul > > __ Dedicated Windows 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=coldfusiona 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: Content Management
We use CVS, but I am not pleased with it. We have a few problems with the windows client not working correctly, overwriting files, and not merging correctly. We have found that many of these problem are solved when the user pays very clse attention. If you use Sun's Forte Programs, they have a built-in CVS Client that works very well. >Rather than reinventing the wheel, you might just take a look at CVS, which >is what I'm doing right now. > >Dave Watts, CTO, Fig Leaf Software __ Get Your Own Dedicated Windows 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=coldfusionb 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: Selecting many records at once
You can use CFQUERY's BLOCKFACTOR attribute to control how many records are pulled from the database at one. (instead of taking them out one at a time). If we're talking thousands of records, braeking it in several pages would be my suggestion (next page, previous page). -Original Message- From: Nick Betts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 05, 2002 10:44 AM To: CF-Talk Subject: Selecting many records at once Afternoon fellow CF'ers around the globe... I have an app that retrieves thousands of records from a database, looping thru them to display to screen. The query takes forever and the page times out. Can anyone suggest a way to prevent this by outputting the data in manageable chunks or is "paging" preferable? TIA. Nick -Original Message- From: Willy Ray [mailto:[EMAIL PROTECTED]] Sent: 05 February 2002 15:38 To: CF-Talk Subject: Write flat files based on HUGE query I have a huge query that takes about 15 minutes to run. I'm a small college, and I'm pulling data on my faculty and their class schedules, office hours for posting on the web site. My legacy administrative database was never designed for servicing the web, and it is just a terribly long request to get all of this data. Currently, I'm caching the query for a week, and that seems to work pretty well. However, I'm getting requests for changes to this application, and I'm considering a re-write. One of the ways I'm thinking about doing this is to run my mongo-query, and then loop through the results writing html, or cfm, files as I go. It would probably be about 300 pages. Is it like this:
RE: Neo Beta program
Maybe you both should be talking about this between eachother off list? -Original Message- From: Neil Clark [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 05, 2002 3:10 AM To: CF-Talk Subject: RE: Neo Beta program :-) If you were on the alpha prog, you would have signed one... maybe your account has not been activated yet? N __ Get Your Own Dedicated Windows 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=coldfusionb 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: Anybody heard of this?
Dave Watts wrote: >>http://ftp.mozilla.org/pub/mozilla/releases/mozilla0.9.8/mozil >>la-win32-0.9.8-installer.exe >> > > If that's the fix, I'd stick with the porn home page myself. It is all about the right tool for the job. Some sites look horrible in Mozilla so I pick IE. Sometimes I need to debug a site with a lot of frames and I will take Mozilla because it can do "Open frame in new window" for existing frames. If standard compliance is required I even use Amaya. But in order to read the mailfolder with all the mail that gets classified as 'Suspicious' by the mail filter I will choose Mozilla over Outlook + IE at any time. Jochem __ Get Your Own Dedicated Windows 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=coldfusionb 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: Anybody heard of this?
Out of curiosity how is this done? Is this done using Active x? I once viewed a site and it did something similar except that it also installed a icon on my desktop and on my startup menu to jump to some porn site!! Kola Oyedeji Web developer Macromedia Certified Advanced ColdFusion 5 Developer ekeda ltd http://www.ekeda.co.uk (+44)020-8429-7300 > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: 05 February 2002 15:27 > To: CF-Talk > Subject: Re: OT: Anybody heard of this? > > > ns will do it no ?'s asked. if ie does it you may have your security > > settings set to extra super duper low :) > > > > > "Dave Hannum" <[EMAIL PROTECTED]> on 02/05/2002 09:25:10 AM > > Please respond to [EMAIL PROTECTED] > > To: CF-Talk <[EMAIL PROTECTED]> > cc: > > Subject: Re: OT: Anybody heard of this? > > > It didn't ask me nothing! It just did it. > > Dave > > > - Original Message - > From: <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, February 05, 2002 10:05 AM > Subject: RE: OT: Anybody heard of this? > > > haha, cute trick huh? at least in IE it asks you if you want > to set it > > or > not. > > > > > Dave Watts <[EMAIL PROTECTED]> on 02/05/2002 09:03:01 AM > > Please respond to [EMAIL PROTECTED] > > To: CF-Talk <[EMAIL PROTECTED]> > cc: > > Subject: RE: OT: Anybody heard of this? > > > > > I has some spam in my email this morning. It immediately > > > popped me to a porn site. What it did though, was reset > > > my start page through their server, and I now, cannot > > > reset my start page. > > > > > > If I go into Internet Options, it does not allow me to > > > change the Start Page settings. What's the fix for this? > > > > http://ftp.mozilla.org/pub/mozilla/releases/mozilla0.9.8/mozi > > l > > la-win32-0.9.8-installer.exe > > If that's the fix, I'd stick with the porn home page myself. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > voice: (202) 797-5496 > fax: (202) 797-5444 > > > > __ Dedicated Windows 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=coldfusiona 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: Neo Beta program
I have to agree. While this is a relatively simple request, there is a support email on the beta site. Any and all talk about Neo, no matter how innocent is under the NDA and should not be posted up to the lists. Thanks for helping out in this. At 10:55 AM 2/5/02, you wrote: >Maybe you both should be talking about this between eachother off list? > > >-Original Message- >From: Neil Clark [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, February 05, 2002 3:10 AM >To: CF-Talk >Subject: RE: Neo Beta program > > >:-) If you were on the alpha prog, you would have signed one... maybe >your account has not been activated yet? > >N > > > __ 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: cfscript vs markup...
I can't see the problem. Can you post your dataset so I can try it out? Thanks At 10:13 AM 2/5/02, you wrote: >Hello list, > >I have two pieces of code and I can't figure out why one works and the other >does not. The regular markup works perfect, so I thought I would move it to >CFSCRIPT, which is normally not a problem, but on barely 3 hours of sleep >it's one today... anyway here they both are followed by the error: __ 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: Easy way to loop over first x items of long list
and to further what Larry said To just loop over the first 3 items you CFSET a variable called LoopCounter to 0 (zero) before the loop. Then you increment it inside the loop (LoopCounter + 1). When LoopCounter hits 3 you use CFBREAK to break out of the loop. HTH Bryan Stevenson VP & Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Original Message - From: "Larry Juncker" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, February 05, 2002 7:26 AM Subject: RE: Easy way to loop over first x items of long list > Why not CFLOOP? > > > #myListItem# > > > -Original Message- > From: Paul Sinclair [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, February 05, 2002 9:16 AM > To: CF-Talk > Subject: Easy way to loop over first x items of long list > > > If I have a list of 10 items or so (0,1,2,3,4,5,6,7,8,9) and want to > loop over just the first 3 items (for example), what's the easiest way? > I can't find a List function that selects just the first x items of a > list. I can use ListGetAt to select the 1st one, then the 2nd, then the > 3rd, but if I wanted to loop through a large number of items in a long > list, that gets tedious. > > I guess there is probably some List function that does this that I have > just overlooked? > > Thanks, > Paul > > __ Dedicated Windows 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=coldfusiona 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: Selecting many records at once
I'd do seperate pages with forward/back buttons. If that isn't an option then look into CFFLUSH or increasing the timeout for that page. HTH Bryan Stevenson VP & Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Original Message - From: "Nick Betts" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, February 05, 2002 7:44 AM Subject: Selecting many records at once > Afternoon fellow CF'ers around the globe... > > I have an app that retrieves thousands of records from a database, > looping thru them to display to screen. > The query takes forever and the page times out. Can anyone suggest a > way to prevent this by outputting the data in manageable chunks or is > "paging" preferable? > > TIA. Nick > > -Original Message- > From: Willy Ray [mailto:[EMAIL PROTECTED]] > Sent: 05 February 2002 15:38 > To: CF-Talk > Subject: Write flat files based on HUGE query > > > I have a huge query that takes about 15 minutes to run. I'm a small > college, and I'm pulling data on my faculty and their class schedules, > office hours for posting on the web site. My legacy administrative > database was never designed for servicing the web, and it is just a > terribly long request to get all of this data. Currently, I'm caching > the > query for a week, and that seems to work pretty well. However, I'm > getting requests for changes to this application, and I'm considering a > re-write. > > One of the ways I'm thinking about doing this is to run my mongo-query, > and then loop through the results writing html, or cfm, files as I go. > It > would probably be about 300 pages. Is it like this: > > >
Seasonal Content
I want to have some seasonal content in an app I am building. The content will reside in a db and I want to query for it based on today's date. I am clear on how I could do this for a single year: simply put fields to search on for start and end dates and look for records where getdate() between start_date and end_date. However, next year these dates would be invalid. I'm sure there is some slick way to do this computation based on the current day of the year (1-365), but I'm not sure of how exactly to store the valid range. I could have content valid from day 27 through day 189 of the same year. Or, I could have content valid from day 325 through day 4 of the following year. So a simple "between start_day and end_day" won't do the trick. Thanks in advance. - Sean ~~ Sean Daniels Director, Engineering Marketplace Technologies, Inc (T): 207.363.7374 (C): 207.332.6340 (F): 240.269.6319 ~~ http://www.dealforce.com http://www.mergernetwork.com __ Get Your Own Dedicated Windows 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=coldfusionb 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: Write flat files based on HUGE query
I think you should look at solving your backend problem first - perhaps a data export to a different rdbms , or perhaps you should be running more, smaller queries. The paging thing would probably work, but I'm guessing it would be clunky and it would cause some of the same problems you have now (data not up to date etc.). -Original Message- From: Willy Ray [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 05, 2002 7:38 AM To: CF-Talk Subject: Write flat files based on HUGE query I have a huge query that takes about 15 minutes to run. I'm a small college, and I'm pulling data on my faculty and their class schedules, office hours for posting on the web site. My legacy administrative database was never designed for servicing the web, and it is just a terribly long request to get all of this data. Currently, I'm caching the query for a week, and that seems to work pretty well. However, I'm getting requests for changes to this application, and I'm considering a re-write. One of the ways I'm thinking about doing this is to run my mongo-query, and then loop through the results writing html, or cfm, files as I go. It would probably be about 300 pages. Is it like this:
RE: OT: Anybody heard of this?
Yes .. I once found a site that did this and after a bit of meddling got the source out, It was an active-x dropper that was encrypted (much like some of these virii recently). I did mean to approach some AV vendors with the source i had because my virus-killer (at the time) didnt disable it from doing this because it decrypted the source client side. This program altered my start page directly in registry if i remember correctly which is what got my annoyance up. Now you've reminded me when i get home from work i am going to see if my current upto date virus killer will stop it, if not i shall forward the source to the AV ppl. -+ SteG +- -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] Sent: 05 February 2002 16:00 To: CF-Talk Subject: RE: OT: Anybody heard of this? Out of curiosity how is this done? Is this done using Active x? I once viewed a site and it did something similar except that it also installed a icon on my desktop and on my startup menu to jump to some porn site!! Kola Oyedeji Web developer Macromedia Certified Advanced ColdFusion 5 Developer ekeda ltd http://www.ekeda.co.uk (+44)020-8429-7300 > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: 05 February 2002 15:27 > To: CF-Talk > Subject: Re: OT: Anybody heard of this? > > > ns will do it no ?'s asked. if ie does it you may have your security > > settings set to extra super duper low :) > > > > > "Dave Hannum" <[EMAIL PROTECTED]> on 02/05/2002 09:25:10 AM > > Please respond to [EMAIL PROTECTED] > > To: CF-Talk <[EMAIL PROTECTED]> > cc: > > Subject: Re: OT: Anybody heard of this? > > > It didn't ask me nothing! It just did it. > > Dave > > > - Original Message - > From: <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, February 05, 2002 10:05 AM > Subject: RE: OT: Anybody heard of this? > > > haha, cute trick huh? at least in IE it asks you if you want > to set it > > or > not. > > > > > Dave Watts <[EMAIL PROTECTED]> on 02/05/2002 09:03:01 AM > > Please respond to [EMAIL PROTECTED] > > To: CF-Talk <[EMAIL PROTECTED]> > cc: > > Subject: RE: OT: Anybody heard of this? > > > > > I has some spam in my email this morning. It immediately > > > popped me to a porn site. What it did though, was reset > > > my start page through their server, and I now, cannot > > > reset my start page. > > > > > > If I go into Internet Options, it does not allow me to > > > change the Start Page settings. What's the fix for this? > > > > http://ftp.mozilla.org/pub/mozilla/releases/mozilla0.9.8/mozi > > l > > la-win32-0.9.8-installer.exe > > If that's the fix, I'd stick with the porn home page myself. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > voice: (202) 797-5496 > fax: (202) 797-5444 > > > > __ Get Your Own Dedicated Windows 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=coldfusionb 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
Macromedia in talks with Microsoft??
Are these rumors true? and if so, what do you think it will mean for the future of ColdFusion if Microsoft was to acquire Macromedia? I got this info from fuckedcompany.com which has been a pretty reliable source in the past. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. __ 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: Macromedia in talks with Microsoft??
Not true, been discussed so look in the archives, off topic for this list, I'm going to have to ban this subject. At 11:45 AM 2/5/02, you wrote: >Are these rumors true? and if so, what do you think it will mean for the >future of ColdFusion if Microsoft was to acquire Macromedia? I got this info >from fuckedcompany.com which has been a pretty reliable source in the past. > >_ >Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. > __ Get Your Own Dedicated Windows 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=coldfusionb 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
Passing HTML to a FORM
I have a developer that is having a tough time with an HTML FORM and submitting HTML text via hidden form fields. He has a form that has two parts, one an html designer inputs HTML text into a textarea field. The other part of the form, accepts product ids and then the system will generate default HTML text for those product id's. Now, both of these sniplets of HTML have to be passed over from our Cold Fusion Servers to the Java Servers via form submit. But it is breaking. What is the best way to send over HTML code via hidden form fields to another application that needs that HTML text. I am sure there is an easy answer... Thanks Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder __ Get Your Own Dedicated Windows 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=coldfusionb 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: Macromedia in talks with Microsoft??
Please read the archives at houseoffusion. This has been discussed in depth before, and you would most likely get what info you need there. But if it happensit happens whatcha gonna do. There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown - Original Message - From: "S R" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, February 05, 2002 8:45 AM Subject: Macromedia in talks with Microsoft?? > Are these rumors true? and if so, what do you think it will mean for the > future of ColdFusion if Microsoft was to acquire Macromedia? I got this info > from fuckedcompany.com which has been a pretty reliable source in the past. > > _ > Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. > __ Get Your Own Dedicated Windows 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=coldfusionb 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: Macromedia in talks with Microsoft??
Agreed Michael. Blow it away. ;) Lee -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 05, 2002 8:48 AM To: CF-Talk Subject: Re: Macromedia in talks with Microsoft?? Not true, been discussed so look in the archives, off topic for this list, I'm going to have to ban this subject. At 11:45 AM 2/5/02, you wrote: >Are these rumors true? and if so, what do you think it will mean for >the >future of ColdFusion if Microsoft was to acquire Macromedia? I got this info >from fuckedcompany.com which has been a pretty reliable source in the >past. > >_ >Get your FREE download of MSN Explorer at >http://explorer.msn.com/intl.asp. > __ Dedicated Windows 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=coldfusiona 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: Macromedia in talks with Microsoft??
Cool I'll look in the archives. Sorry about this. >From: "Douglas Brown" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: Re: Macromedia in talks with Microsoft?? >Date: Tue, 5 Feb 2002 09:12:46 -0800 > >Please read the archives at houseoffusion. This has been discussed in >depth before, and you would most likely get what info you need there. >But if it happensit happens whatcha gonna do. > > > > >There are two major products that come out of Berkeley: LSD and [Unix] >BSD. We don't believe this to be a coincidence. > > > >Doug Brown >- Original Message - >From: "S R" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Tuesday, February 05, 2002 8:45 AM >Subject: Macromedia in talks with Microsoft?? > > > > Are these rumors true? and if so, what do you think it will mean for >the > > future of ColdFusion if Microsoft was to acquire Macromedia? I got >this info > > from fuckedcompany.com which has been a pretty reliable source in the >past. > > > > _ > > Get your FREE download of MSN Explorer at >http://explorer.msn.com/intl.asp. > > > __ Get Your Own Dedicated Windows 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=coldfusionb 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 format
#DateFormat(Now(), " dd, ")# Nathaniel Horwitz http://www.nathanielhorwitz.com > Hello, > > I know this is an easy one, but I can't get it to work. How can I have > the current date display as Month, Day, Year? The DateFormat parameter > doesn't accept a mask as one CF book reads: #DateFormat(Now," dd, > ")# > > Any help appreciated. Thanks. > > Robert O. > __ 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: Content Management
After few quirks in the beginning, I was really happy with CVS. It does everything you want it to - merge, update and commit files into the production environment. It's primarily a UNIX tool but I think there's a program called win_cvs that does the same thing but on the windows side. Anyone know about the win_cvs software? Nathaniel Horwitz http://www.nathanielhorwitz.com > > Anyone out there use special software for production-cycle > > and source-code-management other than Visual Source Safe? > > I've only taken a peek at MM's SiteSpring. > > I've looked at Sitespring too, and while I think it's pretty interesting, I > don't think it's there yet as what you'd call a "production cycle" tool - > the way it handles version control is automatic (which is nice) but it > doesn't handle the concept of builds. > > > Has anyone built a custom system for doing this? Is anyone > > interested in building one as a team? > > Rather than reinventing the wheel, you might just take a look at CVS, which > is what I'm doing right now. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > voice: (202) 797-5496 > fax: (202) 797-5444 __ 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: CGI variables
Not really. It works when you'd come from a link. Nathaniel Horwitz http://www.nathanielhorwitz.com > > But isn't cgi.http_referer, for example, exist only if the page is called f > rom a form? So it wouldn't exist if you came from a link? > > Chris Norloff > > -- Original Message -- > from: "Kreig Zimmerman" <[EMAIL PROTECTED]> > >True. > > > >- Original Message - > >From: "Jamie Jackson" <[EMAIL PROTECTED]> > >Subject: CGI variables > > > >> True or False? > >> > >> ALL CGI variables are ALWAYS "defined" within CF, so you test for them > >> using len() instead of isdefined(). > >> > > __ 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[2]: Content Management
Has anyone tried the software mentioned in the recent CFDJ? Code Co-op? It was neat that instead of being client/server based - you checked in/out files via an email system, the benefit there being that remote users didn't need access through firewalls, etc in order to access files. http://www.relisoft.com/co_op/datasheet.html They have a trial version I just haven't had any free time to try it out :) jim __ Dedicated Windows 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=coldfusiona 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
Rotating Banner
Does anyone have a good rotating banner tag they could send me? Thanks, Brian Yager President - North AL Cold Fusion Users Group Sr. Systems Analyst NCCIM/CIC [EMAIL PROTECTED] (256) 842-8342 __ Get Your Own Dedicated Windows 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=coldfusionb 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: Groove
John Cummings wrote: > furthermore, is there a central CF shared space run by someone that > they'd mind if I joined? If I understand what you're looking for (some web space that would allow you to do some CF), you can try http://members.evolt.org/ . You can get free web space there for testing out Cold Fusion and PHP (there may be other features as well). You can't host a site there, since it's only to be used for learning/testing. Scott -- Scott Brady http://www.scottbrady.net/ __ Dedicated Windows 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=coldfusiona 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: Seasonal Content
Since the first day of every year is January 1 (I think, I hope), you should be able to just use dateadd() to get your date range based on the two day-of-year values you specify (ie. 525 - 4). If the second value is less than the first, you know to add 365 to it in your addition. You can get the current year using year(now()). Does that work? Adam. > -Original Message- > From: Sean Daniels [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, February 05, 2002 10:06 AM > To: CF-Talk > Subject: Seasonal Content > > > I want to have some seasonal content in an app I am building. > The content > will reside in a db and I want to query for it based on > today's date. I am > clear on how I could do this for a single year: simply put > fields to search > on for start and end dates and look for records where > getdate() between > start_date and end_date. However, next year these dates would > be invalid. > > I'm sure there is some slick way to do this computation based > on the current > day of the year (1-365), but I'm not sure of how exactly to > store the valid > range. I could have content valid from day 27 through day 189 > of the same > year. Or, I could have content valid from day 325 through day 4 of the > following year. So a simple "between start_day and end_day" > won't do the > trick. > > Thanks in advance. > > - Sean > > ~~ > Sean Daniels > Director, Engineering > Marketplace Technologies, Inc > (T): 207.363.7374 > (C): 207.332.6340 > (F): 240.269.6319 > ~~ > http://www.dealforce.com > http://www.mergernetwork.com > > > __ Get Your Own Dedicated Windows 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=coldfusionb 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: Seasonal Content
Ooops - that was supposed to be 325 in my example - not 525. I'm sure you knew what I was talking about though. Adam. > -Original Message- > From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, February 05, 2002 12:09 PM > To: CF-Talk > Subject: RE: Seasonal Content > > > Since the first day of every year is January 1 (I think, I > hope), you should > be able to just use dateadd() to get your date range based on the two > day-of-year values you specify (ie. 525 - 4). If the second > value is less > than the first, you know to add 365 to it in your addition. > You can get the > current year using year(now()). > > Does that work? > > Adam. > > > > > -Original Message- > > From: Sean Daniels [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, February 05, 2002 10:06 AM > > To: CF-Talk > > Subject: Seasonal Content > > > > > > I want to have some seasonal content in an app I am building. > > The content > > will reside in a db and I want to query for it based on > > today's date. I am > > clear on how I could do this for a single year: simply put > > fields to search > > on for start and end dates and look for records where > > getdate() between > > start_date and end_date. However, next year these dates would > > be invalid. > > > > I'm sure there is some slick way to do this computation based > > on the current > > day of the year (1-365), but I'm not sure of how exactly to > > store the valid > > range. I could have content valid from day 27 through day 189 > > of the same > > year. Or, I could have content valid from day 325 through > day 4 of the > > following year. So a simple "between start_day and end_day" > > won't do the > > trick. > > > > Thanks in advance. > > > > - Sean > > > > ~~ > > Sean Daniels > > Director, Engineering > > Marketplace Technologies, Inc > > (T): 207.363.7374 > > (C): 207.332.6340 > > (F): 240.269.6319 > > ~~ > > http://www.dealforce.com > > http://www.mergernetwork.com > > > > > > > __ Get Your Own Dedicated Windows 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=coldfusionb 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: Microsoft and Macromedia
That didn't sound like a flame...It actually is pretty funny compared to the last thread about it! Brian Yager President - North AL Cold Fusion Users Group Sr. Systems Analyst NCCIM/CIC [EMAIL PROTECTED] (256) 842-8342 -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 2:59 PM To: CF-Talk Subject: RE: Microsoft and Macromedia Look in the archives and see how much I contribute to this list. Search for my name and see for yourself. That entitles me to ask. This is one of the first times I've actually asked a question in this forum. I really hope you're not symbolic of the cf-community at large. This was a customer question. Just relaying it so I can go back with ammo. Sorry I didn't check the archives. Look at the questions that come up in this group and see for yourself how many have already been answered in the archives. Thanks for flaming me. -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 12:25 PM To: CF-Talk Subject: RE: Microsoft and Macromedia Summation of replies to this from last week: a. This is off topic, take it to cf-community. b. This is a rumor that was dispelled years ago, macromedia says so. c. You are a negative person for even asking! Why are you even spreading this rumor you piece of trash? You don't even belong in this community! I hate you dearly! (btw, please ignore the 'senior macromedia premier ultra-mega-super-duper partner' in my sig.) d. If it is true, it's nobody's fault other than yours for acting so negative all the time. e. This is off topic, take it to cf-community. That's pretty much it, but I'm sure you'll get the same exact replies this week, so I'm sorry to fill up your inbox with redundancy. Just letting you know what to expect. Adam. > -Original Message- > From: Costas Piliotis [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 04, 2002 1:56 PM > To: CF-Talk > Subject: Microsoft and Macromedia > > > http://forum.fuckedcompany.com/phpcomments/index.php?newsid=82 > 133&page=1&par > entid=0&crapfilter=1 > > Anyone know if there's any truth to this? > > (Pardon the language in the link - What else could I do?) > > __ 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: How many in here bother to resell shared webspace?
I get 30% of all mothly fees from Advances.com. This works out to be about $7.50/month/ per client. Brian Yager President - North AL Cold Fusion Users Group Sr. Systems Analyst NCCIM/CIC [EMAIL PROTECTED] (256) 842-8342 -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 2:37 PM To: CF-Talk Subject: OT: How many in here bother to resell shared webspace? Monday, February 04, 2002, 3:33:03 PM Hello cf-talk, Just wondering how many in here bother to resell webspace. By this I mean getting a large hosting plan at some host, then reselling the space to your clients. Typical reselling plan that many webhosts seem to push. If you do, does it seem worth your while? What can one expect to make on this stuff. $15 per client? Best regards, Jeff F. __ 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
FK related to PK in same table?
I've got a table with details of pages in a site. There's a pageID, and also a parentID. If the page has no parent, this is 0, otherwise it's the same as the pageID of the parent. What's the deal with having Foreign Keys that aren't exactly er... foreign?! I pretty much know this is "doable" cos I've done it before, but I'm trying to define the relationship with Access 2000's GUI, and I can't seem to get it to recognise parentID as being related to the pageID in the same table. Any ideas? - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ 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: FK related to PK in same table?
> I've got a table with details of pages in a site. There's > a pageID, and also a parentID. If the page has no parent, > this is 0, otherwise it's the same as the pageID of the > parent. > > What's the deal with having Foreign Keys that aren't exactly > er... foreign?! I pretty much know this is "doable" cos I've > done it before, but I'm trying to define the relationship > with Access 2000's GUI, and I can't seem to get it to > recognise parentID as being related to the pageID in the > same table. I don't think that the Access Relationship Builder GUI supports self-referential relationships, or "fishhooks" as they're sometimes called. I think you'd have to build that manually, using SQL, and even that may not be supported by Access for all I know. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Get Your Own Dedicated Windows 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=coldfusionb 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: Getting results from a checkbox list...
Hi, I'm displaying a list of fonts from a database. SELECT sti, ID FROMfontsti ORDER BY sti #GetFontFamily.sti# Which displays something like: [ X ] aachen [ ] accolade [ X ] adelon [ X ] amelia and so on... My question is, how can I display just the fonts that are checked above in another template for further processing. __ Get Your Own Dedicated Windows 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=coldfusionb 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
