Re: nvarchar Insert
Booyah! It Works. Thanks again, wise ones. Truly, Guy McDowell Web Developer [EMAIL PROTECTED] - Magma Communications Ltd. t: 613.228.3565 x6348 f: 613.228.8313 http://websites.magma.ca This e-mail message is confidential, may be privileged and is intended for the exclusive use of the addressee. Any other person is strictly prohibited from disclosing, distributing or reproducing it. If the addressee cannot be reached or is unknown to you, please inform the sender by return e-mail immediately and delete this e-mail message and destroy all copies. Due to the inherent risks associated with the Internet, we assume no responsibility for unauthorized interception of any Internet communication with you or the transmission of computer viruses. Thank you. ~| Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta http://www.houseoffusion.com/banners/view.cfm?bannerid=40 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182936 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: nvarchar Insert
Yep, it's Latin. In design circles it's known as the Lorem Ipsum text and has been the standard place-holder text since about the 1500's. I think it's a piece by Cicero on human suffering and the pursuit of pleasure. My latin's not so good anymore. Thanks Michael for On Line Books tip. Should have cheked there first... Truly, Guy McDowell Web Developer [EMAIL PROTECTED] - Magma Communications Ltd. t: 613.228.3565 x6348 f: 613.228.8313 http://websites.magma.ca This e-mail message is confidential, may be privileged and is intended for the exclusive use of the addressee. Any other person is strictly prohibited from disclosing, distributing or reproducing it. If the addressee cannot be reached or is unknown to you, please inform the sender by return e-mail immediately and delete this e-mail message and destroy all copies. Due to the inherent risks associated with the Internet, we assume no responsibility for unauthorized interception of any Internet communication with you or the transmission of computer viruses. Thank you. ~| This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.houseoffusion.com/banners/view.cfm?bannerid=11 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182935 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: nvarchar Insert
Yep, double checked that. Now I'm using cfqueryparam, and the insert is
working flawlessly. However the output is truncated to less than 30
characters.
When I insert:
Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Sed ultrices
iaculis erat. Phasellus nisl magna, sollicitudin a, condimentum at, ornare
in, eros. Nulla tellus est, faucibus ut, mollis eu, fermentum sed, wisi.
Nulla a ipsum. Proin posuere nullam.
All I get back from it is:
Lorem ipsum dolor sit amet, co
The text in the table is identical to what I am inserting, so is there a
different way to output this stuff?
The output query grabs it like such:
CAST(pl.txtDescription AS nvarchar) AS txtDescription
Truly,
Guy McDowell
Web Developer
[EMAIL PROTECTED] - Magma Communications Ltd.
t: 613.228.3565 x6348
f: 613.228.8313
http://websites.magma.ca
This e-mail message is confidential, may be privileged and is intended for
the exclusive use of the addressee. Any other person is strictly
prohibited from disclosing, distributing or reproducing it. If the
addressee cannot be reached or is unknown to you, please inform the sender
by return e-mail immediately and delete this e-mail message and destroy
all copies. Due to the inherent risks associated with the Internet, we
assume no responsibility for unauthorized interception of any Internet
communication with you or the transmission of computer viruses. Thank
you.
Joe Rinehart <[EMAIL PROTECTED]>
29/10/2004 10:17 AM
Please respond to
[EMAIL PROTECTED]
To
CF-Talk <[EMAIL PROTECTED]>
cc
Subject
Re: nvarchar Insert
Guy,
I'd double check your column definition to make sure it's set to 300
and not 30...I've been known to do things like this from time to time.
-joe
On Fri, 29 Oct 2004 10:12:56 -0400, Guy McDowell <[EMAIL PROTECTED]>
wrote:
> Hi,
>
> Having trouble with this one.
>
> SQL 2000 and the field datatype is nvarchar set to 300 chars.
>
> Insert Statement:
> INSERT INTO tblMyTable (txtField)
> VALUES ('#frmTxtField#')
>
> '#frmTxtField#' comes from a textarea form element.
> Sometimes I get a "truncate data" error from the database. Sometimes it
does the insert but only the first 30 or so characters.
>
> I feel like I'm missing something obvious.
>
> ~Guy
>
>
~|
Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta
http://www.houseoffusion.com/banners/view.cfm?bannerid=40
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182931
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
nvarchar Insert
Hi,
Having trouble with this one.
SQL 2000 and the field datatype is nvarchar set to 300 chars.
Insert Statement:
INSERT INTO tblMyTable (txtField)
VALUES ('#frmTxtField#')
'#frmTxtField#' comes from a textarea form element.
Sometimes I get a "truncate data" error from the database. Sometimes it does the
insert but only the first 30 or so characters.
I feel like I'm missing something obvious.
~Guy
~|
Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta
http://www.houseoffusion.com/banners/view.cfm?bannerid=40
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182923
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Image Resize Tag on Unix
The kicker is finding one that doesn't use CreateObject or cf_object or such (due to security implications). Truly, Guy McDowell Web Developer [EMAIL PROTECTED] - Magma Communications Ltd. t: 613.228.3565 x6348 f: 613.228.8313 http://websites.magma.ca This e-mail message is confidential, may be privileged and is intended for the exclusive use of the addressee. Any other person is strictly prohibited from disclosing, distributing or reproducing it. If the addressee cannot be reached or is unknown to you, please inform the sender by return e-mail immediately and delete this e-mail message and destroy all copies. Due to the inherent risks associated with the Internet, we assume no responsibility for unauthorized interception of any Internet communication with you or the transmission of computer viruses. Thank you. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Image Resize Tag on Unix
Hi, We're looking forn image resize tag to use in a Unix/CFMX environment. Any leads? We're Googling to no avail. Truly, Guy McDowell Web Developer [EMAIL PROTECTED] - Magma Communications Ltd. t: 613.228.3565 x6348 f: 613.228.8313 http://websites.magma.ca This e-mail message is confidential, may be privileged and is intended for the exclusive use of the addressee. Any other person is strictly prohibited from disclosing, distributing or reproducing it. If the addressee cannot be reached or is unknown to you, please inform the sender by return e-mail immediately and delete this e-mail message and destroy all copies. Due to the inherent risks associated with the Internet, we assume no responsibility for unauthorized interception of any Internet communication with you or the transmission of computer viruses. Thank you. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
UNIX Image Resizer Tag
We're looking for an image resize tag to be used in a Unix/CFMX environment. Anybody know of one? Googling isn't paying off. Truly, Guy McDowell Web Developer [EMAIL PROTECTED] - Magma Communications Ltd. t: 613.228.3565 x6348 f: 613.228.8313 http://websites.magma.ca This e-mail message is confidential, may be privileged and is intended for the exclusive use of the addressee. Any other person is strictly prohibited from disclosing, distributing or reproducing it. If the addressee cannot be reached or is unknown to you, please inform the sender by return e-mail immediately and delete this e-mail message and destroy all copies. Due to the inherent risks associated with the Internet, we assume no responsibility for unauthorized interception of any Internet communication with you or the transmission of computer viruses. Thank you. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CF and JavaScript Form Question
That's how I would have done it, were I coding from scratch. But I'm working with someone's old code, so I'm somewhat limited, if I don't want to rewrite the action page. And I don't as it's due tomorrow. I think I'll go with the list in the URL. It should work. Guy McDowell Web Developer [EMAIL PROTECTED] - Magma Communications Ltd. t: 613.228.3565 x6348 f: 613.228.8313 http://websites.magma.ca This e-mail message is confidential, may be privileged and is intended for the exclusive use of the addressee. Any other person is strictly prohibited from disclosing, distributing or reproducing it. If the addressee cannot be reached or is unknown to you, please inform the sender by return e-mail immediately and delete this e-mail message and destroy all copies. Due to the inherent risks associated with the Internet, we assume no responsibility for unauthorized interception of any Internet communication with you or the transmission of computer viruses. Thank you. Michael Traher <[EMAIL PROTECTED]> wrote on 25/09/2004 08:30:38 AM: > Hi Guy, > Sorry about your Dad, thats a tough one we all have to face. > > On your question; why not just submit the form to an action page in > the normal way? > i.e. > > in the action page you can loop through the #form# structure and all > your dynamic form fields will be there. > > You can use structure functions such as structKeyList() if you need to > know the names of the form fields. > > Hope that is of some help. > Michael > > - Original Message - > From: [EMAIL PROTECTED] <[EMAIL PROTECTED]> > Date: Fri, 24 Sep 2004 19:49:53 -0400 > Subject: CF and _javascript_ Form Question > To: CF-Talk <[EMAIL PROTECTED]> > > Goal : > > To take form values from the dynamically generated, and named, form > elements and pass those values onto an action page. > > Intended Course: > Write the variables to a CF Array or Structure, client side through a > _javascript_ function -> WDDX serialize that Array into a client scope WDDX > -> Deserialize the WDDX Packet on the action page. > > Challenge: > I absolutely suck at _javascript_. I thought I knew something - turns out I > don't. > > Code in Question: > > > > > Size="1">Qty. of #MakeSize#: > > size="4"> > > > > NOTE: MakeSize is the String Equiv of Value_ID ie. ValueID =24 then > MakeSize = Large, ValueID = 23 then MakeSize = Small, etc > > Question: > What's the quickest way to do this? > > This could generate 0 - 15 or so form elements, so I think URL variables > are out. Maybe not. Possibly put these into a list and pass that in the > URL and parse it out on the other side? If so - how? > > Am I out to lunch with the WDDX idea? If not, where could I go to see how > to create a CF Array or Struct via a _javascript_ function? > > Personal Note: Not thinking well - my first B-day without my dad. First > everything after losing someone always sucks. Yeah, I'm a > heart-on-my-sleeve guy. > > Guy McDowell > Web Developer > [EMAIL PROTECTED] - Magma Communications Ltd. > t: 613.228.3565 x6348 > f: 613.228.8313 > http://websites.magma.ca > > This e-mail message is confidential, may be privileged and is intended for > the exclusive use of the addressee. Any other person is strictly > prohibited from disclosing, distributing or reproducing it. If the > addressee cannot be reached or is unknown to you, please inform the sender > by return e-mail immediately and delete this e-mail message and destroy > all copies. Due to the inherent risks associated with the Internet, we > assume no responsibility for unauthorized interception of any Internet > communication with you or the transmission of computer viruses. Thank > you. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CF and JavaScript Form Question
Goal : To take form values from the dynamically generated, and named, form elements and pass those values onto an action page. Intended Course: Write the variables to a CF Array or Structure, client side through a _javascript_ function -> WDDX serialize that Array into a client scope WDDX -> Deserialize the WDDX Packet on the action page. Challenge: I absolutely suck at _javascript_. I thought I knew something - turns out I don't. Code in Question: Size="1">Qty. of #MakeSize#: size="4"> NOTE: MakeSize is the String Equiv of Value_ID ie. ValueID =24 then MakeSize = Large, ValueID = 23 then MakeSize = Small, etc Question: What's the quickest way to do this? This could generate 0 - 15 or so form elements, so I think URL variables are out. Maybe not. Possibly put these into a list and pass that in the URL and parse it out on the other side? If so - how? Am I out to lunch with the WDDX idea? If not, where could I go to see how to create a CF Array or Struct via a _javascript_ function? Personal Note: Not thinking well - my first B-day without my dad. First everything after losing someone always sucks. Yeah, I'm a heart-on-my-sleeve guy. Guy McDowell Web Developer [EMAIL PROTECTED] - Magma Communications Ltd. t: 613.228.3565 x6348 f: 613.228.8313 http://websites.magma.ca This e-mail message is confidential, may be privileged and is intended for the exclusive use of the addressee. Any other person is strictly prohibited from disclosing, distributing or reproducing it. If the addressee cannot be reached or is unknown to you, please inform the sender by return e-mail immediately and delete this e-mail message and destroy all copies. Due to the inherent risks associated with the Internet, we assume no responsibility for unauthorized interception of any Internet communication with you or the transmission of computer viruses. Thank you. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Brain Fart...GetTemplatePath(), I don't want it *all*
What if you did a function on it like? remove)> I haven't actually tried this, so I'm not sure exactly how to set the start point and would only work if the path to your root was consistently the same num of characters. Guy McDowell Web Developer [EMAIL PROTECTED] - Magma Communications Ltd. t: 613.228.3565 x6348 f: 613.228.8313 http://websites.magma.ca This e-mail message is confidential, may be privileged and is intended for the exclusive use of the addressee. Any other person is strictly prohibited from disclosing, distributing or reproducing it. If the addressee cannot be reached or is unknown to you, please inform the sender by return e-mail immediately and delete this e-mail message and destroy all copies. Due to the inherent risks associated with the Internet, we assume no responsibility for unauthorized interception of any Internet communication with you or the transmission of computer viruses. Thank you. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: OT- NEWS - cfcertification.com
RE: OT- NEWS - cfcertification.com Don't visit this site - it has very little to do with ColdFusion. READ: Pr0n Guy McDowell Web Developer [EMAIL PROTECTED] - Magma Communications Ltd. t: 613.228.3565 x6348 f: 613.228.8313 http://websites.magma.ca This e-mail message is confidential, may be privileged and is intended for the exclusive use of the addressee. Any other person is strictly prohibited from disclosing, distributing or reproducing it. If the addressee cannot be reached or is unknown to you, please inform the sender by return e-mail immediately and delete this e-mail message and destroy all copies. Due to the inherent risks associated with the Internet, we assume no responsibility for unauthorized interception of any Internet communication with you or the transmission of computer viruses. Thank you. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Bad Radio Button
Turns out my problem stemmed from using deprecated values for checked. I used checked = "yes", when it's supposed to be just checked or nothing at all. Guy McDowell Web Developer [EMAIL PROTECTED] - Magma Communications Ltd. t: 613.228.3565 x6348 f: 613.228.8313 http://websites.magma.ca This e-mail message is confidential, may be privileged and is intended for the exclusive use of the addressee. Any other person is strictly prohibited from disclosing, distributing or reproducing it. If the addressee cannot be reached or is unknown to you, please inform the sender by return e-mail immediately and delete this e-mail message and destroy all copies. Due to the inherent risks associated with the Internet, we assume no responsibility for unauthorized interception of any Internet communication with you or the transmission of computer viruses. Thank you. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Bad Radio Button
I'm just going through a query. When I run my query through SQL Query analyzer, the third record is the one with the flag of '1', when I dump the query the third record is the one with the flag of '1' - but still it's the fifth radio button that gets set to 'checked'. I also have it set up so that only one record can ever be set to one. I dunno. It's an amatuer error somewhere I'm sure. Guy McDowell Web Developer [EMAIL PROTECTED] - Magma Communications Ltd. t: 613.228.3565 x6348 f: 613.228.8313 http://websites.magma.ca This e-mail message is confidential, may be privileged and is intended for the exclusive use of the addressee. Any other person is strictly prohibited from disclosing, distributing or reproducing it. If the addressee cannot be reached or is unknown to you, please inform the sender by return e-mail immediately and delete this e-mail message and destroy all copies. Due to the inherent risks associated with the Internet, we assume no responsibility for unauthorized interception of any Internet communication with you or the transmission of computer viruses. Thank you. "Adrian Lynch" <[EMAIL PROTECTED]> 12/09/2004 04:51 PM Please respond to [EMAIL PROTECTED] To CF-Talk <[EMAIL PROTECTED]> cc Subject RE: Bad Radio Button Got any more info? Are you looping over a recordset? What else is happening? Ade -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 12 September 2004 21:11 To: CF-Talk Subject: Bad Radio Button Alright, this is what I've got getInspirationsPEBanner.blnLgBnrActive IS 1> value="1" checked="Yes" value="0" checked="No"> But what's happening is that the 3rd record through should be checked, since getInspirationsPEBanner.blnLgBnrActive EQ 1, but no, the last record is getting checked. I can do this stuff, I just need a fresh set of eyes to look at it. Guy McDowell Web Developer [EMAIL PROTECTED] - Magma Communications Ltd. t: 613.228.3565 x6348 f: 613.228.8313 http://websites.magma.ca This e-mail message is confidential, may be privileged and is intended for the exclusive use of the addressee. Any other person is strictly prohibited from disclosing, distributing or reproducing it. If the addressee cannot be reached or is unknown to you, please inform the sender by return e-mail immediately and delete this e-mail message and destroy all copies. Due to the inherent risks associated with the Internet, we assume no responsibility for unauthorized interception of any Internet communication with you or the transmission of computer viruses. Thank you. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Bad Radio Button
Alright, this is what I've got getInspirationsPEBanner.blnLgBnrActive IS 1> value="1" checked="Yes" value="0" checked="No"> But what's happening is that the 3rd record through should be checked, since getInspirationsPEBanner.blnLgBnrActive EQ 1, but no, the last record is getting checked. I can do this stuff, I just need a fresh set of eyes to look at it. Guy McDowell Web Developer [EMAIL PROTECTED] - Magma Communications Ltd. t: 613.228.3565 x6348 f: 613.228.8313 http://websites.magma.ca This e-mail message is confidential, may be privileged and is intended for the exclusive use of the addressee. Any other person is strictly prohibited from disclosing, distributing or reproducing it. If the addressee cannot be reached or is unknown to you, please inform the sender by return e-mail immediately and delete this e-mail message and destroy all copies. Due to the inherent risks associated with the Internet, we assume no responsibility for unauthorized interception of any Internet communication with you or the transmission of computer viruses. Thank you. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
DHTML Drag and Drop pt.2
There's the kicker. It's on an internal dev server. I'm going to just put in the time getting to know _javascript_ just like you folks did. Your pointing in the right direction has certainly helped. Guy McDowell Web Developer [EMAIL PROTECTED] - Magma Communications Ltd. t: 613.228.3565 x6348 f: 613.228.8313 http://websites.magma.ca This e-mail message is confidential, may be privileged and is intended for the exclusive use of the addressee. Any other person is strictly prohibited from disclosing, distributing or reproducing it. If the addressee cannot be reached or is unknown to you, please inform the sender by return e-mail immediately and delete this e-mail message and destroy all copies. Due to the inherent risks associated with the Internet, we assume no responsibility for unauthorized interception of any Internet communication with you or the transmission of computer viruses. Thank you. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: DHTML Drag and Drop pt.2
That's the kicker. It's on an internal dev server. I think I'm just going to have to put in the extra hours at night to really wrap my head around this. I understand, in principal, what needs to happen and the events required, now I just need to get to know the code. Thanks anyway folks! Guy McDowell Web Developer [EMAIL PROTECTED] - Magma Communications Ltd. t: 613.228.3565 x6348 f: 613.228.8313 http://websites.magma.ca This e-mail message is confidential, may be privileged and is intended for the exclusive use of the addressee. Any other person is strictly prohibited from disclosing, distributing or reproducing it. If the addressee cannot be reached or is unknown to you, please inform the sender by return e-mail immediately and delete this e-mail message and destroy all copies. Due to the inherent risks associated with the Internet, we assume no responsibility for unauthorized interception of any Internet communication with you or the transmission of computer viruses. Thank you. >> Still struggling with this drag and drop issue. > >Guy, > >I would like to help, but as Micha said, we'll need to see a little more of >what you are talking about. Can you post it? > >Matthieu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
DHTML Drag and Drop pt.2
Hi again. Still struggling with this drag and drop issue. I think the problem is I am not that strong with _javascript_. But time is limited for this mini-project. I've mostly only taken existing JS and manipulated to my need. What I am trying to do is have the records from a query be 'draggable' so that say, I have a record in position 32 but I want it moved up to position 28. Instead of using buttons to promote or demote by one each time, I would simply drag the record up to position 28. It would then call to the appropriate query to make the change in the database and send the former 28 down to 29. Then it would, of course, call back to the page with the list and be updated. Has anyone seen anything close to what I'm trying to do so that I might bend that JS source to my will? Believe me when I say I will be taking a course in JS! Guy McDowell Web Developer [EMAIL PROTECTED] - Magma Communications Ltd. t: 613.228.3565 x6348 f: 613.228.8313 http://websites.magma.ca This e-mail message is confidential, may be privileged and is intended for the exclusive use of the addressee. Any other person is strictly prohibited from disclosing, distributing or reproducing it. If the addressee cannot be reached or is unknown to you, please inform the sender by return e-mail immediately and delete this e-mail message and destroy all copies. Due to the inherent risks associated with the Internet, we assume no responsibility for unauthorized interception of any Internet communication with you or the transmission of computer viruses. Thank you. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
request scope and grouped output
Hi All, I have a table that I would like to replicate each time the output loops through, based on grouping. However, within the table there are outputs that call to the request scope variables. That in turn throws an error as the request scope variables aren't a part of the grouped query's record set. Help? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: DHTML Drag and Drop to reorder record set
Hi Matthieu, That's exactly the launching pad I was hoping for. Not to mention the exact same functionality that I am going for. Your description is excellent and concise. Might you think of doing a tutorial on it for other folks? Thanks again. ~Guy [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Problem with accented character in file names and CFFILE
I believe this is a multilanguage issue. Check on multilanguage settings in your CF Admin if you have access. Or, if it is expected that people will be naming things using accents frequently, parse out accented letters and replace with the corresponding unaccented letters prior to executing your CFFILE. Much like you would do should you not want people to use numbers or such. Hope this points you in the right direction. ~Guy [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
DHTML Drag and Drop to reorder record set
Hi, I'm not a DHTML guy by any means. Could someone point me in the right direction to figuring out how to use DHTML to take a record from within a record set, drag it to a higher or lower position, and have it change its position within the record set? Basically what I have is like a to do list. But lets say I want to take item #5 and drop it between item #2 and #3 so it becomes the new #3 and the old #3 becomes #4 and so on. I've got the logic basically but not the code. Any good tutorials or examples of something similar? TIA, Guy [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Dynamic DNS and IP
Hi John, Yep, noip.com is what I'm using too for the DNS update. However, due to my daftness, I kept going into IIS and changing the IP manually instead of just setting it to All Unnassigned. Works wonderfully now. I'm looking into easyDNS as they have some sort of association with my ISP. Hard to find out if they have all the features of noip or not though. I'd like to be able to host multiple domains on my box and noip has the ability to let me do that, DNS wise, but I can't tell if easyDNS will. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Dynamic DNS and IP
Whoops, it works now, after a few restarts. Should have known a few restarts was all I needed with MS stuff. Thanks Jochem. ~Guy http://guymcdowell.hopto.org [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Dynamic DNS and IP
Hi Jochem, I've set the IP Address value to "All Unassigned" and it doesn't work. Is that what you meant by setting IIS to listen on all IP addresses? ~Guy http://guuymcdowell.hopto.org >Guy McDowell said: > >Why? If you set IIS to listen on all IP addresses it works >automagically. But if you *really* want to, I use mdutil.exe for all >IIS automation and it can do this too. > >Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Dynamic DNS and IP
Hello all, I'd like to be able to host my personal site of my home box. I've got a util for updating the IP on the DNS automatically, but I'd like to know if there is a util for updating the IP on my webserver automatically, or at least just by running a batch file or something similar. Anyone seen such a creature? Specs: IIS 5.0 (willing to go apache though), Win2K Pro, CF 5 Thx, Guy http://guymcdowell.hopto.org [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Encrypting CF code/files
I think cfhub.com has a quick tutorial on making a simple app to use cfencrypt.exe And, yes, it is super easy to decrypt, I think it's MOD10 encryption if I remember correctly. As always, locked doors only keep honest people out. So licensing is important in any "boxed" product. ~Guy http://guymcdowell.hopto.org [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Any Interest In Managing A Small Web Site?
Please accept my apologies for posting my reply to this to the list. I truly regret that. Truly, Guy J. McDowell, M.M.C.P. (705) 324-9144 ex 3422 [EMAIL PROTECTED] Sir Sandford Fleming College Frost Campus P.O. Box 8000 Lindsay, Ontario K9V 5E6 >>> [EMAIL PROTECTED] 03/05/03 06:35am >>> I'm looking for anyone interested in managing www.divepuertorico.com It's a scuba shop in Puerto Rico, It probably doesn't pay much, but you'd get all the free diving or snorkling you could handle should you visit. Please respond off-line, and I apologize for using this forum for this, but time is a big factor and I know there's the right webster here somewhere. Keith ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Any Interest In Managing A Small Web Site?
Hello Keith, I'm interested in doing this, pending some clarification. If they are just looking for HTML based updates I do that for $20/hr Canadian. If they are looking for a dynamic backend to be developed (a la ColdFusion) I do that for $40/hr Canadian. I've done web editing/design and Content Management System development for such sites as www.canlearn.ca, www.ofah.org, www.quidnovis.com and more. I'm strongest in ColdFusion 5, HTML, SQL, JavaScript and Flash 5 as well as Spectra 1.5.1. The downside is that my time is limited as I have a full-time job and would be doing this in the off-hours. A few hours a week would be the most I could handle for updates. If they need some serious development work I could handle about 10 hours per week. I hope that provides all the info you need. I look forward to hearing back from you! So how's the weather out west? We just got another foot of snow in Ontario. Truly, Guy J. McDowell, M.M.C.P. (705) 324-9144 ex 3422 [EMAIL PROTECTED] Sir Sandford Fleming College Frost Campus P.O. Box 8000 Lindsay, Ontario K9V 5E6 >>> [EMAIL PROTECTED] 03/05/03 06:35am >>> I'm looking for anyone interested in managing www.divepuertorico.com It's a scuba shop in Puerto Rico, It probably doesn't pay much, but you'd get all the free diving or snorkling you could handle should you visit. Please respond off-line, and I apologize for using this forum for this, but time is a big factor and I know there's the right webster here somewhere. Keith ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Inserting into MySQL database
Hello All,
Naive guy here...would cfinsert be suitable in this situation? Whih
leads me to another question; which is more effective/efficient /?
Cfinsert or an SQL insert statement?
Truly,
Guy J. McDowell, M.M.C.P.
(705) 324-9144 ex 3422
[EMAIL PROTECTED]
Sir Sandford Fleming College
Frost Campus
P.O. Box 8000
Lindsay, Ontario
K9V 5E6
>>> [EMAIL PROTECTED] 02/24/03 09:56AM >>>
FlashGuy wrote:
>
>
> Insert into myresults
> (strFileName, strCommand, strCreatedOn, strLastAcc, strLastMod,
strSize, strDirectory, strDateCommand, strUsername)
> VALUES
> ('#Filename#', )
> ('#FileCommand#', )
>
> ...and so on...
>
>
> Is this the correct syntax?
No: http://www.mysql.com/doc/en/INSERT.html
INSERT INTO myresults (
strFileName,
strCommand,
strCreatedOn,
strLastAcc,
strLastMod,
strSize,
strDirectory,
strDateCommand,
strUsername
)
VALUES (
,
,
...,
...,
...,
...,
...,
...,
...
)
> Is there an easier way?
No.
Jochem
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: 3 Cells Wide
Hi Nathan, Did you ever have one of those experiences where, when you see the solution it all becomes so painfully clear? Well, this is one of those experiences for me. ;-) Thank you very much for your incredibly timely help. Truly, Guy J. McDowell, M.M.C.P. (705) 324-9144 ex 3422 [EMAIL PROTECTED] Sir Sandford Fleming College Frost Campus P.O. Box 8000 Lindsay, Ontario K9V 5E6 >>> [EMAIL PROTECTED] 02/21/03 12:28pm >>> Sorry, I posted that without testing. To get a new row every three cells, the output code should be: #queryName.categoryName# #queryName.subCategoryName# More... --Nathan > -Original Message- > From: Nathan Mische > Sent: Friday, February 21, 2003 12:23 PM > To: CF-Talk > Subject: 3 Cells Wide > > > Hey Guy, > > This is what I came up with: > > > > SELECT c.categoryName, s.subCategoryName > FROM tblCategory c, tblSubCategory s > WHERE c.categoryid = s.categoryid > ORDER BY c.categoryName > > > > > > > > > #queryName.categoryName# > > > > #queryName.subCategoryName# > > More... > >subCategoryCount=subCategoryCount+1> > > > > > > > > > There may be a more efficient way of doing what you proposed, > but this gets the job done. > > Best, > > Nathan > > > > -Original Message- > > From: Guy McDowell [mailto:[EMAIL PROTECTED]] > > Sent: Friday, February 21, 2003 11:26 AM > > To: CF-Talk > > Subject: Re: 3 Cells Wide > > > > > > Hi Dave (and everyone else), > > > > I've got the grouping and ordering down, it's the formatting > > of the output that's the challenge. The trick is to get my > > HTML table only 3 cols wide and then only have the first 3 > > results of the query on the Subcategory table displayed under > > the appropriate Category heading. > > > > I have a straight HTML version on the index of my site to > > illustrate where I am trying to go with this. It's at > > http://www.guymcdowell.com > > > > TIA, > > > > > > > > Truly, > > > > Guy J. McDowell, M.M.C.P. > > (705) 324-9144 ex 3422 > > [EMAIL PROTECTED] > > > > Sir Sandford Fleming College > > Frost Campus > > P.O. Box 8000 > > Lindsay, Ontario > > K9V 5E6 > > > > > > >>> [EMAIL PROTECTED] 02/21/03 10:33am >>> > > >This is a borderline newbie question. Perhaps we should have a > > >CF-Brainfart list. Anyway > > > > > >Challenge: To have out put from two tables put into a three column > > >wide, n-rows deep HTML table a la Yahoo! Each column's formatted > > output > > >would look something like this: > > > > > >Category Name > > > > > >Subcategory Name 1, Subcategory Name 2, Subcategory Name 3, more... > > > > > >Given: CF 5, MS Access 2000, tblCategory, tblSubcategory, one rusty > > CF > > >developer. > > > > > >I'm pretty sure this is a job for query-a-query and loop list while > > >n<=3 type logic, but I just can't get it to jive. Help? > > > > Nah. Look into the "group" attribute of the > query...> tag. Just > > group your query results by the category name and you should > > be good to go. > > The key is the ORDER BY clause in your SQL statement. You > > want to make sure > > you order by the category name so that CF can properly > group the data. > > > > Here's a brief sample: > > > > > > SELECT c.categoryName, > > s.subcategory > > FROM tblCategory c, tblSubcategory s > > WHERE c.categoryid = s.categoryid > > ORDER BY c.categoryName > > > > > > Then in your
Re: 3 Cells Wide
Hi Dave (and everyone else), I've got the grouping and ordering down, it's the formatting of the output that's the challenge. The trick is to get my HTML table only 3 cols wide and then only have the first 3 results of the query on the Subcategory table displayed under the appropriate Category heading. I have a straight HTML version on the index of my site to illustrate where I am trying to go with this. It's at http://www.guymcdowell.com TIA, Truly, Guy J. McDowell, M.M.C.P. (705) 324-9144 ex 3422 [EMAIL PROTECTED] Sir Sandford Fleming College Frost Campus P.O. Box 8000 Lindsay, Ontario K9V 5E6 >>> [EMAIL PROTECTED] 02/21/03 10:33am >>> >This is a borderline newbie question. Perhaps we should have a >CF-Brainfart list. Anyway > >Challenge: To have out put from two tables put into a three column >wide, n-rows deep HTML table a la Yahoo! Each column's formatted output >would look something like this: > >Category Name > >Subcategory Name 1, Subcategory Name 2, Subcategory Name 3, more... > >Given: CF 5, MS Access 2000, tblCategory, tblSubcategory, one rusty CF >developer. > >I'm pretty sure this is a job for query-a-query and loop list while >n<=3 type logic, but I just can't get it to jive. Help? Nah. Look into the "group" attribute of the tag. Just group your query results by the category name and you should be good to go. The key is the ORDER BY clause in your SQL statement. You want to make sure you order by the category name so that CF can properly group the data. Here's a brief sample: SELECT c.categoryName, s.subcategory FROM tblCategory c, tblSubcategory s WHERE c.categoryid = s.categoryid ORDER BY c.categoryName Then in your output, you'd do something like: #queryName.categoryName# #queryName.subcategory# The nested is necessary because you need to "tell" CF which fields to group. Something like that should take care of your issue. Haven't tested that code, but it looks Kosher. Regards, Dave. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
3 Cells Wide
This is a borderline newbie question. Perhaps we should have a CF-Brainfart list. Anyway Challenge: To have out put from two tables put into a three column wide, n-rows deep HTML table a la Yahoo! Each column's formatted output would look something like this: Category Name Subcategory Name 1, Subcategory Name 2, Subcategory Name 3, more... Given: CF 5, MS Access 2000, tblCategory, tblSubcategory, one rusty CF developer. I'm pretty sure this is a job for query-a-query and loop list while n<=3 type logic, but I just can't get it to jive. Help? Truly, Guy J. McDowell, M.M.C.P. (705) 324-9144 ex 3422 [EMAIL PROTECTED] Sir Sandford Fleming College Frost Campus P.O. Box 8000 Lindsay, Ontario K9V 5E6 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Disable form field based on select box
Also, check the spelling when you do this.
In your initial efforts you had disabled spelled 'diasabled'. Happens to me
more than I care to admit. ;-)
Guy J. McDowell
[EMAIL PROTECTED]
http://www.guymcdowell.com
>From: Bryan Love <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: RE: Disable form field based on select box
>Date: Thu, 20 Dec 2001 10:39:32 -0800
>
>You'll need this JS function at the top of your page...
>
>function txtDisable( theForm ){
> cBox = theForm.Contract_Type;
>
> if( cBox.options[cBox.selectedIndex].value == "Open Hourly" )
> theForm.Contract_Amount.disabled = true;
> else
> theForm.Contract_Amount.disabled = false;
>}
>
>the rest is pretty obvious...
>
>
>
>
>
>
>
>+---+
>Bryan Love
> Macromedia Certified Professional
> Internet Application Developer
> Database Analyst
>Telecomunication Systems
>[EMAIL PROTECTED]
>+---+
>
>"...'If there must be trouble, let it be in my day, that my child may
>have
>peace'..."
> - Thomas Paine, The American Crisis
>
>
>
>-Original Message-
>From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, December 20, 2001 10:27 AM
>To: CF-Talk
>Subject: Disable form field based on select box
>
>
>hello all!
>i have a select box called
>i would like to Disable a text field called
>value="#DollarFormat(RS_Update_PG2.Contract_Amount)#ut>">
>if the selecton in the select box IS
>
>but leave the text field enable if it is not selected
>
>I have tried this, but it dosnt seem to work
>
> onChange="
>
>
>value="#DollarFormat(RS_Update_PG2.Contract_Amount)#ut>">
>">
>
>
>any help would be great!
>-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: E-commerce
If no one has mentioned it, there is a tutorial over at Webmonkey.com on cf shopping carts. Truly, Guy J. McDowell NorthernObjects.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFPOP and Header Issue
Long time no inquire... Situation: Using CFPOP to retrieve messages, then validating the messages are from registered users. If so, then the message is forwarded via cfmail to the rest of the registered users. Problem: Using the 'header' or 'from' variable from cfpop and comparing the 'from' field to the e-mail field in the membership db doesn't always work. This is due to apps like MS Outlook allowing you to change the 'from' portion of your header to a non e-mail format. ie Guy McDowell instead of [EMAIL PROTECTED] Attempted Solutions: Tried using IP as unique identifier as well, however IP's often change each time the user signs on to their ISP. Given: Using Spectra and CF 4.5 Bueller? Bueller? Anyone? TIA, Guy J. McDowell 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: Sort by 1st three letters of month?
What I do is on forms in in the database I just use the numbers 1-12 for months as the data. Then on output I do somehting like JanuaryFebruary etc. It's not the most eloquent way but it works and is highly reusable. That way I just do an ordinary ORDER BY months, and it works. Of course this calls for having seperate fields for month, day, date. Guy www.guymcdowell.com >-- > >Date: Wed, 01 Aug 2001 00:33:11 -0600 >From: "Kwang Suh" <[EMAIL PROTECTED]> >Subject: RE: Sort by 1st three letters of month? >Message-ID: <000101c11a53$d676c440$[EMAIL PROTECTED]> > >Cast the text strings to a date within your SQL query. Then, you can >easily >sort by month. > >-Original Message- >From: Willy Ray [mailto:[EMAIL PROTECTED]] >Sent: July 31, 2001 2:23 PM >To: CF-Talk >Subject: Sort by 1st three letters of month? > > >Ok, I'm an idiot. I have my users putting in text strings for months. > >I need > >Jan. 12 > >to be ordered ahead of > >Aug. 9 > >These are text records. Is there any way to do this? I guess I could >parse >out the first three characters of whatever my user entered, run it through >a >big cfswitch to assign numerical values to the months, add a leading zero >to >the day part... > >Is there any easier way? > >Willy >~~ >Structure your ColdFusion code with Fusebox. Get the official book at >http://www.fusionauthority.com/bkinfo.cfm > _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp 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
Refresh Banner Rotator
Hi folks, I'm doing a simple banner rotator using CF and Flash 4. What I would like it to do is change the banners dynamically without refreshing the entire page via meta refresh. I've seen a few custom tags that do that nicely, but my ISP doesn't allow custom tags. I could cfmodule it in but then I'd have it in a bazillion directories and I'd rather not do that. Any ideas? Is JavaScript the answer here? Also, I'd like to be able to pass the variables into the Flash, but the only tutorial I found on this uses Flash5 not 4 so I can't read it. Code follows for selecting the banners and tracking them. Code modified from TeraTech ColdCuts. SELECT Sum(1) AS rnum FROM Banners SELECT RecID, BNRFile, BNRViews, BNRLink FROM Banners WHERE (((RecID)=#R1#)) UPDATE Banners SET BNRViews = #NewBNRViews# WHERE (((RecID)=#R1#)) http://active.macromedia.com/flash2/cabs/swflash.cab#version=4,0,0,0"; ID=OFAHBannerAds WIDTH=450 HEIGHT=75> http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash";> _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Displaying Images according to a queries output
Hi Andy, You could do so through Flash by outputting the results of your cfquery through a textfield. Heck, you could even make it animated if you want. Guy www.guymcdowell.com Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Verity Limits
Hi Philip, It may be in your indexing that the problem lies. Are you indexing the collection through the server admin or through ? You may be somehow excluding subdirectories. I use because I don't have access to the server and my code looks like such... I know you know this CF stuff way better than I do, but sometimes we miss little things like saying 'Yes' to recurse or forgetting extensions we might have used like .html or .asp I'm wondering also, if maybe there is some sort of server timeout going on before all results can be returned. HTH, Guy Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Custom tag dilemma
I could really use some custom tag functionality. Problem is, our host will not install or support any custom tags period. Add to that, that my organization is practically married to our host and won't change hosting. So...is there a way to implement a custom tag without it having to be in the CustomTags directory? Yours In Conservation, Guy J. McDowell Webmaster Ontario Federation of Anglers & Hunters (705) 748-6324 ext. 262 www.OFAH.org Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Dynamic Table Height
Hmmm... Situation: Two tables beside each other. One contains dynamic content, the other is static. Goal: To have both tables the same height at all times regardless of how much content is in the dynamic table. However, the dynamic table should also never be shorter than the static table. Resources: A novice understanding of JavaScript, info brought in via from an Access DB My Priority on this: Pretty low, but it would be really cool to be able to do. Yours In Conservation, Guy J. McDowell Webmaster Ontario Federation of Anglers & Hunters (705) 748-6324 ext. 262 www.OFAH.org Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
IP lookup
Hello, If I have a numeric IP address how can I look up who it is registered to? Just curious, because I'm getting some weird traffic that might be related to Poison Box. Yours In Conservation, Guy J. McDowell Webmaster Ontario Federation of Anglers & Hunters (705) 748-6324 ext. 262 www.OFAH.org Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Inexpensive Hosting
G'day eh? I'm trying to find very inexpensive CF hosting to no avail. Something under $20 CDN is preferred. I need to host my personal/resume site along with some CF examples I have done. Thought I saw someone post something about hosting for $5.95 a month If there is nothing like that, then is it possible for me to institute CF Server Express within my own account/directory on a regular hosting package of the WinNT variety? Guy www.guymcdowell.com Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Bulk Insert
Situation: Need to add about 1000 records to a remote DB. Trying to write a bulk insert type app in CF for it. Pretty sure I need to use CFLOOP - list to get it done. Resources: Access 2000 DB, csv file of records (comma delimited), no admin access to server, 24 hours. I'm thinking something like: INSERT INTO MyTable (Field1, Field2, Field3) VALUES (#ThisFile#) Form.Input comes, of course, from a textarea field on a form not shown here. Am I even close here? Just wanting tips or pointers, not outright answers. I love to learn this sort of thing for myself so I always know it. How does this know when it has reached EOF? Guy J. McDowell www.guymcdowell.com Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
