Re: Best way to create an .xls file from a page

2008-10-28 Thread Stephane Vantroyen
Hi, another possibility is to use the POI Utility you can find on Ben Nadel's page : http://www.bennadel.com/blog/865-POIUtility-cfc-Examples-For-Reading-And-Writing-Excel-Files-In-ColdFusion.htm Greets Stéphane I wouldn't say it is the *best* way but this will maintain table layouts:

AW: Apache/CF8 problems

2008-10-28 Thread Markus Wollny
Hi! Will Tomlinson wrote: The problem we're having is, whenever he hits one of his domains we setup in his windows hosts file, it directs you to the default apache website. It works! But we have virtualhost directives in the httpd.config file to direct to C:\webRoot\somesite What's

Re: Best way to create an .xls file from a page

2008-10-28 Thread Marco Antonio C. Santos
Another good option is jExcel integration: http://www.cfinsider.com/index.cfm/2008/1/3/Modify-Excel-Spreadsheets-with-ColdFusion-the-easy-way Cheers Marco Antonio On Tue, Oct 28, 2008 at 5:37 AM, Stephane Vantroyen [EMAIL PROTECTED] wrote: Hi, another possibility is to use the POI Utility

Re: Ben Forta for president?

2008-10-28 Thread Tom Chiverton
On Friday 24 Oct 2008, Mike Kear wrote: first name and last name in the form, and click 'submit'. Then on the fly, there's a news report using the name you just put in. Whatever it is, the BBC go one step better with their 'Spooks' game. Upload a head on shot of someone, mark the mouth, eyes

Oracle 11g

2008-10-28 Thread Maureen Barger
Hi - does anyone know of any plans to push out free DataDirect drivers (an updated macromedia.jar) in support of Oracle 11g? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free

Lines of credit or credit account online

2008-10-28 Thread ColdFusion Developer
Hi all, I had an interesting request from a client and I'm not finding much info out there on what the client needs. Without going into too much detail (love those NDAs!), the client wants to offer instant-approval lines of credit to Web site visitors. In essence, the thinking is: visitor

passing a list through a url

2008-10-28 Thread Scott Stewart
Is it possible to pass a list of values through the url: IE: index.cfm?a=1,2,3 thanks sas -- Scott Stewart ColdFusion Developer Office of Research Information Systems Research amp; Economic Development University of North Carolina at Chapel Hill Phone:(919)843-2408 Fax: (919)962-3600 Email:

Re: Convert variable to UTF-16LE?

2008-10-28 Thread Massimo Foti
However, I can't for the life of me figure out how to get CF to pass the password through the LDAPS connection as UTF-16LE, and with double quotes around it. Not sure if this UDF could help, but it's worth a quick try: http://www.massimocorner.com/coldfusion/udf/convertCharset.zip

Re: Lines of credit or credit account online

2008-10-28 Thread Sonny Savage
I work in the Merchant side of the industry. You'll need a bank that backs the line of credit. Each bank is going to have its own underwriting rules. Your online app would have to do whatever it takes to satisfy those guidelines, and then give an approval based on that. Edward A Savage Jr -

RE: passing a list through a url

2008-10-28 Thread Adrian Lynch
Yes, but be careful of the length of the list as browsers have limits. Adrian -Original Message- From: Scott Stewart Sent: 28 October 2008 15:39 To: cf-talk Subject: passing a list through a url Is it possible to pass a list of values through the url: IE: index.cfm?a=1,2,3 thanks

Re: passing a list through a url

2008-10-28 Thread Tom Chiverton
On Tuesday 28 Oct 2008, Scott Stewart wrote: IE: index.cfm?a=1,2,3 Yes. As long as it isn't too long. -- Tom Chiverton Helping to administratively optimize mission-critical B2C scalable out-of-the-box e-services This email is sent for

Re: passing a list through a url

2008-10-28 Thread Scott Stewart
Thanks Adrian and Tom sas Scott Stewart wrote: Is it possible to pass a list of values through the url: IE: index.cfm?a=1,2,3 thanks sas -- Scott Stewart ColdFusion Developer Office of Research Information Systems Research amp; Economic Development University of North Carolina

Re: cfthread and queue management

2008-10-28 Thread Judah McAuley
This is what I think I was trying to get at. Moving the loop into the thread instead of having the loop outside the thread is the part I think I was missing. Having a generic tool to do queue management could be quite handy. Of course I've since realized that my particular situation is slightly

