cftransaction and Access autonumber
Hi. I've got a client that every now and again finds her sequence of order IDs skips a number. I do the thing where I put cftransaction around the order being entered, get the max(order_id) as lastorder, then use that ID for the line items. If there is an error or a timeout between the ID being incremented in the orders database and the items being entered into LineItems, and the transaction rolls back, then the user has to refresh or go back and enter again, will that cause Access to go the the next number in the sequence? I don't know how else to explain it. It doesn't happen often. Every couple hundred orders or so. TIA, -- 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
Session time out error
I am getting a session time out error even if I am using that session. any help? Thanks Veena ~~ 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: Page Counter
Hi Brendan
Thank you very much :)))
its working good :)
um.. but i wonder why have these 3 lines below;
1. cfif attributes.result is not ""
2. cfset "caller.#attributes.result#"=#currentvalue#
3. /cfif
Thank you very much
regards,
phim
-Original Message-
From: brendan avery [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 16, 2001 6:32 PM
To: CF-Talk
Subject: Re: Page Counter
!---
SIMPLECOUNTER.CFM
(may be renamed to whatever you want)
by brendan avery - [EMAIL PROTECTED] - http://www.brendanavery.com
description
a simple hit counter example. use only in the context of cfmodule or
as a custom-tag.
requirements
CFFILE must be enabled.
attributes
"filename" - string - required - this is the filename to use for the counter
data. this filename should be the name of the file. if the full path is
not
used, the file will be read/written in the directory of the base template.
to
have different counters for different pages, just use different filenames.
examples usage:
cf_simplecounter filename="mycounter.txt"
cf_simplecounter filename="mycounter2.txt"
cf_simplecounter filename="subdir\mycounter.txt"
cf_simplecounter filename="C:\mysite\mycounter.txt"
cf_simplecounter filename="#expandpath('mycounter.txt')#"
"result" - string - optional - this is the name of a variable to return
which
will have a value equal to the NEW number of hits in the counter, or, in the
event of an error, the value 0. example usage:
cf_simplecounter filename="C:\mysite\counter.txt"
result="mynumber"
total hits: cfoutput#mynumber#/cfoutput
---
cfparam name="attributes.filename"
cfparam name="attributes.result" default=""
cfset attributes.filename=#ExpandPath(attributes.filename)#
cftry
cffile action="READ" file="#attributes.filename#"
variable="currentvalue"
cfset currentvalue=#Int(Trim(currentvalue))#
cfcatch
cfset currentvalue=0
/cfcatch
/cftry
cfset currentvalue=#currentvalue#+1
cftry
cffile action="WRITE" file="#attributes.filename#"
output="#currentvalue#" addnewline="No"
cfcatch
cfset currentvalue=0
/cfcatch
/cftry
cfif attributes.result is not ""
cfset "caller.#attributes.result#"=#currentvalue#
/cfif
~~
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: Java CFX Tags
Nick, Connecting to a ssl server is possible through JAVA ala JSSE and JDK1.2. http://java.sun.com/products/jsse/ You should be able to modify your existing cfx tag to implement https support. Although I haven't had an occasion to use cfhttp with a https url I believe that it was possible. Borrowing advice from David Watts you could use a recording proxy to log the conversation between the servers. The two he recommends are: Stretch http://www.kestral.com.au/devtools/ HTTPSniffer (requires Perl) http://www.compansr.demon.co.uk/ Hope this helps. Jeff Sarsoun -Original Message- From: Nick Texidor [mailto:[EMAIL PROTECTED]] Sent: Friday, February 16, 2001 4:48 PM To: [EMAIL PROTECTED] Subject: Re: Java CFX Tags Hi Jeff, If only I knew!! :^) Where do I start? It's been a long week! Ok, I need to call a secure server in order to send an sms message. Using CFLOCATION was a big no-no because it exposed the URL it was posting to. It also meant I had to go through 3 pages to complete all the database updates etc. So I looked at CFHTTP, this meant I could post to this page, and then continue in the same script, and hide the URL. Great I thought. Except it wasn't. I just could not get it to work. I have tried it on four different servers 1) My machine, CF4.5.1 SP2, NT4 + SP6. Continually for a connection failure 2) Server where site is hosted, CF4.5, Win2K. Same problem 3) Our Allaire VAR. CF 4.5, NT4. Same problem. 4) Another web server hosting our site, CF4.02, NT4 + SP5. WORKS!! So based on this information, I'm assuming there are some changes to CFHTTP between 4.02 and 4.5. So anyway, I looked at writing a Java tag. And after spending an age trying to get the CF Server set up for it, only to discover that using Java, you can't connect to a secure server using the URL Connection. It bombs if you try and use HTTPS. I dare say there is a way around it. But time is not on my side. Fortunately, the site I'm trying to link to also has a telnet service. So I managed to change the tag I was writing to use Sockets and connect to that, and it worked a treat! If your tag will help with the CFHTTP problem, it would be great, I can see I'm going to need to do this again and again with this ongoing project. Thanks Nick From: "Jeff Sarsoun" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Fri, 16 Feb 2001 13:57:02 -0500 To: CF-Talk [EMAIL PROTECTED] Subject: RE: Java CFX Tags Nick, I have a beta version of a java cfx tag that is helping me get around some issues I had with cfx_http and cfhttp. What is it that your having a problem with and what version of cf are you using? cf 4.5.2 cures some cfhttp issues. Jeff -Original Message- From: Nick Texidor [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 15, 2001 9:58 PM To: CF-Talk Subject: Java CFX Tags Hi, Due to some problems I'm experiencing with CFHTTP, I'm having to look at writing a CFX tag to achieve something I'm trying to do. I'm wondering what the lists experiences are of Java Tags with regards to performance, development etc. tia N ~~ 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: CFMail -- Good Substitute???
CHeck out iMS mail from coolfusion.com Justin -Original Message- From: Melissa Fraher [mailto:[EMAIL PROTECTED]] Sent: Friday, February 16, 2001 7:40 PM To: CF-Talk Subject: CFMail -- Good Substitute??? Hello. Does anyone know of a good custom tag to use instead of CFMAIL? Any input on this would be appreciated. Thank you. Melissa Fraher ~~ 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: ParseDog
There is a difference between solicitation, and a comment in a sig. ;) Theoretically I only post on relevant topics. (this thread aside, of course). Mr Bean wrote: Yea SLAM DUNK, talk talk, bitch and moan and your GUILTY Have a great weekend "Billy Cravens" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hey Jeff, Just noticed you have a book in your sig. Did you author it? Isn't that advertising? ;) -- Billy Cravens HR Web Development, Sabre [EMAIL PROTECTED] Jeffry Houser wrote: Clint Tredway wrote: I agree. Without this list and others like, it is very difficult to impossible to make CF developers aware that new tools or development aids exist. I don't agree. . There are other ways to reach developers than this list. This list is not meant for advertising. But, that doesn't mean I won't point you (or whoever) in the direction of a product I know about if you ask. I don't have anything against advertisements, or product announcements, but they work better on the CF-COMMUNITY list. One more thing, if we could not 'advertise' on this list, no one would now about some apps that we build. If you don't like the email JUST DELETE IT. I really hate this argument. It's the same one used for SPAM. I have a dozen filters or so set up to delete incoming mail that I perceive as spam. And it has cut down on spam. No one is more surprised than I. -- Jeff Houser | mailto:[EMAIL PROTECTED] AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781 -- Instant ColdFusion 4.5 | ISBN: 0-07-213238-8 Due out 3rd Quarter 2001 -- DotComIt, LLC database driven web data using ColdFusion, Lotus Notes/Domino -- Half of the Alternative Folk Duo called Far Cry Fly http://www.farcryfly.com | http://www.mp3.com/FarCryFly -- I've got the brains, you've got the looks, let's make lots of money ~~ 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: advanced list
You cant say it any better than that. "Jon Hall" [EMAIL PROTECTED] wrote in message 001d01c09869$0b37d3d0$a41f88d8@ns2">news:001d01c09869$0b37d3d0$a41f88d8@ns2... Ask your question and it shall be answered. I have never seen a question no matter how advanced that has not been addressed in this group. The beta.allaire.com forums are tend to be more advanced but are not focused on getting actual things done as this group is. If you think Dave Watts,Steve Drucker, Ben Forta, Mike Dinowitz and the host of other CF Luminaries are not advanced enough, perhaps you could contribute some of your voluminous wisdom to our ever evolving community. The local cfug mailing lists probably tend to be more advanced, but less wide ranging. jon - Original Message - From: [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, February 16, 2001 4:11 PM Subject: advanced list Can someone suggest another ColdFusion list-serv with more advanced topics and where the bulk of the members actually discuss ColdFusion topics, not jobs, or how to build simple JavaScript stuff? Cheers! -- Douglas Knudsen LTT, that's Leveraged Technologies Team [EMAIL PROTECTED] Got Linux? http://linuxmall.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: Studio losing DW path
I think if you create a custom button within Studio that points to the correct executable, it straightens out the path issue. Debbie -Original Message- From: Joe Sheble (Wizaerd) [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 17, 2001 2:32 AM To: CF-Talk Subject: OT: Studio losing DW path I was running Studio and Dreamweaver 3 just fine. I've however, installed the upgrade to Dreamweaver 4 (not ultradev) and now the DW button in CF Studio doesn't work anymore. Anyone know how to fix or correct this? Joseph E. Sheble a.k.a. Wizaerd Wizaerd's Realm Canvas, 3D, Graphics, ColdFusion, PHP, and mySQL http://www.wizaerd.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
Admin .htaccess files
Hello, Is it possible to build an interface to administer .htaccess files from the browser? I've never tried, but can't think of a reason why it would not work. Any thoughts? Dave ~~ 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: Admin .htaccess files
well you could build an interface to run it from the web, but anytime you put a security function on the web you give yourself one more vunerablity. So unless its important you might as well just do it the old fashined way. Now i may be in the minority where i feel you should not expose yourself to anything that you dont have to, anything on the net is vunerable so just take that into consideration Bill Wheatley Director of Development AEPS INC Allaire ColdFusion Consulting Partner Allaire Certified ColdFusion Developer http://www.aeps.com ICQ: 417645 http://www.aeps2000.com 954-472-6684 X303 IMPORTANT NOTICE: This e-mail and any attachment to it is intended only to be read or used by the named addressee. It is confidential and may contain legally privileged information. No confidentiality or privilege is waived or lost by any mistaken transmission to you. If you receive this e-mail in error, please immediately delete it from your system and notify the sender. You must not disclose, copy or use any part of this e-mail if you are not the intended recipient. The RTA is not responsible for any unauthorized alterations to this e-mail or attachment to it - Original Message - From: "David Hannum" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Saturday, February 17, 2001 9:51 AM Subject: Admin .htaccess files Hello, Is it possible to build an interface to administer .htaccess files from the browser? I've never tried, but can't think of a reason why it would not work. Any thoughts? Dave ~~ 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: Admin .htaccess files
YEah , there are 1000's of perl scripts to just that. http://www.google.com/search?q=perl+htaccess+cgibtnG=Google+Search Justin -Original Message- From: David Hannum [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 17, 2001 2:51 PM To: CF-Talk Subject: Admin .htaccess files Hello, Is it possible to build an interface to administer .htaccess files from the browser? I've never tried, but can't think of a reason why it would not work. Any thoughts? Dave ~~ 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
SQL error
Help?
I'm sure this is a silly insert error but I just don't see the problem. The answer
filed is set up for 2000 Char. Do I need to use a special tag to insert HTML into the
field? Running CF 4.5 and SQL7.
ODBC Error Code = 22001 (String data right truncation)P [Microsoft][ODBC SQL Server
Driver][SQL Server]String or binary data would be truncated.
SQL = "insert into dbo.faq (question,answer) values ('What do I need to play at
IWONITLIVE.com? ','Below are the requirements to plat at IWONITLIVE.com:br
table width="100%" border="0" cellpadding="4" align="center" cellspacing="6"
tr
td width="193"bfont face="Verdana, Arial, Helvetica,
sans-serif" size="2" color="#FF"Requirement/font/b/td
td width="143"bfont face="Verdana, Arial, Helvetica,
sans-serif" size="2" color="#FF"Minimum/font/b/td
td width="132"bfont face="Verdana, Arial, Helvetica,
sans-serif" size="2" color="#FF"Recommended/font/b/td
/tr
tr
td width="193"font face="Verdana, Arial, Helvetica, sans-serif"
size="2"Internet
Connection /font/td
td width="143"font face="Verdana, Arial, Helvetica, sans-serif"
size="2"56K
Dial-Up /font/td
td width="132"font face="Verdana, Arial, Helvetica, sans-serif"
size="2"DSL/Cable
or higher/font/td
/tr
tr
td width="193"font face="Verdana, Arial, Helvetica, sans-serif"
size="2"Windows
Media Player/font/td
td width="143"font face="Verdana, Arial, Helvetica, sans-serif"
size="2"Version
5 /font/td
td width="132"font face="Verdana, Arial, Helvetica, sans-serif"
size="2"Version
7 /font/td
/tr
tr
td width="193"font face="Verdana, Arial, Helvetica, sans-serif"
size="2"Speakers/font/td
td width="143"font face="Verdana, Arial, Helvetica, sans-serif"
size="2"Any/font/td
td width="132"font face="Verdana, Arial, Helvetica, sans-serif"
size="2"Any/font/td
/tr
tr
td width="193"font face="Verdana, Arial, Helvetica, sans-serif"
size="2"Microphone/font/td
td width="143"font face="Verdana, Arial, Helvetica, sans-serif"
size="2"Any/font/td
td width="132"font face="Verdana, Arial, Helvetica, sans-serif"
size="2"Any/font/td
/tr
/table')"P
Jeff Davis
~~
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: SQL error
Is that # hash mark in the color value causing you trouble?
- Original Message -
From: "Jeff Davis" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Saturday, February 17, 2001 10:16 AM
Subject: SQL error
Help?
I'm sure this is a silly insert error but I just don't see the problem.
The answer filed is set up for 2000 Char. Do I need to use a special tag to
insert HTML into the field? Running CF 4.5 and SQL7.
ODBC Error Code = 22001 (String data right truncation)P [Microsoft][ODBC
SQL Server Driver][SQL Server]String or binary data would be truncated.
SQL = "insert into dbo.faq (question,answer) values ('What do I need to
play at IWONITLIVE.com? ','Below are the requirements to plat at
IWONITLIVE.com:br
table width="100%" border="0" cellpadding="4" align="center"
cellspacing="6"
tr
td width="193"bfont face="Verdana, Arial,
Helvetica, sans-serif" size="2" color="#FF"Requirement/font/b/td
td width="143"bfont face="Verdana, Arial,
Helvetica, sans-serif" size="2" color="#FF"Minimum/font/b/td
td width="132"bfont face="Verdana, Arial,
Helvetica, sans-serif" size="2" color="#FF"Recommended/font/b/td
/tr
tr
td width="193"font face="Verdana, Arial, Helvetica,
sans-serif" size="2"Internet
Connection /font/td
td width="143"font face="Verdana, Arial, Helvetica,
sans-serif" size="2"56K
Dial-Up /font/td
td width="132"font face="Verdana, Arial, Helvetica,
sans-serif" size="2"DSL/Cable
or higher/font/td
/tr
tr
td width="193"font face="Verdana, Arial, Helvetica,
sans-serif" size="2"Windows
Media Player/font/td
td width="143"font face="Verdana, Arial, Helvetica,
sans-serif" size="2"Version
5 /font/td
td width="132"font face="Verdana, Arial, Helvetica,
sans-serif" size="2"Version
7 /font/td
/tr
tr
td width="193"font face="Verdana, Arial, Helvetica,
sans-serif" size="2"Speakers/font/td
td width="143"font face="Verdana, Arial, Helvetica,
sans-serif" size="2"Any/font/td
td width="132"font face="Verdana, Arial, Helvetica,
sans-serif" size="2"Any/font/td
/tr
tr
td width="193"font face="Verdana, Arial, Helvetica,
sans-serif" size="2"Microphone/font/td
td width="143"font face="Verdana, Arial, Helvetica,
sans-serif" size="2"Any/font/td
td width="132"font face="Verdana, Arial, Helvetica,
sans-serif" size="2"Any/font/td
/tr
/table')"P
Jeff Davis
~~
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: SQL error
You may want to use a text field, not a char field.
I imagine the quotes in the insert may be cause of the problems. There are a
handful of statements that have an effect on the quotes. Look into htmleditformat()
first. I don't see any single quotes
in your insert, so preservesinglequotes() probably won't have an effect.
Why do you want to store so much HTML in the database?
Jeff Davis wrote:
Help?
I'm sure this is a silly insert error but I just don't see the problem. The answer
filed is set up for 2000 Char. Do I need to use a special tag to insert HTML into the
field? Running CF 4.5 and SQL7.
ODBC Error Code = 22001 (String data right truncation)P [Microsoft][ODBC SQL
Server Driver][SQL Server]String or binary data would be truncated.
SQL = "insert into dbo.faq (question,answer) values ('What do I need to play at
IWONITLIVE.com? ','Below are the requirements to plat at IWONITLIVE.com:br
table width="100%" border="0" cellpadding="4" align="center" cellspacing="6"
tr
td width="193"bfont face="Verdana, Arial, Helvetica,
sans-serif" size="2" color="#FF"Requirement/font/b/td
td width="143"bfont face="Verdana, Arial, Helvetica,
sans-serif" size="2" color="#FF"Minimum/font/b/td
td width="132"bfont face="Verdana, Arial, Helvetica,
sans-serif" size="2" color="#FF"Recommended/font/b/td
/tr
tr
td width="193"font face="Verdana, Arial, Helvetica, sans-serif"
size="2"Internet
Connection /font/td
td width="143"font face="Verdana, Arial, Helvetica, sans-serif"
size="2"56K
Dial-Up /font/td
td width="132"font face="Verdana, Arial, Helvetica, sans-serif"
size="2"DSL/Cable
or higher/font/td
/tr
tr
td width="193"font face="Verdana, Arial, Helvetica, sans-serif"
size="2"Windows
Media Player/font/td
td width="143"font face="Verdana, Arial, Helvetica, sans-serif"
size="2"Version
5 /font/td
td width="132"font face="Verdana, Arial, Helvetica, sans-serif"
size="2"Version
7 /font/td
/tr
tr
td width="193"font face="Verdana, Arial, Helvetica, sans-serif"
size="2"Speakers/font/td
td width="143"font face="Verdana, Arial, Helvetica, sans-serif"
size="2"Any/font/td
td width="132"font face="Verdana, Arial, Helvetica, sans-serif"
size="2"Any/font/td
/tr
tr
td width="193"font face="Verdana, Arial, Helvetica, sans-serif"
size="2"Microphone/font/td
td width="143"font face="Verdana, Arial, Helvetica, sans-serif"
size="2"Any/font/td
td width="132"font face="Verdana, Arial, Helvetica, sans-serif"
size="2"Any/font/td
/tr
/table')"P
Jeff Davis
~~
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: SQL error
I have a backend page set up to insert new FAQ's to the site so teh CEO can
add them as they come up. This is really the only one that has this much
HTML for the table layout of requirements. It was teh # sign causing the
problem, I removed all the Font tags and it inserted just fine. Thanks
Guys.
Jeff Davis
- Original Message -
From: "Jeffry Houser" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Saturday, February 17, 2001 2:31 PM
Subject: Re: SQL error
You may want to use a text field, not a char field.
I imagine the quotes in the insert may be cause of the problems. There
are a handful of statements that have an effect on the quotes. Look into
htmleditformat() first. I don't see any single quotes
in your insert, so preservesinglequotes() probably won't have an effect.
Why do you want to store so much HTML in the database?
Jeff Davis wrote:
Help?
I'm sure this is a silly insert error but I just don't see the problem.
The answer filed is set up for 2000 Char. Do I need to use a special tag to
insert HTML into the field? Running CF 4.5 and SQL7.
ODBC Error Code = 22001 (String data right truncation)P
[Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would
be truncated.
SQL = "insert into dbo.faq (question,answer) values ('What do I need to
play at IWONITLIVE.com? ','Below are the requirements to plat at
IWONITLIVE.com:br
table width="100%" border="0" cellpadding="4" align="center"
cellspacing="6"
tr
td width="193"bfont face="Verdana, Arial,
Helvetica, sans-serif" size="2" color="#FF"Requirement/font/b/td
td width="143"bfont face="Verdana, Arial,
Helvetica, sans-serif" size="2" color="#FF"Minimum/font/b/td
td width="132"bfont face="Verdana, Arial,
Helvetica, sans-serif" size="2" color="#FF"Recommended/font/b/td
/tr
tr
td width="193"font face="Verdana, Arial, Helvetica,
sans-serif" size="2"Internet
Connection /font/td
td width="143"font face="Verdana, Arial, Helvetica,
sans-serif" size="2"56K
Dial-Up /font/td
td width="132"font face="Verdana, Arial, Helvetica,
sans-serif" size="2"DSL/Cable
or higher/font/td
/tr
tr
td width="193"font face="Verdana, Arial, Helvetica,
sans-serif" size="2"Windows
Media Player/font/td
td width="143"font face="Verdana, Arial, Helvetica,
sans-serif" size="2"Version
5 /font/td
td width="132"font face="Verdana, Arial, Helvetica,
sans-serif" size="2"Version
7 /font/td
/tr
tr
td width="193"font face="Verdana, Arial, Helvetica,
sans-serif" size="2"Speakers/font/td
td width="143"font face="Verdana, Arial, Helvetica,
sans-serif" size="2"Any/font/td
td width="132"font face="Verdana, Arial, Helvetica,
sans-serif" size="2"Any/font/td
/tr
tr
td width="193"font face="Verdana, Arial, Helvetica,
sans-serif" size="2"Microphone/font/td
td width="143"font face="Verdana, Arial, Helvetica,
sans-serif" size="2"Any/font/td
td width="132"font face="Verdana, Arial, Helvetica,
sans-serif" size="2"Any/font/td
/tr
/table')"P
Jeff Davis
~~
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
ParseDog and Mr Bean?
I have no idea who Mr Bean is or where he has come from, nor do I recall any previous contributions being posted to this list from Mr Bean. I am deeply suspicious of anyone who uses the name Mr Bean (For those who are not aware, the character of Mr Bean is played to great effect by Rowan Atkinson here in the UK where the character is a particularly ineffective and idiotic comic buffoon). Mr Bean's email address of PT Barnum does not inspire me with confidence about the posters identity or their genuine interest in our community. His attack on Howie who consistently and regularly provides valuable help on this list is just ludicrous. It was Howie who stepped in and helped Michael out when he had his last problems with the list hosting it and running for several months to the benefit of us all. I will declare an interest here in that I use Howie's products. I for one am very happy that we have people on this list like Howie, Min, Dave Watts, etc ( apologies to the many others who I have not mentioned) who offer advice and help. Personal attacks of this sort are not going encourage anyone to share their knowledge and advice and that would be to the detriment of us all. Gordon This coming from the person who is pushing there own product! NOW who's the LIAR "Howie Hamlin" [EMAIL PROTECTED] wrote in message 129201c0984e$d1e2b2e0$[EMAIL PROTECTED]"news:129201c0984e$d1e2b2e0$ [EMAIL PROTECTED] OMG - can we please kill this thread? It was bad enough before but now it's getting profane. BTW - I went to the page right after the original posting and the software was free. At any rate - I think that the point of not advertising here has been made. Please take this privately. Howie P.S. The word is "liar" ~~ 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: Admin .htaccess files
It would be just as secure as .htaccess itself, because the tool would be in a directory protected by both CF and .htaccess Dave - Original Message - From: William J Wheatley [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, February 17, 2001 10:40 AM Subject: Re: Admin .htaccess files well you could build an interface to run it from the web, but anytime you put a security function on the web you give yourself one more vunerablity. So unless its important you might as well just do it the old fashined way. Now i may be in the minority where i feel you should not expose yourself to anything that you dont have to, anything on the net is vunerable so just take that into consideration Bill Wheatley Director of Development AEPS INC Allaire ColdFusion Consulting Partner Allaire Certified ColdFusion Developer http://www.aeps.com ICQ: 417645 http://www.aeps2000.com 954-472-6684 X303 IMPORTANT NOTICE: This e-mail and any attachment to it is intended only to be read or used by the named addressee. It is confidential and may contain legally privileged information. No confidentiality or privilege is waived or lost by any mistaken transmission to you. If you receive this e-mail in error, please immediately delete it from your system and notify the sender. You must not disclose, copy or use any part of this e-mail if you are not the intended recipient. The RTA is not responsible for any unauthorized alterations to this e-mail or attachment to it - Original Message - From: "David Hannum" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Saturday, February 17, 2001 9:51 AM Subject: Admin .htaccess files Hello, Is it possible to build an interface to administer .htaccess files from the browser? I've never tried, but can't think of a reason why it would not work. Any thoughts? Dave ~~ 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
Custom 404 in CF.
IN a virtual hosting environment how would you use a custom 404 that is CF based? Actually even if it a .cfm and the file is not found IIS wouldn't return the 404 page but there is something else displayed. Thanks, Neil p.s. It can not be the server wide error handler since there are several different people using the Server. ~~ 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: SQL 7 vs SQL2k...
You can manage SQL 7 (and 6.5) databases using the SQL 2k Enterprise Manager. You cannot manage SQL 2k databases using the SQL 7 Enterprise Manager. Cary At 06:54 PM 2/16/2001 -0500, you wrote: On 2/16/01, Cary Gordon penned: One possible negative is that, if you have a mixed environment, you cannot manage SQL-2k databases from the SQL 7 Enterprise Manager. The converse works fine. Can you elaborate on that? -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 Cary Gordon The Cherry Hill Company ~~ 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: cftransaction and Access autonumber
Yup, that is exactly what is happening. Once you insert a new record the autonumber index gets incremented. If you delete that record as happens in case of an error with cftransaction. The next time a new record is inserted it just continues on to the next highest number. jon - Original Message - From: "Bud" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Saturday, February 17, 2001 4:26 AM Subject: cftransaction and Access autonumber Hi. I've got a client that every now and again finds her sequence of order IDs skips a number. I do the thing where I put cftransaction around the order being entered, get the max(order_id) as lastorder, then use that ID for the line items. If there is an error or a timeout between the ID being incremented in the orders database and the items being entered into LineItems, and the transaction rolls back, then the user has to refresh or go back and enter again, will that cause Access to go the the next number in the sequence? I don't know how else to explain it. It doesn't happen often. Every couple hundred orders or so. TIA, -- 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: Custom 404 in CF.
The only way to do this is with iEP's redirection (error) handler. It allows for the use of CFM's for error handling/custom 404's.. etc. Lee Fuller Chief Technical Officer PrimeDNA Corporation -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 17, 2001 11:37 AM To: CF-Talk Subject: Custom 404 in CF. IN a virtual hosting environment how would you use a custom 404 that is CF based? Actually even if it a .cfm and the file is not found IIS wouldn't return the 404 page but there is something else displayed. Thanks, Neil p.s. It can not be the server wide error handler since there are several different people using the Server. ~~ 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: Custom 404 in CF.
Neil, If you have enabled session variables, this is easy. In your application.cfm page insert this code below your cfapplication... CFERROR TYPE="Request" TEMPLATE="error.html" MAILTO="[EMAIL PROTECTED]" Then be sure to have a custom error.html page within that directory scope. It is important to note that CFSERVER will not process anything but html on the error page so you can't use a .cfm page. Tony Gruen -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 17, 2001 11:37 AM To: CF-Talk Subject: Custom 404 in CF. IN a virtual hosting environment how would you use a custom 404 that is CF based? Actually even if it a .cfm and the file is not found IIS wouldn't return the 404 page but there is something else displayed. Thanks, Neil p.s. It can not be the server wide error handler since there are several different people using the Server. ~~ 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: cftransaction and Access autonumber
On 2/17/01, Jon Hall penned: Yup, that is exactly what is happening. Once you insert a new record the autonumber index gets incremented. If you delete that record as happens in case of an error with cftransaction. The next time a new record is inserted it just continues on to the next highest number. I figured that's what it must be. Thanks for the confirmation. -- 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: cftransaction and Access autonumber
I think there is more to what you stated then Jon Hall mentioned. Why not lose the autonumber field and do autonumber yourself by incrementing MAX(id) + 1 and using that as your unique id. This way your related link from the line items to the order header is something YOU created and can RECREATE at will. With an autonumber field if you ever lose any data you cannot create an accurate reproduction as the autonumber field when regenerated will fill in the gaps and there goes your relationship accurracy. I recently had a datasource that would not open in Access, but was still able to be viewed using the odbc driver. I wrote a file that exported all the fields of all the tables in the datasource and then imported them into an empty copy of the database. I was able to get it all back because my indexes were not autonumber. Just a thought to ponder, as it worked for me. - Original Message - From: Bud [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, February 17, 2001 12:26 PM Subject: Re: cftransaction and Access autonumber On 2/17/01, Jon Hall penned: Yup, that is exactly what is happening. Once you insert a new record the autonumber index gets incremented. If you delete that record as happens in case of an error with cftransaction. The next time a new record is inserted it just continues on to the next highest number. I figured that's what it must be. Thanks for the confirmation. -- 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
Locking question
I have seen all of the warnings to make sure to use cflock around any of
the in memory variable types in a CF application. I hear that every access
of a session, or application variable should have cflock around it, or I
could enable automatic locking on the server which will exact a performance
hit though. Is there a different kind of lock I should use when reading a
session or app variable than when I am writing to one of these variables?
How about when I create a session or app variable?
Here is a bit of code from a shoppingcart that I have written. It's is the
addtocart()... Where should the cflocks go? Since I am not totally sure
about cflock and it's uses I currently just cflock all of this tag,
essentially single threading the entire function. This probably isn't too
bad, since performance isn't a big requirement for the sites that I am using
this code on. In my never ending quest for that extra millisecond though,
understanding cflock is the next step.
cfif isDefined("attributes.price") and isDefined("attributes.quantity")
and isDefined("attributes.itemcode")
cfif NOT isDefined("session.cart")
cfset session.cart = structnew()
/cfif
cfset temp = ListToArray('#attributes.price#,#attributes.quantity#')
cfif NOT structKeyExists(session.cart, attributes.itemcode)
cfset rs = structInsert(session.cart, attributes.itemcode, temp)
cfelse
cfset temp[2] = attributes.quantity
cfset rs = structUpdate(session.cart, attributes.itemcode, temp)
/cfif
/cfif
jon
~~
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: Custom 404 in CF.
Hi, I've found CFERROR does not trap the CF 404 errors even when used in the global application.cfm. Also a couple of statements in Tony's mail aren't correct in regards to CFERROR: At 2/17/2001 12:09 PM -0800, Tony Gruen wrote: If you have enabled session variables, this is easy. You don't need to have session management enabled, or even a cfapplication tag. In your application.cfm page insert this code below your cfapplication... CFERROR TYPE="Request" TEMPLATE="error.html" MAILTO="[EMAIL PROTECTED]" Then be sure to have a custom error.html page within that directory scope. It is important to note that CFSERVER will not process anything but html on the error page so you can't use a .cfm page. That's not entirely accurate. You can have a cfm page as the error handler, there's just a very limited amount of CF functionality you can actually use in the error page. See CFERROR tag help for details. Cheers, -Max ~~ 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
A question on queries
Hi all. This may be a little long, but I really need some advice from
the gurus out there.
I'm updating an application I built for a client awhile back and am
looking to try and pick up some speed if possible. The way it works
now is, the items being sold can only be sold one to an area. Sales
reps access the application so I have to make items unavailable to
other reps in the area once the item has been purchased.
Currently it works like this:
I have a column in the products table, which currently has about
2,000 items in it, named "area".
I also have a table called "areas" with an "area_id" field.
When a sales rep makes a purchase in an area, I place that "area_id"
into the area column of the products table, period delimited, like so.
..100.
As other reps purchase the product in other areas, the area_id is
added to the column. Example:
..100.,.101.,.200.,.350.,.etc.
On the query to show the products, I'm using the LOCATE scalar function:
SELECT Product_ID, etc
FROM Products
WHERE ({ fn locate('.#area_ID#.', area) } = 0 or area is null)
This has been working fine, but he just landed a big contract and may
end up with
gulp
several hundred (or more) reps hitting the application at once.
/gulp
There are about 1,500 areas so I have to use a large field for the
area column of the products table. Right now I have it set as ntext
as there could potentially be over 10,000 characters in the column.
OK. I have one other option. I also write the area_id to the lineitem
table. I could write my query like this and delete the area column
from the products table altogether.
SELECT Product_ID, etc
FROM Products
WHERE Product_ID NOT IN
(SELECT Product_ID FROM LineItem
WHERE area_id = #area_id#)
This also works, but is slower. About 35ms for the first to 160ms for
the second example. The thing is, right now the products haven't been
purchased in many areas and there aren't many line items. I'm
wondering what you think may happen down the road when the area
fields of the products table have tons of data in them as opposed to
querying what will be probably thousands of Line Items.
Whatcha think?
--
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: Locking question
Jon Hall wrote:
I have seen all of the warnings to make sure to use cflock around any of
the in memory variable types in a CF application. I hear that every access
of a session, or application variable should have cflock around it, or I
could enable automatic locking on the server which will exact a performance
hit though. Is there a different kind of lock I should use when reading a
session or app variable than when I am writing to one of these variables?
As long as you are using cf 4.5, make sure you use the scope attribute of a CFLOCK.
CFLOCK scope="session"(for session variables)
CFLOCK scope="application" (for application variables)
How about when I create a session or app variable?
You want to use the type attribute of CFLOCK.
CFLOCK type="exclusive" (for reading)
CFLOCK type="read-only" (for writing)
At this point, I hope I haven't swapped the use of type and the use of scope, so
check your documentation. ;)
Here is a bit of code from a shoppingcart that I have written. It's is the
addtocart()... Where should the cflocks go? Since I am not totally sure
about cflock and it's uses I currently just cflock all of this tag,
essentially single threading the entire function. This probably isn't too
bad, since performance isn't a big requirement for the sites that I am using
this code on. In my never ending quest for that extra millisecond though,
understanding cflock is the next step.
cfif isDefined("attributes.price") and isDefined("attributes.quantity")
and isDefined("attributes.itemcode")
cfif NOT isDefined("session.cart")
cfset session.cart = structnew()
/cfif
You'll want to use an exclusive lock here.
cfset temp = ListToArray('#attributes.price#,#attributes.quantity#')
cfif NOT structKeyExists(session.cart, attributes.itemcode)
cfset rs = structInsert(session.cart, attributes.itemcode, temp)
cfelse
cfset temp[2] = attributes.quantity
cfset rs = structUpdate(session.cart, attributes.itemcode, temp)
/cfif
You'll want to put a lock around the above if statement, also exclusive.
/cfif
Why not remove all session variable access from your 'function'? Create a temporary
variable for your cart and
pass it back into the caller (if this is a custom tag). You eliminate the need for
CFLOCKs within your function.
After the function is complete, just add a line (surrounded by CFLOCK) CFSET
session.cart = mytempcart
Food for thought.
--
Jeff Houser | mailto:[EMAIL PROTECTED]
AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781
--
Instant ColdFusion 4.5 | ISBN: 0-07-213238-8
Due out 3rd Quarter 2001
--
DotComIt, LLC
database driven web data using ColdFusion, Lotus Notes/Domino
--
Half of the Alternative Folk Duo called Far Cry Fly
http://www.farcryfly.com | http://www.mp3.com/FarCryFly
--
I've got the brains, you've got the looks, let's make lots of money
~~
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: A question on queries
Bud
Have you considered making a separate ProductArea table which is a
child of the Product table:
ProductID Int,
AreaID Int,
PRIMARY KEY (ProductID, AreaID)
Both as the PK
You could just do the insert bookended with CFTry...
If no error, it was the first of that ProductArea Combo... otherwise
notify the user that it's already taken.
Dick
At 5:35 PM -0500 2/17/01, Bud wrote:
Hi all. This may be a little long, but I really need some advice from
the gurus out there.
I'm updating an application I built for a client awhile back and am
looking to try and pick up some speed if possible. The way it works
now is, the items being sold can only be sold one to an area. Sales
reps access the application so I have to make items unavailable to
other reps in the area once the item has been purchased.
Currently it works like this:
I have a column in the products table, which currently has about
2,000 items in it, named "area".
I also have a table called "areas" with an "area_id" field.
When a sales rep makes a purchase in an area, I place that "area_id"
into the area column of the products table, period delimited, like so.
.100.
As other reps purchase the product in other areas, the area_id is
added to the column. Example:
.100.,.101.,.200.,.350.,.etc.
On the query to show the products, I'm using the LOCATE scalar function:
SELECT Product_ID, etc
FROM Products
WHERE ({ fn locate('.#area_ID#.', area) } = 0 or area is null)
This has been working fine, but he just landed a big contract and may
end up with
gulp
several hundred (or more) reps hitting the application at once.
/gulp
There are about 1,500 areas so I have to use a large field for the
area column of the products table. Right now I have it set as ntext
as there could potentially be over 10,000 characters in the column.
OK. I have one other option. I also write the area_id to the lineitem
table. I could write my query like this and delete the area column
from the products table altogether.
SELECT Product_ID, etc
FROM Products
WHERE Product_ID NOT IN
(SELECT Product_ID FROM LineItem
WHERE area_id = #area_id#)
This also works, but is slower. About 35ms for the first to 160ms for
the second example. The thing is, right now the products haven't been
purchased in many areas and there aren't many line items. I'm
wondering what you think may happen down the road when the area
fields of the products table have tons of data in them as opposed to
querying what will be probably thousands of Line Items.
Whatcha think?
--
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: advanced list
OK, I've heard the call for an advanced list and I I'll see what I can do over the next 2 days. Why 2 days? Because I'm taking down post.office and putting up the iMS listserver (which I'm writing from scratch now). Once its up, I'll set up a CF mailing list that's moderated only, but of a special type. Anyone can read from the list. Only a few people can post. Posters are set by recommendation from a current poster. If a post is off topic, the privilege is removed. Any message can be posted to the list by anyone but it will go into a queue (unless posted by a moderator). Any moderator can review the queue and say which posts should go to the list. After a post is answered, it MUST be placed into a FAQ so that the question will not be posted again. A switch will be placed into the moderator review section to allow a moderator to return a post with a message of "look in the FAQ". How does this sound? Would you (the community) like any changes? I know it sounds strict, but it allows us to have a question/answer only list that stays on topic. Now, as for the CFDJ list, my gripes against them and especially their marketing can go on for an hour and are definitely off topic. On 2/16/01, [EMAIL PROTECTED] penned: Can someone suggest another ColdFusion list-serv with more advanced topics and where the bulk of the members actually discuss ColdFusion topics, not jobs, or how to build simple JavaScript stuff? They don't make mailing lists that stay on topic. Mainly because mailing lists are made up of people. Unless of course it's moderated, in which case you wouldn't be reading this because your original post was way off topic. That said. CFDJ has supposedly started a new list-serv. All my needs are met here for now though. I find the level of the topic discussed here is in direct correlation to the level of question asked. So, if you want advanced topics, ask advanced questions. :) -- 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: advanced list
Strongly support you on this Michael. Sounds like a great idea. I'll be waiting to hear more about it. Lee Fuller Chief Technical Officer PrimeDNA Corporation -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 17, 2001 5:28 PM To: CF-Talk Subject: Re: advanced list OK, I've heard the call for an advanced list and I I'll see what I can do over the next 2 days. Why 2 days? Because I'm taking down post.office and putting up the iMS listserver (which I'm writing from scratch now). Once its up, I'll set up a CF mailing list that's moderated only, but of a special type. Anyone can read from the list. Only a few people can post. Posters are set by recommendation from a current poster. If a post is off topic, the privilege is removed. Any message can be posted to the list by anyone but it will go into a queue (unless posted by a moderator). Any moderator can review the queue and say which posts should go to the list. After a post is answered, it MUST be placed into a FAQ so that the question will not be posted again. A switch will be placed into the moderator review section to allow a moderator to return a post with a message of "look in the FAQ". How does this sound? Would you (the community) like any changes? I know it sounds strict, but it allows us to have a question/answer only list that stays on topic. Now, as for the CFDJ list, my gripes against them and especially their marketing can go on for an hour and are definitely off topic. On 2/16/01, [EMAIL PROTECTED] penned: Can someone suggest another ColdFusion list-serv with more advanced topics and where the bulk of the members actually discuss ColdFusion topics, not jobs, or how to build simple JavaScript stuff? They don't make mailing lists that stay on topic. Mainly because mailing lists are made up of people. Unless of course it's moderated, in which case you wouldn't be reading this because your original post was way off topic. That said. CFDJ has supposedly started a new list-serv. All my needs are met here for now though. I find the level of the topic discussed here is in direct correlation to the level of question asked. So, if you want advanced topics, ask advanced questions. :) -- 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: advanced list
Current specs: 1. A person has to sign up for a list online. This will change in the future, but for now that's the fastest and easiest signup we have. 2. A subscription allows a person to enter the following information: a. username b. password c. primary email address (address used to receive mail) d. posting addresses (addresses that they can post from, but not receive to) e. which lists they want to be part of and the subscription status 3. Each list subscribed to can be set to: a. immediate b. read only (no posting) c. digest (24, 12, 8, 6, 4, 2 and 1 times a day) 4. subscribers can always post from the archives (when they have signed in) 5. A subscription can be set to 'away' where they will not receive email until they return. 6. Later, posts can be set to receive attachments, html formatting, etc. Currently all this will be turned off. 7. All attachments to a post will be available in the archives for download. 8. digests can be set to: a. full b. full threaded c. subjects only d. subjects only threaded I think this covers all the user options we need. Any that I missed? And yes, I'll be opensourcing and giving the code over to Howie for inclusion with iMS as something like FusionLists. Strongly support you on this Michael. Sounds like a great idea. I'll be waiting to hear more about it. Lee Fuller Chief Technical Officer PrimeDNA Corporation -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 17, 2001 5:28 PM To: CF-Talk Subject: Re: advanced list OK, I've heard the call for an advanced list and I I'll see what I can do over the next 2 days. Why 2 days? Because I'm taking down post.office and putting up the iMS listserver (which I'm writing from scratch now). Once its up, I'll set up a CF mailing list that's moderated only, but of a special type. Anyone can read from the list. Only a few people can post. Posters are set by recommendation from a current poster. If a post is off topic, the privilege is removed. Any message can be posted to the list by anyone but it will go into a queue (unless posted by a moderator). Any moderator can review the queue and say which posts should go to the list. After a post is answered, it MUST be placed into a FAQ so that the question will not be posted again. A switch will be placed into the moderator review section to allow a moderator to return a post with a message of "look in the FAQ". How does this sound? Would you (the community) like any changes? I know it sounds strict, but it allows us to have a question/answer only list that stays on topic. Now, as for the CFDJ list, my gripes against them and especially their marketing can go on for an hour and are definitely off topic. On 2/16/01, [EMAIL PROTECTED] penned: Can someone suggest another ColdFusion list-serv with more advanced topics and where the bulk of the members actually discuss ColdFusion topics, not jobs, or how to build simple JavaScript stuff? They don't make mailing lists that stay on topic. Mainly because mailing lists are made up of people. Unless of course it's moderated, in which case you wouldn't be reading this because your original post was way off topic. That said. CFDJ has supposedly started a new list-serv. All my needs are met here for now though. I find the level of the topic discussed here is in direct correlation to the level of question asked. So, if you want advanced topics, ask advanced questions. :) -- 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: advanced list
Quite a project, Micahel. Looks good. A couple of comments interspersed below . OK, I've heard the call for an advanced list and I I'll see what I can do over the next 2 days. Why 2 days? Because I'm taking down post.office and putting up the iMS listserver (which I'm writing from scratch now). Once its up, I'll set up a CF mailing list that's moderated only, but of a special type. Anyone can read from the list. Only a few people can post. Posters are set by recommendation from a current poster. Can you compile a 'grandfathered' list of historically productive cf-talk members in order to streamline the start up of the posting privileged list? If a post is off topic, the privilege is removed. Any message can be posted to the list by anyone but it will go into a queue (unless posted by a moderator). Any moderator can review the queue and say which posts should go to the list. As hand moderation is labor/time intensive one technique used on other lists might be worth looking at: id est - trusted poster's messages are automatically propagated to the list until such a time the mods decide that it is waranted that trust has been besmirched and a poster's messages need to pass through the queueing filter. After a post is answered, it MUST be placed into a FAQ so that the question will not be posted again. A switch will be placed into the moderator review section to allow a moderator to return a post with a message of "look in the FAQ". How does this sound? I would suggest a labelling standard such that a question:answer pair can be easily indexed along the folllowing fields; software version [CFAS4_5_2_sp2] general topic [SQL, BUG, INSTALL, PROCEDURE, STYLE, etc.] specific topic [QUERY, $TAGNAME, HTML, SCRIPT, etc.] answer_date (guide to when update to faq entry might need to be reviewed) code_included_y_n (sometimes a texutal answer is best, sometimes example code speaks most clearly) reference_frequency (how many times has this question been asked or looked up in gaq(s) ) Because answers can depend heavily on whcih version of CF is being used, maybe a cvs like tree would work? Good prep work on the above will reduce workload later, especially if any robo-mod functionality can parse new questions and correlate a rtfaq response if an answer exists or flag the new question as needing de novo attention. Hmmm ... maybe a bit much to code now??? I don't think writing a faq that delineates how to topic code a subject line will work that well - people don't think that way - they just want to ask a question and get an answer. The faq is what needs to be organized as well as possible - both to make it useful and to make it easy for mods (or a robo-mod script) to match questionX with answerY. Would you (the community) like any changes? I know it sounds strict, but it allows us to have a question/answer only list that stays on topic. What you are proposing is an interactive reference that is going to be a lot of work and will be a direct reflection of the strength of the cf-talk community's cohesiveness, knowledge and spirit (and maybe our masochism too). Definitve references need to be strict in order to have value and in order to be maintainable. Maybe some of the above will be helpful as you do this thing. Now, as for the CFDJ list, my gripes against them and especially their marketing can go on for an hour and are definitely off topic. Funny how comp mags come and go and tend to get overweight with advertising and style as opposed to content ; Pan p.s. If the contents of this new thing becomes extensive and comprehensive enough, then it strikes me as something I just might be willing to pay some subscription price to access -- ??? -- ~~ 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: Locking question
In short
1) You need to have locks around even the Cfif Isdefined() statements. In
order for CF to check if a function is defined it has to attempt a read of
said function.
2) When accessing a shared variable to read its value the cflock type=""
attribute should be Readonly.
3) When accessing a shared variable to create or modify its value the cflock
type="" attribute should be Exclusive.
I would modify your code like this:
cfif isDefined("attributes.price") and
isDefined("attributes.quantity")
and isDefined("attributes.itemcode")
cflock timeout="1" throwontimeout="No" type="EXCLUSIVE" scope="SESSION"
cfif NOT isDefined("session.cart")
cfset session.cart = structnew()
/cfif
/cflock
cfset temp = ListToArray('#attributes.price#,#attributes.quantity#')
cflock timeout="1" throwontimeout="No" type="EXCLUSIVE" scope="SESSION"
cfif NOT structKeyExists(session.cart, attributes.itemcode)
cfset rs = structInsert(session.cart, attributes.itemcode,
temp)
cfelse
cfset temp[2] = attributes.quantity
cfset rs = structUpdate(session.cart, attributes.itemcode,
temp)
/cfif
/cfif
/cflock
/cfif
I used exclusive locks because after the isdefined(), which by itself only
requires a readonly lock, you're modifying the session variables.
|-Original Message-
|From: Jon Hall [mailto:[EMAIL PROTECTED]]
|Sent: Saturday, February 17, 2001 5:11 PM
|To: CF-Talk
|Subject: Locking question
|
|
|I have seen all of the warnings to make sure to use cflock
|around any of
|the in memory variable types in a CF application. I hear that
|every access
|of a session, or application variable should have cflock
|around it, or I
|could enable automatic locking on the server which will exact
|a performance
|hit though. Is there a different kind of lock I should use
|when reading a
|session or app variable than when I am writing to one of these
|variables?
|How about when I create a session or app variable?
|
|Here is a bit of code from a shoppingcart that I have written.
|It's is the
|addtocart()... Where should the cflocks go? Since I am not totally sure
|about cflock and it's uses I currently just cflock all of this tag,
|essentially single threading the entire function. This
|probably isn't too
|bad, since performance isn't a big requirement for the sites
|that I am using
|this code on. In my never ending quest for that extra
|millisecond though,
|understanding cflock is the next step.
|
|cfif isDefined("attributes.price") and
|isDefined("attributes.quantity")
|and isDefined("attributes.itemcode")
|
|cfif NOT isDefined("session.cart")
| cfset session.cart = structnew()
|/cfif
|
|cfset temp = ListToArray('#attributes.price#,#attributes.quantity#')
|
|cfif NOT structKeyExists(session.cart, attributes.itemcode)
| cfset rs = structInsert(session.cart, attributes.itemcode, temp)
|cfelse
|
| cfset temp[2] = attributes.quantity
| cfset rs = structUpdate(session.cart, attributes.itemcode, temp)
|/cfif
|
|/cfif
|
|jon
|
|
|
~~
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: advanced list
At 8:27 PM -0500 2/17/01, Michael Dinowitz wrote: OK, I've heard the call for an advanced list and I I'll see what I can do Michael I like the cf-talk list the way it is. I am a member of several moderated lists and they leave a lot to be desire. Sometimes, something appears on the cf-talk list, that is a little unexpected treasure... often it is OT... It more than compensates for the ones that are not of interest (to me)... delete key fixes taht. I wish you success with the new list, I will subscribe. I hope that the heavyweight contributors will still participate in cf-talk! Dick ~~ 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: advanced list
I have to agree. I like the list the way it is. We all have delete keys. Let the list live as is. At 08:36 PM 2/17/01 -0700, you wrote: At 8:27 PM -0500 2/17/01, Michael Dinowitz wrote: OK, I've heard the call for an advanced list and I I'll see what I can do Michael I like the cf-talk list the way it is. I am a member of several moderated lists and they leave a lot to be desire. Sometimes, something appears on the cf-talk list, that is a little unexpected treasure... often it is OT... It more than compensates for the ones that are not of interest (to me)... delete key fixes taht. I wish you success with the new list, I will subscribe. I hope that the heavyweight contributors will still participate in cf-talk! Dick ~~ 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: advanced list
I second that too. I have no problems using the delete key. And it's been the source of some great help, suggestions and ideas in the past. I'd prefer to see it continue as is. From: Chad Gray [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Sat, 17 Feb 2001 11:16:15 -0500 To: CF-Talk [EMAIL PROTECTED] Subject: Re: advanced list I have to agree. I like the list the way it is. We all have delete keys. Let the list live as is. At 08:36 PM 2/17/01 -0700, you wrote: At 8:27 PM -0500 2/17/01, Michael Dinowitz wrote: OK, I've heard the call for an advanced list and I I'll see what I can do Michael I like the cf-talk list the way it is. I am a member of several moderated lists and they leave a lot to be desire. Sometimes, something appears on the cf-talk list, that is a little unexpected treasure... often it is OT... It more than compensates for the ones that are not of interest (to me)... delete key fixes taht. I wish you success with the new list, I will subscribe. I hope that the heavyweight contributors will still participate in cf-talk! Dick ~~ 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
SMB feature idea
Since I run (and moderate) several forums (is300.net the most active right now), I'm always trying to think of ways to make Simple Message Board the best and easiest to use (that's where the Brownie Point idea came from) and the other day I had a thought (watch out!): I'm going to add a "This message will self destruct" feature to SMB. The idea is this. I like to keep a neat forum, but when you delete threads, people wonder where they went, or don't know what happened. And I hate locking a thread and seeing it there when I want to delete it! So I can add a feature that will mark a thread for deletion after a certain time after a certain number of posts. So when you close a thread, you have the option of setting its "expiration" and when reached, it will be deleted. Cool? My question is, does anyone have any ideas on how to best schedule something like this? I don't want to use cfschedule or anything, I'd rather it be triggered by activity on the message board... Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.linktoss.com ___The Fastest Way to Send a Link to Anyone! http://www.digitacamera.com __DigitA Camera Scripts and Tips http://www.is300.net ___The Enthusiast's Home of the Lexus IS300 http://www.cfug-sfl.org ___South Florida Cold Fusion Users Group http://www.simplemessageboard.comFree Forum Software for Cold Fusion ~~ 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 launch a windows app from a web page?
Kirk and all, This may be insufficient for your needs, but it is easy and useful: You can add an "Add this meeting to your calendar" hyperlink to your web pages. The link is to a simple text file in the vCalendar format. When the user clicks on the link, the browser invokes the user's calendar program, be it MS Outlook Calendar or another PIM. The hyperlink can be dynamically generated, of course, from info pulled from a database. Thanks to Dave Watts for alerting me to this. -David On Fri, 16 Feb 2001 09:15:55 -0800 "Kirk Boecker" [EMAIL PROTECTED] writes: we also have a huge need for this, we need to have a link for users of our CF app to pull up their own OutLook Calendar from the link (and ideally pass some variables to it) if anyone knows how to do this please respond, we would be willing to pay for a simple, clean solution kirk - Original Message - From: "Paul Sizemore" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, February 16, 2001 7:00 AM Subject: RE: how to launch a windows app from a web page? James, I am passively trying to do the same thing. I've got it to creating a signed VB Active x control that shells out to the app (currently note pad). I want to pass the app name to the active x control to open (maybe in a URL variable, for example http://www.foo.com/Index.cfm?OpenAppID=NotePad to open notepad.exe). Any thoughts on how I would do this? Start VB code Private Sub Command1_Click() Dim rc As Double rc = Shell(Text1.Text, vbMaximizedFocus) End Sub Private Sub UserControl_Initialize() Text1.Text = "c:\notepad.exe" Dim rc As Double rc = Shell(Text1.Text, vbMaximizedFocus) End Sub End VB code -Original Message- From: James Birchler [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 9:30 PM To: CF-Talk Subject: OT: how to launch a windows app from a web page? Has anyone ever successfully launched a Windows application from a web page? If so, how? The only way I've found so far is using an ActiveX component--but only in theory. I'm looking for source code I could modify to launch a particular application. Is it possible to simply use an object tag to launch the application? Anyone know anything about this sort of thing? ~~ 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: Custom 404 in CF.
Lee, Do you have a link to more information? Jim - Original Message - From: "Lee Fuller" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Saturday, February 17, 2001 1:01 PM Subject: RE: Custom 404 in CF. The only way to do this is with iEP's redirection (error) handler. It allows for the use of CFM's for error handling/custom 404's.. etc. Lee Fuller Chief Technical Officer PrimeDNA Corporation -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 17, 2001 11:37 AM To: CF-Talk Subject: Custom 404 in CF. IN a virtual hosting environment how would you use a custom 404 that is CF based? Actually even if it a .cfm and the file is not found IIS wouldn't return the 404 page but there is something else displayed. Thanks, Neil p.s. It can not be the server wide error handler since there are several different people using the Server. ~~ 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: advanced list
I don't like the idea of a new list. Face it. 90% of us are going to join both lists anyway. Where is the savings? I run about 10 mailing list, and have run into this problem of too much off topic stuff a few times. I think I found a way to stop it Just assign a few volunteers to be the policemen.. to enforce the rules. State the rules in a message once a week. Require descriptive subjects, and do not tolerate nonsense posts. These "police" watch for bad messages, and send the poster a warning, explaining the rules, and threatening them if they continue, they will require moderation ( a moderator would have to approve anything they send to the list) for their posts. On the second infraction, put them on moderation - until they get a string of "good" posts through. Al Musella, DPM Musella Foundation At 08:36 PM 2/17/2001 -0700, you wrote: I like the cf-talk list the way it is. I am a member of several moderated lists and they leave a lot to be desire. Sometimes, something appears on the cf-talk list, that is a little unexpected treasure... often it is OT... It more than compensates for the ones that are not of interest (to me)... delete key fixes taht. I wish you success with the new list, I will subscribe. I hope that the heavyweight contributors will still participate in cf-talk! ~~ 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: advanced list
I agree. While my delete button gets overheated from time to time, that's a small penalty for the usefulness of the list. I think Al's suggestions below are more practical than setting up a new list. The new rules, whichever list, should identify whether messages like this one are off topic. I vote that they should be off-topic. Such messages should go to the list moderator only. best, paul At 11:12 PM 2/17/01 -0500, you wrote: I don't like the idea of a new list. Face it. 90% of us are going to join both lists anyway. Where is the savings? I run about 10 mailing list, and have run into this problem of too much off topic stuff a few times. I think I found a way to stop it Just assign a few volunteers to be the policemen.. to enforce the rules. State the rules in a message once a week. Require descriptive subjects, and do not tolerate nonsense posts. These "police" watch for bad messages, and send the poster a warning, explaining the rules, and threatening them if they continue, they will require moderation ( a moderator would have to approve anything they send to the list) for their posts. On the second infraction, put them on moderation - until they get a string of "good" posts through. Al Musella, DPM Musella Foundation At 08:36 PM 2/17/2001 -0700, you wrote: I like the cf-talk list the way it is. I am a member of several moderated lists and they leave a lot to be desire. Sometimes, something appears on the cf-talk list, that is a little unexpected treasure... often it is OT... It more than compensates for the ones that are not of interest (to me)... delete key fixes taht. I wish you success with the new list, I will subscribe. I hope that the heavyweight contributors will still participate in cf-talk! ~~ 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: advanced list
Only a few people can post. Posters are set by recommendation from a current poster. Can you compile a 'grandfathered' list of historically productive cf-talk members in order to streamline the start up of the posting privileged list? Already done. We've got a number of people who are known by 'name' and they will be granted initial posting and moderation privlages. This goes to the next point in that those who are allowed to moderate are also allowed to post and those who post OT are removed from moderation. Those who post well are judged to get moderation. As for labeling, we'll deal with the specifics of that after the lists are up. First steps first. If a post is off topic, the privilege is removed. Any message can be posted to the list by anyone but it will go into a queue (unless posted by a moderator). Any moderator can review the queue and say which posts should go to the list. As hand moderation is labor/time intensive one technique used on other lists might be worth looking at: id est - trusted poster's messages are automatically propagated to the list until such a time the mods decide that it is waranted that trust has been besmirched and a poster's messages need to pass through the queueing filter. After a post is answered, it MUST be placed into a FAQ so that the question will not be posted again. A switch will be placed into the moderator review section to allow a moderator to return a post with a message of "look in the FAQ". How does this sound? I would suggest a labelling standard such that a question:answer pair can be easily indexed along the folllowing fields; software version [CFAS4_5_2_sp2] general topic [SQL, BUG, INSTALL, PROCEDURE, STYLE, etc.] specific topic [QUERY, $TAGNAME, HTML, SCRIPT, etc.] answer_date (guide to when update to faq entry might need to be reviewed) code_included_y_n (sometimes a texutal answer is best, sometimes example code speaks most clearly) reference_frequency (how many times has this question been asked or looked up in gaq(s) ) Because answers can depend heavily on whcih version of CF is being used, maybe a cvs like tree would work? Good prep work on the above will reduce workload later, especially if any robo-mod functionality can parse new questions and correlate a rtfaq response if an answer exists or flag the new question as needing de novo attention. Hmmm ... maybe a bit much to code now??? I don't think writing a faq that delineates how to topic code a subject line will work that well - people don't think that way - they just want to ask a question and get an answer. The faq is what needs to be organized as well as possible - both to make it useful and to make it easy for mods (or a robo-mod script) to match questionX with answerY. Would you (the community) like any changes? I know it sounds strict, but it allows us to have a question/answer only list that stays on topic. What you are proposing is an interactive reference that is going to be a lot of work and will be a direct reflection of the strength of the cf-talk community's cohesiveness, knowledge and spirit (and maybe our masochism too). Definitve references need to be strict in order to have value and in order to be maintainable. Maybe some of the above will be helpful as you do this thing. Now, as for the CFDJ list, my gripes against them and especially their marketing can go on for an hour and are definitely off topic. Funny how comp mags come and go and tend to get overweight with advertising and style as opposed to content ; Pan p.s. If the contents of this new thing becomes extensive and comprehensive enough, then it strikes me as something I just might be willing to pay some subscription price to access -- ??? -- ~~ 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: advanced list
Michael I like the cf-talk list the way it is. I am a member of several moderated lists and they leave a lot to be desire. CF-Talk will not be changing. I'm defining a new, extended list that'll be both more limited than CF-Talk and more restrictive. Also, due to its nature it'll be slower. I expect the real posts to be on CF-Talk and this list to be for straight tech to tech questions. It's an experiment, both for the list and for the new list software. Sometimes, something appears on the cf-talk list, that is a little unexpected treasure... often it is OT... It more than compensates for the ones that are not of interest (to me)... delete key fixes taht. I wish you success with the new list, I will subscribe. I hope that the heavyweight contributors will still participate in cf-talk! Dick ~~ 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: advanced list
I have to agree. I like the list the way it is. We all have delete keys. Let the list live as is. The lists are staying as is, I was talking about a new experimental list. ~~ 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: SMB feature idea
Let it be a Administrator defined maintenance task. So in the Admin menu somewhere there will be a "Run Maintenance Profiles" button or something that will execute this and other features. Yeah..this is manual, but it's either that or do a check everytime the board is accessed to see what needs to be removed, which I'm sure would slow it and the server down a bit. If you do it whenever that particular thread with an expiry date is set, you still run into the problem of the thread not being popular, so no one clicks through into it to read it..thus the code never gets run (this too is a manual solution..it needs action by the admin/user to initiate it.) -Gel -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] My question is, does anyone have any ideas on how to best schedule something like this? I don't want to use cfschedule or anything, I'd rather it be triggered by activity on the message board... ~~ 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: SMB feature idea
Let it be a Administrator defined maintenance task. So in the Admin menu somewhere there will be a "Run Maintenance Profiles" button or something that will execute this and other features. Yeah..this is manual, but it's either that or do a check everytime the board is accessed to see what needs to be removed, which I'm sure would slow it and the server down a bit. Well, I don't want it to be manual, that's for sure. And I wouldn't want to run it everytime the board was accessed either... If you do it whenever that particular thread with an expiry date is set, you still run into the problem of the thread not being popular, so no one clicks through into it to read it..thus the code never gets run (this too is a manual solution..it needs action by the admin/user to initiate it.) I don't want it to be manual - since I want to set a thread to self-destruct, then forget about it... Sigh... Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.linktoss.com ___The Fastest Way to Send a Link to Anyone! http://www.digitacamera.com __DigitA Camera Scripts and Tips http://www.is300.net ___The Enthusiast's Home of the Lexus IS300 http://www.cfug-sfl.org ___South Florida Cold Fusion Users Group http://www.simplemessageboard.comFree Forum Software for Cold Fusion ~~ 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: advanced list
I don't know if the will work out or not, but kudos for trying something new. I'm sure it was a huge amount of work, too. Hal Helms == See ColdFusionTraining.com for info on "Best Practices with ColdFusion Fusebox" training == -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 18, 2001 12:55 AM To: CF-Talk Subject: Re: advanced list I have to agree. I like the list the way it is. We all have delete keys. Let the list live as is. The lists are staying as is, I was talking about a new experimental list. ~~ 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
