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

Re: nvarchar Insert

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

Re: nvarchar Insert

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

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

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

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

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

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

CF and JavaScript Form Question

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

Re: Brain Fart...GetTemplatePath(), I don't want it *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

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

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

Bad Radio Button

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

RE: Bad Radio Button

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

DHTML Drag and Drop pt.2

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

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

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

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

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

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]

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

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

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

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

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

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

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]

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

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

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

RE: 3 Cells Wide

-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

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

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:

CFPOP and Header Issue

' 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

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 cfif month IS 1January/cfif cfif month IS 2February/cfif etc. It's not the most eloquent way but it works and is highly reusable. That way I just do an ordinary

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

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:

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

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 cfindex? You may be somehow excluding subdirectories. I use cfindex because I don't have access to the server and my code looks like such... cfindex

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.

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

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,

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