Re: Lines of credit or credit account online

2008-10-28 Thread Jason Fisher
Are you looking for an actual credit-check service with an API? or are you looking for the bank that would actually back the credit line? For checking credit ratings, I guess you could check to see whether Experian, Equifax, and TransUnion have APIs. Still, not sure you would be able to verify

CFQueryParam question

2008-10-28 Thread Scott Stewart
I have a variable passed though a URL that looks like this index.cfm?a=1,2,3 The variable a is passed to a SQL statement WHERE clause as part of an IN operator IE: WHERE b in (#url.a#). How would I encapsulate url.a in a CFQueryParam properly, is this a case where I wouldn't define the

Re: CFQueryParam question

2008-10-28 Thread Nick G
cfqueryparam cfsqltype=cf_sql_integer value=#url.a# list=true separator=, Obviously you would need to change the sqltype to what your sql type is. On Tue, Oct 28, 2008 at 10:13 AM, Scott Stewart [EMAIL PROTECTED]wrote: I have a variable passed though a URL that looks like this

Re: CFQueryParam question

2008-10-28 Thread Jason Fisher
WHERE b IN ( cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#url.a# list=yes ) The list=yes parameter of CFQUERYPARAM will properly wrap the single quotes around each list element. -Jason I have a variable passed though a URL that looks like this index.cfm?a=1,2,3 The variable a is passed to a

RE: CFQueryParam question

2008-10-28 Thread Adrian Lynch
cfqp has a list attribute. Adrian Building a database of ColdFusion errors at http://cferror.org/ -Original Message- From: Scott Stewart Sent: 28 October 2008 17:13 To: cf-talk Subject: CFQueryParam question I have a variable passed though a URL that looks like this index.cfm?a=1,2,3

Re: CFQueryParam question

2008-10-28 Thread Eric Cobb
Try this: cfqueryparam value=#Trim(URL.a)# cfsqltype=cf_sql_varchar list=true / Thanks, Eric Cobb Scott Stewart wrote: I have a variable passed though a URL that looks like this index.cfm?a=1,2,3 The variable a is passed to a SQL statement WHERE clause as part of an IN operator

CFCHART Developer Edition Watermark

2008-10-28 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
[This might sound similar to the September posting for CFDOCUMENT, but it's not] I have servers that were originally installed with the trial edition of CF8 and then changed to standard edition by entering our valid license numbers within the 30 day period. That all worked fine, and the edition

Random record identifiers in MySQL 5.0

2008-10-28 Thread Jim McAtee
What are you using for random (unique) record identifiers in MySQL? I could use UUIDs, generated either in my CF application, or in MySQL itself. But for a table that's never likely to have more than a few hundred thousand records I could also just use something like a 10 character randomly

Re: Random record identifiers in MySQL 5.0

2008-10-28 Thread Barney Boisvert
Can't you just use an AUTO_INCREMENT column? That's what they're there for. On Tue, Oct 28, 2008 at 11:40 AM, Jim McAtee [EMAIL PROTECTED] wrote: What are you using for random (unique) record identifiers in MySQL? I could use UUIDs, generated either in my CF application, or in MySQL itself.

Re: Random record identifiers in MySQL 5.0

2008-10-28 Thread Phillip M. Vector
The only thing I've noticed in using that is that you can guess the next number. If you have a URL string of id set to 7, I've always tried manually typing in 6 and seeing what happens. Sometimes, 5. :) Now, can you guess another record if the ID is 3219-D87562EFA- etc.? :) Barney Boisvert

Re: CFQueryParam question

2008-10-28 Thread Dominic Watson
The list=yes parameter of CFQUERYPARAM will properly wrap the single quotes around each list element. That's not quite right. What it will do is create a parameter for every element in the list and map it to the database type you supply. Even with character data, no single quotes are used when

RE: CFCHART Developer Edition Watermark

2008-10-28 Thread brad
If you are using multiple instance, ensure that the new serial has been entered for all of them-- i.e. not just the base instance. ~Brad Original Message Subject: CFCHART Developer Edition Watermark From: [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Tue,

Re: Random record identifiers in MySQL 5.0

2008-10-28 Thread Matt Quackenbush
On Tue, Oct 28, 2008 at 2:13 PM, Phillip M. Vector wrote: The only thing I've noticed in using that is that you can guess the next number. If you have a URL string of id set to 7, I've always tried manually typing in 6 and seeing what happens. Sometimes, 5. :) That's what permission

Prototype problems with cfgrid

2008-10-28 Thread Charles Lewis
Hello everyone, this is my first post here on the Cf-Talk mailing list. Hoping you guys can help me work through a problem I'm having. Basically I have a page that contains a cfwindow. On a certain event, I show the cfwindow, and navigate it to a url. On the code that's now inside of the

Re: Lines of credit or credit account online

2008-10-28 Thread ColdFusion Developer
Are you looking for an actual credit-check service with an API? or are you looking for the bank that would actually back the credit line? That's a very good question. I'm not sure my client really knows which one is needed and I have absolutely no knowledge of how this process works ... so

Re: Random record identifiers in MySQL 5.0

2008-10-28 Thread Barney Boisvert
And you can guess my login for Gmail from my email address. But in order to access it, you have to know my credentials. Hopefully you do similar checks in your applications? On Tue, Oct 28, 2008 at 12:13 PM, Phillip M. Vector [EMAIL PROTECTED] wrote: The only thing I've noticed in using that

Re: Random record identifiers in MySQL 5.0

2008-10-28 Thread Phillip M. Vector
Oh.. I have that as well. But take for example the UserID that I store as a cookie to someone else based on the UserID field. It's easy to change a cookie to a 1 and hope to get admin access. It's harder to figure out someone elses ID. :) and yeah, I can set it to the IP and so on, but

