Re: Graphic Manipulation in Coldfusion question.

2005-03-30 Thread Cutter (CF-Talk)
es not contain that part of the > cropped part of the image. > > Jeff > > > >>-Original Message- >>From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED] >>Sent: Wednesday, March 30, 2005 2:28 PM >>To: CF-Talk >>Subject: Re: Graphic Manipulation

Re: Graphic Manipulation in Coldfusion question.

2005-03-30 Thread Cutter (CF-Talk)
Jeff, You'll have to test this, but you should be able to assign the graphic an idea and then, using CSS, set your clip region to "clip off" the excess pixels. Better option may be to place the image in a div (a) within another div (b) and set the clip region to div b while setting the width a

Re: Process CF Page Then Cancel Response

2005-03-24 Thread Cutter (CF-Talk)
erson who is logged in. > > This really isn't a mission-critical feature. Even if I put a > confirmation page, that doesn't really mean the email actually got all > the way to their inbox. > > Thanks! > > -Original Message- > From: Spike [mailto:[EMAIL PRO

Re: embedding an image in cfmail

2005-03-18 Thread cf coder
thanks for this. I'll do this on Monday as I have to wait for clearance. Regards cfcoder ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a proj

Re: embedding an image in cfmail

2005-03-18 Thread cf coder
Just looked up the cfmailparam tag in the coldfusion 6.1 online documentation. CONTENTID attribute is not part of the tag. It is however included in CFMX 7 http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-pb2.htm#wp1101294 http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/ww

Re: embedding an image in cfmail

2005-03-18 Thread cf coder
I get an error when I run that code Attribute validation error for tag CFMAILPARAM. The tag does not allow the attribute(s) CONTENTID. The valid attribute(s) are FILE,NAME,TYPE,VALUE. This is the cfmx version I have installed on the server Version 6,1,0,hf52806_61 Any thoughts?

Re: embedding an image in cfmail

2005-03-18 Thread cf coder
thanks Jedi for your reply. How do I go about embeding it. And the cid where can I generate this? I'm sorry I don't have any past experience in it Regards cfcoder ~| Find out how CFTicket can increase your company's customer sup

Re: embedding an image in cfmail

2005-03-18 Thread cf coder
another thing I forgot to mention, when I run the image on the browser, I don't get prompted to enter the username and password. http://gateway/pages/Images/jobupdated.gif The security settings on the images folder is set to "Full Control" ~~~

embedding an image in cfmail

2005-03-18 Thread cf coder
Is it possible to do this in ColdFusion 6.1? I ask this because the email that is sent via cfmail has a div tag in it with the style background-image attribute and when I try to open the email in ms outlook, I get prompted to enter the username and password. I have XP Professional SP2 running on

Re: format y-axis in cfchart

2005-03-16 Thread cf coder
Hi again, I'm just so loosing my focus here. Not knowing how this things works is probably what's getting me all frustrated. Ok, here is what my query looks like SELECT CONVERT(varchar(15), dt.dtlogged, 106) AS dtlogged, dt.jobcount, j.jobPriority, j.jobNumber FROM ( SELECT CAST(CONVERT(v

format y-axis in cfchart

2005-03-15 Thread cf coder
The values displayed on the y-axis are are mix of float and int. The chart displays int values on the y-axis if I use only one cfchartseries tag. The code below calculates the value for the gridlines and scaleto attributes. [code] [/code] When I output this variable, the value returned is 88

SIGSEGV 11 segmentation violation

2005-03-15 Thread cf-talk
Has anyone ever seen this error in their server.log? SIGSEGV 11 segmentation violation si_signo [11]: SEGV si_errno [0]: si_code [1]: SEGV_MAPERR [addr: 0x0] "Information","TID=1","03/15/05","10:40:44"," The ColdFusion Application Server started" this is happening every 5 minute

Re: cfchart and cfchartdata question. Kindly help!

2005-03-15 Thread cf coder
I'm afraid that does not return the results I want to see returned. I am building a graph with the dates displayed on the x-axis and the count of jobs logged in a day dispalyed on the y-axis. If there are 3 jobs logged in a day, each job has a different jobPriority, I want to build a chart looki

sql select statement help..

2005-03-14 Thread cf coder
Hello everybody, I really need someone to help me here. I'm developing a graphical interface to report the no of jobs logged in a period. The x axis displays the period (days) and the y-axis displays the number of jobs logged in a given day. The data is pulled from the jobs table. The job logge

Re: cfchart and cfchartdata question. Kindly help!

2005-03-14 Thread cf coder
thanks Cliff for the reply. That did occur to me and its probably the only way to do it. However, I don't know how to build the select sql query. From what I understand when using the count() function, I can't any other column name in the select. select count(*), jobPriority from call where log

cfchart and cfchartdata question. Kindly help!

2005-03-14 Thread cf coder
Hello everybody, I really need someone to help me here. I'm new to charting. I'm developing a graphical interface to report the no of jobs logged in a period. The x axis displays the period (days) and the y-axis displays the number of jobs logged in a given day. The data is pulled from the jobs

CF 5 Server and Windows 2000 Server hanging almost every day

2005-03-13 Thread cf-talk
Hi list, every other day my CF-Server is hanging with the following results: "Warning","3112","03/13/05","04:40:56",,"A request exceeded the timeout. The unresponsive thread count is up to 1. [D:\kunden\customer1\eshop\import.cfm]" "Error&

Re: CFChart: Set Axis Markers?

2005-03-10 Thread cf coder
I would really appreciate it if someone showed me how to do this. I'm building a bar chart which displays the no of jobs logged in a month. Here is my code The values displayed in the y-axis are of type float. I want them to be numeric. Any help would be great

Re: ColdFusion ignores empty list elements

2005-03-07 Thread cf coder
Here is the code QuerySetCell(qTmp,"ref", Replace(listGetAt(fileLine,1),,"","All")); QuerySetCell(qTmp,"asset", Replace(listGetAt(fileLine,2),,"","All")); QuerySetCell(qTmp,"serial", Replace(listGetAt(fileLine,3),,"","All")); QuerySetCell(qTmp,"manufact", Replace(list

Re: ColdFusion ignores empty list elements

2005-03-07 Thread cf coder
thanks for that guys. I'm still getting an invalid list index error. if the list has 4 elements and I try to use the listgetat function to get the 5th element. I get an error. QuerySetCell(qTmp,"model", listGetAt(list,5)); Is there a way to say if it does not exist, do something else ex: i

ColdFusion ignores empty list elements

2005-03-07 Thread cf coder
ex: the list "a,b,c,,,d" has four elements How do I force it to not ignore empty elements? I'm getting an error with listGetAt(list,4). Any thoughts? Best regards cfcoder ~| Discover CFTicket - The leading ColdFusion Help Desk

OT: Forta and MDCFUG

2005-02-25 Thread Cutter (CF related)
Yesterday I received notice that Ben will be at our (somewhat) local CFUG next Tuesday. This is great news, except for me. I'm going in for some minor surgery the day before, so not only will I miss the chance to meet and hear Ben I will also miss out on the opportunity to win that copy of CFMX

New Charting in CFMX 7 (part 2)

2005-02-22 Thread cf-talk
Hi list, in addition to this thread I would like to know if the new CFMX charting engine allows you to view 3 axis instead of 2 ? We need this to view additional data in the third dimension (z-axis) in the same axis-system. Thanks in advance for ideas. Uwe ~~~

Re: Outlook & Coldfusion

2005-02-18 Thread Cutter (CF related)
ted that for this project, > many of us aren't in the same office or even the same > company. > > Also, if you use the COM objects, does outlook need to > be installed on the server too? > > EC > > -Original Message- > From: James Holmes > [mailto

Re: SQL Select statment query - kindly help

2005-02-18 Thread cf coder
>so you're saying "give me any job where eventCode is 100 and jobID is N, >but where the same job doesn't have an eventCode of 150 somewhere else" That was exactly what I was trying to acheive. You sql worked straight away. Thank you again for your reply. Best regards coder

SQL Select statment query - kindly help

2005-02-17 Thread cf coder
Hello everybody, I have a question with regards to a sql select statement and was hoping someone could help. I'm trying to query a table and trying to return row where a condition is true. To give you a better idea; picture a event table. A job can have muliple events ex, an event to indicate th

Re: Internet Explorer 7 (no really!)

2005-02-16 Thread Cutter (CF related)
I'm not sure I can entirely agree. One of my sites (fairly small, only about 110,000 unique users with 2.5M page views over the last year +) has listed WinXP as the most used os to visit the site for most of the reported time frame. Cutter Dave Carabetta wrote: > On Wed, 16 Feb 2005 06:55:38 -

Re: CFMX7 on DevNet

2005-02-11 Thread Cutter (CF related)
--- >From: Cutter (CF related) [mailto:[EMAIL PROTECTED] >Sent: Friday, February 11, 2005 8:13 AM >To: CF-Talk >Subject: CFMX7 on DevNet > >As promised (for those who want to know) CFMX 7 is now available from >the DevNet Subscription Downloads page! > >Cutter > > &

Re: CFGrid Styles

2005-02-11 Thread Cutter (CF related)
erence about that. The only thing I saw was some > attributes that are available *only* if the grid is being rendered in Flash > format. > > > > // YEX // > > > -Original Message- > From: Jeff Chastain [mailto:[EMAIL PROTECTED] > S

CFMX7 on DevNet

2005-02-11 Thread Cutter (CF related)
As promised (for those who want to know) CFMX 7 is now available from the DevNet Subscription Downloads page! Cutter -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.7 - Release Date: 2/10/2005 ~~~

Re: Problems Querying Text File Datasource Using ODBC/Coldfusion MX

2005-02-10 Thread cf coder
Hi Jared, Thanks for responding (I work with cfcoder btw). You're right; we don't have to do it this way, but it fitted in nicely with some other stuff, and being stubborn and not liking to admit defeat, we'd been wanting to get this to work. In the end though, even if it does work we'll stil

Re: CFMX7 and DevNet

2005-02-09 Thread Cutter (CF related)
I was going to post this information here to the advantage of the community at large (or at least us folks who frequent anyway). Cutter (CF related) wrote: >Christian, > >Thanks for your response. > >1) As I noted previously, the developer portion I mentioned really >doesn't p

Re: CFMX7 and DevNet

2005-02-09 Thread Cutter (CF related)
Christian, Thanks for your response. 1) As I noted previously, the developer portion I mentioned really doesn't pertain to my situation so much (as I am our sole developer), but it was worth noting for larger development shops who may have found that an advantage. I'll need to re-read that lic

Re: CFMX7 and DevNet

2005-02-09 Thread Cutter (CF related)
a specific workstation and without us having to place that developing site on a production server with our hosting provider. Cutter Calvin Ward wrote: >I believe the DevNet version of CF license required that each developer who >used it also had a DevNet license. Am I remembering correc

CFMX7 and DevNet

2005-02-09 Thread Cutter (CF related)
This has been asked once before without answer. Even though no more DevNet subscriptions are being sold there are still many of us with active subscriptions. Some people have almost a year left on their subscriptions since they purchased just prior to it's demise. One advantage to these subscri

Problems Querying Text File Datasource Using ODBC/Coldfusion MX

2005-02-09 Thread cf coder
namely to add both "dat" and "cgi" to the registry entry - and this cured the problem. Next I added the ODBC DSN into the ColdFusion datasources. However, when I wrote a short CF script to query this datasource, I got the below error: Error Executing Database Query.

Re: CFMX 6.1 Install issue: Resolved

2005-02-01 Thread Cutter (CF related)
r ZoneAlarm). > > Let us know ... > > -Steven Erat > > > > > >>-Original Message- >>From: Cutter [mailto:[EMAIL PROTECTED] >>Sent: Monday, January 31, 2005 8:27 PM >>To: CF-Talk >>Subject: CFMX 6.1 Install issue (2nd try) >>

CFWebstore

2005-01-31 Thread Cutter (CF related)
Anyone out there with experience with CFWebstore that wouldn't mind helping me through an issue (off list)? Cutter -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.2 - Release Date: 1/28/2005 ~

Re: ot: licencing ?

2005-01-29 Thread Cutter (CF related)
Yes, though both copies of the program can not be open at the same time... dave wrote: > sorry, i know this has come up but i dont recall what the final word was. > can studio be legally run on 2 puters, a work and a home? or a home and home? > i seem t recall it can but want to be sure > ty >

Table Layout

2005-01-20 Thread Cutter (CF related)
This probably seems like an easy question, I've just never had the need before now. I have a query with x number of records. I want to dynamically create a table on my display that displays five records per row, ie (qf = queryfield): qf | spacer | qf | spacer | qf | spacer | qf | spacer | qf q

Re: SOT: Browser Stats (stirring the pot)

2004-12-08 Thread Cutter (CF related)
GUYS GIVE IT A REST!! Please move this extended, futile, out of control conversation to CF-Community or something so those of us who need some cf help can find it in the sea of messages... Cutter Adrocknaphobia wrote: >>i would sure like to hear from someone at MM though about why no

Re: Image color info?

2004-11-17 Thread Cutter (CF related)
ight be a different story... Cutter Emmet McGovern wrote: >Anyone know of a way to determine color format in an image with cf. I need >to know if a file is cmyk or rgb. > >Thanks, >Emmet > > > > ~~~~~

Re: For the kids

2004-11-13 Thread Cutter (CF related)
t; >>near-time solution that they could use for several years so the program >>does not get shelved. >> >>> >> > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Messa

Re: Bluedragon Server

2004-11-03 Thread Cutter (CF related)
Ryan, In my past life, working for an ISP that was a CF house, we had several high subscriber e-newsletter clients. One technique that we employed, which greatly reduced server load and errors, was to send out these newsletters in batches of 500. Fairly easy to script, did not drag out system

Re: Pattern matching in ASP - Kindly help

2004-10-26 Thread cf coder
, but I'm trying to re-write the code in ASP. I tried this but it does not work ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?ba

Pattern matching in ASP - Kindly help

2004-10-22 Thread cf coder
Hi guys, I'm really hoping someone could help me, this may not be the forum for this question but I thought I'll ask for your help anyway. I am a ColdFusion developer. I'm trying to re-write some CF code in ASP, and am stuck. To give you an overview, I'm working on a job

Re: Select distinct record - help

2004-10-20 Thread cf coder
Pascal, I was just trying to illustrate to you if it makes sense ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=37

Select distinct record - help

2004-10-20 Thread cf coder
2 records, and I want it to only return 1 row. #reference# The data in the table looks like this 1 cfcoder cf coder 2 CFCODEr cf coder There are two rows in the table with the same reference. How do I get it to only display 1 record. Ca

Re: exception handling, kindly help

2004-10-20 Thread cf coder
thanks Simon ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=37 Message: http://www.houseoffusion.com/lists.cfm/link=i:4

Re: exception handling, kindly help

2004-10-20 Thread cf coder
thanks for that... I'll give it a bash Regards cfcoder ~| 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.

Re: exception handling, kindly help

2004-10-20 Thread cf coder
Can somebody please help? I don't know where to go from here. I'll really appreciate it ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.c

Re: exception handling, kindly help

2004-10-11 Thread cf coder
Hi and thank you all for posting the code. I'm afraid I'm still stuck with this problem. My application uses a lot of iframes and the custom error message can have a green background or a orange background depending on the page the error occurred and to be able to do that I use the custom tag insid

Re: exception handling, kindly help

2004-10-11 Thread cf coder
Hi and thank you all for posting the code. I'm afraid I'm still stuck with this problem. My application uses a lot of iframes and the custom error message can have a green background or a orange background depending on the page the error occurred and to be able to do that I use the custom tag insid

Re: exception handling, kindly help

2004-10-08 Thread cf coder
that a cfcatch variable was >empty when I did not expect it to be. > > > > > From: Dave Carabetta [mailto:[EMAIL PROTECTED] > Sent: Thursday, October 07, 2004 11:57 AM > To: CF-Talk > Subject: Re: exception handling, kindly help > >

Re: exception handling, kindly help

2004-10-08 Thread cf coder
thanks Mark, the cfcatch tags are wrapped inside a cftry block, I didn't post it because I thought it wasn't necessary. And secondly the cfcatch tag is not in the error handler page, its on a file where the error has occurred. throws an error and that's because as Pascal pointed out, struct "erro

Re: exception handling, kindly help

2004-10-08 Thread cf coder
Hi there, sorry for not getting back sooner. I've been banging my head trying to find a solution ALL day. I would really appreciate your help. I have added the custom error message in the error handler file.     I modified caughtIT.cfm a bit. It now contains the custom error message. What I al

Re: exception handling, kindly help

2004-10-08 Thread cf coder
I'm sorry I made a typo mistake in my last post. What I meant was that the "error" structure is empty when I try to dump it [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: exception handling, kindly help

2004-10-08 Thread cf coder
Thank you guys for replying to my thread. Ewok I tried your code, but still don't get back a empty "error" structure                       [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: exception handling, kindly help

2004-10-07 Thread cf coder
cfcatch.details returns nothing. Does it depend on the type of exception I select? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

exception handling, kindly help

2004-10-07 Thread cf coder
Hello everybody, I'm hoping someone can help me. I am working on this exception handling code. I have written a custom error handler that displays a custom error message when a coldfusion error occurs and sends an email to the administrator. I want to append the complete error block to the email b

Re: file name with no extensions

2004-10-05 Thread Cutter (CF related)
http://www.somesite.com/Welcome/index.cfm will appear if only http://www.somesite.com/Welcome is typed in Daniel Farmer wrote: > We have a request to create an opening page like so... > > Welcome > > with no extension. > for example www.somesite.com/Welcome > > How is this done?.. something I'

Re: How do I close the pop-up window - kindly help

2004-09-28 Thread cf coder
thanks Pascal. I went with the second option: function openAttachment(){ opener.location = "#cgi.SCRIPT_NAME#?FILENAME=#url.FILENAME#&ID=#url.id#&promptU ser=false"; window.close(); } It works just fine, many thanks Pascal, you are a genius Regards, cfcoder [Todays Threads] [This Message] [S

How do I close the pop-up window - kindly help

2004-09-28 Thread cf coder
Hi Guys, I'm hoping someone can help me. I've tried everything but can't quiet nail this problem. I have this page that has a hyper-link. Clicking on the hyper-link opens up a pop-up window. The url looks something like this: window.open('attachment.cfm?promptUser=true&id=12345&filename=testfile',

Re: datetime problems - 01/01/1900

2004-09-24 Thread cf coder
cheers guys! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: datetime problems - 01/01/1900

2004-09-24 Thread cf coder
my bad. It works now, I changed the null attribute to yes and it submits '' in the db Thanks for your help guys [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: datetime problems - 01/01/1900

2004-09-24 Thread cf coder
The table column allows null values. Hey Pascal, hope you're doing well mate! I copied your code. I am checking for some condition; if it is false, I want to insert in the datetime column. ActionDateTime = I get an error when I submit the form Error Occurred While Processing Request   The cau

datetime problems - 01/01/1900

2004-09-24 Thread cf coder
Hello, I'm assuming this one should be an easy one.  I'm running an insert query and one of the fields is date/time. When I DO NOT send a value to it, I want to insert is as , but instead, it's going in as "1/1/1900". How should I do my query where I can send a NULL Value? Thanks, cfcoder [Tod

Re: Word Wrap

2004-09-17 Thread cf coder
apping is a big ask, can you suggest me how to display the horizontal bar just above the windows task bar? I hope I'm making sense. Regards, cfcoder > cf coder wrote: > > >I'm trying to word wrap some text. I don't if there is a client side > tag that does this for yo

Re: Word Wrap

2004-09-17 Thread cf coder
I'm trying to word wrap some text. I don't if there is a client side tag that does this for you. Can someone please point me to the right direction Best regards, cfcoder [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

date difference (DateDiff) question?

2004-09-09 Thread cf coder
Hello everybody, I'm working on this script to get the date difference between two dates in minutes. After doing that; I want to then deduct/subtract the value returned by the datediff function from another date value. Here is what I'm trying to do: Reading the two date values from a table:

Strange WS Behavior

2004-09-06 Thread Cutter (CF related)
large (i.e.: a service I found at xmethods for pulling the current temperature). I'm not positive, but looking at some of the error codes from the CF side it almost looks like the soap definitions reference (which we have no way of controlling that I know of) has been moved on the apache

Re: escaping " character

2004-09-06 Thread Cutter (CF related)
Mark, Don't quote me on this, you'll have to double check, but in reference to item 'a' of your list I think I remember seeing a UDF function library at cflib.org for handling CSV files. If that wasn't it then I may have seen a CFC somewhere (cfczone.org maybe). There are resources out there...

Dealing with Undeliverable Emails - CFMX

2004-09-01 Thread cf coder
day, I want to delete it, else I want to move it to the spool directory. I also want to check if there is any file in the "spool" folder that is 0 KB, and if there is I want to delete it. I found this really intutive article: http://www.cfm-resources.com/resources/tutorials/view.cfm?tID=7

Flash and WS Blues

2004-09-01 Thread Cutter (CF related)
Ok, thank all of you for your book suggestions. Unfortunately Flash Remoting is not an option I have available (which makes things very interesting). I am still trying to get a grip on writing ColdFusion webservices that are accessible via Flash. I have no problems getting results our of CF

Book Recomendations

2004-08-31 Thread Cutter (CF related)
I'm looking for a good book on integrating CF and Flash, specifically with heavy references to webservices. Anybody have any suggestions? Cutter [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: Excel Output File

2004-08-26 Thread CF Coder2
> CSV will work, and HTML table should too, though I've not checked on > '97. > I should have stated that I have Excel 2000, not 1997. How do you deal with column values that have commas in the data? Do you quote each list item or ? [Todays Threads] [This Message] [Subscription] [Fast Un

Excel Output File

2004-08-26 Thread CF Coder2
I'm needing to generate a file in CF that can be directly read in to Excel spreadsheet.  I thought a tab-delimited file would do it but Excel '97 won't read it.  Complains about it not being a valid SYLK file format. I'm sure others have been able to create excel compatib

Re: UCase() issue

2004-08-24 Thread Cutter (CF related)
yb > > On Tue, 24 Aug 2004 12:20:20 -0400, Cutter (CF related) > <[EMAIL PROTECTED]> wrote: >  > Here's my problem. I have a variable that is set from a db call. This >  > variable is passed to a tag through an attribute. The attribute value is >  > displ

Re: URLEncode/URLDecode

2004-08-24 Thread Cutter (CF related)
Jordan, Though I appreciate your reply, though I made a mistake with my message. It's not URLEncode, but rather the URLEncrypt UDF from cflib, in conjunction with the URLDecrypt UDF. Cutter Jordan Michaels wrote: > Cutter (CF related) wrote: > >  > Still looking for any pra

UCase() issue

2004-08-24 Thread Cutter (CF related)
Here's my problem. I have a variable that is set from a db call. This variable is passed to a tag through an attribute. The attribute value is displayed from within a UCase() function. Pretty simple stuff. But, sometimes the value of the db call contains html code (i.e.: >, or & rsquo ;[broken

URLEncode/URLDecode

2004-08-23 Thread Cutter (CF related)
Still looking for any practical example of using the URLEncode/URLDecode UDF's found on cflib.org. Anybody? The (little) documentation just doesn't cut it... Cutter [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

URLEncrypt/Decrypt

2004-08-22 Thread Cutter (CF related)
Anybody have a good usable example of how to use the URLEncrypt and URLDecrypt functions (from cflib.org). I've been playing with this for an hour now, and not only can I not get anything to work but their examples don't show me much in the way of a "usable" example. Cutter [Todays Threads]

exporting to csv or excel spreadsheet

2004-08-20 Thread cf coder
Hello everybody, I've written this code that exports the search results to a csv file. Here is the code:    FILE="searchResults.csv"     ADDNEWLINE="Yes"     OUTPUT="Date, Ref, Name #Chr(10)##Chr(10)#"> & QUOTE & Reference & QUOTE & "," & QUOTE & FirstName & QUOTE> FILE="searchR

Re: Web Form Data Security

2004-08-20 Thread CF Coder2
Not to beat this topic to death but... I have a few more questions: I can see how it may be possible to insert SQL into a number variable on a web form given the var isn't quoted.  But are varchar2 type vars invulnerable simply because they are single quoted in the query?  Or are there ways that e

Re: escaping apostrphee in a select statement

2004-08-19 Thread cf coder
ok, I'm passing the url variable to the stored procedure page two --- VALUE="#URLDecode(url.text)#" DBVARNAME="@db_txt" CFSQLTYPE="cf_sql_char"> This is when the error occurrs. When I execute the query in query analyser this is what the text looks like @db_txt

Re: escaping apostrphee in a select statement

2004-08-19 Thread cf coder
you what? what's your problem? are you a clown or something? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: escaping apostrphee in a select statement

2004-08-19 Thread cf coder
you what? what's your problem? are you a you clown or something? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

escaping apostrphee in a select statement

2004-08-19 Thread cf coder
Hi Guys, I'm passing a url variable a string/text that has a apostrphee in it. Ex: mytext = It's a test I'm escaping it like this: window.location.href = ""> I'm passing this url varialbe, url.txt to the select statement, I get an error: Incorrect syntax near 's'. Can someone show me how

Re: Web Form Data Security

2004-08-18 Thread CF Coder2
Thanks, Barney! Now it makes sense! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: Web Form Data Security

2004-08-18 Thread CF Coder2
Thanks Matt and the others! This was helpful. I'm not sure what the point of wrapping vars in HTMLEditFormat.  The Ref Man is almost useless in stating it's value...returns an HTML-escaped string...so?  Why does that help.  I'll have to think on that. I'll have to read up on XSS though.  Haven't

Re: Web Form Data Security

2004-08-18 Thread CF Coder2
Where can I learn about XSS protection?  I'm sure google can give me zillions of references but if you can recommend one or two that would be great. > CFQUERYPARAM will protect your database from SQL injection attacks. > If you need other things (such as XSS protection), then you'll have > to >

Re: Web Form Data Security

2004-08-18 Thread CF Coder2
>cfqueryparam So is that adequate? What other best practices are there to ensure nothing can happen? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: Dreamweaver Find RE

2004-08-18 Thread CF Coder2
u find and replace line by line so I was going to step forward 20-30 lines then cancel. >--Ben > >CF Coder2 wrote: > >> [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Web Form Data Security

2004-08-18 Thread CF Coder2
How secure is a web form built with CF that (when submitted) INSERTS the data into a database with respect to someone hacking and accessing data from that database?  Is it possible for an expert to place SQL code into text fields that will extract data in any way? How can I guerantee that this

Dreamweaver Find RE

2004-08-18 Thread CF Coder2
I'm trying to use the Find and Replace feature of Dreamweaver using Regular Expressions.  Either I'm doing something wrong or DW is totally brain dead when it comes to trying to use RE for this purpose.  If this is the wrong forum, politely tell me where to go. I'm trying to find take a list of wo

Re: CFSELECT selected parameter

2004-08-18 Thread CF Coder2
I read 3 different books on CFSELECT and none of them had this little tid-bit about it applying only when items are generated from a query. Thanks for the info Qasim!!  That is the answer I needed. cfcoder2 >This is from the documentation > >attributes: selected(Optional) -  A list of option val

CFSELECT selected parameter

2004-08-18 Thread CF Coder2
Sorry if this has been discussed but I'm finding that in the following CFSELECT code, the "selected=8" parameter has no bearing on the default pulldown that's selected when the page is visited.  It appears to basically be broken and a useless parameter.  Have others seen this? Or is this a pilot er

Re: cfdump related!

2004-08-16 Thread cf coder
I've figured out how to do this. #elementsList# Cheers cfcoder [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

cfdump related!

2004-08-16 Thread cf coder
Hello everybody, I want to re-arrange everything dumped out by cfdump and comma separate all the elements of the cfdump structure. I want to take the results returned by the above cfdump structure and comma separate each element. I want to insert all the comma separated elements into a db colu

Re: OT: MySQL 4.1 reliability?

2004-08-09 Thread Cutter (CF-Talk)
I use 4.1.2 on my development system (which I beat the *&%$# out of everyday) and I have no problems. I think a basic bug tracker would probably go fine... Cutter Damien McKenna wrote: > How reliable is MySQL 4.1?  I know its flagged as beta but would it be > safe to use for a small task, e.g.

<    1   2   3   4   5   6   7   8   9   10   >