Password Protection
Hi all! I have a question that i'd like suggested solutions to if possible! I want to allow certain people to access certain pages. I already have a log in page which is password protected, but everybody who logs in has full access to all the pages. I want to eliminate that full access. So, how about if i categorize the people into various levels of access, and assign each a number. Then have that number in the database in the password/username table. Then when a person tries to access the page, before displaying it checks which number/level the person is in and if the person is allowed access. What do you think? Thanks! = Heidi Belal ICQ# 32127109 http://m3.easyspace.com/hmbelal A bus stops at a bus station. A train stops at a train station. On my desk I have a work station... ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Studio and Save As shenanigans
Aidan, The checkbox you're looking for is "Display current local folder in file dialogs" (not "Use standard file dialogs"), in the General pane of the Settings dialog box. Yours is apparently toggled on. John Finlayson-Fife --- Begin Included Message --- In the settings, do you have "use standard file dialogs" turned off? I think that's the setting to allow the folder in the side bar to be the default save folder. Don't know but I reported this back in the days that V4.0 was in beta, if it hasn't been fixed I suggest sending an email to [EMAIL PROTECTED] with the details:-) -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: 27 February 2001 03:20 To: CF-Talk Subject: Studio and Save As shenanigans How can you get Studio to open successive Save As dialogue boxes starting in the same folder instead of having to constantly change to the folder you're working in? Thanks -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Password Protection
Oh! There is a cool system that someone gave me that does just this! You need to set Privelages.. So on say an admin page, you do a check against a database, to determine if the user has the "Admin" Privelage. You need to create groups, otherwise it gets unmanageable. So : User table- User Name/Password/Group Groups- Group ID/GroupName GroupPrivelages- GroupID/Privelage (Repeating) Privelages- List of Privelages. And you cue a privelage to a webpage/area of the website..and then a group to certain privelages..and then a User to a Group. You can cut the group part out if your needs are simpler..but this is a cool way to do it :) I believe what I was given is free to hand out, and available from a website (some one of the CF user groups..I can't recall which one). I will send it monday when I get to work if someone else doesn't reply sooner with the info :) -Gel http://www.carigamer.com Island Gaming At Its Best!(tm) -Original Message- From: Heidi Belal [mailto:[EMAIL PROTECTED]] So, how about if i categorize the people into various levels of access, and assign each a number. Then have that number in the database in the password/username table. Then when a person tries to access the page, before displaying it checks which number/level the person is in and if the person is allowed access. What do you think? Thanks! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Password Protection
Can send you what I've done if you like -- basically the same thing. Structure of USERS table I used is as follows: Items 8 and 12 thru 18 are Y/N fields that provide/deny access to various buttons on various templates throughout the app. Just a bunch of CFIF... statements throughout the program -- the values of the items in this table are stored in client variables so they are avaiable throughout the app. I used the login/password and session management login contained in Chapter 17 of Sybex's Mastering Cold Fusion directly and then added fields as I needed them. User Level is a 0/1 thing with 0 meaning no access (so don't have to remove a user from the table to deny access). Structure for table:USERS.DBF Field Field Name TypeWidthDec Index Collate Nulls 1 F_NAME Character 15Yes 2 L_NAME Character 15Yes 3 USER_NAME Character 25Yes 4 USER_ID Character 10Asc MachineNo 5 PASSWORDCharacter 10Yes 6 LAST_CHNG Character 16Yes 7 USER_LEVEL Character 1Yes 8 REPT_MENU Character 1Yes 9 EMAIL Character 70Yes 10 PHONE Character 30Yes 11 FAX Character 30Yes 12 CAN_APRVCharacter 1Yes 13 CAN_RECALL Character 1Yes 14 CAN_FTP Character 1Yes 15 CAN_EXPORT Character 1Yes 16 CAN_ADMIN Character 1Yes 17 ONLY_SHIP Character 1Yes 18 CAN_AP_SHP Character 1Yes ** Total ** 234 ^ / \__ (@\___ / O /(_/ /_/ Whoof... 410-757-3487 -Original Message- From: Heidi Belal [SMTP:[EMAIL PROTECTED]] Sent: Sunday, April 01, 2001 10:52 AM To: CF-Talk Subject:Password Protection Hi all! I have a question that i'd like suggested solutions to if possible! I want to allow certain people to access certain pages. I already have a log in page which is password protected, but everybody who logs in has full access to all the pages. I want to eliminate that full access. So, how about if i categorize the people into various levels of access, and assign each a number. Then have that number in the database in the password/username table. Then when a person tries to access the page, before displaying it checks which number/level the person is in and if the person is allowed access. What do you think? Thanks! = Heidi Belal ICQ# 32127109 http://m3.easyspace.com/hmbelal A bus stops at a bus station. A train stops at a train station. On my desk I have a work station... ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Password Protection
We have a system where users have access privledges and roles. The access privledges control what pages the users have access to and can even control what they can and cannot do in a particular page. The roles control what groups of access privledges the user has at any given time. A single user can have more than one role (administrator, guardian, staff, student, etc.) and switch between them at will, changing their access priveledges on the fly. Using this setup, an administrator can give a trusted parent/guardian a limited staff role, but only let them update student records, while other normal staff members can add, update, and delete students, as well as guardians. While this person is assuming the role of guardian, they will only see their own kids, but if they switch their role to staff, then they will be able to see all of the kids. They can switch back and forth whenever they want, as often as they want. This is accomplished using the access permissions built into the database. Very little of the security is managed by CF. We use role based views to decide what data the user will see. It's pretty slick and it really takes a load off of CF and the CF programmer. Todd Ashworth Web Application Developer Network Administrator Saber Corporation 314 Oakland Ave. Rock Hill, SC 29730 (803) 327-0137 [111] (p) (803) 328-2868 (f) - Original Message - From: "Heidi Belal" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, April 01, 2001 10:52 AM Subject: Password Protection Hi all! I have a question that i'd like suggested solutions to if possible! I want to allow certain people to access certain pages. I already have a log in page which is password protected, but everybody who logs in has full access to all the pages. I want to eliminate that full access. So, how about if i categorize the people into various levels of access, and assign each a number. Then have that number in the database in the password/username table. Then when a person tries to access the page, before displaying it checks which number/level the person is in and if the person is allowed access. What do you think? Thanks! = Heidi Belal ICQ# 32127109 http://m3.easyspace.com/hmbelal A bus stops at a bus station. A train stops at a train station. On my desk I have a work station... ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Password Protection
oops .. hit send too soon. I think the method you described will work just fine if you are interested in nothing more than page level access control. Todd Ashworth Web Application Developer Network Administrator Saber Corporation 314 Oakland Ave. Rock Hill, SC 29730 (803) 327-0137 [111] (p) (803) 328-2868 (f) - Original Message - From: "CF" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, April 01, 2001 11:39 AM Subject: Re: Password Protection We have a system where users have access privledges and roles. The access privledges control what pages the users have access to and can even control what they can and cannot do in a particular page. The roles control what groups of access privledges the user has at any given time. A single user can have more than one role (administrator, guardian, staff, student, etc.) and switch between them at will, changing their access priveledges on the fly. Using this setup, an administrator can give a trusted parent/guardian a limited staff role, but only let them update student records, while other normal staff members can add, update, and delete students, as well as guardians. While this person is assuming the role of guardian, they will only see their own kids, but if they switch their role to staff, then they will be able to see all of the kids. They can switch back and forth whenever they want, as often as they want. This is accomplished using the access permissions built into the database. Very little of the security is managed by CF. We use role based views to decide what data the user will see. It's pretty slick and it really takes a load off of CF and the CF programmer. Todd Ashworth Web Application Developer Network Administrator Saber Corporation 314 Oakland Ave. Rock Hill, SC 29730 (803) 327-0137 [111] (p) (803) 328-2868 (f) - Original Message - From: "Heidi Belal" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, April 01, 2001 10:52 AM Subject: Password Protection Hi all! I have a question that i'd like suggested solutions to if possible! I want to allow certain people to access certain pages. I already have a log in page which is password protected, but everybody who logs in has full access to all the pages. I want to eliminate that full access. So, how about if i categorize the people into various levels of access, and assign each a number. Then have that number in the database in the password/username table. Then when a person tries to access the page, before displaying it checks which number/level the person is in and if the person is allowed access. What do you think? Thanks! = Heidi Belal ICQ# 32127109 http://m3.easyspace.com/hmbelal A bus stops at a bus station. A train stops at a train station. On my desk I have a work station... ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfwddx action=wddx2cfml question
Col2 might not contain a query. download one of the following tools from the taggallery: cf_dump cf_objectdump Then, select the wddx packets from the db as you have and use these tools to examine the columns. These tools will let you visually see what information is in the columns and will tell you the datatype of the information. Col2 might hold a serialized array, or structure rather than a query. Besides, I think every developer should be using these tools it makes life SO MUCH EASIER! |-Original Message- |From: Evan Lavidor [mailto:[EMAIL PROTECTED]] |Sent: Sunday, April 01, 2001 12:36 AM |To: CF-Talk |Subject: cfwddx action="wddx2cfml" question | | |I have a table of data that was populated by an app not built |by me (so I'm |starting off at a disadvantage in terms of not knowing |everything about it - |I'm getting more info to help clear that up). | |In two of the columns in the table (SQL Server 7), the data |has been stored |as WDDX packets. | |So, I'm doing the following to get at them and have a look at |the data in a |more usable and understandable form: | || cfquery datasource="#Request.DSN_OldData#" dbtype="ODBC" |name="getpacket" |maxrows="1" || SELECT T.Col1, T.Col2 || FROM OldDataTable T || /cfquery || || cfwddx action="WDDX2CFML" input="#getpacket.col1" |output="col1query" || cfwddx action="WDDX2CFML" input="#getpacket.col2#" |output="col2query" || || cfoutput || #col1query.recordcount#br || #col1query.columnlist#br || br || #col2query.recordcount#br || #col2query.columnlist#br || /cfoutput | |All pretty straightforward, right? | |Both of the cfwddx tags execute fine and I see the recordcount and |columnlist from col1query. However, when it gets to the |col2query outputs, |I get the following: | || Error Diagnostic Information || An error occurred while evaluating the expression: || #col2query.recordcount# || || Error near line 26, column 2. || |--- |--- |-- || Error resolving parameter COL2QUERY.RECORDCOUNT || || The object RECORDCOUNT is not present in the scope named |COL2QUERY. It is |likely that you || have misspelled the name of the object you are trying to access. | | |Now, if it was an invalid packet (which it doesn't look like |when I just |output it to the screen), it would fail the cfwddx call, |right? Since it |passes it, why can't I access it like a query? | |Col1query works just fine. Gives me a recordcount, a |columnlist, I can loop |over records, etc. etc. etc. | | |Thanks in advance for any insight anyone can offer. | |Let's not even discuss the fact that I'm working on this at |12:35 on April |Fools Day ;-) | | |Evan | | | ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Excluding IDs in queries
Hello. I'm trying to exclude an ID from the WHERE in a query, by looping through a list, but it's causing a lot of headaches. The list contains delimited list of IDS (120,145,987,564 etc) cfquery name="users_adverts" datasource="localads" SELECT ID,email,subject,paid FROM advert_details WHERE featured = No AND ( cfloop index="i" list="#client.troll#" OR ID #i# /cfloop) /cfquery I know the above is glaringly wrong, but I've tried everything - is it the positioning of ANDs and ORs? Any advice would be muuuch appreciated. Will ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Cold Fusion Forums
Well fusebox or not. Right or wrong, I always try and get the application programming out of the web root, and use cfmodule to call the application. And if I can't do this, then I usually rework the code a little. So if he built his application in fsebox, it would be easier for me. Eric From: "Angel Stewart" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: Cold Fusion Forums Date: Sat, 31 Mar 2001 19:57:14 -0400 *whimpers* *mumbles fusebox several times fearfully* ;-P hee hee hee Ok ok..seriously..I share Zac's concerns. Us islanders are just slightly more excitable is all ^_^ . Yes it is CFML, and in some cases it may be easier..but it still adds a further layer of complexity to the message board system, in that you now have to take the time to understand this particular methodology, and make your own changes in keeping with it. So you can't deny that using fusebox specifically DOES add some overhead to modifying the system. It will no longer be the Simplemessageboard.. it will be the Fuseboxed(AIEEE!)simplemessageboard. ^_^ -Gel www.carigamer.com Island Gaming At Its Best!(tm) Coldfusion Powered! -Original Message- From: John Allred [mailto:[EMAIL PROTECTED]] zac, I'm not sure, but you may be over-thinking this. Tony's application is simple enough without Fusebox. Coding it in that methodology, believe it or not, would make it even easier for you to modify or troubleshoot, even with no prior exposure to Fusebox. Fusebox is still CFML, after all. If he breaks it out in a consistent manner, the files will be shorter, and the program flow will be more logical and easier to follow. The only differences that might throw you into unfamiliar territory will lie in some of the application-level files. --John ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Excluding IDs in queries
Use NOT IN WHERE featured = No AND ID NOT IN (#ListofIDs#) - Original Message - From: "W Luke" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, April 01, 2001 9:48 AM Subject: Excluding IDs in queries Hello. I'm trying to exclude an ID from the WHERE in a query, by looping through a list, but it's causing a lot of headaches. The list contains delimited list of IDS (120,145,987,564 etc) cfquery name="users_adverts" datasource="localads" SELECT ID,email,subject,paid FROM advert_details WHERE featured = No AND ( cfloop index="i" list="#client.troll#" OR ID #i# /cfloop) /cfquery I know the above is glaringly wrong, but I've tried everything - is it the positioning of ANDs and ORs? Any advice would be muuuch appreciated. Will ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Excluding IDs in queries
Use the IN operator cfquery name="users_adverts" datasource="localads" SELECT ID,email,subject,paid FROM advert_details WHERE featured IN (120,145,987,564) /cfquery |-Original Message- |From: W Luke [mailto:[EMAIL PROTECTED]] |Sent: Sunday, April 01, 2001 12:48 PM |To: CF-Talk |Subject: Excluding IDs in queries | | |Hello. | |I'm trying to exclude an ID from the WHERE in a query, by |looping through a |list, but it's causing a lot of headaches. The list contains |delimited list |of IDS (120,145,987,564 etc) | | cfquery name="users_adverts" datasource="localads" |SELECT ID,email,subject,paid FROM advert_details |WHERE featured = No |AND ( |cfloop index="i" list="#client.troll#" |OR ID #i# |/cfloop) |/cfquery | |I know the above is glaringly wrong, but I've tried everything |- is it the |positioning of ANDs and ORs? | |Any advice would be muuuch appreciated. | |Will | | | ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Excluding IDs in queries
Thanks, working now..:/ Will - Original Message - From: ""Sean Renet"" [EMAIL PROTECTED] Newsgroups: dotcom.lists.cftalk Sent: Sunday, April 01, 2001 6:05 PM Subject: Re: Excluding IDs in queries Use NOT IN WHERE featured = No AND ID NOT IN (#ListofIDs#) - Original Message - From: "W Luke" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, April 01, 2001 9:48 AM Subject: Excluding IDs in queries Hello. I'm trying to exclude an ID from the WHERE in a query, by looping through a list, but it's causing a lot of headaches. The list contains delimited list of IDS (120,145,987,564 etc) cfquery name="users_adverts" datasource="localads" SELECT ID,email,subject,paid FROM advert_details WHERE featured = No AND ( cfloop index="i" list="#client.troll#" OR ID #i# /cfloop) /cfquery I know the above is glaringly wrong, but I've tried everything - is it the positioning of ANDs and ORs? Any advice would be muuuch appreciated. Will ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Excluding IDs in queries
AND ID NOT IN #CLIENT.TROLL# (The RDBMS will translate IN into multiple OR statements and NOT IN into multiple AND statements.) -David On Sunday, April 01, 2001 9:48 AM, W Luke [SMTP:[EMAIL PROTECTED]] wrote: Hello. I'm trying to exclude an ID from the WHERE in a query, by looping through a list, but it's causing a lot of headaches. The list contains delimited list of IDS (120,145,987,564 etc) cfquery name="users_adverts" datasource="localads" SELECT ID,email,subject,paid FROM advert_details WHERE featured = No AND ( cfloop index="i" list="#client.troll#" OR ID #i# /cfloop) /cfquery I know the above is glaringly wrong, but I've tried everything - is it the positioning of ANDs and ORs? Any advice would be muuuch appreciated. Will ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfwddx action=wddx2cfml question
Just to chime in:
I recommend the use of assertions. Don't assume that any input is present and
correct.
For example, my custom tag CF_ColumnList requires a CFML query as input, so I
test that this input item is:
(a) provided, via cfif not IsDefined("Attributes.Query")
(b) a CFML query object, via cfif not IsQuery(Attributes.Query)
-David
On Sunday, April 01, 2001 9:47 AM, Patricia Lee [SMTP:[EMAIL PROTECTED]] wrote:
Col2 might not contain a query.
download one of the following tools from the taggallery:
cf_dump
cf_objectdump
Then, select the wddx packets from the db as you have and use these tools to
examine the columns. These tools will let you visually see what information
is in the columns and will tell you the datatype of the information.
Col2 might hold a serialized array, or structure rather than a query.
Besides, I think every developer should be using these tools it makes
life SO MUCH EASIER!
|-Original Message-
|From: Evan Lavidor [mailto:[EMAIL PROTECTED]]
|Sent: Sunday, April 01, 2001 12:36 AM
|To: CF-Talk
|Subject: cfwddx action="wddx2cfml" question
|
|
|I have a table of data that was populated by an app not built
|by me (so I'm
|starting off at a disadvantage in terms of not knowing
|everything about it -
|I'm getting more info to help clear that up).
|
|In two of the columns in the table (SQL Server 7), the data
|has been stored
|as WDDX packets.
|
|So, I'm doing the following to get at them and have a look at
|the data in a
|more usable and understandable form:
|
|| cfquery datasource="#Request.DSN_OldData#" dbtype="ODBC"
|name="getpacket"
|maxrows="1"
||SELECT T.Col1, T.Col2
||FROM OldDataTable T
|| /cfquery
||
|| cfwddx action="WDDX2CFML" input="#getpacket.col1"
|output="col1query"
|| cfwddx action="WDDX2CFML" input="#getpacket.col2#"
|output="col2query"
||
|| cfoutput
||#col1query.recordcount#br
||#col1query.columnlist#br
||br
||#col2query.recordcount#br
||#col2query.columnlist#br
|| /cfoutput
|
|All pretty straightforward, right?
|
|Both of the cfwddx tags execute fine and I see the recordcount and
|columnlist from col1query. However, when it gets to the
|col2query outputs,
|I get the following:
|
|| Error Diagnostic Information
|| An error occurred while evaluating the expression:
|| #col2query.recordcount#
||
|| Error near line 26, column 2.
||
|---
|---
|--
|| Error resolving parameter COL2QUERY.RECORDCOUNT
||
|| The object RECORDCOUNT is not present in the scope named
|COL2QUERY. It is
|likely that you
|| have misspelled the name of the object you are trying to access.
|
|
|Now, if it was an invalid packet (which it doesn't look like
|when I just
|output it to the screen), it would fail the cfwddx call,
|right? Since it
|passes it, why can't I access it like a query?
|
|Col1query works just fine. Gives me a recordcount, a
|columnlist, I can loop
|over records, etc. etc. etc.
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Excluding IDs in queries
The below should do the trick - I didn't have time to check it but give it a shot. cfquery name="users_adverts" datasource="localads" SELECT ID,email,subject,paid FROM advert_details WHERE featured = No AND ( cfloop index="i" list="#client.troll#" ID #i# OR /cfloop 1=2) /cfquery -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 01, 2001 9:48 AM To: CF-Talk Subject: Excluding IDs in queries Hello. I'm trying to exclude an ID from the WHERE in a query, by looping through a list, but it's causing a lot of headaches. The list contains delimited list of IDS (120,145,987,564 etc) cfquery name="users_adverts" datasource="localads" SELECT ID,email,subject,paid FROM advert_details WHERE featured = No AND ( cfloop index="i" list="#client.troll#" OR ID #i# /cfloop) /cfquery I know the above is glaringly wrong, but I've tried everything - is it the positioning of ANDs and ORs? Any advice would be muuuch appreciated. Will ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfwddx action=wddx2cfml question
Yep. I also ran an IsQuery and IsStruct functions on it. Turns out one of them is a query and one of them is a structure. Thanks! Evan -Original Message- From: Patricia Lee [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 01, 2001 12:47 PM To: CF-Talk Subject: RE: cfwddx action="wddx2cfml" question Col2 might not contain a query. download one of the following tools from the taggallery: cf_dump cf_objectdump Then, select the wddx packets from the db as you have and use these tools to examine the columns. These tools will let you visually see what information is in the columns and will tell you the datatype of the information. Col2 might hold a serialized array, or structure rather than a query. Besides, I think every developer should be using these tools it makes life SO MUCH EASIER! |-Original Message- |From: Evan Lavidor [mailto:[EMAIL PROTECTED]] |Sent: Sunday, April 01, 2001 12:36 AM |To: CF-Talk |Subject: cfwddx action="wddx2cfml" question | | |I have a table of data that was populated by an app not built |by me (so I'm |starting off at a disadvantage in terms of not knowing |everything about it - |I'm getting more info to help clear that up). | |In two of the columns in the table (SQL Server 7), the data |has been stored |as WDDX packets. | |So, I'm doing the following to get at them and have a look at |the data in a |more usable and understandable form: | || cfquery datasource="#Request.DSN_OldData#" dbtype="ODBC" |name="getpacket" |maxrows="1" ||SELECT T.Col1, T.Col2 ||FROM OldDataTable T || /cfquery || || cfwddx action="WDDX2CFML" input="#getpacket.col1" |output="col1query" || cfwddx action="WDDX2CFML" input="#getpacket.col2#" |output="col2query" || || cfoutput ||#col1query.recordcount#br ||#col1query.columnlist#br ||br ||#col2query.recordcount#br ||#col2query.columnlist#br || /cfoutput | |All pretty straightforward, right? | |Both of the cfwddx tags execute fine and I see the recordcount and |columnlist from col1query. However, when it gets to the |col2query outputs, |I get the following: | || Error Diagnostic Information || An error occurred while evaluating the expression: || #col2query.recordcount# || || Error near line 26, column 2. || |--- |--- |-- || Error resolving parameter COL2QUERY.RECORDCOUNT || || The object RECORDCOUNT is not present in the scope named |COL2QUERY. It is |likely that you || have misspelled the name of the object you are trying to access. | | |Now, if it was an invalid packet (which it doesn't look like |when I just |output it to the screen), it would fail the cfwddx call, |right? Since it |passes it, why can't I access it like a query? | |Col1query works just fine. Gives me a recordcount, a |columnlist, I can loop |over records, etc. etc. etc. | | |Thanks in advance for any insight anyone can offer. | |Let's not even discuss the fact that I'm working on this at |12:35 on April |Fools Day ;-) | | |Evan | | | ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF5 Beta 3
Is anybody else out there having trouble installing CF5.0 Beta 3? I get an empty pop up box every time it gets the cfgraph installation. This is the whole reason I downloaded the new beta. You'll get direct help from Allaire Beta team at the Beta Forum Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Numbers to Text
If you include the and it implies a decimal. 101.50 is one hundred one and fifty But if you're ignoring decimals, then the "and" is still required - therefore if you want the words for "101" it should still be "one hundred and one" Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Numbers to Text
That's US, the "and" is sternly tought to be dropped in CA schools and I'd image so for other metric countries. -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: April 1, 2001 10:46 To: CF-Talk Subject: RE: Numbers to Text If you include the and it implies a decimal. 101.50 is one hundred one and fifty But if you're ignoring decimals, then the "and" is still required - therefore if you want the words for "101" it should still be "one hundred and one" Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [Re: An ignorance question to the masters]
Thank you, Brian. Julia "Brian Thornton" [EMAIL PROTECTED] wrote: I would either create a network share or a ftp directory to somewhere in your root. Use the files in Studio and upload / copy them to the network... - Original Message - From: "Julia Phu" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Saturday, March 31, 2001 10:06 PM Subject: An ignorance question to the masters Hi, I'm new to ColdFusion and yet have a stupid question. I have a development server which has IIS, Oracle8i, and CF Application Server installed. The CF Studio is installed on my laptop. My ignorance is how to do my work from my laptop and connect to the development server. Is this the right setup? Thanks in advance. Julia ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: [Re: An ignorance question to the masters]
As it's your dev server I'd enable RDS and work through that. That way you can use Studio's full debugging, as well as having direct read/write to the files, the database view as reference, and quick preview w/in studio. RDS uses port 80 so there should be no firewall issues to worry about it. For easier db stuff you might want to telnet right into Oracle or grab some client tools. -Original Message- From: Julia Phu [mailto:[EMAIL PROTECTED]] Sent: April 1, 2001 13:35 To: CF-Talk Subject: Re: [Re: An ignorance question to the masters] Thank you, Brian. Julia "Brian Thornton" [EMAIL PROTECTED] wrote: I would either create a network share or a ftp directory to somewhere in your root. Use the files in Studio and upload / copy them to the network... - Original Message - From: "Julia Phu" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Saturday, March 31, 2001 10:06 PM Subject: An ignorance question to the masters Hi, I'm new to ColdFusion and yet have a stupid question. I have a development server which has IIS, Oracle8i, and CF Application Server installed. The CF Studio is installed on my laptop. My ignorance is how to do my work from my laptop and connect to the development server. Is this the right setup? Thanks in advance. Julia ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Auto Parts Database?
Hi Bud, Thanks for your thoughtful reply. I follow your logic, which makes sense, but it doesn't cover all cases. For example, let's say you've got light bulbs in your database like 1152's and 1157's (I think those are valid numbers). Do you have an entry in the Availability table for every single vehicle they're used in? What do you do if you have say, fender skirts in three different colors, all costing the same? Do you represent these with three different entries in the Products table? If so you need a Color field. But colors won't apply to all products so in that case you've got a bad DB design. You could have a separate Colors table with just one record in the Products table for all three colors but then you need some kind of a flag in the Products table which tells you to look there, and logic requiring at least two queries to get all the information you need. How do you see resolving this problem? I'm not in a major rush but it's coming up soon. I will happily share with you any solutions discovered or invented. Thanks for your help, Bud. Regards, Karl Simanonok At 07:03 AM 4/1/2001 -0400, you wrote: On 3/31/01, Karl Simanonok penned: Can anyone on the list point me toward an existing auto parts database schema? Because of the many vehicles they can fit on, different ways that manufacturers refer to them, and the different ways individual parts can be categorized it seems that a database to accommodate them all must be quite complex, perhaps with different tables for different types of parts. Rather than reinvent the wheel I'm hoping someone can help me out here... Karl. Let me know what you come up with. I'm in the same boat myself. I'm going to be building a store for truck/jeep accessories. I've already got my shopping cart which breaks down into Manufacturer, Main Category, Category, Product. I've got a Styles table that I can relate miscellaneous features of a part to, and it is capable of changing price based on size and can offer different colors, which of course, dealing with autos probably won't work since you can't really just say "Red". What I'm planning on doing is this. I'm going to add 3 tables to the database: Make ... related to; Model ... related to; Availability (or something to that extent) Make will consist of: Make_Name, Make_ID. Model will consist of: Make_ID, Model_Name, Model_ID. Availability will consist of: Model_ID, Product_ID, Year_Min, Year_Max, Part_Price So, for instance I'm going to put an "Interceptor Bug Shield" as a Product in the database with an ID of 001. I only have to put it once and only have to make one picture. Then say for argument sake, the product is available in 40 different makes and models of vehicle. I'll have to put 40 records in the availability database. If the product is available for a Ford Ranger (Model_ID 100) going back to the year 1980 thru now and sells for a price of $50.99, that record will look like: Model_ID, Product_ID, Year_Min, Year_Max, Part_Price 100,001,1980,2001,50.99 Suppose that the price for the bug shield cost more for the Ranger if the year is between 1980 and 1989, say $60.99. 100,001,1980,1989,60.99 100,001,1990,2001,50.99 I'm thinking about probably making Year_Max nullable, so basically you won't have to go in every year and change the 2001 to 2002 for a zillion records. Basically it would just consider the year as now() if that field is null. So for the scenario above, the records for the Ranger's product would look like: 100,001,1980,1989,60.99 100,001,1990,null,50.99 Then we could have a query so that if for some reason Ford pulls the plug on the Ranger and makes 2002 the last year, before the end of 2002 we do: UPDATE Availability SET Year_Max = 2002 WHERE Model_ID is 100 and Year_Max is NULL It's going to be a week or so before I get into this full bore, so if you're not in a do or die situation... -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Excluding IDs in queries
In certain situations, I have run into trouble using IN with lists of values
... most notably when also using sub-queries. If you run accross the same
problem, also try:
WHERE LOCATE('#Client.Troll#', ID, 1) = 0
Todd Ashworth
Web Application Developer
Network Administrator
Saber Corporation
314 Oakland Ave.
Rock Hill, SC 29730
(803) 327-0137 [111] (p)
(803) 328-2868 (f)
- Original Message -
From: "David Shadovitz" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Sunday, April 01, 2001 1:20 PM
Subject: RE: Excluding IDs in queries
AND ID NOT IN #CLIENT.TROLL#
(The RDBMS will translate IN into multiple OR statements and NOT IN into
multiple AND statements.)
-David
On Sunday, April 01, 2001 9:48 AM, W Luke [SMTP:[EMAIL PROTECTED]]
wrote:
Hello.
I'm trying to exclude an ID from the WHERE in a query, by looping
through a
list, but it's causing a lot of headaches. The list contains delimited
list
of IDS (120,145,987,564 etc)
cfquery name="users_adverts" datasource="localads"
SELECT ID,email,subject,paid FROM advert_details
WHERE featured = No
AND (
cfloop index="i" list="#client.troll#"
OR ID #i#
/cfloop)
/cfquery
I know the above is glaringly wrong, but I've tried everything - is it
the
positioning of ANDs and ORs?
Any advice would be muuuch appreciated.
Will
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: [Re: An ignorance question to the masters]
Personnally, I use CuteFTP for FTP processes (except when I use CFFTP WS_FTP is also another excellent alternative -- both free for initial download and $30 or so to keep. Note, that if you set up locally at 127.0.0.1 then just use DOS or Window file copy commands to do whatever you want with the files in the C:\inetpub\wwwroot\. folders. Then, I also have a staging site at a CF hosting service (for pre-production testing). I use CuteFTP to manage my area on that site. Similarly, I use CuteFTP to manage files on the production site wherever that is. ^ / \__ (@\___ / O /(_/ /_/ Whoof... 410-757-3487 -Original Message- From: Julia Phu [SMTP:[EMAIL PROTECTED]] Sent: Sunday, April 01, 2001 4:35 PM To: CF-Talk Subject:Re: [Re: An ignorance question to the masters] Thank you, Brian. Julia "Brian Thornton" [EMAIL PROTECTED] wrote: I would either create a network share or a ftp directory to somewhere in your root. Use the files in Studio and upload / copy them to the network... - Original Message - From: "Julia Phu" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Saturday, March 31, 2001 10:06 PM Subject: An ignorance question to the masters Hi, I'm new to ColdFusion and yet have a stupid question. I have a development server which has IIS, Oracle8i, and CF Application Server installed. The CF Studio is installed on my laptop. My ignorance is how to do my work from my laptop and connect to the development server. Is this the right setup? Thanks in advance. Julia ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [Re: An ignorance question to the masters]
Arden Weiss wrote: Personnally, I use CuteFTP for FTP processes (except when I use CFFTP WS_FTP is also another excellent alternative -- both free for initial download and $30 or so to keep. I was under the impression (perhaps mistaken) that Cuteftp was a piece of spy ware that reported all your uploads? I remember seeing some hacks around to remove this. Is that not the case anymore? -- How to become a writer 1.Get angry. 2.Think you're better than most people. 3.Try to explain this to others. 4.Feel alienated by their reactions. 5.Get angrier. Heather Havrilesky aka Polly Esther ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: [Re: An ignorance question to the masters]
Surely you jest -- and yes it still is April Fool's day... See http://www.globalscape.com for the cutest FTP trick available... ^ / \__ (@\___ / O /(_/ /_/ Whoof... 410-757-3487 -Original Message- From: zac [SMTP:[EMAIL PROTECTED]] Sent: Sunday, April 01, 2001 5:38 PM To: CF-Talk Subject:Re: [Re: An ignorance question to the masters] Arden Weiss wrote: Personnally, I use CuteFTP for FTP processes (except when I use CFFTP WS_FTP is also another excellent alternative -- both free for initial download and $30 or so to keep. I was under the impression (perhaps mistaken) that Cuteftp was a piece of spy ware that reported all your uploads? I remember seeing some hacks around to remove this. Is that not the case anymore? -- How to become a writer 1.Get angry. 2.Think you're better than most people. 3.Try to explain this to others. 4.Feel alienated by their reactions. 5.Get angrier. Heather Havrilesky aka Polly Esther ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Auto Parts Database?
It is even worse than you have described... Way back in '98 i did a custom shopping cart for this in Perl subset and no database. here is a brief description of the site from my resume: This is a specialized shopping cart that was custom-written to address a specific set of issues related to the auto accessory industry. The product line is complex, including issues not addressed by most shopping carts: -Many different manufacturers, each with their own SKU numbering scheme -Up to 4 options per product -The Manufacturer's SKU may be determined by the product options selected -Some options determine price, others increase the price, still others have no affect on price -Many products have several applications (a bug deflector may fit several different make/model/year combinations of vehicles). This means that the shopping cart must contain both product information and application information -Many products include detailed descriptions, dimensions, vehicle submodel designations, installation requirements, etc the shopping cart must contain these for each product, when present The shopping cart and the search routines were written in a Perl subset. This subset has no sort. loop, subroutine or database functions. These functions were implemented as part of the application programs. The cart and search were integrated into the overall site design (graphics and layout) by Henry Perlmutter. You can see the cart at: http://www.stbtrucks.com/www4/ Browse some of the product categories, especially: Rocker Panels Bed Protection--- Bed Caps--- Bed Rail Caps There is absolutely no standardization within the industry... you need to create the db from the mfgr. product spec sheets which often contain confusing notes, etc. HTH Dick At 2:06 PM -0700 4/1/01, Karl Simanonok wrote: Hi Bud, Thanks for your thoughtful reply. I follow your logic, which makes sense, but it doesn't cover all cases. For example, let's say you've got light bulbs in your database like 1152's and 1157's (I think those are valid numbers). Do you have an entry in the Availability table for every single vehicle they're used in? What do you do if you have say, fender skirts in three different colors, all costing the same? Do you represent these with three different entries in the Products table? If so you need a Color field. But colors won't apply to all products so in that case you've got a bad DB design. You could have a separate Colors table with just one record in the Products table for all three colors but then you need some kind of a flag in the Products table which tells you to look there, and logic requiring at least two queries to get all the information you need. How do you see resolving this problem? I'm not in a major rush but it's coming up soon. I will happily share with you any solutions discovered or invented. Thanks for your help, Bud. Regards, Karl Simanonok At 07:03 AM 4/1/2001 -0400, you wrote: On 3/31/01, Karl Simanonok penned: Can anyone on the list point me toward an existing auto parts database schema? Because of the many vehicles they can fit on, different ways that manufacturers refer to them, and the different ways individual parts can be categorized it seems that a database to accommodate them all must be quite complex, perhaps with different tables for different types of parts. Rather than reinvent the wheel I'm hoping someone can help me out here... Karl. Let me know what you come up with. I'm in the same boat myself. I'm going to be building a store for truck/jeep accessories. I've already got my shopping cart which breaks down into Manufacturer, Main Category, Category, Product. I've got a Styles table that I can relate miscellaneous features of a part to, and it is capable of changing price based on size and can offer different colors, which of course, dealing with autos probably won't work since you can't really just say "Red". What I'm planning on doing is this. I'm going to add 3 tables to the database: Make ... related to; Model ... related to; Availability (or something to that extent) Make will consist of: Make_Name, Make_ID. Model will consist of: Make_ID, Model_Name, Model_ID. Availability will consist of: Model_ID, Product_ID, Year_Min, Year_Max, Part_Price So, for instance I'm going to put an "Interceptor Bug Shield" as a Product in the database with an ID of 001. I only have to put it once and only have to make one picture. Then say for argument sake, the product is available in 40 different makes and models of vehicle. I'll have to put 40 records in the availability database. If the product is available for a Ford Ranger (Model_ID 100) going back to the year 1980 thru now and sells for a price of $50.99, that record will look like: Model_ID, Product_ID, Year_Min, Year_Max, Part_Price 100,001,1980,2001,50.99 Suppose that the price for the bug shield
Re: [Re: An ignorance question to the masters]
Arden Weiss wrote: Surely you jest -- and yes it still is April Fool's day... No I don't (because I don't joke about security issues and I also think that April Fools gets overplayed on the net by people without much of a sense of humour) -- Microsoft products are successful -- they make a lot of money -- but that doesn't make them innovative, or even particularly good. Robert X. Cringely email: [EMAIL PROTECTED] WWW: http://www.director-online.com/ ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Auto Parts Database?
On 4/1/01, Karl Simanonok penned: Thanks for your thoughtful reply. I follow your logic, which makes sense, but it doesn't cover all cases. For example, let's say you've got light bulbs in your database like 1152's and 1157's (I think those are valid numbers). Do you have an entry in the Availability table for every single vehicle they're used in? Sure. I guess you'd have to. Somewhere you're going to have to specify which light lamp fits which vehicle. Better than entering a zillion different lamps. It looks like it's definitely going to need to run on SQL Server since even if you only have 1,000 parts, you're probably going to end up with 100,000 entries in the Availability table. Especially if you get into selling stuff like lamps and wiper blades, etc. What do you do if you have say, fender skirts in three different colors, all costing the same? Do you represent these with three different entries in the Products table? If so you need a Color field. But colors won't apply to all products so in that case you've got a bad DB design. You could have a separate Colors table with just one record in the Products table for all three colors but then you need some kind of a flag in the Products table which tells you to look there, and logic requiring at least two queries to get all the information you need. How do you see resolving this problem? I have a color table in the database with Color IDs and Color Names. The products table has a field which is just a list of color IDs. If that's not empty then it runs a query of the list items to pick up the colors from the color table. I guess you could go ahead and enter every color of every vehicle ever made if you wanted. LOL http://www.cf-ezcart.com/ Click on Glass Creations and scroll down to the peacock. I'm not in a major rush but it's coming up soon. I will happily share with you any solutions discovered or invented. Thanks for your help, Bud. Okeydoke. I'm pretty much stuck on using my own cart, which may not be a solution if you're going to be doing a site for Discount Auto Parts or someone that carries every part for every vehicle ever made. Hell, even if you could build it in a week, it would take 2 years to enter all the parts. LOL -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: how to get result from applet
George, Look at the CFAPPLET tag. You can embed Java applets in a CFFORM. The Java return value is stored as a form value. Jack Tumlin Vice President Business Development Millennium Software, Inc. The Software Solutions Company [EMAIL PROTECTED] www.millsoftinc.com At 07:54 PM 3/30/2001 -0500, you wrote: Hi there, If any one kwone how to get a result from java applet in CF. I have an applet, after executing, I want to applet return some params that i can use in CF template. Thanks. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CreateUUID()
Does anyone on this list rely on CreateUUID() for creating a completely unique identifier? Anyone know how it compares in effectiveness to using uniqueidentifier and making it a row GUID in SQL? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Version 2
Hallo, Where can i get software version 2 which integrated with ColdFusion for source control integration? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OOP
Hallo, Is ColdFusion support OOP? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Using CFOBJECT to connect to WORD?
Going to the below site causes a redirect to http://www.coldfusionmonthly.com/cfm/, a blank page. Anyone else seeing this? I'm using IE 5.0 on Win2K. -Original Message- From: Reed Powell [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 12:44 PM I just read a real interesting article on the www.coldfusionmonthly.com site ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [Re: An ignorance question to the masters]]
Thank you all for your enlightement. Raymond's suggestion is a better solution for my situation. I'm developing a web application using Oracle 8i as a back end database. My concern is the ODBC from my laptop to the development server. I'm still learning. Julia "Raymond B." [EMAIL PROTECTED] wrote: As it's your dev server I'd enable RDS and work through that. That way you can use Studio's full debugging, as well as having direct read/write to the files, the database view as reference, and quick preview w/in studio. RDS uses port 80 so there should be no firewall issues to worry about it. For easier db stuff you might want to telnet right into Oracle or grab some client tools. -Original Message- From: Julia Phu [mailto:[EMAIL PROTECTED]] Sent: April 1, 2001 13:35 To: CF-Talk Subject: Re: [Re: An ignorance question to the masters] Thank you, Brian. Julia "Brian Thornton" [EMAIL PROTECTED] wrote: I would either create a network share or a ftp directory to somewhere in your root. Use the files in Studio and upload / copy them to the network... - Original Message - From: "Julia Phu" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Saturday, March 31, 2001 10:06 PM Subject: An ignorance question to the masters Hi, I'm new to ColdFusion and yet have a stupid question. I have a development server which has IIS, Oracle8i, and CF Application Server installed. The CF Studio is installed on my laptop. My ignorance is how to do my work from my laptop and connect to the development server. Is this the right setup? Thanks in advance. Julia ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OOP
No , CF is not an OO language/environment. But fusebox, spectra and cfobjects all attempt to bridge this gap in thier own way. The next version of CF will be different, possibly including native java? Jared Clinton. Maxi Multimedia -Original Message- From: Haryono ... [mailto:[EMAIL PROTECTED]] Sent: Monday, 2 April 2001 11:22 To: CF-Talk Subject: OOP Hallo, Is ColdFusion support OOP? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Variables for shopping cart?
U must have to maintain a session Array .. "W Luke" [EMAIL PROTECTED]To: CF-Talk [EMAIL PROTECTED] ative.com cc: Subject: Variables for shopping cart? 03/31/01 09:36 PM Please respond to cf-talk Hi, I'm using a basic client variable, client.adshop, to set a list of Advert Numbers (eg 876,567,987,665) which are later cflooped to query the Database. They're part of a basic shopping cart, and I need to allow the removing of items in that list/variable by the user. Do I need an Array for this (not much experience with arrays) - or else how can I do it? Thanks Will -- [EMAIL PROTECTED] -=- www.lukrative.com Local-Advertising -=- www.localbounty.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
support for unicode in CF5?
Hi all, Can anyone comment on whether CF5 will have full unicode support? I can't seem to find it on the site or in the beta release notes. Thanks, Kay. __ Kay Smoljak - HTML/ColdFusion Developer - PerthWeb Pty Ltd Internet Solutions for your business! Level 9/105 St George's Tc - Perth - Western Australia Ph: (08) 9226 1366 Fax: (08) 9226 1375 Mobile : 0419 949 007 Visit Perth online! : www.perthweb.com.au Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