Re: Random record identifiers in MySQL 5.0

2008-10-28 Thread Phillip M. Vector
*nods* I do. But the extra layer of UUID is better then using auto increase. Barney Boisvert wrote: And you can guess my login for Gmail from my email address. But in order to access it, you have to know my credentials. Hopefully you do similar checks in your applications? On Tue, Oct 28,

Re: Prototype problems with cfgrid

2008-10-28 Thread Phillip M. Vector
I've had the same issue. All I can offer is not to use prototype on the page your cfgrid is in. Charles Lewis wrote: Hello everyone, this is my first post here on the Cf-Talk mailing list. Hoping you guys can help me work through a problem I'm having. Basically I have a page that contains

Re: Lines of credit or credit account online

2008-10-28 Thread Rob Parkhill
Why not just have them provide a credit card that you can keep on file. It is already a line of credit :) Rob On Tue, Oct 28, 2008 at 3:26 PM, ColdFusion Developer [EMAIL PROTECTED]wrote: Are you looking for an actual credit-check service with an API? or are you looking for the bank that

Adding Updating empty values

2008-10-28 Thread Rick Sanders
Hey all, In my form some values may be left empty. For example a form field named q1. It's fine if it's empty because the user can go back and fill it in later if they wish. How do I get passed the q1 is not defined in Form CF error? All I want to do is enter an empty value. How can I

Re: Lines of credit or credit account online

2008-10-28 Thread Phillip M. Vector
Sounds like you are looking for a bank then. ColdFusion Developer wrote: Are you looking for an actual credit-check service with an API? or are you looking for the bank that would actually back the credit line? That's a very good question. I'm not sure my client really knows which one is

Re: Lines of credit or credit account online

2008-10-28 Thread Judah McAuley
On Tue, Oct 28, 2008 at 12:26 PM, ColdFusion Developer [EMAIL PROTECTED] wrote: Are you looking for an actual credit-check service with an API? or are you looking for the bank that would actually back the credit line? That's a very good question. I'm not sure my client really knows which one

RE: Random record identifiers in MySQL 5.0

2008-10-28 Thread Craig Dudley
*nods* I do. But the extra layer of UUID is better then using auto increase. Personally I strongly disagree with that but hey ho, each to their own ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release

Re: Lines of credit or credit account online

2008-10-28 Thread Phillip M. Vector
Storing a credit card online is a very, VERY bad idea. If you go that route (Which WOULD be simplier), you may want to check out a separate company to handle the transactions. I know Shift4 (www.Shift4.com) is very good security wise (not good to work for, but good in what they do). But

Re: Random record identifiers in MySQL 5.0

2008-10-28 Thread Jason Fisher
@Jim, If you use CF to generate a UUID, then you do *not* need to hit the DB to verify uniqueness. Each call to createUUID() will create a unique value, within all limits of reasonableness. So, yes, autoIncrement works as well, but to answer your original question, createUUID() is a clean

RSS Issue

2008-10-28 Thread Steve LaBadie
I am pulling an RSS feed to my page using this code: td valign=top cfhttp url=http://www4.esu.edu/news.xml; method=get cfset objRSS = xmlParse(cfhttp.filecontent) cfset Item_Length = arraylen(objRSS.rss.channel.item) cfloop index=i from=1 to=#Item_Length# step=1 p class=newsspan

Re: Random record identifiers in MySQL 5.0

2008-10-28 Thread Barney Boisvert
WHAT You store a userId in a cookie and trust it Are you mad??? Numbers are as inherently secure as UUIDs - they're both simply identifiers. Authentication and authorization are where security happens. If an application is susceptible to spin attacks like that, I suppose that a UUID

Re: Random record identifiers in MySQL 5.0

2008-10-28 Thread Judah McAuley
Yeah, I don't think that logically follows at all. An id is not a credential, it shouldn't matter if the id is easy to guess or not. The id is the representation of the item in question. Knowing what/who the item is shouldn't allow you to become that item. I have no problems with using uuid's as

Re: Adding Updating empty values

2008-10-28 Thread Rob Parkhill
wrap it in a cfif so.. cfif isundefined(form.q1) cfset form.q1 = /cfif Rob On Tue, Oct 28, 2008 at 3:33 PM, Rick Sanders [EMAIL PROTECTED] wrote: Hey all, In my form some values may be left empty. For example a form field named q1. It's fine if it's empty because the user

Re: Random record identifiers in MySQL 5.0

2008-10-28 Thread Judah McAuley
On Tue, Oct 28, 2008 at 12:37 PM, Jason Fisher [EMAIL PROTECTED] wrote: @Jim, If you use CF to generate a UUID, then you do *not* need to hit the DB to verify uniqueness. Each call to createUUID() will create a unique value, within all limits of reasonableness. So, yes, autoIncrement

RE: Random record identifiers in MySQL 5.0

2008-10-28 Thread Ron Eis
-Original Message- From: Judah McAuley [EMAIL PROTECTED] Sent: Tuesday, October 28, 2008 2:45 PM To: cf-talk cf-talk@houseoffusion.com Subject: Re: Random record identifiers in MySQL 5.0 ~| Adobe® ColdFusion® 8 software

RE: Adding Updating empty values

2008-10-28 Thread Rick Sanders
Is that the only way? It's a questionnaire form with 50 questions! You mean I have to do a cfif for every question and assign it a blank value if there's no value!? -Original Message- From: Rob Parkhill [mailto:[EMAIL PROTECTED] Sent: October-28-08 4:42 PM To: cf-talk Subject: Re:

Re: Prototype problems with cfgrid

2008-10-28 Thread Charles Lewis
I wonder if I used the Ext Prototype Adapter if that would do anything? Thoughts on that? On Tue, Oct 28, 2008 at 2:32 PM, Phillip M. Vector [EMAIL PROTECTED] wrote: I've had the same issue. All I can offer is not to use prototype on the page your cfgrid is in. Charles Lewis wrote: Hello

Re: Random record identifiers in MySQL 5.0

2008-10-28 Thread Phillip M. Vector
Perhaps you weren't reading it clearly. Allow me to explain. I give the UserID (in UUID form and encrypted) out when someone hits my site. When a user has it, I load up that profile and they log in to the site. If a user doesn't have it, they need to log in with a username and password. I

Re: Lines of credit or credit account online

2008-10-28 Thread Rob Parkhill
Well, I guess that my suggestion should have been more full bodied to say that using a Credit Card as your line of credit would simplify the process, and there are lots of different ways to basically build that e-commerce-ness of a site without storing the data within your own site. I guess what

Re: Lines of credit or credit account online

2008-10-28 Thread Jason Fisher
Aha, so the client is offering direct credit: we'll let you buy up to $500 on our site and bill you later for it or something along those lines? If that's the case, then they don't need a bank, but they'll need some pretty robust business rules: a) how do you verify that the person is 'good'

Re: Adding Updating empty values

2008-10-28 Thread Jason Fisher
The other option is to use yes and no radio buttons instead of checkboxes, where the radio buttons default to no. That way, the field always exists, but you still get the difference between 1 and 0. Checkbox that is unchecked really doesn't exist in the POST, so the CFIF solution is pretty

Re: Random record identifiers in MySQL 5.0

2008-10-28 Thread Judah McAuley
What if I copied your cookie to my machine? I go to your site, it checks to see if I have a cookie, I do, so it grabs the encrypted UUID value in that cookie, checks it against your db, matches your record, then logs me in as you. I don't have to know the value of the UUID. It doesn't matter that

Re: Adding Updating empty values

2008-10-28 Thread Rob Parkhill
Or use radio buttons, so that your values always exist in the post method of the form. Rob On Tue, Oct 28, 2008 at 3:46 PM, Rick Sanders [EMAIL PROTECTED] wrote: Is that the only way? It's a questionnaire form with 50 questions! You mean I have to do a cfif for every question and assign it a

Re: Random record identifiers in MySQL 5.0

2008-10-28 Thread Phillip M. Vector
If you managed to copy a cookie to your machine, then either 1 of 2 things happened. 1) I gave you permission to do so and therefore, I understand the concept that I'm giving you my ID on the site basically. 2) You took it without me knowing. This would involve you accessing my computer in

Re: RSS Issue

2008-10-28 Thread Dominic Watson
cfhttp is not neccessary here if you are using CF7 or above. Either... cfset objRss = xmlParse(http://www4.esu.edu/news.xml;) / ...or.. cffeed action=read source=http://www4.esu.edu/news.xml; query=qry_feed / CFFEED is CF8+ only:

Re: Random record identifiers in MySQL 5.0

2008-10-28 Thread Barney Boisvert
A spin attack is when you manipulate some form of captured user input. It's usually a number, so the name comes from spinning a numeric dial. Any user input, which includes cookies, has to be validated. If you just trust the cookie, anyone who steals the cookie can impersonate the user. Even

RE: Adding Updating empty values

2008-10-28 Thread Rick Sanders
I hear you, and already did that for checkboxes. But, I have text fields and radio buttons in my form! -Original Message- From: Jason Fisher [mailto:[EMAIL PROTECTED] Sent: October-28-08 4:47 PM To: cf-talk Subject: Re: Adding Updating empty values The other option is to use yes and

Re: CFCHART Developer Edition Watermark

2008-10-28 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Nope - just a single instance! -reed ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive:

Re: Lines of credit or credit account online

2008-10-28 Thread ColdFusion Developer
Wow! All wonderful information, guys, and many different points that I'm sure my client has not considered. I really, really appreciate this. I guess I'm going to have to go back to this client and hash out the exact requirements before I can give the price estimate for this portion. But you

Re: Lines of credit or credit account online

2008-10-28 Thread Ian Skinner
The client's exact words were: I want visitors to fill out a form and submit it and get approved for a line of credit they can use to pay for services on my site. The first way I read that line, is this is a company that already deals with credit lines. If so, my first question would be How

Re: Adding Updating empty values

2008-10-28 Thread Gerald Guido
Write a code generator for it. fill out the form, and loop over the #Form.FIELDNAMES# Like so pre cfoutput cfloop list=#form.FIELDNAMES# index=GO lt;cfif isundefined(form.#GO#) lt;cfset form.q#GO# = lt;/cfif /cfloop /cfoutput /pre On Tue, Oct 28, 2008 at 3:46 PM, Rick Sanders [EMAIL

Re: Adding Updating empty values

2008-10-28 Thread Jason Fisher
Well, then isDefined(form.q1) or structKeyExists(form, q1) should both be true, whether or not q1 is blank. If you're getting the not defined error for a text input, then something else is going on ... is there a redirect or a layer of translation between the post and the processing or some

Re: Random record identifiers in MySQL 5.0

2008-10-28 Thread Phillip M. Vector
So how do you suggest I validate the cookie without requiring User input (invalidating the purpose of the cookie in the first place)? Barney Boisvert wrote: A spin attack is when you manipulate some form of captured user input. It's usually a number, so the name comes from spinning a numeric

Re: Adding Updating empty values

2008-10-28 Thread Judah McAuley
Use cfparam for all of your form fields, that way they exist for certain, and param them to an empty string (or 0 in the case of numbers). Actually, I tend to param them all to an empty string and then your sql query param fields will turn the empty string into an int/numeric for you (you are

Re: Adding Updating empty values

2008-10-28 Thread Charlie Griefer
text fields are defined even if they are empty. the value is simply an empty string. On Tue, Oct 28, 2008 at 12:58 PM, Rick Sanders [EMAIL PROTECTED] wrote: I hear you, and already did that for checkboxes. But, I have text fields and radio buttons in my form! -Original Message-

Re: Random record identifiers in MySQL 5.0

2008-10-28 Thread Barney Boisvert
create your cookie like this: #userId#:#expirationDate#:#hash(userId expirationDate yourSecretKey)# Then you can ensure the cookie came from you and that it hasn't been manipulated, because only you can properly create the hash (because only you know the secret key). cheers, barneyb On Tue,

Re: Adding Updating empty values

2008-10-28 Thread Rob Parkhill
then it looks as though there are a lot of CFIFs in your future. of course, if you are returning results in the format shown ie q1, q2, q3, you could throw it all into a loop and use an Evaluate statement to build the q# portion Rob On Tue, Oct 28, 2008 at 3:58 PM, Rick Sanders [EMAIL

RE: Adding Updating empty values

2008-10-28 Thread Rick Sanders
Yup, you're right. It's the radio buttons that are giving me the hassle! -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: October-28-08 5:14 PM To: cf-talk Subject: Re: Adding Updating empty values text fields are defined even if they are empty. the value is

Re: Random record identifiers in MySQL 5.0

2008-10-28 Thread Phillip M. Vector
When you say You know the secret key, are you referring to the site or the user? Either way, how would this stop someone from copying the key and using it on another computer? Let's say the phrase SecretKey was the secret key.. So my cookie would look like this..

Re: Random record identifiers in MySQL 5.0

2008-10-28 Thread Barney Boisvert
The simplest mechanism is to only allow a cookie to be used once, and then reset it each request. You get the cookie, ensure it's valid, ensure the id hasn't been used before, create a new cookie, set it, and then process the request. If the cookie isn't valid or the id has been used, you clear

Re: Random record identifiers in MySQL 5.0

2008-10-28 Thread Judah McAuley
I would add the following: Barney's solution is good but doesn't change the fact that you are authenticating based on a piece of information that someone else can grab (a cookie). I understand that one of your requirements is that people not have to use a username and password to log in every

Re: Random record identifiers in MySQL 5.0

2008-10-28 Thread Phillip M. Vector
Well, I set the cookie every page load, but you are saying.. If the cookie doesn't match up with what the last Counter I used (I.e. if the cookie shows a counterID of 5 and it should be a 6), then redirect to the login. Right? If that's correct, once they stop using the page, what's to prevent

Re: Random record identifiers in MySQL 5.0

2008-10-28 Thread Barney Boisvert
When you say You know the secret key, are you referring to the site or the user? Sorry, I wasn't very clear. The site knows the key, so only the site can validate the contents of cookies. Either way, how would this stop someone from copying the key and using it on another computer? Yes,

Re: Lines of credit or credit account online

2008-10-28 Thread ColdFusion Developer
The first way I read that line, is this is a company that already deals If they do not do this, then much work and risk is ahead for you and them. ;P Thanks, Ian. Unfortunately, it's the latter. ~| Adobe® ColdFusion® 8

Re: Random record identifiers in MySQL 5.0

2008-10-28 Thread Phillip M. Vector
Judah McAuley wrote: Barney's solution is good but doesn't change the fact that you are authenticating based on a piece of information that someone else can grab (a cookie). I understand that one of your requirements is that people not have to use a username and password to log in every time.

RE: Adding Updating empty values

2008-10-28 Thread Ben Forta
How do I get passed the q1 is not defined in Form CF error? All I want to do is enter an empty value. How can I allow it to do that for insert and updates? Actually, you'd never want to have to deal with not defined errors in your core code. That's what cfparam is for, all form fields should

RE: Adding Updating empty values

2008-10-28 Thread Rick Sanders
I agree, but I still have to enter all the form field names in the cfparam anyways so I'm not really gaining anything. -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: October-28-08 5:32 PM To: cf-talk Subject: RE: Adding Updating empty values How do I get passed the

admin api login error handling

2008-10-28 Thread Dana Kowalski
I've never really used the admin api until today. I'm having a problem catching a bad login. I tried wrapping the instantiation/login in a try catch, but it seems to be ignoring the catch. Is there any easy way to catch a bad admin api login? I'm not seeing anything in the docs or examples I've

Re: Adding Updating empty values

2008-10-28 Thread Charlie Griefer
well, cfparam name=foo default= / is shorter than: cfif structkeyExists(form, 'foo') do stuff /cfif especially over 50 iterations :) On Tue, Oct 28, 2008 at 1:36 PM, Rick Sanders [EMAIL PROTECTED] wrote: I agree, but I still have to enter all the form field names in the cfparam anyways

Re: Adding Updating empty values

2008-10-28 Thread Judah McAuley
On Tue, Oct 28, 2008 at 1:36 PM, Rick Sanders [EMAIL PROTECTED] wrote: I agree, but I still have to enter all the form field names in the cfparam anyways so I'm not really gaining anything. Coding templates are your friend. But regardless, I offered a suggestion to solve this earlier in a

Re: admin api login error handling

2008-10-28 Thread Wil Genovese
Try this cfset variables.thepassword = 'your password' cfset variables.isLoggedin = createObject(component,cfide.adminapi.administrator).login(adminPassword=variables.thepassword) cfdump var=#variables.isLoggedin# The result is True or False Wil Genovese On Tue, Oct 28, 2008 at 3:36 PM, Dana

Re: admin api login error handling

2008-10-28 Thread C S
I've never really used the admin api until today. I'm having a problem catching a bad login. I tried wrapping the instantiation/login in a try catch, but it seems to be ignoring the catch. Is there any easy way to catch a bad admin api login? I'm not seeing anything in the docs or

Re: Adding Updating empty values

2008-10-28 Thread Donnie Snyder
here is a good method to add defaults for a form to the page you are posting to. cfif isdefined('form.any_form_field') cfloop index=i list=#form.fieldnames# cfparam name=form.#i# default= /cfloop /cfif NOTE: remember to remove the (name=submit) from your submit button. This way it will not be

Re: CF8 HTML CFGRID with checkbox possible with binding?

2008-10-28 Thread John Bliss
So are the docs wrong? Because that's not what happens. If your cfgrid is marked as selectMode='edit', and your cfgridcolumn has a type='boolean' (and the cell is editable, which should be the default), then the docs say: boolean: column displays as check box; if cell is editable, user can

Re: Adding Updating empty values

2008-10-28 Thread Jason Fisher
Be sure that one of the radio options is checked by default. input type=radio name=q1 value=0 checked=checked /No input type=radio name=q1 value=1 /Yes That way you should never get an empty radio, but the user still has to choose yes where appropriate. Yup, you're right. It's the radio

Re: Adding Updating empty values

2008-10-28 Thread Gerald Guido
Rick, It may be time to make yourself acquainted with the wonderful world of code generators. Here is a partial list of the various offerings. I make heavy use of cfcgenerator and cfcblaster. I rarely create CRUD's by hand. http://code.google.com/p/cfcgenerator/

Re: Adding Updating empty values

2008-10-28 Thread Gerald Guido
I forgot squidhead http://squidhead.riaforge.org/ On Tue, Oct 28, 2008 at 5:27 PM, Gerald Guido [EMAIL PROTECTED]wrote: Rick, It may be time to make yourself acquainted with the wonderful world of code generators. Here is a partial list of the various offerings. I make heavy use of

Re: admin api login error handling

2008-10-28 Thread Dana Kowalski
Thanks fellas. That was pretty silly. I didn't think hard enough about it I guess haha. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial

RE: Adding Updating empty values

2008-10-28 Thread Rick Sanders
Ah! Thank you! I've been looking for resources like this! Excellent! Thank you! -Original Message- From: Gerald Guido [mailto:[EMAIL PROTECTED] Sent: October-28-08 6:27 PM To: cf-talk Subject: Re: Adding Updating empty values Rick, It may be time to make yourself acquainted with the

Re: Oracle 11g

2008-10-28 Thread AJ Mercer
you can do a JDBC connect then use the drivers from your Oracle client Here are a couple of blog posts to get your started http://www.talkingtree.com/blog/index.cfm/2005/11/14/Oracle10gJDBCHowTo

Re: Oracle 11g

2008-10-28 Thread Maureen Barger
The ironic drawback is that the Oracle drivers don't support stored procedures which the DD drivers do. And we need that. The current delivered drivers support just 10g. On Tue, Oct 28, 2008 at 18:29, AJ Mercer [EMAIL PROTECTED] wrote: you can do a JDBC connect then use the drivers from your