RE: Submit after Page loads
Personally I wouldn't use the js at the beginning of frame b. Have the button
disabled by default then use the onload method to enable the button. Something along
the line of:
(frame a)
(frame b)
function LoadEnable() {
parent.frames['framea'].submitbutton.enable = true;
}
...
Anyhow, my $.02 worth.
______
Bill Grover
Manager, Information SystemsPhone: 301.424.3300 x3324
EU Services, Inc. FAX:301.424.3696
649 North Horners Lane E-Mail: [EMAIL PROTECTED]
Rockville, MD 20850-1299WWW: <http://www.euservices.com>
__
> -Original Message-
> From: John Stanley [mailto:[EMAIL PROTECTED]
> Sent: Thursday, October 21, 2004 8:59 AM
> To: CF-Talk
> Subject: RE: Submit after Page loads
>
>
> in frame b at the beginning of the page using js disable the
> submit button.
> then in the body tag use the onLoad method to enable the
> button, or just put
> another call at the end of the page.
>
> -Original Message-
> From: DeMarco, Alex [mailto:[EMAIL PROTECTED]
> Sent: Thursday, October 21, 2004 8:53 AM
> To: CF-Talk
> Subject: Submit after Page loads
>
>
> Hello,
>
> We have an CFMX app that is using frames(arrrgh).
>
> Is there any way to prevent a submit button in Frame A from working
> until all of the frame B is loaded?
>
> Thanks!
>
> - Alex
>
>
>
>
~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182183
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: 100% CPU
Thanks for the info. I agree 100% not to make the system do all that work. I'm going to change the datasource definitions on my development server today. Since they will continue to work I'll change my live server tomorrow. ______ Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com __ -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 11:02 AM To: CF-Talk Subject: RE: 100% CPU Bill, FYI In regard to point 9 below. When you use a regular "server name" instead of a FLQN name you cause the JDBC server system to do the following: First it uses the unc service... check the host file for that string to resolve (no dice) check dns (also no dice) .move to rnc service (windows locator - basically a handoff to windows) check lmhosts file (if enabled and configured to do so)... check active directory created flqn on the nearest dc if you are on a domain ([EMAIL PROTECTED]) check Active dir on the master domain controller if nearest dc fails.. try to resolve the name using windows locator broadcasting It's a lot of hoops just for a friendlier naming scheme. Mostly, you just don't want windows to have to do this work for you. Windows networking is more dns based, but it still has a locator service with a fairly complicated heirarchy of resolution attempts. Instead, you want the JDBC service to bypass the application layer and get that name resolved prior to it arriving at the windows locator service. Simply ask yourself - "how is the server going to resolve this name". Mark Minasi's "mastering windows server 200x" books have some great information on how windows goes about this process. Mark A. Kruger, CFG, MSCE www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com -Original Message- From: Bill Grover [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 9:34 AM To: CF-Talk Subject: RE: 100% CPU Thanks for the response. I'll work on this list and see if it doesn't help. Here is some responses to a few of your points. 1. On the server in question we don't have any access. Just SQL Server 2. I'll try the updated drivers. 8. SQL is not on the web server. Both boxes are separate servers. 9. Our names are not FQDN but are not IP addresses either. We just use the server name (sql-server). I'll play with the host file. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: 100% CPU
Thanks for the response. I'll work on this list and see if it doesn't help. Here is some responses to a few of your points. 1. On the server in question we don't have any access. Just SQL Server 2. I'll try the updated drivers. 8. SQL is not on the web server. Both boxes are separate servers. 9. Our names are not FQDN but are not IP addresses either. We just use the server name (sql-server). I'll play with the host file. ______ Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com __ -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 9:41 AM To: CF-Talk Subject: RE: 100% CPU Bill, I went through a similar process with a client of ours. We did several things to mitigate this issue. 1. Eliminate Access dbs. If you have anything running on Access get rid of it. 2. Make sure and use the JDBC Merant 3.3 drivers for SQL - this is an update from 6.1. 3. Check out long running db requests - maintenance tasks, utility tasks, data imports, exports and dumps ect. Create a separate datasource for these, restrict the number of connections and deselect the "maintain db connections" for that db resource in cf admin. 4. Fiddle with the JVM maxperm memory, and heap sizes. Try to get them large enough so that the heap is not being constantly resized and garbage collection is efficient. There are a ton more JVM settings depending on the JVM you are using. 5. Use Perfmon to figure out which resource is hanging. 6. Consider increasing the process isolation in IIS for the application - it can tell you if IIS is having conflicts with other processes outside the ap. 7. Check the web logs for a burst of http requests at the point of failure. One customer I know created a dynamic publishing system with constantly updated content - then he used google adsense to serve ads and make himself money. But every time a new page was published (new to google) the googlebots attack to figure out which ads to serve. Since his server was near capacity this sometimes surfaced as a denial of service type attack (much like you are seeing) - and since many of his pages were driven by database calls it looked like a possible db problem - or connection issue etc. 8. Consider moving the SQL server Off of the web server. 9. Make sure and use a FQDN for the server name in the database administrator. In other words, don't use "127.0.0.1" or any other IP address. use "sql.mydomain.com" type syntax. In fact, put the domain in the HOST file if you have a default win server configuration. Windows will check the host file first to resolve the domain - which saves a dns request. JDBC will attempt to resolve an ip into a domain name using reverse lookup before making a connection. In many cases this results in a lengthy initial connection request. Having a guaranteed resolution to a flqn (a la the host file) eliminates this problem. That's my short list - anyone else? Mark A. Kruger, CFG, MSCE www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: 100% CPU
Thanks for the response. I'll work on this list and see if it doesn't help. Here is some responses to a few of your points. 1. On the server in question we don't have any access. Just SQL Server 2. I'll try the updated drivers. 8. SQL is not on the web server. Both boxes are separate servers. 9. Our names are not FQDN but are not IP addresses either. We just use the server name (sql-server). I'll play with the host file. ______ Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com __ -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 9:41 AM To: CF-Talk Subject: RE: 100% CPU Bill, I went through a similar process with a client of ours. We did several things to mitigate this issue. 1. Eliminate Access dbs. If you have anything running on Access get rid of it. 2. Make sure and use the JDBC Merant 3.3 drivers for SQL - this is an update from 6.1. 3. Check out long running db requests - maintenance tasks, utility tasks, data imports, exports and dumps ect. Create a separate datasource for these, restrict the number of connections and deselect the "maintain db connections" for that db resource in cf admin. 4. Fiddle with the JVM maxperm memory, and heap sizes. Try to get them large enough so that the heap is not being constantly resized and garbage collection is efficient. There are a ton more JVM settings depending on the JVM you are using. 5. Use Perfmon to figure out which resource is hanging. 6. Consider increasing the process isolation in IIS for the application - it can tell you if IIS is having conflicts with other processes outside the ap. 7. Check the web logs for a burst of http requests at the point of failure. One customer I know created a dynamic publishing system with constantly updated content - then he used google adsense to serve ads and make himself money. But every time a new page was published (new to google) the googlebots attack to figure out which ads to serve. Since his server was near capacity this sometimes surfaced as a denial of service type attack (much like you are seeing) - and since many of his pages were driven by database calls it looked like a possible db problem - or connection issue etc. 8. Consider moving the SQL server Off of the web server. 9. Make sure and use a FQDN for the server name in the database administrator. In other words, don't use "127.0.0.1" or any other IP address. use "sql.mydomain.com" type syntax. In fact, put the domain in the HOST file if you have a default win server configuration. Windows will check the host file first to resolve the domain - which saves a dns request. JDBC will attempt to resolve an ip into a domain name using reverse lookup before making a connection. In many cases this results in a lengthy initial connection request. Having a guaranteed resolution to a flqn (a la the host file) eliminates this problem. That's my short list - anyone else? Mark A. Kruger, CFG, MSCE www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com -Original Message- From: Bill Grover [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 8:11 AM To: CF-Talk Subject: RE: 100% CPU Ian, We have seen this behavior as well. When we start experiencing the page slowdowns and notice the jrun CPU very high we will stop and restart the CF Application Server, this "fixes" the problem. Yes the pages are down for a few seconds but in our environment this is not as big a problem as having the slow page response, or the page never coming up at all. __ Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com __ -Original Message- From: Ian Buzer [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 5:00 AM To: CF-Talk Subject: 100% CPU Hi all, We're running a CFMX 6.1 / SQL server 2000 app on a 1.6GHz AMD server with 1.5Gb of RAM. The app gets about 2.5 million page requests a month, peaking at about 7000 page requests per hour. Since yesterday morning it's suddenly started to misbehave, with the processor regularly maxing out at 100%. It will run clean an fast for 20 minutes or so, then suddenly requests will start to queue up and the whole thing grinds to a halt. Usually it recovers, but sometimes the service needs restarting to get it back. The app is well behaved, with most reques
RE: 100% CPU
Ian, We have seen this behavior as well. When we start experiencing the page slowdowns and notice the jrun CPU very high we will stop and restart the CF Application Server, this "fixes" the problem. Yes the pages are down for a few seconds but in our environment this is not as big a problem as having the slow page response, or the page never coming up at all. ______ Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com __ -Original Message- From: Ian Buzer [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 5:00 AM To: CF-Talk Subject: 100% CPU Hi all, We're running a CFMX 6.1 / SQL server 2000 app on a 1.6GHz AMD server with 1.5Gb of RAM. The app gets about 2.5 million page requests a month, peaking at about 7000 page requests per hour. Since yesterday morning it's suddenly started to misbehave, with the processor regularly maxing out at 100%. It will run clean an fast for 20 minutes or so, then suddenly requests will start to queue up and the whole thing grinds to a halt. Usually it recovers, but sometimes the service needs restarting to get it back. The app is well behaved, with most requests taking about half a second. There seem to be no particular long running requests that trigger it. This happened a couple of months ago and I restricted the amount of memory SQL server used and increased the RAM on the box to 1.5Gb. It currently appears to have about 3-400Mb free. I've installed the CFMX updater (released a few days ago), reinstalled ColdFusion, scandisked the drive and defragged. I wonder if anyone can give me any clues on what else to look for. Surely we should be able to get more traffic out of this spec machine? Many thanks Ian Buzer _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: stored procedures
True, but coming up with the execution plan is what takes the longest and has the greatest impact on the server. So by having a SP once it is executed and that execution plan is cached they become very quick. For example, I have a SP that uses about 10 select statements to retrieve data from 4 different databases and about 15 different tables. The 1st time it is run it takes about 10-15 seconds to return 2,100 rows. If I wait a few seconds and run it again it takes about 3 seconds to return the same rows. That is where the benefit of SP's are, that once run all future runs are significantly faster. __ Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com __ -Original Message- From: Micha Schopman [mailto:[EMAIL PROTECTED] Sent: Thursday, August 26, 2004 6:53 AM To: CF-Talk Subject: RE: stored procedures Stored procedures are NOT pre-compiled. This is a common made mistake. Only the execution plan gets cached, but the stored procedure is compiled upon execution. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Find out table names and fields?
If you have an ODBC connection, or can make one, according to Microsoft's website there are catalog functions built into ODBC that returns database information. Here is the link to the info in MSDN: http://msdn.microsoft.com/library/default.asp?url=""> Might or might not help! ______ Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com __ -Original Message- From: Stephen Milligan [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 07, 2004 5:25 PM To: CF-Talk Subject: RE: Find out table names and fields? You can also dig down to the java level and do this in a database independent way through the macromedia.jdbc.MacromediaDriver class if you need to support more than just MSSQL and MySQL. I have written a CFC that does this, but I haven't tested it on many systems. I'll try to get it tidied up and make it available once it's been tested a bit more thoroughly. Spike Stephen Milligan Code poet for hire http://www.spike.org.uk Do you cfeclipse? http://cfeclipse.tigris.org >-Original Message- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of S.Isaac Dealey >Sent: Wednesday, July 07, 2004 1:13 PM >To: CF-Talk >Subject: Re: Find out table names and fields? > >Those are specific to MySQL - MS SQL uses standard tables, views and >sql queries to expose its meta data. i.e. > >select * from information_schema.columns >where table_name = 'mytablename' > >and the like > >s. isaac dealey 214.823.9345 > >new epoch : isn't it time for a change? > >add features without fixtures with >the onTap open source framework >http://www.sys-con.com/story/?storyid=44477&DE=1 > >> how do i dump the results to display on the page? Will >> this only work for mySQL, or for MS SQL as well? > >> thanks! >> - Original Message - >> From: Barney Boisvert >> To: CF-Talk >> Sent: Wednesday, July 07, 2004 3:42 PM >> Subject: RE: Find out table names and fields? > > >> Sure, run these queries, and dump the result. > >> `show databases` will list all databases you have access >> to via the DSN. >> `show tables` will list all tables in the database the >> DSN is connected to. >> `show tables in ` will list all tables in the >> named database. >> `explain ` will list the columns of the named >> table. You can use >> cross-database tables by saying . > >> Cheers, >> barneyb > >> > -Original Message- >> > From: brobborb [mailto:[EMAIL PROTECTED] >> > Sent: Wednesday, July 07, 2004 1:26 PM >> > To: CF-Talk >> > Subject: Find out table names and fields? >> > >> > Hey guys, I have a host that has no web admin support >> > for >> > mySQL. I mean, they have MySQL running, but no admin. >> > At >> > least thats what I'm told by my client. I was >> > wondering if >> > there was a way to extract the table names and fields >> > using >> > coldfusion instead. Would that be possible? >> > >> > > > >> > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Screen and Print question.
Thanks for the feedback! I'll look for some other possibilities. __ Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com __ -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED] Sent: Thursday, July 08, 2004 8:10 AM To: CF-Talk Subject: Re: Screen and Print question. Easy enough to check: Just brought up the CFMX graphing example with IE (Mac) Printing resulted in no new page requests! And the browser display of the chart does not expire after 5 minutes. You must have something else going on! Dick On Jul 8, 2004, at 4:53 AM, Bill Grover wrote: > I could be wrong but I thought I read somewhere awhile ago that IE > makes another call. I know that one of my pages which uses the > cfchart tag if I don't print the page within about 30 seconds all of > the charts will change from what they are to a label saying that the > chart expired refresh the page. > ______ > > Bill Grover > Manager, Information Systems Phone: 301.424.3300 x3324 > EU Services, Inc. FAX: 301.424.3696 > 649 North Horners Lane E-Mail: > [EMAIL PROTECTED] > Rockville, MD 20850-1299 WWW: > http://www.euservices.com > __ > > -Original Message- > From: Dick Applebaum [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 07, 2004 8:27 PM > To: CF-Talk > Subject: Re: Screen and Print question. > > Totally within the browser -- no page request to the server. > > Some pages have a button to format for printing -- this usually is > a > request to the server for another page with the data formatted in > plain > text, with no (or limited) html tags. > > You could also do this client side with _javascript_. > > hth > > Dick > > On Jul 7, 2004, at 2:14 PM, Ian Skinner wrote: > > > I have a bit of an off the wall question? If you are looking at a > > webpage, then print it from the browser, does this create to new > call > > to the page from the server or does it print the current screen in > the > > browser? > > > > -- > > Ian Skinner > > Web Programmer > > BloodSource > > > > > > > \Documents%20and%20Settings\iskinner\Application%20Data\Microsoft\Signa > > tures\www.BloodSource.org> www.BloodSource.org > > > > Sacramento, CA > > > > "C code. C code run. Run code run. Please!" > > - Cynthia Dunning > > > > Confidentiality Notice: This message including any > > attachments is for the sole use of the intended > > recipient(s) and may contain confidential and privileged > > information. Any unauthorized review, use, disclosure or > > distribution is prohibited. If you are not the > > intended recipient, please contact the sender and > > delete any copies of this message. > > > _ > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Screen and Print question.
I could be wrong but I thought I read somewhere awhile ago that IE makes another call. I know that one of my pages which uses the cfchart tag if I don't print the page within about 30 seconds all of the charts will change from what they are to a label saying that the chart expired refresh the page. __ Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com __ -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 07, 2004 8:27 PM To: CF-Talk Subject: Re: Screen and Print question. Totally within the browser -- no page request to the server. Some pages have a button to format for printing -- this usually is a request to the server for another page with the data formatted in plain text, with no (or limited) html tags. You could also do this client side with _javascript_. hth Dick On Jul 7, 2004, at 2:14 PM, Ian Skinner wrote: > I have a bit of an off the wall question? If you are looking at a > webpage, then print it from the browser, does this create to new call > to the page from the server or does it print the current screen in the > browser? > > -- > Ian Skinner > Web Programmer > BloodSource > > > \Documents%20and%20Settings\iskinner\Application%20Data\Microsoft\Signa > tures\www.BloodSource.org> www.BloodSource.org > > Sacramento, CA > > "C code. C code run. Run code run. Please!" > - Cynthia Dunning > > Confidentiality Notice: This message including any > attachments is for the sole use of the intended > recipient(s) and may contain confidential and privileged > information. Any unauthorized review, use, disclosure or > distribution is prohibited. If you are not the > intended recipient, please contact the sender and > delete any copies of this message. > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Backup SQL Server Users
Dave's article will work fine. If you will be running SQL2000 on both servers just make sure they are both on the same SP level and the only thing you need to do is restore the master database. Then when you restore the individual databases everything will work just fine. We have done that here several times without a problem. __ Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com __ -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 08, 2004 10:09 PM To: CF-Talk Subject: RE: Backup SQL Server Users > I don't think I was clear in my original post. There are a > lot of databases & users for this SQL Server installation. > Before the re-install what do I need to do in order to backup > the users & permissions for all the databases? Do I just > backup the Master database or maybe if I backup the correct > configuration database(s), then I won't need to re-attached > any of the databases, clean up orphaned users, and/or > manually add back all the users & their permissions. You might find this useful: http://support.microsoft.com/?id=246133 Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Is Parallel Processing Possible With CF?
Maybe I'm way off base but what if you created a page with multiple frames and in each frame loaded a page that synced a different site. Wouldn't each frame be processed as a different request causing CF to process them in parallel? ______ Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com __ -Original Message- From: Geoff Bowers [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 24, 2004 1:19 AM To: CF-Talk Subject: Re: Is Parallel Processing Possible With CF? Nick Baker wrote: > That is basically what we are currently doing, i.e., a serial approach. The > system will work > but when Internet traffic becomes sluggish we start experiencing too many > pending events > and this results in performance degradation. A parallel approach would > reduce the seriousness > of the problem. There is a multi-threaded CFHTTP replacement tag floating around on one of the DRK's. You could use that to have a single scheduled task simultaneously kick off several processes. -- geoff http://www.daemon.com.au/ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Emailing Form.FieldNames results via looping?
Sorry but maybe 4.5 and up. If you try it in 4.01 form was not a structure, you had to do the evaluate. Believe me I wanted it to work when we were on that version prior to our upgrade. __ Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com __ -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, March 18, 2004 2:02 PM To: CF-Talk Subject: RE: Emailing Form.FieldNames results via looping? > if I remember correctly, #form[thisField]# won't work in > cf5, but I'm not 100% sure of that (It's been so long since > I used CF5). I'm pretty sure that syntax will work in CF 4 and up. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Quick SQL Question...
If you want to save on some of the typing you can rework the select statement into this: select count(createdate), createdate from (select convert(varchar, creationdate, 101) AS createdate from referer) makedate group by createdate __ Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com __ -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] Sent: Sunday, March 14, 2004 2:39 PM To: CF-Talk Subject: RE: Quick SQL Question... That's a neat trick - saves a lot of typing. Thanks! -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Friday, March 12, 2004 2:35 PM To: CF-Talk Subject: RE: Quick SQL Question... thank you! -Original Message- From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] Sent: Friday, March 12, 2004 3:31 PM To: CF-Talk Subject: RE: Quick SQL Question... The numbers in the 3rd position of the convert are qualifiers for how it will convert. In this case 101 = USA = MM/DD/YY. If you look in the SQL Books Online under Cast and Convert it will give you a list of all of the date conversions. -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Friday, March 12, 2004 3:18 PM To: CF-Talk Subject: RE: Quick SQL Question... WOW! WOW! WOW! Thanks so much. I knew this was possible. what is the significanse of the 101 -Original Message- From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] Sent: Friday, March 12, 2004 3:03 PM To: CF-Talk Subject: RE: Quick SQL Question... Che, If you are on MSSql 2K then this is the solution: select count(convert(varchar, creationdate, 101)), convert(varchar, creationdate, 101) from referer group by convert(varchar, creationdate, 101) Steve -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Friday, March 12, 2004 2:52 PM To: CF-Talk Subject: RE: Quick SQL Question... mark, i see where you are coming from...alas, i still am having no luck. -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] Sent: Friday, March 12, 2004 2:51 PM To: CF-Talk Subject: RE: Quick SQL Question... The 2 are mutually exclusive. One is the "group" of all the stuff on this day, but the other (the actual date) is not merely a date - but a - by nature a very unique item - down to the second. So you are actually getting the grouping you are asking for. If 2 referals occured at the exact instant (say '3/4/2004 5:07:35 PM') ... then you would see "2 3/4/2004 5:07:35 PM" - but since that's unlikey this is more or less like doing a "select * from.". What you need is a label and an order by clause: SELECT COUNT(creationdate) AS TotalRefsPerDay, datepart(month,creationdate) + '-' + datepart(day,creationdate) + '-' + datepart(year,creationdate) AS datelabel group by datepart(dw,creationdate) order by datelabel or something similar. The DateName( ) function would work as well - maybe better. It usally takes some work to get it exactly right. -Mark Mark A. Kruger, MCSE, CFG www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com ...what the web can be! -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Friday, March 12, 2004 1:28 PM To: CF-Talk Subject: Quick SQL Question... This SQL Code works: SELECT COUNT(creationdate) AS TotalRefsPerDay FROM Referer GROUP BY DATEPART(dw, creationdate) 197 364 350 294 260 243 196 But when I add a column... this does not): SELECT COUNT(creationdate) AS TotalRefsPerDay, creationdate FROM Referer GROUP BY DATEPART(dw, creationdate), creationdate 1 3/4/2004 5:07:35 PM 1 3/4/2004 5:09:27 PM 1 3/4/2004 5:11:19 PM 1 3/4/2004 5:13:14 PM 1 3/4/2004 5:14:31 PM 1 3/4/2004 5:14:53 PM 1 3/4/2004 5:16:19 PM 1 3/4/2004 5:20:37 PM 1 3/4/2004 5:21:10 PM What am I doing wrong? I'd like a simple two column table: creation date and the total number of referers for each day! TIA...Che _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX 6.1 VFP ODBC Resolved
That would be true. CF is running as a service and doesn't have access to any "mapped drives". We find that using UNC naming works great ( \\server\share\dir\dir\file.dbf). As you also found out the CF Service needs to be running as a user who has rights to the share and directory you want to access. ______ Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com __ -Original Message- From: Dan O'Keefe [mailto:[EMAIL PROTECTED] Sent: Friday, February 20, 2004 6:01 PM To: CF-Talk Subject: Re: CFMX 6.1 VFP ODBC Resolved > I have a fresh install of CF MX 6.1 Standard on Windows Server 2003. I > configured a Visual Foxpro system datasource in ODBC administrator, > selecting the "free tables" option and set the path as I normally > would. Then in CF Admin-Datasources, Created a datasource name, > selected ODBC Socket, submitted and selected my previously configured > system datasource in the ODBC DSN dropdown. Everything else looks > normal to me. > > When trying to use that datasource and access a dbf free table, I get > the error the table is not found. In my experience with CF 5 and . > dbf's, that does not necessarily mean the table is not there. A > permission issue can cause that error also. > > Anyone successfully connecting to free table .dbf's with MX 6.1? > > Thanks, Dan In my Microsoft ODBC config, I was using a mapped drive to get to the other box where the dbf resided. Once I changed it to use an IP, CF now sees the dbf. Go figure. Dan _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Which is quicker
Interesting, thanks. I thought I had done that before and received an error about not being able to nest the CFIF tag inside another tag. But it is very possible I was using a CFINPUT instead of a regular INPUT. I was probably on v4.01 at the time as well.
__
Bill Grover
Manager, Information Systems Phone: 301.424.3300 x3324
EU Services, Inc. FAX: 301.424.3696
649 North Horners Lane E-Mail: [EMAIL PROTECTED]
Rockville, MD 20850-1299 WWW: http://www.euservices.com
__
-Original Message-
From: David Ashworth [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 12, 2004 9:00 AM
To: CF-Talk
Subject: RE: Which is quicker
you wouldn't have to code it twice using CFIF
just have the CFIF around the checked parameter
checked>
-Original Message-
From: Bill Grover [mailto:[EMAIL PROTECTED]
Sent: 12 February 2004 12:47
To: CF-Talk
Subject: RE: Which is quicker
The one place I've found that I really like the IIF is to use it in
areas like the following code sample:
name="#REQUEST.cReorderFormArtPrefix##ReorderJob.ljob#"
value="Yes"
#IIF(laReorderJobs[lnLoop][REQUEST.cReorderFormArtPrefix] NEQ "",
DE("CHECKED"), DE(""))#>
I found using it this way is much more readable in my code then using
and having to code the almost identical tag twice with
only the "CHECKED" option in or out.
__
Bill Grover
Manager, Information Systems Phone:301.424.3300 x3324
EU Services, Inc. FAX:301.424.3696
649 North Horners Lane E-Mail:[EMAIL PROTECTED]
Rockville, MD 20850-1299 WWW:http://www.euservices.com
__
-Original Message-
From: Matthew Walker [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 11, 2004 6:27 PM
To: CF-Talk
Subject: RE: Which is quicker
Really? I'm getting about 50 and 150ms respectively. So for me while
iif()
is slower it's only one hundredth of a millisecond difference i.e. way
below
anything I'd worry about. So it's a style thing then.
-Original Message-
From: Tom Kitta [mailto:[EMAIL PROTECTED]
Sent: Thursday, 12 February 2004 11:11 a.m.
To: CF-Talk
Subject: RE: Which is quicker
You may get these results due to use of de(), run this code, which I
think
is more fair:
12
#temp-getTickCount()#
#iif(i mod 2, 1, 2)#
#temp-getTickCount()#
I got 15 - 16 as results for both of them with some variations both ways
which I discard as noise.
TK
-Original Message-
From: Matthew Walker [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 11, 2004 5:57 PM
To: CF-Talk
Subject: RE: Which is quicker
My test indicates iif() is about 400% slower. But the real issue is
code
readability. If you think it's more readable in any or all
circumstances,
I
say go for it. Personally, I think this example demonstrates it is
less
readable. There are probably other example that show it in a better
light.
Here's my sample:
!?
#iif(i mod 2, de("!"), de("?"))#
-Original Message-
From: Tom Kitta [mailto:[EMAIL PROTECTED]
Sent: Thursday, 12 February 2004 10:47 a.m.
To: CF-Talk
Subject: RE: Which is quicker
I don't know why people don't like iif (immediate if), it is as quick
as
cfif and takes only one line. For simple things, like "if x < y print
true
else print false", I think using iif makes code shorter without
sacrificing
clarity and speed.
If you don't believe iif is fast then I encourage you to write a small
test
and see for yourself.
TK
-Original Message-
From: Matthew Walker [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 11, 2004 5:34 PM
To: CF-Talk
Subject: RE: Which is quicker
cfswitch is both quicker and more elegant. The only downside is that
it
doesn't handle dynamic values.
Iii() is one of those functions, like evaluate(), usage of which is
generally discouraged.
-Original Message-
From: Parker, Kevin [mailto:[EMAIL PROTECTED]
Sent: Thursday, 12 February 2004 10:30 a.m.
To: CF-Talk
Subject: Which is quicker
Can I get a little advice on which is quicker or which is the
preferred
way
of programming - there are 8 items to select from:
CFIF, CFCASE or IIF
TIA!
+++
Kevin Parker
Web Services Manager
WorkCover Corporation
p: 08 8233 2548
e: [EMAIL PROTECTED]
w: www.workcover.com
+++
This e-mail is intended for the use of the addressee only. It may
contain information that is protected by legisl
RE: Which is quicker
The one place I've found that I really like the IIF is to use it in areas like the following code sample:
name="#REQUEST.cReorderFormArtPrefix##ReorderJob.ljob#"
value="Yes"
#IIF(laReorderJobs[lnLoop][REQUEST.cReorderFormArtPrefix] NEQ "",
DE("CHECKED"), DE(""))#>
I found using it this way is much more readable in my code then using and having to code the almost identical tag twice with only the "CHECKED" option in or out.
__
Bill Grover
Manager, Information Systems Phone:301.424.3300 x3324
EU Services, Inc. FAX:301.424.3696
649 North Horners Lane E-Mail:[EMAIL PROTECTED]
Rockville, MD 20850-1299 WWW:http://www.euservices.com
__
-Original Message-
From: Matthew Walker [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 11, 2004 6:27 PM
To: CF-Talk
Subject: RE: Which is quicker
Really? I'm getting about 50 and 150ms respectively. So for me while iif()
is slower it's only one hundredth of a millisecond difference i.e. way below
anything I'd worry about. So it's a style thing then.
-Original Message-
From: Tom Kitta [mailto:[EMAIL PROTECTED]
Sent: Thursday, 12 February 2004 11:11 a.m.
To: CF-Talk
Subject: RE: Which is quicker
You may get these results due to use of de(), run this code, which I think
is more fair:
12
#temp-getTickCount()#
#iif(i mod 2, 1, 2)#
#temp-getTickCount()#
I got 15 - 16 as results for both of them with some variations both ways
which I discard as noise.
TK
-Original Message-
From: Matthew Walker [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 11, 2004 5:57 PM
To: CF-Talk
Subject: RE: Which is quicker
My test indicates iif() is about 400% slower. But the real issue is code
readability. If you think it's more readable in any or all circumstances,
I
say go for it. Personally, I think this example demonstrates it is less
readable. There are probably other example that show it in a better light.
Here's my sample:
!?
#iif(i mod 2, de("!"), de("?"))#
-Original Message-
From: Tom Kitta [mailto:[EMAIL PROTECTED]
Sent: Thursday, 12 February 2004 10:47 a.m.
To: CF-Talk
Subject: RE: Which is quicker
I don't know why people don't like iif (immediate if), it is as quick as
cfif and takes only one line. For simple things, like "if x < y print true
else print false", I think using iif makes code shorter without
sacrificing
clarity and speed.
If you don't believe iif is fast then I encourage you to write a small
test
and see for yourself.
TK
-Original Message-
From: Matthew Walker [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 11, 2004 5:34 PM
To: CF-Talk
Subject: RE: Which is quicker
cfswitch is both quicker and more elegant. The only downside is that it
doesn't handle dynamic values.
Iii() is one of those functions, like evaluate(), usage of which is
generally discouraged.
-Original Message-
From: Parker, Kevin [mailto:[EMAIL PROTECTED]
Sent: Thursday, 12 February 2004 10:30 a.m.
To: CF-Talk
Subject: Which is quicker
Can I get a little advice on which is quicker or which is the preferred
way
of programming - there are 8 items to select from:
CFIF, CFCASE or IIF
TIA!
+++
Kevin Parker
Web Services Manager
WorkCover Corporation
p: 08 8233 2548
e: [EMAIL PROTECTED]
w: www.workcover.com
+++
This e-mail is intended for the use of the addressee only. It may
contain information that is protected by legislated confidentiality
and/or is legally privileged. If you are not the intended recipient you
are prohibited from disseminating, distributing or copying this e-mail.
Any opinion expressed in this e-mail may not necessarily be that of the
WorkCover Corporation of South Australia. Although precautions have
been taken, the sender cannot warrant that this e-mail or any files
transmitted with it are free of viruses or any other defect.
If you have received this e-mail in error, please notify the sender
immediately by return e-mail and destroy the original e-mail and any
copies.
_
_
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: List ? in a CFIF
I beg to differ on a point. ListFind returns the index of the item found, not True/False. So ListFind("Blue,Black","Blue") = 1 but ListFind("Blue,Black","Black") = 2. If you try to find something that isn't in the list the return value is zero, so ListFind("Blue,Black","Red") = 0
It is just the nature of CF that a value of any value other than zero is true and zero is false, which can be used to great advantage.
______
Bill Grover
Manager, Information Systems Phone: 301.424.3300 x3324
EU Services, Inc. FAX: 301.424.3696
649 North Horners Lane E-Mail: [EMAIL PROTECTED]
Rockville, MD 20850-1299 WWW: http://www.euservices.com
__
-Original Message-
From: Taco Fleur [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 22, 2004 4:57 PM
To: CF-Talk
Subject: RE: List ? in a CFIF
Mike,
the thing that might confuse you is the fact there is only a function listed
in the cfif statement
The function either returns TRUE or FALSE depending on whether the value
"phone" is found in the list, so in short it would be
If you want to type it all out, which saves time typing but is quicker to
evaluate, you'd have
Which might make more sense to you.
Taco Fleur
Blog
http://www.tacofleur.com/index/blog/
Methodology http://www.tacofleur.com/index/methodology/
0421 851 786
Tell me and I will forget
Show me and I will remember
Teach me and I will learn
-Original Message-
From: Mickael [mailto:[EMAIL PROTECTED]
Sent: Friday, 23 January 2004 7:40 AM
To: CF-Talk
Subject: Re: List ? in a CFIF
Hi Raymond,
Can you explain how to use it. I see examples on the web like this
listfindnocase(validation_error, "phone")> I just don't understand the
first argument in that example validation_error sorry for my newbieness
Mike
- Original Message -
From: Raymond Camden
To: CF-Talk
Sent: Thursday, January 22, 2004 5:18 PM
Subject: RE: List ? in a CFIF
Sure, use listFind or ListFindNoCase.
Raymond Camden
.sigless in Boston
> -Original Message-
> From: Mickael [mailto:[EMAIL PROTECTED]
> Sent: Thursday, January 22, 2004 3:13 PM
> To: CF-Talk
> Subject: List ? in a CFIF
>
> Hi All,
>
> I am sure there is a way to do this but I am unclear on the syntax.
>
> Instead of having many CFIF's is there a way to check for a
> value similar to SQL where you say
>
> select * from table where something in ('value','value','value)
>
>
> I have thisBut
> instead of creating more than one cfif statement I would like
> to add more than one value without making it ugly with a
> whole bunch of OR's
>
> Can this be done?
>
> Mike
>
>
>
_
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: Two Destinations for POST form?
Another option is to do something like the following. I've done this a couple of places where we wrote systems that submitted to a page then after everything is released the specs changed and we needed to submit to 2 pages to get things to work. Have your form submit to a page that does your local stuff. Then at the bottom of that page have the following code: <br> document.values.submit();<br> So now your localpage will submit on to the SMS page which will still display to the user what it usually does. __ Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com __ -Original Message- From: Hugo Ahlenius [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 13, 2004 3:47 AM To: CF-Talk Subject: RE: Two Destinations for POST form? Another way is to (using _javascript_) also submit the data to a (hidden) iframe that calls the local database. - Hugo Ahlenius E-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-Arendal Fax: +46 8 230441 Stockholm Office Mobile: +46 733 467111 WWW: http://www.grida.no - | -Original Message- | From: Mike Townend [mailto:[EMAIL PROTECTED] | Sent: Monday, January 12, 2004 13:51 | To: CF-Talk | Subject: RE: Two Destinations for POST form? | | Do an initial post to a local page, then insert these | details. Then you can do a CFHTTP post to the SMS provider | | HTH | | | | -Original Message- | From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] | Sent: Monday, January 12, 2004 12:47 | To: CF-Talk | Subject: Two Destinations for POST form? | | | Afternoon all, I trust you had a good weekend? | | I've got a form that sends a textarea message to an SMS | service. This is | simple enough, but I want to record the very same message | (and who sent it) | on the local site's database, meaning the form would have to | POST to two | destinations. Is this possible? Any ideas? | | Cheers, | Rob | _ | | | _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Get URL
Try This is the code I use in a my login page. Basically I do it so a user can bookmark any page on the site (i.e. www.euservices.com/myeu/somepage.cfm?parm=somevalue) and if they select their bookmark the system will try to go there, switch to my login page, log them in then continue to the page they requested. __ Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com __ -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 7:15 AM To: CF-Talk Subject: Get URL How can I get the current URL (from browser)? e.g. I type in http://abc.com/myTest/test.cfm I need to save this URL in a variable inside test.cfm... Thanks Shaz _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: How do I access COM Object properties in CF
If memory serves me correct the last time I used the CFObject tag all it does is create an instance of the object and assigns a reference to a variable. So will create the object and return the reference. To set a property just and to read a value you . To call a method you can __ Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com __ -Original Message- From: Sam komolafe [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 6:48 PM To: CF-Talk Subject: How do I access COM Object properties in CF Hi, How do I access COM Object properties using CFObject tag? Thank Sam --- [This E-mail scanned for viruses.] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFFunction Question - SOLVED
Thanks to Raymond, Bryan and everyone else that responded. I did log a bug as Raymond suggested. There was 2 solutions to the problem. The first solution was to pass the default value in for every argument that I didn't want to change. Very messy, but it does work. The 2nd solution was to use the then output #var#. When I left this yesterday I was receiving a message about var being undefined. This morning on my way in it suddenly came to me that I was seeing the output of my function on the screen before the error message appeared, just not where I wanted it. This got me thinking about how my function was declared. I had declared my function with the argument output="Yes". This was causing the UDF's body to be output. But I never had a in my function declaration so nothing was actually returned to be put in the variable I was trying to set. DUH! So I changed the to have output="no", loaded the HTML I wanted to output into a variable in the UDF then did a of that variable. This works like a champ! Once again, thanks for all the help. ______ Bill Grover Manager, Information Systems Phone:301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail:[EMAIL PROTECTED] Rockville, MD 20850-1299 WWW:http://www.euservices.com __ -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Monday, January 05, 2004 4:34 PM To: CF-Talk Subject: RE: CFFunction Question Ah, ok. It is in the error msg, but in small type: Use ordered arguments instead. It looks like if you copy a UDF to one of the built-in scopes, you can't do udf(a=b) format. Which sucks. All I can say is log a bug for it. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFFunction Question
Tried various combinations of #'s and still get the same message. __ Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com __ -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: Monday, January 05, 2004 4:12 PM To: CF-Talk Subject: RE: CFFunction Question Place pounds around your variables. -Original Message- From: Bill Grover [mailto:[EMAIL PROTECTED] Sent: Monday, January 05, 2004 4:05 PM To: CF-Talk Subject: RE: CFFunction Question I changed the calling code to: tcLinkType = APPLICATION.cJobImgLinkType, tcLinkDesc = APPLICATION.cJobImgLinkDesc)> #lcLink# _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFFunction Question
B is defined in all cases. __ Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com __ -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Monday, January 05, 2004 4:18 PM To: CF-Talk Subject: RE: CFFunction Question You don't need that. x = udf(a=b) works just fine w/o # signs... assuming that B is defined. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFFunction Question
It should have been on the line directly below the tag. __ Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com __ -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Monday, January 05, 2004 4:12 PM To: CF-Talk Subject: RE: CFFunction Question In your code example, I did not see an argument named tcItemNumber. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFFunction Question
If I use the code I just e-mailed in response to Raymond's answer but drop the REQUEST. I get "LCLink is underfined" ______ Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com __ -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: Monday, January 05, 2004 3:58 PM To: CF-Talk Subject: RE: CFFunction Question Just use the name of the function fImageCol(tcLinkType=yourValue, tcLinkDesc=yourValue) -Original Message----- From: Bill Grover [mailto:[EMAIL PROTECTED] Sent: Monday, January 05, 2004 3:52 PM To: CF-Talk Subject: CFFunction Question Oh Great Guru's! _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFFunction Question
I changed the calling code to: #lcLink# Now I get the message: Cannot invoke method fImageCol on an object of type coldfusion.runtime.RequestScope with named arguments I define the function in my Application.cfm file this way: And the last line of the fImageCol.cfm file is: __ Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com __ -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Monday, January 05, 2004 3:56 PM To: CF-Talk Subject: RE: CFFunction Question Use x=y notation: _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFFunction Question
Oh Great Guru's! I'm sure the solution is simple but I can't seem to find the answer. Basically how do you call a with only some of the arguments? I have the following function: A BUNCH OF CODE GOES HERE! target="_blank" title="EU Services | Customer Inventory Browser">#ARGUMENTS.tcLinkDesc# NA When I call the function this way: #REQUEST.fImageCol(KitItems.CarrierInv)# Everything works perfectly. However, I need to call the function and pass in the last 2 arguments. If I try and call the function like this: #REQUEST.fImageCol(KitItems.CarrierInvAPPLICATION.cJobImgLinkType, APPLICATION.cJobImgLinkDesc)# The program fails with the message: Missing Argument Name. How do I call the fuction and only pass the 3 arguments I want to? ______ Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com __ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMAIL vs. CDO
One other point I just thought of, if memory serves me correctly I believe there is a memory leak in CDO so that if you use it a lot it has a tendency to use memory without releasing it. Bill Grover Manager, Information Systems EU Services, Inc. 649 N Horners Ln Rockville, MD 20850 Phone: 301-424-3300 x3324 Fax: 301-424-3696 E-Mail: [EMAIL PROTECTED] At 05:53 PM 1/1/2004 -0500, you wrote: >We had an application that used CDO to e-mail to a list of about 2,500 >people. The application would create an object, send and e-mail to 1 >address, drop the object then update a table that it had e-mailed that >address. Yes it might not have been the most efficient but we only ran it >once a month and one of the highest priorities was to insure that if the >application crashed in the middle of sending the e-mail that when restarted >it wouldn't send the e-mail to the same address a 2nd time. > >When it ran under CF 4.01 it would take about 10-15 minutes to send the >e-mails. After migrating to MX 6.0 it would take hours to run. We ended >up rewritting the application to directly write files to CF's mail spool >folder. > >Bill Grover >Manager, Information Systems >EU Services, Inc. >649 N Horners Ln >Rockville, MD 20850 > >Phone: 301-424-3300 x3324 >Fax: 301-424-3696 >E-Mail: [EMAIL PROTECTED] > >At 04:39 PM 1/1/2004 -0500, you wrote: > > > I have this newsletter application wich I have used for over a > > > year now to send a monthly newsletter to about 900 people. It has > > > worked fine using while splitting the list into 4 small > > > lists of about 250 subscribers. This is under a shared hosting > > > environment with Crystaltech.com. I never had any issues until a > > > week ago. > > > > > > Now, I email is not delivered and when I called tech support they > > > say I must use CDO insted of Coldfusion's native tag. > > > > > > Is this advice sound? Or is it time to look for a new host? > > > > > > 900 emails split into 4 small lists doesn't seem excessive. And, > > > most importantly, how come it worked fine before? > > > > > > The tech support guy flatly said he didn't know the answer to this > > > question, but insisted I use CDO > > > >If you're using CFMX, I'd strongly recommend using CFMAIL instead of > >alternative solutions - especially if they're COM-based like CDO. > > > >If you're using an older version of CF, there have been quite a few issues > >with CFMAIL, but I don't know that they'd warrant rewriting your code to use > >CDO. > > > >Dave Watts, CTO, Fig Leaf Software > >http://www.figleaf.com/ > >phone: 202-797-5496 > >fax: 202-797-5444 > > > >-- > >[ > >-- >[ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMAIL vs. CDO
We had an application that used CDO to e-mail to a list of about 2,500 people. The application would create an object, send and e-mail to 1 address, drop the object then update a table that it had e-mailed that address. Yes it might not have been the most efficient but we only ran it once a month and one of the highest priorities was to insure that if the application crashed in the middle of sending the e-mail that when restarted it wouldn't send the e-mail to the same address a 2nd time. When it ran under CF 4.01 it would take about 10-15 minutes to send the e-mails. After migrating to MX 6.0 it would take hours to run. We ended up rewritting the application to directly write files to CF's mail spool folder. Bill Grover Manager, Information Systems EU Services, Inc. 649 N Horners Ln Rockville, MD 20850 Phone: 301-424-3300 x3324 Fax: 301-424-3696 E-Mail: [EMAIL PROTECTED] At 04:39 PM 1/1/2004 -0500, you wrote: > > I have this newsletter application wich I have used for over a > > year now to send a monthly newsletter to about 900 people. It has > > worked fine using while splitting the list into 4 small > > lists of about 250 subscribers. This is under a shared hosting > > environment with Crystaltech.com. I never had any issues until a > > week ago. > > > > Now, I email is not delivered and when I called tech support they > > say I must use CDO insted of Coldfusion's native tag. > > > > Is this advice sound? Or is it time to look for a new host? > > > > 900 emails split into 4 small lists doesn't seem excessive. And, > > most importantly, how come it worked fine before? > > > > The tech support guy flatly said he didn't know the answer to this > > question, but insisted I use CDO > >If you're using CFMX, I'd strongly recommend using CFMAIL instead of >alternative solutions - especially if they're COM-based like CDO. > >If you're using an older version of CF, there have been quite a few issues >with CFMAIL, but I don't know that they'd warrant rewriting your code to use >CDO. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ >phone: 202-797-5496 >fax: 202-797-5444 > >-- >[ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cflogin vs. GetAuthUser
As Dave said cflogin does a lot of things other than just setting session variables. But whatever works, I found that using the cflogin in MX was much easier than writing my own, especially if you want to do several things during login. Basically what I did was the following: In my Application.cfm page I have the following lines: Login.cfm is the following: datasource="#APPLICATION.cWebClientDSN#" username="#APPLICATION.cWebClientUser#" password="#APPLICATION.cWebClientPass#"> cfsqltype="CF_SQL_VARCHAR" value="#FORM.UserName#" null="No"> cfsqltype="CF_SQL_VARCHAR" value="#FORM.UserPass#" null="No"> password="#FORM.UserPass#" roles=""> WebClientInfo.wcu_id> WebClientInfo.wcu_userid> WebClientInfo.wcu_email> WebClientInfo.wcu_company> WebClientInfo.wcu_usermaint> And GetLogin.cfm is: #APPLICATION.cTitle# GetFileFromPath(GetBaseTemplatePath()))> method="post"> CGI.query_string> method="post"> lcField) EQ 0> name="#lcField#" value="#Form[lcField]#"> Welcome to myEU. Log in here to access your FTP and/or online inventory site if you already have a username and password assigned. User: name="UserName" size="15" maxlength="15"> Password: name="UserPass" size="15" maxlength="15"> value="Login"> value="Reset"> If you do not have a username and password, or this is your first time to myEU, you may request a username and password Your request will be handled promptly. Note: you must be an EU Services' customer to request a myEU username and password Note to Mac users: We recommend you use Fetch for your FTP client. Internet Explorer will not work as an FTP client on a Mac platform. At 10:53 AM 12/30/2003 -0800, you wrote: >Dave, >I appreciate your (always thoughtful) response. I was hoping to >take advantage of cflogin since moving to CFMX, but in this >particular case, I think I'm trying to fit a square peg into a >round hole. I'll probably continue to roll my own until I'm in a >situation where cflogin is a better fit. > >Dave Jones >NetEffect > >At 11:18 AM 12/30/03 -0500, you wrote: > > > So then my question is, why do I need cflogin? cfloginuser used > > > by itself will log in a user. GetAuthUser will test if a user > > > is logged in. > > > >The CFLOGIN tag does quite a bit more than just ask whether the user has > >logged in. It allows you access to the CFLOGIN structure (useful if you're > >using web server authentication, or follow the standard "j_username" and > >"j_password" naming scheme for HTML login
RE: cflogin vs. GetAuthUser
This is correct, you must use the cfloginuser within the cflogin tag. cflogin looks for session variables it sets to determine if you have run the cflogin tag before. If these variables are not found then it executes the code withing the tag pair. You should put your cfloginuser tag in here. GetAuthUser() simply returns the name of the user you supplied in the cfloginuser tag. I use this after my pair to insure that a user really got logged in. If the user didn't get logged in then I deal with it there. More specifically, I use cflogin to attempt to login a user when they haven't logged in yet. The code within the tag will take their user information and validate it aginst a list of valid users and if they are found then execute the cfloginuser tag to do the actual login. Once the tag ends I make a call to GetAuthUser() to validate that I have a user name and continue to let the page load, otherwise I reprompt the user for their information. Hope that helped. Bill Grover Manager, Information Systems EU Services, Inc. 649 N Horners Ln Rockville, MD 20850 Phone: 301-424-3300 x3324 Fax: 301-424-3696 E-Mail: [EMAIL PROTECTED] At 07:33 AM 12/30/2003 -0500, you wrote: >You should only be using cfloginuser within cflogin tags. > > >http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-p74.htm#wp287308 >9 > >89> > >-Original Message- >From: Dave Jones [mailto:[EMAIL PROTECTED] >Sent: Monday, December 29, 2003 3:23 PM >To: CF-Talk >Subject: cflogin vs. GetAuthUser > >I can use some help on understanding the relationship between >cflogin and GetAuthUser. I understand that cflogin is only >executed if there is no logged-in user. If there is no logged-in >user, should GetAuthUser return an empty string? Conversely, if >GetAuthUser contains a non-null value, does that mean cflogin >should not get executed? > >I'm asking because I'm encountering a situation where GetAuthUser >is returning a valid user, yet cflogin is still getting executed. > >Note that I am invoking cfloginuser outside of the cflogin tag. >It seems to be registering the user properly, but is that why >cflogin is not recognizing the logged-in user? If this is the >case, can I safely replace the cflogin tag with >Len(GetAuthUser()) eq 0>to test if a logged-in user exists? > >Thanks, >Dave Jones >NetEffect > _ > >-- >[ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Ektron CMS
We use their emPower software and like it. You just have to be real careful about how it is installed. We've had the best success by accepting all the defaults when installing. This allowed us to push all publishing to our admin/marketing department and IS doesn't do any of it any more. The only thing we as the IS department do is some of the special sections where security and registration is required. Then we write the code needed to run to validate the security and leave the rest up to the users to add the content in the page. You can checkout our website via the link below. Everything but the RFQ, MyEU and phone directory lookup pages are powered by emPower. ______ Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com __ -Original Message- From: Ryan Sabir [mailto:[EMAIL PROTECTED] Sent: Thursday, December 11, 2003 1:41 AM To: CF-Talk Subject: Ektron CMS Hi Folks, Has anyone here implemented a site using the Ektron CMS product "CMS 300"? We use their eWebEditPro WYSIWYG editor a lot and find it great, but as yet haven't looked at their CMS products. What are they like from a developers point of view? Any major hassles working with it? What's the CF integration like? thanks, bye! --- Ryan Sabir Newgency Pty Ltd 2a Broughton St Paddington 2021 Sydney, Australia Ph (02) 9331 2133 Fax (02) 9331 5199 Mobile: 0411 512 454 http://www.newgency.com/index.cfm?referer=rysig _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: (CF 6 reliability) from Re: Memory Leak on Win2k/CMX6.1
We are running 6.1 and have seen a memory leak, not severe. We seem to run fine for a couple of weeks before things begin to slow down. We've found that simply stopping and restarting the service will fix the issue. We might try the Microsoft JDBC drivers to see if that doesn't help us. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com __ -Original Message- From: Ryan Sabir [mailto:[EMAIL PROTECTED] Sent: Monday, November 03, 2003 8:46 PM To: CF-Talk Subject: Re:(CF 6 reliability) from Re: Memory Leak on Win2k/CMX6.1 Hi all, I have recently installed CFMX 6.1 in a high traffic production environment, and I can say that I haven't experienced this memory leak problem. I am getting quite a few deadlock errors and service too busy error, but I suspect thats an issue with the questionable code that we inherited. By high traffic I mean around 70,000 page views per day. My machine configuration is: Intel Xeon 2.4GHz cache 1024 MB RAM 36 G Hard Drive It was a completely fresh install of MS Windows 2000 Server, fully patched, and a completely fresh install of CFMX. I'm using the JDBC drivers provided by Microsoft and installed as described in this technote: http://www.macromedia.com/support/coldfusion/ts/documents/cfmx_config_mssql2000.htm Hope this helps someone get to the bottom of their problem... Tuesday, November 4, 2003, 12:08:46 PM, you wrote: KW> Might be easier to ask how many people are having serious problems with MX. KW> Ken KW> Boldacious Web Design wrote: >> What are other people's views on this - how many people are using >> MX with no problems? >> >> >> You wrote >> >> >> >>>>I suggest the user with problems with the server product, to >> >> uninstall >>it completely and revert to CF 5.0, until Macromedia >> gets its act >> >>>>together. While a lot was accomplished with the 6.1 release >> >> over >>previous editions, it still is not a stable product., and >> IMHO should >>not even be on the market. >> >> >> Seamus Campbell Boldacious WebDesign >> http://www.boldacious.com [EMAIL PROTECTED] >> ph 02 6297 4883 fax 02 6297 4883 mob 0410 609 267 >> >> >> KW> _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Query to Stored Proc
On further thought, The where clause could possibly even be simplified to the following. WHERE 1 = CASE WHEN FormrfpNumber <> '' AND o.rfpNumber = FormrfpNumber THEN 1 WHEN FormTitle <> '' AND o.title = FormTitle THEN 1 WHEN FormAwardType <> -1 AND o.awardtypeid = FormAwardType THEN 1 ELSE 0 END ______ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com __ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Query to Stored Proc
Caveat: My experience is with MS SQL so this may not apply to other flavors! Yes you can do what Mike say, just be careful where you place your spaces. In Mike's example the trailing space after the "where" would be truncated off so your where clause could end up looking like "wherebar=1" which would be invalid. It is better to put the space at the beginning of your string something like ' bar=1' to result in a string of "where bar=1" You can also do what you want without having the string with case statements in your where clause. You would need to pass all of your form fields as parameters in the stored procedure. Your statement would then be like: SELECT O.opportunityId, O.title, O.lastUpdateUserId, O.lastUpdateOn, O.createDate, U1.firstName AS creatorFirstName, U1.lastName AS creatorLastName, U1.emailAddress AS creatorEmailAddress, U2.firstName AS updaterFirstName, U2.lastName AS updaterLastName, U2.emailAddress AS updaterEmailAddress, P.phaseName FROM tbl_opportunity O LEFT JOIN tbl_user U1 ON (O.createUserId = U1.userId) LEFT JOIN tbl_user U2 ON (O.lastUpdateUserId = U2.userId) LEFT JOIN tbl_phase P ON (O.phaseId = P.phaseId) WHERE 1=0 OR 1 = CASE WHEN FormrfpNumber <> '' AND o.rfpNumber = FormrfpNumber THEN 1 ELSE 0 END OR 1 = CASE WHEN FormTitle <> '' AND o.title = FormTitle THEN 1 ELSE 0 END OR 1 = CASE WHEN FormAwardType <> -1 AND o.awardtypeid = FormAwardType THEN 1 ELSE 0 END ORDER BY O.createDate DESC __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com __ -Original Message- From: Mike Townend [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 04, 2003 6:07 AM To: CF-Talk Subject: RE: Query to Stored Proc afaik you will need to build a VARCHAR of IF statements something like DECLARE @sSQL VARCHAR(1000) SET @sSQL = 'select * from foo where ' IF (@bar = 1) BEGIN SET @sSQL = @sSQL + ' bar = 1' END ELSE BEGIN SET @sSQL = @sSQL + ' 1=1' END exec (@sSQL) HTH -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 4, 2003 10:57 To: CF-Talk Subject: Query to Stored Proc How would you rework the logic in the WHERE clause to get this query put into a stored proc? Can you put conditional logic in the WHERE clause inside a stored proc? SQL 2K Enterprise SELECT O.opportunityId, O.title, O.lastUpdateUserId, O.lastUpdateOn, O.createDate, U1.firstName AS creatorFirstName, U1.lastName AS creatorLastName, U1.emailAddress AS creatorEmailAddress, U2.firstName AS updaterFirstName, U2.lastName AS updaterLastName, U2.emailAddress AS updaterEmailAddress, P.phaseName FROM tbl_opportunity O LEFT JOIN tbl_user U1 ON (O.createUserId = U1.userId) LEFT JOIN tbl_user U2 ON (O.lastUpdateUserId = U2.userId) LEFT JOIN tbl_phase P ON (O.phaseId = P.phaseId) WHERE 1=0 OR O.rfpNumber = '#form.rfpNumber#' OR O.title = '#form.title#' OR O.naicsCode = '#form.naicsCode#' OR O.costCenterId = '#form.costCenterLocation#' OR O.procurementTypeId = '#form.procurementType#' OR O.awardTypeId = '#form.awardType#' OR O.classificationId = '#form.classification#' OR O.phaseId = '#form.phase#' OR O.agencyId = '#form.clientAgency#' OR O.bureauId = '#form.clientBureau#' OR O.bureauOtherId = '#form.clientBureauOther#' ORDER BY O.createDate DESC _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: using CONNECT STRING with CFMX
The string should be: dsn=dsn;uid=uname;pwd=pword I've made the same mistake forgetting that it isn't "username" but "uid". ______ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: John McCosker [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 28, 2003 6:10 AM > To: CF-Talk > Subject: using CONNECT STRING with CFMX > > > Hi, > > Could someone tell what would be the correct syntax to connect > to MSSQL using ODBC SOCKETS through the connect string. > > We are using MX 6.0 and MSSQL 7.0. > > The server docs shed little light on this, and having trouble > getting any > reasonable documentation on the MM website. > > Our IT guy here has been working with the server and everything going > through > ODBC is running very slow, except one ASP site which uses > connection string. > > He wants me to look into this for the time being. > > In coldfusion 5 I'm almost sure there was a connectstring > attribute of the > , > there is not with MX. > in MX admin the connect string option is there under the > advanced settings > for my DSN in datasources. > > I really just need to know the correct syntax and what do I > leave out in the > settings for this to take > effect, for instance do I leave USERNAME and PASSWORD blank. > > I tried this, > leaving them blank and in the connect string box, > > dsn=dsn;username=uname;pwd=pword; > > but I get this error, > > Connection verification failed for data source: leocate > []java.sql.SQLException: SQLException while attempting to connect: > java.sql.SQLException: [MERANT][SequeLink JDBC Driver][SequeLink > Server]Required user name is missing. > The root cause was that: java.sql.SQLException: SQLException while > attempting to connect: java.sql.SQLException: [MERANT][SequeLink JDBC > Driver][SequeLink Server]Required user name is missing. > > Any help would be appreciated, > thanx, > > J > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: whitespace is breaking my javascript
I found that when we updated from CF 4.01 to MX and I turned on the server setting to
remove whitespace my javascript started to break as well. In this case it was due to
bad coding practice. I was neglecting to put ';' at the end of each statement so when
the server removed the whitespace I would end up with several statements on 1 line.
So I went through and put the ;'s in and everything started working.
What made me think of this was the javascript code you gave. Basically the 2 lines:
// return message
return this.lang_data[_block][arguments.message];
Could end up as
// return message return this.lang_data[_block][arguments.message];
causing it to treat it as a comment.
Just my $.02 worth.
______
Bill Grover
Supervisor MIS Phone: 301.424.3300 x3324
EU Services, Inc. FAX:301.424.3696
649 North Horners Lane E-Mail: [EMAIL PROTECTED]
Rockville, MD 20850-1299WWW:http://www.euservices.com
__
> -Original Message-
> From: Mauricio Giraldo [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 27, 2003 5:44 AM
> To: CF-Talk
> Subject: whitespace is breaking my javascript
>
>
> hello
>
> thanks for all the input on different issues i have presented
> in this list.
> this is really THE place for CF stuff.
>
> right now i am having a really particular issue with
> coldfusions whitespace.
> i will try and explain as much as i can:
>
> 1- i have a few CFCs (calling each other, extending each other)
> 2- one CFC function is a wrapper to another (a shorthand
> version) and their
> object is returning texts for dialog boxes and javascripts
> 3- more or less the cf:
>
>
>
>
>
>
>
>
>
>
>
> // return message
> return this.lang_data[_block][arguments.message];
>
>
>
> theres more CFML (especially in showMessage) but just so you
> get an idea.
>
> i am outputting texts using something like:
> #obj.m("special_string")# where
> "special_string" is
> some string i use in showMessage to detect stuff (it is a
> multi-language app
> with a lot of parametrization)
>
> the problem:
>
> i am getting A LOT of whitespace. whenever i use those (and
> other) functions
> it breaks all javascript (that is also dynamically created
> with CF and those
> functions). tried using CFSETTING but i simply cannot put that many
> cfoutputs all over the place (tried also combining m and
> showMessage in
> one). one way i "solved" it was using obj.m("special_string")> someplace before the javascript and
> then just
> outputting #myvar# in the javascript. the problem is i have A
> LOT of CFC
> invocations (a single page can have 60+ and i have a few
> dozen pages) and it
> just would not make sense. i am looking for a way to
> minimize/eliminate
> whitespace generated when invoking functions.
>
> i really need this to work (will share the app as soon as i have it
> finished... its actually finished but the javascript is breaking...
> whitespace solved EQ app finished)
>
> i will appreciate any help on this issue
>
> thanks a lot
>
> - mga
>
> _
> Help protect your PC: Get a free online virus scan at McAfee.com.
> http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
>
>
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
http://www.cfhosting.com
RE: SQL aggregate question
Your welcome, I saw Jochem's solution after I sent mine. I had sorted my messages by subject and his answer was in a different location than your message so I didn't realize he had answered it. No harm done. ______ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Dan O'Keefe [mailto:[EMAIL PROTECTED] > Sent: Monday, August 25, 2003 9:00 AM > To: CF-Talk > Subject: RE: SQL aggregate question > > > >Try this: > > >select count(ptssn) as numid, sum(sumar) as totalar > >from (select ptssn, sum(arbalancedue) as sumar > > from ga_temp > > group by ptssn > > having sum(arbalancedue) < 50 > > ) arsum > __ > > >Bill Grover > > Thanks, that was basically the solution Jochem recommended > and it worked. > > Dan > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Return Subquery as text string? MSSQL
It might have help to show how to use it. Assuming you named your function f_OrderList: select UserID, Name, dbo.f_OrderList(UserID) as Orders From Users __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Bill Grover > Sent: Monday, August 25, 2003 8:36 AM > To: CF-Talk > Subject: RE: Return Subquery as text string? MSSQL > > > With MSSQL 2000 you can create UDF's. Your UDF would be the > following, this is the only way I can think of to solve your issue. > > CREATE FUNCTION > (@tnUserid int) > RETURNS varchar(4000) > AS > BEGIN > declare @Worklist varchar(4000) > set @Worklist = '' > > select @Worklist = @Worklist >+ case > when len(@Worklist) > 0 then ',' > else '' > end >+ cast(orderNo as varchar) > from orders > where orderid = @tnUserID > > RETURN @Worklist > END > GO > > __ > > Bill Grover > Supervisor MIS Phone: 301.424.3300 x3324 > EU Services, Inc. FAX:301.424.3696 > 649 North Horners Lane E-Mail: [EMAIL PROTECTED] > Rockville, MD 20850-1299WWW:http://www.euservices.com > __ > > > > > -Original Message- > > From: Mark W. Breneman [mailto:[EMAIL PROTECTED] > > Sent: Friday, August 22, 2003 5:30 PM > > To: CF-Talk > > Subject: RE: Return Subquery as text string? MSSQL > > > > > > From the little research I have done, I have not been able > to confirm > > that MSSQL has UDF for aggregates. > > > > Can anyone confirm this? > > > > Seems that is a some what common task, to generate a list of > > items for a > > report. Maybe not. > > > > Thanks > > MB > > > > -Original Message- > > From: Jochem van Dieten [mailto:[EMAIL PROTECTED] > > Sent: Friday, August 22, 2003 4:12 PM > > To: CF-Talk > > Subject: Re: Return Subquery as text string? MSSQL > > > > Mark W. Breneman wrote: > > > > > Is there any way to do this in MSSQL? Normally you can not return > > more > > > then one value with type of subquery. > > > > > > Here is what I would like to do: > > > Select UserID, Name, (select orderNo from orders where > > OrderID=UserID) > > > as Orders > > > From Users > > > > > > Result: > > > > > > "1", "BOB", "12,63,192" > > > "2", "Ed", "34,45,233" > > > > We should put this in a FAQ, it pops up every other week :-) > > > > You can do this in every DBMS that allows you to create your own > > functions for aggregates. For a PostgreSQL based example, see > > http://www.zope.org/Members/pupq/pg_in_aggregates > > > > Jochem > > > > > > > > > > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Return Subquery as text string? MSSQL
With MSSQL 2000 you can create UDF's. Your UDF would be the following, this is the only way I can think of to solve your issue. CREATE FUNCTION (@tnUserid int) RETURNS varchar(4000) AS BEGIN declare @Worklist varchar(4000) set @Worklist = '' select @Worklist = @Worklist + case when len(@Worklist) > 0 then ',' else '' end + cast(orderNo as varchar) from orders where orderid = @tnUserID RETURN @Worklist END GO ______ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Mark W. Breneman [mailto:[EMAIL PROTECTED] > Sent: Friday, August 22, 2003 5:30 PM > To: CF-Talk > Subject: RE: Return Subquery as text string? MSSQL > > > From the little research I have done, I have not been able to confirm > that MSSQL has UDF for aggregates. > > Can anyone confirm this? > > Seems that is a some what common task, to generate a list of > items for a > report. Maybe not. > > Thanks > MB > > -Original Message- > From: Jochem van Dieten [mailto:[EMAIL PROTECTED] > Sent: Friday, August 22, 2003 4:12 PM > To: CF-Talk > Subject: Re: Return Subquery as text string? MSSQL > > Mark W. Breneman wrote: > > > Is there any way to do this in MSSQL? Normally you can not return > more > > then one value with type of subquery. > > > > Here is what I would like to do: > > Select UserID, Name, (select orderNo from orders where > OrderID=UserID) > > as Orders > > From Users > > > > Result: > > > > "1", "BOB", "12,63,192" > > "2", "Ed", "34,45,233" > > We should put this in a FAQ, it pops up every other week :-) > > You can do this in every DBMS that allows you to create your own > functions for aggregates. For a PostgreSQL based example, see > http://www.zope.org/Members/pupq/pg_in_aggregates > > Jochem > > > > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: SQL aggregate question
Try this: select count(ptssn) as numid, sum(sumar) as totalar from (select ptssn, sum(arbalancedue) as sumar from ga_temp group by ptssn having sum(arbalancedue) < 50 ) arsum __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Dan O'Keefe [mailto:[EMAIL PROTECTED] > Sent: Sunday, August 24, 2003 2:21 PM > To: CF-Talk > Subject: RE: SQL aggregate question > > > That was my original attempt, but results in the following error: > An aggregate may not appear in the WHERE clause unless it is in a > subquery contained in a HAVING clause or a select list, and the column > being aggregated is an outer reference. > > Dan > === Previous Message Below === > > > -Original Message- > From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] > Sent: Sunday, August 24, 2003 10:00 AM > To: CF-Talk > Subject: RE: SQL aggregate question > > > Try a "where" caluse instead of a having... > > SELECT > ptssn, > sum(arbalancedue) as sumar > FROM > ga_temp > WHERE > sum(arbalancedue) < 50 > GROUP BY > by ptssn > > Mike > > > > -Original Message- > From: Dan O'Keefe [mailto:[EMAIL PROTECTED] > Sent: Sunday, August 24, 2003 9:50 AM > To: CF-Talk > Subject: OT: SQL aggregate question > > > Is what I am trying to do possible, and if it is, what am I > doing wrong? > > This query: > --- > select ptssn, sum(arbalancedue) as sumar > from ga_temp > group by ptssn > having sum(arbalancedue) < 50 > > Yields these results: > - > Ptssn sumAr > 237451046 26.4800 > 255785250 25.2000 > 267582694 42.3200 > 294629611 42.3200 > > But what I really want is 1 query to return to me a count of 4 with a > total of 136.32 > > This query returns no results: > -- > select count(distinct ptssn), sum(arbalancedue) as sumar > from ga_temp > having sum(arbalancedue) < 50 > > Thanks, > > Dan > > > Dan O'Keefe > 954-501-3115 > > > > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Updating MDAC
I know what you are saying, it's happened here before! Something in the back of my mind tells me that Microsoft started shipping the Jet drivers as part of the OS. I can't remember where I heard/saw that but it's a fuzzy memory in the back of my mind. ______ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Jim McAtee [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 20, 2003 8:16 PM > To: CF-Talk > Subject: Updating MDAC > > > We're runninng MDAC 2.5 SP3 on our CF5/IIS5 (Win2k) servers. > I was just > looking into updating this to the latest 2.7 SP1 version of > MDAC. These > servers are primarily using Access and MySQL through ODBC. > > The following was found on Microsoft's download page for MDAC > 2.7 SP1 download > page: > > --- > Starting with Microsoft Data Access Components (MDAC) version > 2.6, MDAC no > longer contains Jet components. In other words, MDAC versions > 2.6 and later do > not include Microsoft Jet, Microsoft Jet OLE DB Provider, and > the ODBC Desktop > Database Drivers. > --- > > So, does this mean that updates 2.6 and later have no Access > component, > therefore there's no real reason to update MDAC? I've been > burned before by > updating MDAC and losing support for older databases with no > way to undo the > installation, so want to be very careful. > > Thanks, > Jim > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: SQL Question...
I don't believe there is a direct conversion available for your field. If you are using SQL 2000 you can write a function that will take your field, split it at the '/' and then do the math returning the numeric result. You can then use that in your select statement. ______ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Che Vilnonis [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 13, 2003 1:17 PM > To: CF-Talk > Subject: SQL Question... > > > In my db I've got a varchar column called 'width'. > It has values like 3/4" or 5/8", etc. > > I'd like to write a where clause in a SQL query that does > something like this: > > WHERE 0=0 > AND (WIDTH BETWEEN #FORM.Width1# AND #FORM.Width2#) > [i.e. -- (AND (0.75 BETWEEN 0.5 AND 1))] > > What do I need to do to make this work? Covert? Cast? > > Che Vilnonis > Application Developer > Advertising Systems Incorporated > 8470C Remington Avenue > Pennsauken, NJ 08110 > p: 856.488.2211 > f: 856.488.1990 > www.asitv.com > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: SQL: Brain Teaser
I like your solution Tony. We had an occurrence yesterday where that would have been handy and I didn't think of it. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Tony Schreiber [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 06, 2003 9:49 AM > To: CF-Talk > Subject: RE: SQL: Brain Teaser > > > Ah. But by "loop through results and fetch comments" I > thought you meant > something like query then loop and do a query for each user... > > What I wrote would be perfectly acceptable for me though. ;) > > > That would do it but not from sql. I know really don't > like having to use > > cfoutput to group I wish they would add group to cfloop at > least then it > > would be a little easier. > > > > Tyler Clendenin > > GSL Solutions > > > > -Original Message- > > From: Tony Schreiber [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, August 06, 2003 7:46 AM > > To: CF-Talk > > Subject: RE: SQL: Brain Teaser > > > > > > USERS TABLE > > > > - > > > > USER_ID > > > > USERNAME > > > > etc... > > > > > > > > COMMENTS TABLE > > > > - > > > > COMMENT_ID > > > > USER_ID > > > > COMMENT > > > > etc... > > > > > > > > I know I can query USERS and then loop through the > results fetching > > > > the comments... but I'd rather not do that. Here's the > results I'm > > > > trying to get... in a SINGLE query if possible: > > > > > > > > USER_ID,USERNAME,MERGED_COMMENTS > > > > 1,joe,comment1comment2comment3 > > > > 2,sam,comment > > > > 3,sue,commentanother commentetc. > > > > > > SELECT username, comment > > FROM users u, comments c > > WHERE u.user_id = c.userid > > ORDER BY username > > > > > > > > #username#,#comment# > > > > > > Wouldn't that do it? > > > > Tony Schreiber, Senior Partner > > Man and Machine, Limited > > mailto:[EMAIL PROTECTED] http://www.technocraft.com > > http://www.is300.net The Enthusiast's Home of the Lexus IS300 since 1999 > * PARTS STORE NOW OPEN * http://www.is300.net/store/ > http://www.simplemessageboard.comFree Forum Software for Cold Fusion > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Brain Teaser2
I forgot to add you can even expand it to include different servers. You need to create a linked server but once you do you can access it remotely. So the expanded version would be: SELECT * FROM server.database1.dbo.anytable dt1 INNER JOIN server.database2.dbo.anytable dt2 ON dt1.record_id = dt2.record_id __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Bill Grover > Sent: Wednesday, August 06, 2003 1:54 PM > To: CF-Talk > Subject: RE: Brain Teaser2 > > > That's pretty much how you do it in MS SQL (SQL7, SQL2000). > The difference is that you use the database name, which may > or may not be the same as your datasource name. So your > example is more like: > > SELECT * > FROM database1.dbo.anytable dt1 INNER JOIN > database2.dbo.anytable dt2 ON dt1.record_id = dt2.record_id > > ______ > > Bill Grover > Supervisor MIS Phone: 301.424.3300 x3324 > EU Services, Inc. FAX:301.424.3696 > 649 North Horners Lane E-Mail: [EMAIL PROTECTED] > Rockville, MD 20850-1299WWW:http://www.euservices.com > __ > > > > > -Original Message- > > From: Sarsoun, Jeff [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, August 06, 2003 1:44 PM > > To: CF-Talk > > Subject: RE: Brain Teaser2 > > > > > > I believe you can reference the table using the database as well. > > > > For example: > > > > SELECT * > > FROM datasource1.dbo.anytable dt1 INNER JOIN > > datasource2.dbo.anytable dt2 ON dt1.record_id = dt2.record_id > > > > This may be ODBC specific though. > > > > Jeff > > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, August 06, 2003 1:26 PM > > To: CF-Talk > > Subject: SQL: Brain Teaser2 > > > > > > I have a central login system The user/login information is > > stored in a > > datasource called "CENTRAL_LOGIN". > > > > I then have multiple "stand alone" applications which have their own > > datasources... for example: > > DATASOURCE1 > > DATASOURCE2 > > DATASOURCE3 > > Etc... > > > > The central login system works fine. But one of the problems I'm > > experiencing is that sometimes I'd like to do an SQL join on > > tables which > > exist in multiple datasources. For example, Let's say that > > "DATASOURCE3" > > contains a table which stores the USER_ID of the person who > > added a the > > record to that table. > > > > CENTRAL_LOGIN -- TABLE1 > > --- > > USER_ID,USERNAME,PASSWORD > > 1,john,apple > > 2,sam,orange > > 3,betty,password837! > > > > > > DATASOURCE3 -- TABLE1 > > --- > > USER_ID,COMMENT > > 1,This is a test. > > 3,This is another test. > > 2,This is a test again. > > Etc... > > > > I want my output to look as follows: > > USERNAME,COMMENT > > john,This is a test. > > betty,This is another test. > > sam,This is a test again. > > > > This would be simple if all tables were in the datasource. I > > could just do > > a regular join and get the username. But in this case... the > > tables are in > > two different datasources. I'm using SQL 2000. > > > > Merging all of the datasources together really isn't an > > option. It makes me > > wonder how central login systems are SUPPOSED to be designed. > > How does > > Microsoft Passport work for example? Is there a way to do a > > join across > > multiple datasources in SQL 2000? > > > > -Novak > > > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL: Brain Teaser
What there are others!!! :-)) __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Robertson-Ravo, Neil (RX) > [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 06, 2003 9:08 AM > To: CF-Talk > Subject: RE: SQL: Brain Teaser > > > great for DBs which support t-sql stored procedures :-) > > -----Original Message- > From: Bill Grover [mailto:[EMAIL PROTECTED] > Sent: 06 August 2003 14:05 > To: CF-Talk > Subject: RE: SQL: Brain Teaser > > > If you wanted to do it all in SQL you can try the following. > I would write > it as a stored procedure and call that but you might be able > to do it in a > cfquery. The trick is that if you select into a variable and > the select > statement will have multiple rows the variable assignment > happens for each > row so you can effectively append to the variable. > > declare @lnUserid int, > @lcUserName varchar(50), > @lcComments varchar(8000), > @lrFinalComments table (userid int, > username varchar(50), > comments varchar(8000)) > > declare UserList cursor fast_forward > for select userid, username > from users > > open UserList > > fetch next from UserList into @lnUserid, @lcUserName > > while @@fetch_status = 0 > begin > set @lcComments = '' > select @lcComments = @lcComments + comment + '' > from comments > where userid = @lnUserid > insert into @lrFinalComments > values (@lnUserid, > @lcUserName, > left(@lcComments, len(@lcComments) - 4)) > fetch next from UserList into @lnUserid, @lcUserName > end > > select * from @lrFinalComments > > __ > > Bill Grover > Supervisor MIS Phone: 301.424.3300 x3324 > EU Services, Inc. FAX:301.424.3696 > 649 North Horners Lane E-Mail: [EMAIL PROTECTED] > Rockville, MD 20850-1299WWW:http://www.euservices.com > __ > > > > > -Original Message- > > From: Tyler Clendenin [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, August 06, 2003 8:58 AM > > To: CF-Talk > > Subject: RE: SQL: Brain Teaser > > > > > > That would do it but not from sql. I know really don't like > > having to use > > cfoutput to group I wish they would add group to cfloop at > > least then it > > would be a little easier. > > > > Tyler Clendenin > > GSL Solutions > > > > -Original Message- > > From: Tony Schreiber [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, August 06, 2003 7:46 AM > > To: CF-Talk > > Subject: RE: SQL: Brain Teaser > > > > > > USERS TABLE > > > > - > > > > USER_ID > > > > USERNAME > > > > etc... > > > > > > > > COMMENTS TABLE > > > > - > > > > COMMENT_ID > > > > USER_ID > > > > COMMENT > > > > etc... > > > > > > > > I know I can query USERS and then loop through the > > results fetching > > > > the comments... but I'd rather not do that. Here's the > > results I'm > > > > trying to get... in a SINGLE query if possible: > > > > > > > > USER_ID,USERNAME,MERGED_COMMENTS > > > > 1,joe,comment1comment2comment3 > > > > 2,sam,comment > > > > 3,sue,commentanother commentetc. > > > > > > SELECT username, comment > > FROM users u, comments c > > WHERE u.user_id = c.userid > > ORDER BY username > > > > > > > > #username#,#comment# > > > > > > Wouldn't that do it? > > > > Tony Schreiber, Senior Partner > > Man and Machine, Limited > > mailto:[EMAIL PROTECTED] > http://www.technocraft.com > > http://www.is300.net The Enthusiast's Home of the Lexus IS300 > since 1999 > * PARTS STORE NOW OPEN * http://www.is300.net/store/ > http://www.simplemessageboard.comFree Forum Software for > Cold Fusion > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Brain Teaser2
That's pretty much how you do it in MS SQL (SQL7, SQL2000). The difference is that you use the database name, which may or may not be the same as your datasource name. So your example is more like: SELECT * FROM database1.dbo.anytable dt1 INNER JOIN database2.dbo.anytable dt2 ON dt1.record_id = dt2.record_id __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Sarsoun, Jeff [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 06, 2003 1:44 PM > To: CF-Talk > Subject: RE: Brain Teaser2 > > > I believe you can reference the table using the database as well. > > For example: > > SELECT * > FROM datasource1.dbo.anytable dt1 INNER JOIN > datasource2.dbo.anytable dt2 ON dt1.record_id = dt2.record_id > > This may be ODBC specific though. > > Jeff > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 06, 2003 1:26 PM > To: CF-Talk > Subject: SQL: Brain Teaser2 > > > I have a central login system The user/login information is > stored in a > datasource called "CENTRAL_LOGIN". > > I then have multiple "stand alone" applications which have their own > datasources... for example: > DATASOURCE1 > DATASOURCE2 > DATASOURCE3 > Etc... > > The central login system works fine. But one of the problems I'm > experiencing is that sometimes I'd like to do an SQL join on > tables which > exist in multiple datasources. For example, Let's say that > "DATASOURCE3" > contains a table which stores the USER_ID of the person who > added a the > record to that table. > > CENTRAL_LOGIN -- TABLE1 > --- > USER_ID,USERNAME,PASSWORD > 1,john,apple > 2,sam,orange > 3,betty,password837! > > > DATASOURCE3 -- TABLE1 > --- > USER_ID,COMMENT > 1,This is a test. > 3,This is another test. > 2,This is a test again. > Etc... > > I want my output to look as follows: > USERNAME,COMMENT > john,This is a test. > betty,This is another test. > sam,This is a test again. > > This would be simple if all tables were in the datasource. I > could just do > a regular join and get the username. But in this case... the > tables are in > two different datasources. I'm using SQL 2000. > > Merging all of the datasources together really isn't an > option. It makes me > wonder how central login systems are SUPPOSED to be designed. > How does > Microsoft Passport work for example? Is there a way to do a > join across > multiple datasources in SQL 2000? > > -Novak > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Brain Teaser2
In fact, as long as the user you use in the cfquery tag has access to the databases none of the databases referenced in the select statement have to match the database in the cfquery tag. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Dan O'Keefe [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 06, 2003 2:29 PM > To: CF-Talk > Subject: RE: Brain Teaser2 > > > I have used the database but did not know you can use the > server also. I > have found that the database attribute specified in the > cfquery tag can be > either of the databases and it works fine since it is > specified in the sql > string. > > Dan > > -Original Message- > From: Bill Grover [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 06, 2003 2:05 PM > To: CF-Talk > Subject: RE: Brain Teaser2 > > > I forgot to add you can even expand it to include different > servers. You > need to create a linked server but once you do you can access > it remotely. > So the expanded version would be: > > SELECT * > FROM server.database1.dbo.anytable dt1 INNER JOIN > server.database2.dbo.anytable dt2 ON dt1.record_id = > dt2.record_id > __ > > Bill Grover > Supervisor MIS Phone: 301.424.3300 x3324 > EU Services, Inc. FAX:301.424.3696 > 649 North Horners Lane E-Mail: [EMAIL PROTECTED] > Rockville, MD 20850-1299WWW:http://www.euservices.com > __ > > > > > -Original Message- > > From: Bill Grover > > Sent: Wednesday, August 06, 2003 1:54 PM > > To: CF-Talk > > Subject: RE: Brain Teaser2 > > > > > > That's pretty much how you do it in MS SQL (SQL7, SQL2000). > > The difference is that you use the database name, which may > > or may not be the same as your datasource name. So your > > example is more like: > > > > SELECT * > > FROM database1.dbo.anytable dt1 INNER JOIN > > database2.dbo.anytable dt2 ON dt1.record_id = dt2.record_id > > > > __ > > > > Bill Grover > > Supervisor MIS Phone: 301.424.3300 x3324 > > EU Services, Inc. FAX:301.424.3696 > > 649 North Horners Lane E-Mail: [EMAIL PROTECTED] > > Rockville, MD 20850-1299WWW:http://www.euservices.com > > __ > > > > > > > > > -Original Message- > > > From: Sarsoun, Jeff [mailto:[EMAIL PROTECTED] > > > Sent: Wednesday, August 06, 2003 1:44 PM > > > To: CF-Talk > > > Subject: RE: Brain Teaser2 > > > > > > > > > I believe you can reference the table using the database as well. > > > > > > For example: > > > > > > SELECT * > > > FROM datasource1.dbo.anytable dt1 INNER JOIN > > > datasource2.dbo.anytable dt2 ON dt1.record_id = dt2.record_id > > > > > > This may be ODBC specific though. > > > > > > Jeff > > > > > > -Original Message- > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > > Sent: Wednesday, August 06, 2003 1:26 PM > > > To: CF-Talk > > > Subject: SQL: Brain Teaser2 > > > > > > > > > I have a central login system The user/login information is > > > stored in a > > > datasource called "CENTRAL_LOGIN". > > > > > > I then have multiple "stand alone" applications which > have their own > > > datasources... for example: > > > DATASOURCE1 > > > DATASOURCE2 > > > DATASOURCE3 > > > Etc... > > > > > > The central login system works fine. But one of the problems I'm > > > experiencing is that sometimes I'd like to do an SQL join on > > > tables which > > > exist in multiple datasources. For example, Let's say that > > > "DATASOURCE3" > > > contains a table which stores the USER_ID of the person who > > > added a the > > > record to that table. > > > > > > CENTRAL_LOGIN -- TABLE1 &
RE: SQL: Brain Teaser
If you wanted to do it all in SQL you can try the following. I would write it as a stored procedure and call that but you might be able to do it in a cfquery. The trick is that if you select into a variable and the select statement will have multiple rows the variable assignment happens for each row so you can effectively append to the variable. declare @lnUserid int, @lcUserName varchar(50), @lcComments varchar(8000), @lrFinalComments table (userid int, username varchar(50), comments varchar(8000)) declare UserList cursor fast_forward for select userid, username from users open UserList fetch next from UserList into @lnUserid, @lcUserName while @@fetch_status = 0 begin set @lcComments = '' select @lcComments = @lcComments + comment + '' from comments where userid = @lnUserid insert into @lrFinalComments values (@lnUserid, @lcUserName, left(@lcComments, len(@lcComments) - 4)) fetch next from UserList into @lnUserid, @lcUserName end select * from @lrFinalComments ______ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Tyler Clendenin [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 06, 2003 8:58 AM > To: CF-Talk > Subject: RE: SQL: Brain Teaser > > > That would do it but not from sql. I know really don't like > having to use > cfoutput to group I wish they would add group to cfloop at > least then it > would be a little easier. > > Tyler Clendenin > GSL Solutions > > -Original Message- > From: Tony Schreiber [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 06, 2003 7:46 AM > To: CF-Talk > Subject: RE: SQL: Brain Teaser > > > > USERS TABLE > > > - > > > USER_ID > > > USERNAME > > > etc... > > > > > > COMMENTS TABLE > > > - > > > COMMENT_ID > > > USER_ID > > > COMMENT > > > etc... > > > > > > I know I can query USERS and then loop through the > results fetching > > > the comments... but I'd rather not do that. Here's the > results I'm > > > trying to get... in a SINGLE query if possible: > > > > > > USER_ID,USERNAME,MERGED_COMMENTS > > > 1,joe,comment1comment2comment3 > > > 2,sam,comment > > > 3,sue,commentanother commentetc. > > > SELECT username, comment > FROM users u, comments c > WHERE u.user_id = c.userid > ORDER BY username > > > > #username#,#comment# > > > Wouldn't that do it? > > Tony Schreiber, Senior Partner > Man and Machine, Limited > mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.is300.net The Enthusiast's Home of the Lexus IS300 since 1999 * PARTS STORE NOW OPEN * http://www.is300.net/store/ http://www.simplemessageboard.comFree Forum Software for Cold Fusion ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: T-SQL division drops the decimal?
Joshua, I bump into this all the time. You said it is a numeric field but what is the definition of your numeric field. If it is something like numeric(5,0) then there are no decimal places for it to work with. Like Mark said, to get the fraction part just do it as 2.0 and T-SQL will to an implicit type conversion of all the numbers and return the fraction part. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Joshua Miller [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 31, 2003 11:53 AM > To: CF-Talk > Subject: RE: T-SQL division drops the decimal? > > > The division operator returns an INT according to the T-SQL reference. > It also says that the division operator drops the remainder. The data > comes from a NUMERIC field and I'm storing the value into a > VARCHAR(10) > field so that's not the problem, it just drops the remainder > by default. > > I tried one using: newcolumn = '' +mycolumn/2+ '.' +mycolumn%2+ '' > > This gave me an error that VARCHAR data "." cannot be > converted to INT, > however the field that it's being inserted into is a > VARCHAR(10) field. > > I'll try some of the CAST() CONVERT() options, thanks. > > Joshua Miller > Head Programmer / IT Manager > Garrison Enterprises Inc. > www.garrisonenterprises.net > [EMAIL PROTECTED] > (704) 569-0801 ext. 254 > > ** > ** > * > Any views expressed in this message are those of the > individual sender, > except where the sender states them to be the views of > Garrison Enterprises Inc. > > This e-mail is intended only for the individual or entity to > which it is > addressed and contains information that is private and > confidential. If > you are not the intended recipient you are hereby notified that any > dissemination, distribution or copying is strictly prohibited. If you > have received this e-mail in error please delete it immediately and > advise us by return e-mail to > [EMAIL PROTECTED] > ** > ** > * > > > -Original Message- > From: Craig Dudley [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 31, 2003 11:21 AM > To: CF-Talk > Subject: RE: T-SQL division drops the decimal? > > > Silly question, but what datatype is the column which holds > your result? > Not forgotten about it and left it as an int have you? > > Even if not, I'd play with the datatypes a bit, it may be your issue. > > -Original Message- > From: Joshua Miller [mailto:[EMAIL PROTECTED] > Sent: 31 July 2003 16:15 > To: CF-Talk > Subject: T-SQL division drops the decimal? > > > How do others on the list deal with this? > > I have a query that takes a value from the database and > divides by 2 and > inserts that value into another table, however SQL Server > (T-SQL) drops > the decimal place, so 1/2 of 1 is 0 according to T-SQL. > > Any idea how to overcome this? That seems really odd if > I WANTED to > round I could use FLOOR() or CEILING() to round, why make it > the default > in T-SQL > > Thanks, > > Joshua Miller > Head Programmer / IT Manager > Garrison Enterprises Inc. > www.garrisonenterprises.net <http://www.garrisonenterprises.net/> > [EMAIL PROTECTED] > (704) 569-0801 ext. 254 > > ** > ** > * > Any views expressed in this message are those of the > individual sender, > except where the sender states them to be the views of > Garrison Enterprises Inc. > > This e-mail is intended only for the individual or entity to > which it is > addressed and contains information that is private and > confidential. If > you are not the intended recipient you are hereby notified that any > dissemination, distribution or copying is strictly prohibited. If you > have received this e-mail in error please delete it immediately and > advise us by return e-mail to > <mailto:[EMAIL PROTECTED]> > [EMAIL PROTECTED] > ** > ** > * > > > > >
RE: Virtual directories and UNC paths not working on CFMX?
You might also want to confirm that the CFMX service is still running under your user account. If memory serves me correct I believe ours was reset to the "system account" setting after the upgrade and we had to reset it back to our domain user. Once we did that all UNC and network drive access worked fine. ______ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Dave Watts [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 17, 2003 3:13 PM > To: CF-Talk > Subject: RE: Virtual directories and UNC paths not working on CFMX? > > > > MX is running under a user acct w/access to the UNC dir. > > Nothing has changed except a simple upgrade to CFMX. > > You might want to test this by logging in as this user from the server > console. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > voice: (202) 797-5496 > fax: (202) 797-5444 > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Includes inside a CFOUTPUT problem...
Yeah, I've had the same experience. I've ended up getting in the habit of putting a block in almost all my files that I . I skip the ones I know are not doing any output (db processing ect). ______ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Les Mizzell [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 15, 2003 1:02 PM > To: CF-Talk > Subject: RE: Includes inside a CFOUTPUT problem... > > > Yep, that's what I was getting ready to do > > Bummer, huh? > > :: -Original Message- > :: From: Ben Doom [mailto:[EMAIL PROTECTED] > :: Sent: Tuesday, July 15, 2003 12:56 PM > :: To: CF-Talk > :: Subject: RE: Includes inside a CFOUTPUT problem... > :: > :: > :: I'd just replace the includes with their contents. Not as > :: elegant, I guess, > :: but sometimes you just do what works. > :: > :: > :: -- Ben Doom > :: Programmer & General Lackey > :: Moonbow Software, Inc > :: > :: : -Original Message- > :: : From: Les Mizzell [mailto:[EMAIL PROTECTED] > :: : Sent: Tuesday, July 15, 2003 11:59 AM > :: : To: CF-Talk > :: : Subject: RE: Includes inside a CFOUTPUT problem... > :: : > :: : > :: : :: I don;t think the is inherited by the > :: : :: templates from > :: : :: the calling template, so you'll need to put in > :: each of the > :: : :: include templates where you want to output a variable. > :: : > :: : This will take some head scratching to get to work. Each include > :: : is a single > :: : "td". Basically, I'm building a table in my switch > statement. So, it's > :: : still got to loop through all the records and properly > build the table. > :: : Different results will result in a completely different table. > :: : > :: : Jezz, I may have painted myself into a corner at this point if > :: there's no > :: : good way to get it to work. > :: : > :: : Ideas??? > :: : > :: : > :: : > :: : > :: : :: -Original Message- > :: : :: From: A.Little [mailto:[EMAIL PROTECTED] > :: : :: Sent: Tuesday, July 15, 2003 11:49 AM > :: : :: To: CF-Talk > :: : :: Subject: RE: Includes inside a CFOUTPUT problem... > :: : :: > :: : :: > :: : > :: : :: > :: : :: Don't ask me why it works like this - I have no idea ;-) > :: : :: > :: : :: Alex > :: : :: > :: : :: > :: : :: > -Original Message- > :: : :: > From: Les Mizzell [mailto:[EMAIL PROTECTED] > :: : :: > Sent: 15 July 2003 16:38 > :: : :: > To: CF-Talk > :: : :: > Subject: RE: Includes inside a CFOUTPUT problem... > :: : :: > > :: : :: > > :: : :: > :: What about > :: : :: > :: #prods.some_variable# > :: : :: > :: in the includes ? > :: : :: > :: That's better syntax anyway... > :: : :: > > :: : :: > > :: : :: > Nope, still doesn't do it > :: : :: > > :: : :: > H. > :: : :: > > :: : :: > > :: : :: > Re: > :: : :: > > :: : :: > > :: : :: > > :: : :: > > :: : :: > > :: : :: > > :: : :: > > :: : :: > > :: : :: > > :: : :: > > :: : :: > > :: : :: > > :: : :: > > :: : :: > > :: : :: > > :: : :: > > :: : :: > > :: : :: > :: : > :: > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Unusual SQL error
Maybe but not necessarily. It is possible that SQL thinks the most efficient way to retrieve the data is to process the 2nd part of the where before the 1st part. If you have data in your fields that are not dates then your select will fail because of this data. MAXDOP goes beyond just the where clauses. If you are joining tables together SQL will actually do selects on each individual table simultaneously then link the results together before doing the final filtering. The MAXDOP setting controls how many of these selects will take place simultaneously. I hope that answered your question. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] > Sent: Monday, July 07, 2003 10:47 AM > To: CF-Talk > Subject: RE: Unusual SQL error > > > Bill, > > This just got me thinking about a problem I had a while back. > > I had a sql7 query like this: > > select * > from myTable > where isDate(myDateField) = 1 > and month(myDateField) > 2 > > Everything worked fine until I moved to SQL 2000. Then it > would return an > error because myDateField could not be converted to datetime. > > The myDateField column can have a date, "NR", "INC". (Not my > choice, doing > this was dictated to us by another group in our company). > The explanation I > got from another DBA said that SQL server 7 processed each > item of the where > sequentially, but SQL 2000 processes all of the where items > at the same > time. > > If that is true, do you think that setting the maxdop 1 would > prevent the > error? > > No rush for an answer, we already changed all of our code, > this is more just > for my own piece of mind. > > Steve > > > -Original Message- > From: Bill Grover [mailto:[EMAIL PROTECTED] > Sent: Monday, July 07, 2003 10:36 AM > To: CF-Talk > Subject: RE: Unusual SQL error > > > That should fix it. > > __ > > Bill Grover > Supervisor MIS Phone: 301.424.3300 x3324 > EU Services, Inc. FAX:301.424.3696 > 649 North Horners Lane E-Mail: [EMAIL PROTECTED] > Rockville, MD 20850-1299WWW:http://www.euservices.com > __ > > > > > -Original Message- > > From: Eric Creese [mailto:[EMAIL PROTECTED] > > Sent: Monday, July 07, 2003 10:34 AM > > To: CF-Talk > > Subject: RE: Unusual SQL error > > > > > > Thanks, > > > > I added the option (maxdop 1) to the end of the query to set > > the max degree of parallism to 1 > > > > -Original Message- > > From: Bill Grover [mailto:[EMAIL PROTECTED] > > Sent: Monday, July 07, 2003 9:30 AM > > To: CF-Talk > > Subject: RE: Unusual SQL error > > > > > > Sounds to me like when SQL created it's execution plan it is > > running several parts of the query simultaneously. For some > > reason when this happens it causes a conflict within your > > query. What SQL is asking you to do is give it a hint about > > how to process the query to avoid this problem. > > > > __ > > > > Bill Grover > > Supervisor MIS Phone: 301.424.3300 x3324 > > EU Services, Inc. FAX:301.424.3696 > > 649 North Horners Lane E-Mail: [EMAIL PROTECTED] > > Rockville, MD 20850-1299WWW:http://www.euservices.com > > __ > > > > > > > > > -Original Message- > > > From: Creese, Eric [mailto:[EMAIL PROTECTED] > > > Sent: Friday, July 04, 2003 1:17 PM > > > To: CF-Talk > > > Subject: Unusual SQL error > > > > > > > > > I never have received this error before. > > > > > > [Macromedia][SQLServer JDBC Driver][SQLServer]Intra-query > > > parallelism caused > > > your server command (process ID #52) to deadlock. Rerun the > > > query without > > > intra-query parallelism by using th
RE: Unusual SQL error
That should fix it. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Eric Creese [mailto:[EMAIL PROTECTED] > Sent: Monday, July 07, 2003 10:34 AM > To: CF-Talk > Subject: RE: Unusual SQL error > > > Thanks, > > I added the option (maxdop 1) to the end of the query to set > the max degree of parallism to 1 > > -Original Message- > From: Bill Grover [mailto:[EMAIL PROTECTED] > Sent: Monday, July 07, 2003 9:30 AM > To: CF-Talk > Subject: RE: Unusual SQL error > > > Sounds to me like when SQL created it's execution plan it is > running several parts of the query simultaneously. For some > reason when this happens it causes a conflict within your > query. What SQL is asking you to do is give it a hint about > how to process the query to avoid this problem. > > __ > > Bill Grover > Supervisor MIS Phone: 301.424.3300 x3324 > EU Services, Inc. FAX:301.424.3696 > 649 North Horners Lane E-Mail: [EMAIL PROTECTED] > Rockville, MD 20850-1299WWW:http://www.euservices.com > __ > > > > > -Original Message- > > From: Creese, Eric [mailto:[EMAIL PROTECTED] > > Sent: Friday, July 04, 2003 1:17 PM > > To: CF-Talk > > Subject: Unusual SQL error > > > > > > I never have received this error before. > > > > [Macromedia][SQLServer JDBC Driver][SQLServer]Intra-query > > parallelism caused > > your server command (process ID #52) to deadlock. Rerun the > > query without > > intra-query parallelism by using the query hint option (maxdop 1). > > Can anyone give some insite? > > > > > > -- > > > > This e-mail is intended for the use of the addressee(s) only > > and may contain > > privileged, confidential, or proprietary information that is > > exempt from > > disclosure under law. If you have received this message in > > error, please > > inform us promptly by reply e-mail, then delete the e-mail > > and destroy any > > printed copy. Thank you. > > == > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Returning value from a stored procedure?
Maybe try spelling out the word "OUTPUT" in your stored procedure instead of "OUT"? Just a thought. ______ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Janine Jakim [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 03, 2003 10:35 AM > To: CF-Talk > Subject: RE: Returning value from a stored procedure? > > > Would help if I start reading the whole email before > responding. I'm having > a rough day here > > SET @AffiliateName = '' > Why did you do this in your stored proc?? Won't this > automatically always > set it to ''? > > > -Original Message- > From: Bosky, Dave [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 03, 2003 10:16 AM > To: CF-Talk > Subject: RE: Returning value from a stored procedure? > > > There's still a problem with the sp because when I execute it in query > analyzer it prints a empty string. > Some reason the query value is not getting put in the variable. > > -Original Message- > From: Janine Jakim [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 03, 2003 10:08 AM > To: CF-Talk > Subject: RE: Returning value from a stored procedure? > > > Get rid of the null=yes. That is setting it to ''. > > > -Original Message- > From: Bosky, Dave [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 03, 2003 10:06 AM > To: CF-Talk > Subject: Returning value from a stored procedure? > > > Are there any SQL guru's that can help me with this stored > procedure? I'm > trying to return '@AffiliateName' but it always returns ''. I > know the query > matches one record but the value is never saved to the > Out variable '@AffiliateName'. > > -- > > CFSQLTYPE="cf_sql_char" > null="no" VALUE="qtip"> > CFSQLTYPE="cf_sql_varchar" null="no" VALUE="yahoo"> > CFSQLTYPE="cf_sql_varchar" null="yes" variable="AffiliateName"> > > -- > CREATE PROCEDURE dbo.sp_test > @ratecode char (10), > @referringdomain varchar (100), > @AffiliateName varchar (100) = NULL OUT > AS > DECLARE @affiliateID int, @ratecodeID int > SET @AffiliateName = '' > SELECT @affiliateID = A.AffiliateID, > @ratecodeID = B.RateCodeID, > @AffiliateName = A.AffiliateName > FROM dbo.tbl_A A > INNER JOIN dbo.tbl_B B ON A.AffiliateID = B.AffiliateID > WHERE (A.ReferringDomain = '@referringdomain') > AND (B.RateCode = '@ratecode') > AND (B.ExpirationDate >= getdate()) > IF @AffiliateName <> '' > INSERT INTO dbo.tbl_C (affiliateID, ratecodeID) > VALUES (@affiliateID,@ratecodeID) > -- > > Regards, > Dave Bosky > > > > > HTC Disclaimer: The information contained in this message > may be privileged > and confidential and protected from disclosure. If the reader of this > message is not the intended recipient, or an employee or > agent responsible > for delivering this message to the intended recipient, you are hereby > notified that any dissemination, distribution or copying of this > communication is strictly prohibited. If you have received this > communication in error, please notify us immediately by > replying to the > message and deleting it from your computer. Thank you. > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Unusual SQL error
Sounds to me like when SQL created it's execution plan it is running several parts of the query simultaneously. For some reason when this happens it causes a conflict within your query. What SQL is asking you to do is give it a hint about how to process the query to avoid this problem. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Creese, Eric [mailto:[EMAIL PROTECTED] > Sent: Friday, July 04, 2003 1:17 PM > To: CF-Talk > Subject: Unusual SQL error > > > I never have received this error before. > > [Macromedia][SQLServer JDBC Driver][SQLServer]Intra-query > parallelism caused > your server command (process ID #52) to deadlock. Rerun the > query without > intra-query parallelism by using the query hint option (maxdop 1). > Can anyone give some insite? > > > -- > > This e-mail is intended for the use of the addressee(s) only > and may contain > privileged, confidential, or proprietary information that is > exempt from > disclosure under law. If you have received this message in > error, please > inform us promptly by reply e-mail, then delete the e-mail > and destroy any > printed copy. Thank you. > == > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: visual fox pro db?
That's what I thought. Yeah the terminology is a royal PITA. And even VFP's database implementation of triggers and such is not the cleanest in the world. Thankfully of all the systems we wrote only 2 are left using VFP tables, the rest have been converted to SQL. If we ever get a few months free we might think of converting them as well, but they work so we aren't going to break the wheel. ______ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Doug White [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 02, 2003 8:16 AM > To: CF-Talk > Subject: Re: visual fox pro db? > > > Actually they are "free tables." and not in a database > container. He sent > them to me and I exported them to three different files, > System data format, > Comma delimited, and tab delimited, and he them imported them > into his SQL > database with no further problems. Since the table did not > contain a whole lot > of records, it only took a minute or so to make the export > and send them back. > There is an inherited terminology error with FoxPro, (and for > that matter dbase) > in that free tables were called "database" before they even > knew what a real > database was. > > You are correct that a DBF table can be accessed directly, > but it is cleaner > when using it as a part of a larger application to import it > into an SQL table > where you can apply stored procedures, triggers, etc. > > Had it been in a database container (dbc file) then the VFP > upsize wizard will > convert it to an SQL database file in one pass. > > == > Stop spam on your domain, use our gateway! > For hosting solutions http://www.clickdoug.com > ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 > ====== > If you are not satisfied with my service, my job isn't done! > > - Original Message - > From: "Bill Grover" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, July 02, 2003 6:30 AM > Subject: RE: visual fox pro db? > > > | Sorry it took so long to respond, I got pulled out of the > office all of > yesterday. > | > | I suspect that you are doing your DTS import your DSN is > set to use a VFP > database. In this case when you see the table list SQL is > retrieving it from a > list of tables stored in the VFP database. The VFP database > information is > stored in a set of 3 files, ?.dbc, ?.dct, ?.dcx where ? is > common among the > files. This container holds neat things like triggers, > defaults, referential > integrity and so on. > | > | However, having said that, it is possible to create VFP > tables know as "free > tables". These are tables just like ones in the database but > are not linked to > any database. There are a few restrictions (no triggers, > column names < 10 > characters, etc) but otherwise these tables can be accessed > just like tables > that are part of a VFP database. > | > | So my thought is that the 3 sets of files you are not > seeing in your import > list are free tables. Create yourself another DSN telling > the system to use > tables instead of the database. You should now see all of > the tables in the > folder, both the ones that are part of the database and the > ones that are not. > You should be able to select all of the tables you want to import. > | > | Hope that helps. > | __ > | > | Bill Grover > | Supervisor MIS Phone: 301.424.3300 x3324 > | EU Services, Inc. FAX:301.424.3696 > | 649 North Horners Lane E-Mail: [EMAIL PROTECTED] > | Rockville, MD 20850-1299WWW:http://www.euservices.com > | __ > | > | > | > | > -Original Message- > | > From: Tony Weeg [mailto:[EMAIL PROTECTED] > | > Sent: Tuesday, July 01, 2003 8:45 AM > | > To: CF-Talk > | > Subject: RE: visual fox pro db? > | > > | > > | > just missing a table in the import, that is there, in the > foxpro files > | > directory > | > does this make sense? I have like 55 groups of 3 files, > all I assumed > | > where 55 different > | > table
RE: visual fox pro db?
Sorry it took so long to respond, I got pulled out of the office all of yesterday. I suspect that you are doing your DTS import your DSN is set to use a VFP database. In this case when you see the table list SQL is retrieving it from a list of tables stored in the VFP database. The VFP database information is stored in a set of 3 files, ?.dbc, ?.dct, ?.dcx where ? is common among the files. This container holds neat things like triggers, defaults, referential integrity and so on. However, having said that, it is possible to create VFP tables know as "free tables". These are tables just like ones in the database but are not linked to any database. There are a few restrictions (no triggers, column names < 10 characters, etc) but otherwise these tables can be accessed just like tables that are part of a VFP database. So my thought is that the 3 sets of files you are not seeing in your import list are free tables. Create yourself another DSN telling the system to use tables instead of the database. You should now see all of the tables in the folder, both the ones that are part of the database and the ones that are not. You should be able to select all of the tables you want to import. Hope that helps. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Tony Weeg [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 01, 2003 8:45 AM > To: CF-Talk > Subject: RE: visual fox pro db? > > > just missing a table in the import, that is there, in the foxpro files > directory > does this make sense? I have like 55 groups of 3 files, all I assumed > where 55 different > tables with some ancillary files to hold datacorrect? so, most of > them import fine, its just > that a couple, don't? its like they are not there in the > list of tables > to choose from, on my > dts import...ive got the filename dsn working, its all good, > just three > tables don't show up in > the list to select all when importing into sql server 2000? > > tony weeg > uncertified advanced cold fusion developer > tony at navtrak dot net > www.navtrak.net > office 410.548.2337 > fax 410.860.2337 > > > -Original Message- > From: Bill Grover [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 01, 2003 7:52 AM > To: CF-Talk > Subject: RE: visual fox pro db? > > > Tony, > > We use FoxPro here all the time and have successfully migrated many > systems to SQL. What is the issue/errors you are seeing? > __ > > Bill Grover > Supervisor MIS Phone: 301.424.3300 x3324 > EU Services, Inc. FAX:301.424.3696 > 649 North Horners Lane E-Mail: [EMAIL PROTECTED] > Rockville, MD 20850-1299WWW:http://www.euservices.com > __ > > > > > -Original Message- > > From: Tony Weeg [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, July 01, 2003 12:05 AM > > To: CF-Talk > > Subject: RE: visual fox pro db? > > > > > > and then in turn, im builing a web based collections > system, reverse > > engineering actually...but building from scratch most of > it...taking > > it from a windows based app > > to a web based app :) fun fun fun...old vfp system!!! > > > > later. > > > > and thanks for any help.. > > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > Sent: Monday, June 30, 2003 11:56 PM > > To: CF-Talk > > Subject: Re: visual fox pro db? > > > > > > What's the question? > > > > -Novak > > > > - Original Message - > > From: "Tony Weeg" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Monday, June 30, 2003 8:46 PM > > Subject: ot: visual fox pro db? > > > > > > > hey, if anyone on here is knowledgable about vfp > databases...please > > > if you have time, email me off list, i have a quick > > question...thanks! > > > > > > tony > > > > > > tony weeg > > > [EMAIL PROTECTED] > > > www.revolutionwebdesign.com > > > rEvOlUtIoN wEb DeSiGn > > > 410.334.6331 > > > > > > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Refresh a frame
I've used the following JavaScript function to change/refresh a frame from another
frame:
function ChangeFrame(toFrame, tcLocation)
{
toFrame.location.href = tcLocation;
}
HTH
__
Bill Grover
Supervisor MIS Phone: 301.424.3300 x3324
EU Services, Inc. FAX:301.424.3696
649 North Horners Lane E-Mail: [EMAIL PROTECTED]
Rockville, MD 20850-1299WWW:http://www.euservices.com
__
> -Original Message-
> From: Paul Campano [mailto:[EMAIL PROTECTED]
> Sent: Monday, June 30, 2003 9:05 PM
> To: CF-Talk
> Subject: OT: Refresh a frame
>
>
> I want to refresh a frame called "rightframetop" from
> "mainframe". Does anyone have an idea of how to do this? I
> had been trying to use a Meta tag, but the following tag I
> tried and it just loaded the remote frame's file into itself.
> CONTENT="1;URL=http://www.foo.com/frames/rightframetop.cfm";
> TARGET="rightframetop">
> Thanks.
>
> Paul Campano
>
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at
http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: visual fox pro db?
Tony, We use FoxPro here all the time and have successfully migrated many systems to SQL. What is the issue/errors you are seeing? __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Tony Weeg [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 01, 2003 12:05 AM > To: CF-Talk > Subject: RE: visual fox pro db? > > > and then in turn, im builing a web based collections system, reverse > engineering > actually...but building from scratch most of it...taking it from a > windows based app > to a web based app :) fun fun fun...old vfp system!!! > > later. > > and thanks for any help.. > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Monday, June 30, 2003 11:56 PM > To: CF-Talk > Subject: Re: visual fox pro db? > > > What's the question? > > -Novak > > - Original Message - > From: "Tony Weeg" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, June 30, 2003 8:46 PM > Subject: ot: visual fox pro db? > > > > hey, if anyone on here is knowledgable about vfp databases...please > > if you have time, email me off list, i have a quick > question...thanks! > > > > tony > > > > tony weeg > > [EMAIL PROTECTED] > > www.revolutionwebdesign.com > > rEvOlUtIoN wEb DeSiGn > > 410.334.6331 > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFDIRECTORY over a LAN
We have noticed the same thing. We have an application where the user enters a job number and using CFDIRECTORY we retrieve all of the files in several directories that match a pattern using that job number. We then display a grid of record counts for the user to verify. Once verified the user can update our ERP database with counts so that the proper job instructions can be generated. My suspicion is that CF is opening and closing the network connection several times during the CFDIRECTORY thus slowing down the function. Just my $.02 worth. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Neil Middleton [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 12, 2003 6:10 AM > To: CF-Talk > Subject: RE: CFDIRECTORY over a LAN > > > Just tried it over IP and the performance is the same... > > N > > > -Original Message- > > From: Neil Middleton [mailto:[EMAIL PROTECTED] > > Sent: 12 June 2003 10:59 > > To: CF-Talk > > Subject: RE: CFDIRECTORY over a LAN > > > > > > no firewalls, and I haven't tried using an IP Address. > > > > I will run the test over IP and see if it makes a big > > difference or not. > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Is there SQL equivalent to CF's ListGetAt function??? Please help!
The following function will take a list and return you a table with 1 row
for each element in the list, along with the "row number" (i.e. an identity
column that begins with 1).
I wrote this a while ago because I have several FoxPro programs that needed
to pass a comma delimited list of values into a stored procedure and use
them as a filter on a select statement. It was too much of a pain to make
sure the list is formatted properly before passing. This way I can just
include the function call in the select, such as:
SELECT field1, field2, field3
FROM mytable
INNER JOIN dbo.f_reuParseList(@tclist, ',')
ON mytable.keyfield = ListID
For what you want you can do something like SELECT listitem FROM
f_reuParseList(field, '|') where ListID = 5 to get the 5th item in the list.
______
Bill Grover
Supervisor MIS Phone: 301.424.3300 x3324
EU Services, Inc. FAX:301.424.3696
649 North Horners Lane E-Mail: [EMAIL PROTECTED]
Rockville, MD 20850-1299WWW:http://www.euservices.com
__
CREATE FUNCTION f_reuParseList (@tcList VARCHAR(8000),
@tcDelimiter char(1))
RETURNS @ParsedList TABLE (ListID int IDENTITY,
ListItem varchar(8000))
AS
BEGIN
DECLARE @RetVal INT,
@lcAddlInfo VARCHAR(250),
@lcListWork varchar(8000),
@lnCommaPos int,
@lcItem varchar(8000)
SET @lcListWork = @tcList
WHILE LEN(@lcListWork) > 0
BEGIN
SET @lnCommaPos = CHARINDEX(@tcDelimiter, @lcListWork)
IF @lnCommaPos > 0
BEGIN
SET @lcItem = SUBSTRING(@lcListWork, 1, @lnCommaPos - 1)
SET @lcListWork = SUBSTRING(@lcListWork, @lnCommaPos + 1,
LEN(@lcListWork) - @lnCommaPos)
END
ELSE
BEGIN
SET @lcItem = @lcListWork
SET @lcListWork = ''
END
INSERT INTO @ParsedList
VALUES (@lcItem)
END
RETURN
END
> -Original Message-
> From: Che Vilnonis [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 10, 2003 9:54 AM
> To: CF-Talk
> Subject: RE: Is there SQL equivalent to CF's ListGetAt function???
> Please help!
>
>
> STEVEN...yes I am. M$ SQL 2000 SP3.
> I'd appreciate anything you can 'throw' my way...
>
> ~CV
>
> -Original Message-
> From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 10, 2003 9:44 AM
> To: CF-Talk
> Subject: RE: Is there SQL equivalent to CF's ListGetAt function???
> Please help!
>
>
> Are you using SQL 2000? If so then you could create a user
> defined function
> to do what you want.
>
> Let me know, and I'll see if I can quickly throw something together.
>
> Steve
>
>
> -Original Message-
> From: Che Vilnonis [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 10, 2003 9:39 AM
> To: CF-Talk
> Subject: RE: Is there SQL equivalent to CF's ListGetAt function???
> Please help!
>
>
> thanks...I wish there was an easier fix
>
> -Original Message-
> From: Adrian Lynch [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 10, 2003 9:27 AM
> To: CF-Talk
> Subject: RE: Is there SQL equivalent to CF's ListGetAt function???
> Please help!
>
>
> I don't know if this is the best way, but have a look at
> SubString() and
> CharIndex(), you might be able to use the two together to get
> what you need.
> This is on SQL Server by the way.
>
> Ade
>
> -Original Message-
> From: Che Vilnonis [mailto:[EMAIL PROTECTED]
> Sent: 10 June 2003 14:10
> To: CF-Talk
> Subject: Is there SQL equivalent to CF's ListGetAt function??? Please
> help!
>
>
> I have a column in a db that stores data with a pipe [|] delimiter.
> I would like to write a SQL query that filters data based on a segment
> of data within a pipe delimited variable.
>
> Basically, is there SQL code that is equivalent to the psuedo CF code
> below? A SQL version of ListGetAt if you will???
>
> --> WHERE FinalShipTo =
> ListGetAt("#getOrderInfo.FinalShipTo#","5","~") <--
>
> I hope this makes sense...
>
> TIA - Ché
>
>
>
>
>
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics.
http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Multi Site Installation (Was: Quick note from the CF Team.... )
I didn't see any responses so I thought I would throw my miniscule experience in. BTW, this was all done on Updater 2. We went to MX from 4.01 actually without a hitch but only had the default website defined in IIS. Several months later decided we wanted to host another site for some special customer access. We added the site and followed the instructions found in one of MM's knowledgebase articles to edit the xml file and run the connector batch file only to have CF stop processing all request on ALL sites. After spending another 3 hours trying to get it to work I threw up my hands and restored the server and got everything working. I ended up coming back to it about a month later when I had another weekend I could work on it. In the mean time I read everything I could find on how IIS and CF link together and how ISAPI filters are configured. It ended up being nothing more than that the connector batch file for some reason didn't want to configure IIS's ISAPI filters correctly. When I manually configured the global settings to point to the correct places everything kicked in and started working. So I guess my point, in a round about way, is that if you already have multiple sites setup prior to putting MX on everything probably installs correctly. If you don't and want to add them later it didn't seem to work. Since my problems Updater 3 has come out and MM did some fixes in this area so all this may be moot now. ______ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Dave Watts [mailto:[EMAIL PROTECTED] > Sent: Monday, June 02, 2003 10:33 AM > To: CF-Talk > Subject: RE: Quick note from the CF Team > > > > Where the issues come up is when the web server is hosting > > sites on a different drive(s) and are serving web sites > > other than the default wwwroot directory. We call these > > "multi-homed" servers. There are still issues with the > > install, and even greater ones with the updaters. This > > is not just my imagination, nor is it incompetence in > > server administration. This is not hardware problems as > > the server hardware is state of the art. > > Out of curiosity, could you provide a brief summary of these > issues? I've > deployed CFMX on several Windows servers with multiple virtual servers > configured, and without any problems. I'm not saying your > problems aren't > real, I'd just like to know what might be waiting for me next time. > > > The bottom line for me is that if a server product will > > not play nice with my security requirements, it just will > > not get purchased or installed. > > Could you also provide more information about this? I'm > considered a bit > about security, too, but I haven't run into any > security-specific issues > with CFMX. I've actually found CFMX easier to secure than CF > 5, in general. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > voice: (202) 797-5496 > fax: (202) 797-5444 > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: i think im gettin hacked
Like the others I would suspect a hardware issue. We had one of our Dell's start going off a week ago. The A/C went out in our server room and caused some major heat problems. So we shut one of our servers down that wasn't critical and when we powered it back up the alarm started going off. Ended up one of the hard drives cooked itself to death and had to be replaced. Fortunatly it was a RAID-5 so the server would run fine and the data was recoverable. So I would check drives and possibly the CPU fan. It could be that the CPU fan is off and causing the CPU to overheat. Just my $.02 worth. ______ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Tony Weeg [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 03, 2003 12:28 AM > To: CF-Talk > Subject: RE: i think im gettin hacked > > > ok. > > 1. pc speakers, gone...turned down, SOUND GOES AWAY. > 2. unplug from network. shutdown, wait 5 - 10 minutes > and restart, not logging in...and it starts, after like 2 or 3 minutes > 3. i have ran trendmicro's housecall NOTHING > 4. norton with up to date definitionsNOTHING, > yetstill running. > 5. wow. this is wild. any ideas would rock. > 6. my fan is running, and hummin right along, this is a fairly new > vaio desktop pcgrx450 well kept, i mean, i baby the summabitch... > > WTF!! > > help. > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 03, 2003 12:05 AM > To: CF-Talk > Subject: Re: i think im gettin hacked > > > Three quick things to try: > > 1. Where is the sound coming from? Disconnect your multimedia > speakers. > Is the sound coming from the PC itself? > > 2. Unplug your network and boot up. If the alarm goes off and you're > not > even plugged into your network then it's probably some time > of hardware > alarm. > > 3. Make sure the fan above your CPU and the fan in your > power supply is > still turning (and turning fast). I've seen hardware that > sound a built > in > alarm when the fans slow down too much. If you've never > heard it before > or > didn't know it was there it can be quite confusing. > > -Novak > > > - Original Message - > From: "Sean" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, April 02, 2003 8:50 PM > Subject: RE: i think im gettin hacked > > > > My first thought would be hardware alarm of some nature. > Depending on > the > nature of your setup, run whatever system diagnostics you use, or if > you've > got hotswap hardware, thats normally the easiest test > running, slap your > drive into an identical hardware set, swap over the network connection > and > see if its still broken. > > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > Sent: Thursday, 3 April 2003 1:45 PM > > To: CF-Talk > > Subject: Re: i think im gettin hacked > > > > > > tony, > > do you have an alarm on your system for overheating etc - sometimes > they > > come with alarms & stuff. > > > > if you email me off list with your ip address i will do a > port scan to > see > > what ports are open if that will help > > > > steve soars > > [EMAIL PROTECTED] > > > > - Original Message - > > From: "Tony Weeg" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Thursday, April 03, 2003 1:22 PM > > Subject: RE: i think im gettin hacked > > > > > > | i know it...but comcast also tells me that they have a lot of > protection > > | before my connection gets here...not too sure i believe that > one...but i > > | do > > | netstat, and dont see anything connected to my machine? > > | > > | WTF? > > | > > | tw > > | > > | -Original Message- > > | From: Dave Lyons [mailto:[EMAIL PROTECTED] > > | Sent: Wednesday, April 02, 2003 10:20 PM > > | To: CF-Talk > > | Subject: Re: i think im gettin hacked > > | > > | > > | tony, > > | are you spending too much time in the half pipe? lol > > | btw~ the xp firewall is well. > > | microsoft;) > > | not t
RE: FoxPro databases: does CF use indexes?
CF will access FoxPro efficiently, we do it all day every day. If you submit a poorly written query it will perform poorly, but if you write an optimized query it will fly. For example, we have an inventory table with an index defined as UPPER(stockno). I had a programmer write a query on his page for "WHERE stockno = '#form.stockno#'". It would take FOREVER to run. When I looked at it and realized it wasn't using the index and had him change it to "WHERE UPPER(stockno) = '#form.stockno#'" the results were instant. In fact you could take his original query straight out of CF and execute it in FoxPro and while it was every bit as slow. As others have said, all CF does is pass the query off to the FoxPro ODBC driver you have installed on your server. It's up to that driver to insure the performance. ______ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Dan O'Keefe [mailto:[EMAIL PROTECTED] > Sent: Monday, March 10, 2003 12:55 PM > To: CF-Talk > Subject: RE: FoxPro databases: does CF use indexes? > > > My memory of using VFP databases with CF was not a good one > and seem to > remember running into the same issues. I then turned to > getting the data > into SQL. I realize that may not be an option for you. You > might want to > check some ASP forums and see if that have any threads on using these > databases. Theoretically it is the same, ODBC passing the > query along to the > DB. I also seem to remember queries doing a number on the > server resources. > > Dan > > -Original Message- > From: Jack Ince [mailto:[EMAIL PROTECTED] > Sent: Monday, March 10, 2003 11:38 AM > To: CF-Talk > Subject: RE: Foxpro databases: does CF use indexes? > > > Foxpro is independent of CF. > When you submit you cfquery all data gathering is passed off > to Foxpro. From > there Foxpro will proceed just like it was a Foxpro request, > and will use > any index it can. I assume that your management has upgraded > to Visual FP if > they are so concerned about the speed. > > -Original Message- > From: Ed Gordon [mailto:[EMAIL PROTECTED] > Sent: Monday, March 10, 2003 7:22 AM > To: CF-Talk > Subject: Foxpro databases: does CF use indexes? > > > Management here has seen time-to-production decimated since I > introduced > Cold Fusion. Yet, doubt remains about it's efficiency reading > the legacy > Foxpro databases. > > If I have CF read some Foxpro database files (.dbf), will it use the > database index files (.cdx) automatically? > > How could I tell? > > How could I *prove to management* that it indeed is using them? > > If not, can I explicitly use them? How? > > Thanks in advance for your help... > > Ed Gordon > > --- > > Old so Soon, > Smart so Late, > When I'm Learning, > ... Life is Great! > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Multiple Mail Attachments with CF 4.0
I know it was a PITA! We had written a COM object that interfaced with CDONTS for use in another language. So we took advantage of this and wrote our page to do a to our COM object and send the mail that way. If you have CDONTS on the server you are mailing from you can probably interface directly into it. You may be able to do it even if you have a MAPI client (like Outlook) on the server. With MAPI you could create a mail object and add attachments to it then send the mail. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Kamie Curfman [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 28, 2003 9:40 AM > To: CF-Talk > Subject: RE: Multiple Mail Attachments with CF 4.0 > > > Oh, for the love of crap, I was afraid this was going > to be the answer. I have three (and exactly three) > files I need to attach to every mail I send out. Are > there any workarounds? These people are not going to > want to receive three emails for every application > that gets entered. > > Kamie > > --- Bill Grover <[EMAIL PROTECTED]> wrote: > > In 4.0 you could only attach 1 file at a time. > > > __ > > > > > -Original Message- > > > From: Kamie Curfman [mailto:[EMAIL PROTECTED]] > > > Sent: Monday, January 27, 2003 11:30 PM > > > To: CF-Talk > > > Subject: Multiple Mail Attachments with CF 4.0 > > > > > > > > > I'm freelancing for a client who still has CF 4.0 > > on > > > their server (yes, I know). I'm trying to send > > > multiple attachments with the CFMAIL tag. I had > > > totally forgotten about the MIMEATTACH attribute > > > (tried doing CFMAILPARAM instead) and now can't > > figure > > > out how to send multiple files with it. Can this > > not > > > be done? > > > > > > Thanks in advance. > > > > > > Kamie > > = > Kamie Curfman, Web Developer, FGM Inc. > 45245 Business Court, Suite 400 > Dulles, VA 20166 > http://www.fgm.com > > __ > Do you Yahoo!? > Yahoo! Mail Plus - Powerful. Affordable. Sign up now. > http://mailplus.yahoo.com > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Multiple Mail Attachments with CF 4.0
In 4.0 you could only attach 1 file at a time. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Kamie Curfman [mailto:[EMAIL PROTECTED]] > Sent: Monday, January 27, 2003 11:30 PM > To: CF-Talk > Subject: Multiple Mail Attachments with CF 4.0 > > > I'm freelancing for a client who still has CF 4.0 on > their server (yes, I know). I'm trying to send > multiple attachments with the CFMAIL tag. I had > totally forgotten about the MIMEATTACH attribute > (tried doing CFMAILPARAM instead) and now can't figure > out how to send multiple files with it. Can this not > be done? > > Thanks in advance. > > Kamie > > = > Kamie Curfman, Web Developer, FGM Inc. > 45245 Business Court, Suite 400 > Dulles, VA 20166 > http://www.fgm.com > > __ > Do you Yahoo!? > Yahoo! Mail Plus - Powerful. Affordable. Sign up now. > http://mailplus.yahoo.com > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFLOGIN (Was: stupid newbie tricks)
You know, I saw that timeout attribute and went right by it. I guess I'll play with it a bit. Your right though it would be best if the cflogin timedout at the same interval as your session. On another vein, I saw your presentation at CFUN'02 in Rockville and enjoyed it very much. I downloaded your presentation from DevCon'02 and noticed that you added a point to one of the slides. What you added said "Roles-caching Bug / Timeout Issue". What is the bug/issue? Thanks. ______ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Raymond Camden [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 08, 2003 10:14 AM > To: CF-Talk > Subject: RE: CFLOGIN (Was: stupid newbie tricks) > > > This is one of the more confusing aspects of the roles-based security > system - it is NOT the same as sessions. In fact, the default timeout > for cflogin is different from sessions. One of the > enhancement requests > already requested is to allow cflogin to use the session scope instead > of it's own timeout. > > == > = > Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc > > Email: [EMAIL PROTECTED] > WWW : www.camdenfamily.com/morpheus > Yahoo IM : morpheus > > "My ally is the Force, and a powerful ally it is." - Yoda > > > -Original Message- > > From: Bill Grover [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, January 08, 2003 8:55 AM > > To: CF-Talk > > Subject: RE: CFLOGIN (Was: stupid newbie tricks) > > > > > > Thanks for the complement! > > > > The issue I was having may have been fixed. But what I was > > noticing was I would run my page, login and everything was > > happy. While working on something else I would leave the > > page alone for 20-25 minutes. Come back and refresh the > > page, or go to the next page and the system would error > > saying that SESSION.nUserID was undefined. Yet if you looked > > at the debug window the system still had the logon > > authentication cookie set so it would not run the > > tag. That is why I added the cflogout code at the beginning > > of the page. __ > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFLOGIN (Was: stupid newbie tricks)
Thanks for the complement! The issue I was having may have been fixed. But what I was noticing was I would run my page, login and everything was happy. While working on something else I would leave the page alone for 20-25 minutes. Come back and refresh the page, or go to the next page and the system would error saying that SESSION.nUserID was undefined. Yet if you looked at the debug window the system still had the logon authentication cookie set so it would not run the tag. That is why I added the cflogout code at the beginning of the page. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 08, 2003 8:43 AM > To: CF-Talk > Subject: RE: stupid newbie tricks > > > Quoting Bill Grover <[EMAIL PROTECTED]>: > > > > > > > > > > > > > > > > > There used to be an issue with cflogin and cflogout where you > needed to put the > cflogout after the cflogin or users would get mixed up when > they logged out and > back in again (I think). Not sure if it is resolved yet? > > Jochem > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: stupid newbie tricks
Just to throw in my penny's worth, and maybe learn something new at the same time. I just wrote my first application using the new security. Here's what I did, and I must admit some of it I pulled together from Ray Camden's presentations and the documentation. Hopefully I don't have to many bad practices in it! ______ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ The last lines of my application.cfm file are: My Login.cfm file is: My GetLogin.cfm file is: #APPLICATION.cTitle# Please enter your login information. User: Password: > -Original Message- > From: Mike Miessen [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 07, 2003 7:28 PM > To: CF-Talk > Subject: RE: stupid newbie tricks > > > Thank you I will use the full path. > > -Original Message- > From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 07, 2003 6:43 PM > To: CF-Talk > Subject: Re: stupid newbie tricks > > Dave Watts wrote: > > > > You can simplify this as shown here: > > > > > > > > I would caution using against using contain. If your > webserver adheres > strictly to the formal definition of a URL, the URL > "http://domain.com/index.cfm;login"; might return a script_name of > "index.cfm;login", which would be very undesirable. > > Jochem > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Experiences with VisualSourceSafe?
We use both, but have not tried to "link" them. As one of the other responders noted we use the VSS client to do all of our check-in/check-out work. We have found with other languages/environments that having them do the VSS work was always slow. We have found that it can be an issue for us to forget to add a file to VSS. One procedure we do that helps is when we are ready to release a project onto our testing server we use what is in VSS. Basically we tell VSS to "get latest version" of all files and then point the destination to the testing server. Then when we run the system if any file is missing it becomes very apparent and we can get it added. Just my $.02 ______ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, December 03, 2002 1:07 AM > To: CF-Talk > Subject: Experiences with VisualSourceSafe? > > > Hi All, > > Does anyone here use CFMX and Microsoft Visual SourceSafe? > If so, how do > you like it? Are there any implementation or usage issues we > should know > about? > > Also... on the same note... does anyone recommend using a > different software > solution and if so why? > > -Novak > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Stored Proc list input
I ran into this some time ago. The following function will take your list and a 1 character delimiter and return a table of the parsed results. Originally when I did this we were on SQL7 so I do have a SP version if you want it, but I prefer the function. CREATE FUNCTION f_reuParseList (@tcList VARCHAR(8000), @tcDelimiter CHAR(1)) RETURNS @ParsedList TABLE (ListID int IDENTITY, ListItem varchar(8000)) AS BEGIN DECLARE @lcListWork varchar(8000), @lnCommaPos int, @lcItem varchar(8000) SET @lcListWork = @tcList WHILE LEN(@lcListWork) > 0 BEGIN SET @lnCommaPos = CHARINDEX(@tcDelimiter, @lcListWork) IF @lnCommaPos > 0 BEGIN SET @lcItem = SUBSTRING(@lcListWork, 1, @lnCommaPos - 1) SET @lcListWork = SUBSTRING(@lcListWork, @lnCommaPos + 1, LEN(@lcListWork) - @lnCommaPos) END ELSE BEGIN SET @lcItem = @lcListWork SET @lcListWork = '' END INSERT INTO @ParsedList VALUES (@lcItem) END RETURN END GO ______ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, November 19, 2002 1:52 PM > To: CF-Talk > Subject: Re: Stored Proc list input > > > Likely you're going to run into a larger issue with your > database not being > able to interpret the @PassVariable value as an integer... at > least with MS > SQL Server I have yet to find a way to pass a list to a > stored procedure > without passing it as a varchar and then using exec > (@mysqlstatement) or > exec sp_executesql @mysqlstatement which somewhat defeats the > purpose of the > storedprocedure being pre-processed. > > > I need to pass a string such as 1,2 in to a stored procedure. The > > variable > > is then used like this: > > > Where MYVariable IN (@PassVariable) > > > Now the problem is that MYVariable is an INT and I am passing in the > > @PassVariable as a string. > > > I get this error: > > > Syntax error converting the varchar value '1,2' to a column > of data type > > int. > > > I need to figure some way around this. Any ideas? > > > Thanks, > > > Neil > > S. Isaac Dealey > Certified Advanced ColdFusion 5 Developer > > www.turnkey.to > 954-776-0046 > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Primary Keys & Duplicate Values
As Andy has been saying I also would highly recommend that you create an auto numbered primary key. Just because this field is your primary key does not mean that it has to be the field to link your tables together. But having this key makes it very easy to update a single row in your table. In the future as you add/modify tables you can make this primary key a foreign key in your other tables. We have had databases designed that use both compound keys and unique numbers. The systems that use unique numbers always seem to perform faster and easier. And honestly every time we have defined a case where a combination of fields should be unique we've ended up with a situation where we needed to add a duplicate for some reason. Just my humble $.02 worth. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Andy Ousterhout [mailto:[EMAIL PROTECTED]] > Sent: Monday, October 07, 2002 10:13 PM > To: CF-Talk > Subject: RE: Primary Keys & Duplicate Values > > > I have the same issue in that I have a web system that I am > integrating with > my Order Management/Mfg system. The Order Mgmt uses Product Number as > primary key, my web system does not. The advantage that I > have is that my > Order Mgmt System enforces the unique Product Number Key. In > your example, > if you have purchased items as well, then you can definitely > have duplicate > item numbers, but as you stated, item number+mfg id should be > unique. I > would use this to match the two systems together, but not at your new > system's key. I would have only 1 product table for both > sold as well as > purchased items, work in progress and mfg items. > > Just my two sense (or lack of sense as some more experienced > DB designers > might say -- let me know since I am designing my next release.) > > Andy > > -Original Message- > From: Srimanta [mailto:[EMAIL PROTECTED]] > Sent: Monday, October 07, 2002 4:03 PM > To: CF-Talk > Subject: Re: Primary Keys & Duplicate Values > > > Thanks. > Yes I understand. > What I could do is to combine both modelno and the name of > the manufacturer > and use them in updates. That should prevent updating the > wrong records > should the model number not be unique. > The problem with using an additional field (perhaps with auto > number) is > that the table to be updated > and the table from which the new values (price etc) will be > sourced may not > have the same auto number id. Also my table(Table1) will have > product data > from multiple vendors. > Different vendors will have tables where Id values might clash. > > Srimanta > - Original Message - > From: "Andy Ousterhout" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, October 08, 2002 8:34 AM > Subject: RE: Primary Keys & Duplicate Values > > > > I highly recommend that you don't make Model number your > primary key. Add > a > > new field, numeric, and make your primary key a meaningless > number that > will > > never change. I've used several products that lock model > number and for > > newer companies where their numbering system evolves, this > has been an > > incredible and preventable pain in the back side. > > > > What does everyone else recommend? > > > > Andy > > > > -Original Message- > > From: Srimanta [mailto:[EMAIL PROTECTED]] > > Sent: Monday, October 07, 2002 1:48 PM > > To: CF-Talk > > Subject: Re: Primary Keys & Duplicate Values > > > > > > Thanks > > Field 1 represents model number of products which should be unique. > However > > due to some error in data entry some of the records are > duplicate. I can > > safely delete those records. > > > > Srimanta > > - Original Message - > > From: "Robertson-Ravo, Neil (REC)" > <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Monday, October 07, 2002 10:52 PM > > Subject: RE: Primary Keys & Duplicate Values > > > > > > > Yep, your problem is that you have dupes in the column > you want to tag > as > > a > > > PK. is Field 1 the only field which is uses dupe > values? are the > > records > > > techni
RE: Returning columns with null values when specific columns are unknown at runtime
I figured I'd jump in late and add my $.02 worth! The following will return
a result set with all of the null columns values. If you need the names you
can always retrieve that in CF (query.ColumnList).
CREATE PROCEDURE rGetNullColumns
@tnPrimaryKey int
AS
SET NOCOUNT ON
DECLARE @lcSQL varchar(1000)
SELECT @lcSQL = 'SELECT '
+ CASE WHEN col1 IS NULL THEN 'col1,' ELSE '' END
+ CASE WHEN col2 IS NULL THEN 'col2,' ELSE '' END
+ CASE WHEN col3 IS NULL THEN 'col3,' ELSE '' END
+ CASE WHEN col4 IS NULL THEN 'col4,' ELSE '' END
+ '0 AS DummyField '
+ 'FROM tablename WHERE primarykey = '
+ CAST(@tnPrimaryKey AS varchar)
FROM tablename
WHERE primarykey = @tnPrimaryKey
EXEC (@lcSQL)
__
Bill Grover
Supervisor MIS Phone: 301.424.3300 x3324
EU Services, Inc. FAX:301.424.3696
649 North Horners Lane E-Mail: [EMAIL PROTECTED]
Rockville, MD 20850-1299WWW:http://www.euservices.com
__
> -Original Message-
> From: Patti G. L. Hall [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 18, 2002 11:58 AM
> To: CF-Talk
> Subject: Re: Returning columns with null values when specific columns
> are unknown at runtime
>
>
> Sorry, but you made the same mistake that simon did.
>
> I don't want to return select *
>
> I want to return select (only columns that are null and I
> don't know what
> they are up front) where primarykey = some number
>
> I didin't actually have any questions regarding the where
> statement at all.
> I'm aware that I'll probably have to use the whole IS NULL
> dealie... but
> where I'm stuck is how do I selectively return columns when I
> don't know
> which columns fit my criteria (containing null values only).
>
> Thanks - Patti
> - Original Message -
> From: "Candace Cottrell" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, September 18, 2002 11:23 AM
> Subject: Re: Returning columns with null values when specific
> columns are
> unknown at runtime
>
>
> > How about this or am I still missing something
> >
> > Select * from TABLENAME
> > WHERE col1 IS NULL OR col2 IS NULL OR col3 IS NULL OR col4 IS NULL
> >
> >
> > Candace K. Cottrell, Web Developer
> > The Children's Medical Center
> > One Children's Plaza
> > Dayton, OH 45404
> > 937-641-4293
> > http://www.childrensdayton.org
> >
> >
> > [EMAIL PROTECTED]
> >
> > >>> [EMAIL PROTECTED] 9/18/2002 11:17:41 AM >>>
> > Thanks, but that doesn't get me where I want.
> >
> > I ONLY want to return the columns that ARE null, and I
> never know which
> > ones
> > those are when I run this query... so what I need is
> something for the
> > select statement.
> >
> > -Patti
> > - Original Message -
> >
> > > The only thing I can think to do is create a bunch of OR
> statements
> > i.e.:
> > > WHERE colA IS NULL OR colB IS NULL OR colN IS NULL
> > >
> > > ~Simon
> > >
> > >
> > > -Original Message-
> > >
> > >
> > > Is there a way to write a MSSQL 2k query that will return a result
> > set
> > that
> > > contains only columns with null values when you don't know
> > explicitly
> > which
> > > columns those will be?
> > >
> > > So if I have this data
> > >
> > > pk | col 1 | col 2 | col 3 | col 4|
> > > 1 1 2nullnull
> > > 2null4 nullnull
> > >
> > > I'd like a query that would return col 3 and col 4 where pk = 1 or
> > col 1,
> > > col 3 and col 4 where pk=2.
> > >
> > > Is this possible?
> > > -Patti
> >
> >
> >
> >
>
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: List to stored proc
We wrote a function that takes a list and returns 1 row for each element in the list. You can then use this within your select. By making it a function you can treat the function as a table in SQL 2000. Our function is: CREATE FUNCTION f_reuParseList (@tcList VARCHAR(8000), @tcDelimiter char(1)) RETURNS @ParsedList TABLE (ListID int IDENTITY, ListItem varchar(300)) AS BEGIN IF @tcList IS NULL BEGIN RETURN END DECLARE @lcListWork varchar(8000), @lnCommaPos int, @lcItem varchar(8000) SET @lcListWork = @tcList WHILE LEN(@lcListWork) > 0 BEGIN SET @lnCommaPos = CHARINDEX(@tcDelimiter, @lcListWork) IF @lnCommaPos > 0 BEGIN SET @lcItem = SUBSTRING(@lcListWork, 1, @lnCommaPos - 1) SET @lcListWork = SUBSTRING(@lcListWork, @lnCommaPos + 1, LEN(@lcListWork) - @lnCommaPos) END ELSE BEGIN SET @lcItem = @lcListWork SET @lcListWork = '' END INSERT INTO @ParsedList VALUES (@lcItem) END RETURN END GO ______ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Tangorre, Michael [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, September 10, 2002 9:13 AM > To: CF-Talk > Subject: RE: List to stored proc > > > I have a similar question... > in the stored proc, say you pass in a comma delimited list, > how do you break it apart? > Are there list functions within T-SQL? > > Mike > > -Original Message- > From: Joe Eugene [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, September 10, 2002 9:01 AM > To: CF-Talk > Subject: Re: List to stored proc > > > You can pass the whole String(List) into the StroredProc.. > just as VARCHAR > depends on what you want to do with the LIST... > put into different fields.. u have split it in the stored proc.. > > Joe > - Original Message - > From: "Tipton Josh (orl1jdt)" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, September 10, 2002 7:39 AM > Subject: List to stored proc > > > > I have a comma delimited list that I want to pass into a > procedure. Any > > help. I am using nvarchar(4000) as the data type but I get > invalid cast > > spec. > > > > Josh > > > > > > __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: bug tracking software.
We use Anomaly Tracking System (ATS) from Microsoft. It was included free on Visual Studio 5. The version we use is a FoxPro application but allows you to create user defined fields and choose what to display and not display. Pretty simple. I know there is a web based version that can be downloaded from Microsoft. We looked at it some months ago and have thought about switching but what we are using works great for us and we just haven't decided to spend the time. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 05, 2002 10:53 AM > To: CF-Talk > Subject: bug tracking software. > > > what bug tracking software do you guys and gals on this > list use for your development? > > thanks! > > ..tony > > Tony Weeg > Senior Web Developer > Information System Design > Navtrak, Inc. > Fleet Management Solutions > www.navtrak.net > 410.548.2337 > > __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: extra blank lines problem
My guess is you are correct. What happens if you leave the cfset's where they are and just remove the cfoutput from around them? I believe the page should still work and you won't get the extra lines. Just my thoughts. ______ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Aunger, Mitch [mailto:[EMAIL PROTECTED]] > Sent: Monday, September 02, 2002 5:39 PM > To: CF-Talk > Subject: extra blank lines problem > > > Hello, (don't you people take american holidays off? ;) > > I have a page that exports data to an Excel spreadsheet. I am > able to export > all of the data with headers into Excel, however I am > experiencing some > difficulty with blank rows in between my rows of data (5 blank rows in > between each to be exact). > > Here is my code: > > > select * > from table > > > > > > > > > > > > value="filename=metrics_customer.xls"> > CATEGORY#tabchar#TYPE#tabchar#SYSTEM NAME#tabchar#SURVEY > DATE#tabchar#REQUESTOR NAME#tabchar#REQUESTOR PHONE#tabchar#REQUESTOR > DEPT#tabchar#REQUESTOR EMAIL#tabchar#RESPONDANT ORG#tabchar#SLC > PHASE#tabchar#RESPONDANT NAME#tabchar#RESPONDANT > PHONE#tabchar#RESPONDANT > EMAIL#tabchar#SITE#tabchar#QUESTION 1#tabchar#QUESTION 1 > COMMENT#tabchar#QUESTION 2#tabchar#QUSTION 2 COMMENT#tabchar#QUESTION > 3#tabchar#QUESTION 3 COMMENT#tabchar#QUESTION 4#tabchar#QUESTION 4 > COMMENT#newline# > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > #cat##tabchar##typeof##tabchar##system_name##tabchar > ##dateformat(s > urvey_date, " mmm > dd")##tabchar##request_name##tabchar##request_phone##tabchar## > request_dept## > tabchar##request_email##tabchar##respon_org##tabchar##slc_phas > e##tabchar##re > spon_name##tabchar##respon_phone##tabchar##respon_email##tabch > ar##site##tabc > har##q1_response##tabchar##q1_commenta##tabchar##q2_response## > tabchar##q2_co > mmenta##tabchar##q3_response##tabchar##q3_commenta##tabchar##q > 4_response##ta > bchar##q4_commenta# > > > I think the problem is with the cfoutput tags around the > cfset tags. Is > there a way to work around this? I have tried using the > replace directly in > my variables that I write to Excel, but I get an error. > > Any help would be greatly appreciated! > > Thanks, > Mitch > __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: Using JS to skip a Tab index?
The only other thought I have would be to put some code in the onFocus event. But if the -1 option works it would be much cleaner. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Shawn Grover [mailto:[EMAIL PROTECTED]] > Sent: Thursday, June 20, 2002 7:07 PM > To: CF-Talk > Subject: RE: OT: Using JS to skip a Tab index? > > > Problem with this is that the field will eventually get focus > when tabbing. > We can't allow focus to the element at all when tabbing. > > Ksuh's suggestion to try a -1 for the tabindex might do the > trick. I'll try > it out. > > Shawn Grover > > -Original Message- > From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] > Sent: Thursday, June 20, 2002 4:48 PM > To: CF-Talk > Subject: Re: OT: Using JS to skip a Tab index? > > > I believe the tabindex attribute is HTML standard for most > form elements, so > rather than a complicated javascript, you should be able to > simply tell the > form which elements are at what points in the tab order, i.e. > > > > > > hope this helps > > Isaac > > www.turnkey.to > 954-776-0046 > > > __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How do i pass FORM variables from one action page to another one ?
No it won't work in v4.01. Believe me I've tried. Prior to v4.5 form fields were a pseudo-structure. The only way I've gotten anything to work is by evauating the "form.fieldname". ______ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Jon Hall [mailto:[EMAIL PROTECTED]] > Sent: Monday, May 13, 2002 12:07 PM > To: CF-Talk > Subject: Re: How do i pass FORM variables from one action page to > another one ? > > > 4.5 yeah...earlier I don't know. I can't remeber if the form > variables where > put in a structure before 4.5... > > jon > - Original Message - > From: "Bud" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, May 13, 2002 12:00 PM > Subject: Re: How do i pass FORM variables from one action > page to another > one ? > > > > On 5/13/02, Jon Hall penned: > > >/me plays virtual Raymond :) Just say no to evaluate! Here > is a speedier > way > > >to do it. > > > > > > > > > > > > > > > > Neato. Does that work in 4.5 and earlier? > > -- > > > > Bud Schneehagen - Tropical Web Creations > > > > _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ > > ColdFusion Solutions / eCommerce Development > > [EMAIL PROTECTED] > > http://www.twcreations.com/ > > 954.721.3452 > > > __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: transact-sql datediff function
I hate to say it but the function is working as designed. I ran into the same issue when looking for the number of months between dates. >From SQL Server's Books Online: The method of counting crossed boundaries such as minutes, seconds, and milliseconds makes the result given by DATEDIFF consistent across all data types. The result is a signed integer value equal to the number of datepart boundaries crossed between the first and second date. For example, the number of weeks between Sunday, January 4, and Sunday, January 11, is 1. Basically what you will find is that the number of years difference between the 2 dates is the count of how many times you go past January 1. Each time you pass Jan 1 it adds 1 year. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Dina Hess [mailto:[EMAIL PROTECTED]] > Sent: Monday, May 06, 2002 2:20 PM > To: CF-Talk > Subject: OT: transact-sql datediff function > > > hi all, > > i posted this on the sql list but got no response. > > i have a test table named employees with the following fields: > > fname varchar > lname varchar > hire_date datetime > > the record i'm querying contains 2001-05-11 00:00:00.000 in the > hire_date field. but this query returns 1 rather than the > expected 0: > > select datediff(yy, hire_date, getdate()) as yearsdiff from > employees where fname = 'ann' > > this should give me the number of years between 5/11/2001 and > today's date of 5/6/2002, which should be 0 since it's not 5/11 > yet. so why am i getting 1??? > > ~ dina > > __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Passing values between frames
We have an app that does this all over the place. In our case it is for our intranet so we can insure that everyone is using IE. Therefore we did it with tags. But you can do the same thing with regular frames, you just have another object level in the chain. To reference the form on the parent page we do a parent.formname.submit() - i.e. parent.DataForm.submit() __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Matt Liotta [mailto:[EMAIL PROTECTED]] > Sent: Sunday, May 05, 2002 3:37 PM > To: CF-Talk > Subject: RE: Passing values between frames > > > I am not anywhere a JS reference, but you can reference the parent > frame's form with something like parent.document. > > -Matt > > > -Original Message- > > From: Douglas Brown [mailto:[EMAIL PROTECTED]] > > Sent: Sunday, May 05, 2002 12:24 PM > > To: CF-Talk > > Subject: Re: Passing values between frames > > > > How can I have the child frame cause the parent to submit to > > itself using JS? > > > > > > > > > > Douglas Brown > > Email: [EMAIL PROTECTED] > > - Original Message - > > From: "Matt Liotta" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Sunday, May 05, 2002 11:58 AM > > Subject: RE: Passing values between frames > > > > > > > In order to move data from JavaScript to CF, you will need to > > have the > > > browser make a request. A common way to hide this is to use a > > hidden > > > frame. In the hidden frame, you have JavaScript send and receive > > some > > > data on a regular basis. You might want to look to WDDX for help > > moving > > > the data back and forth. > > > > > > -Matt > > > > > > > -Original Message- > > > > From: Douglas Brown [mailto:[EMAIL PROTECTED]] > > > > Sent: Sunday, May 05, 2002 11:58 AM > > > > To: CF-Talk > > > > Subject: Passing values between frames > > > > > > > > I have a chat application that I am attempting and require the > > brain > > > > energy of the group. This is frames based app, and I am > > attempting to > > > do > > > > it with an array versus a database. the layout etc... is > > below. I am > > > > trying to use a Coldfusion array, but do not know if I can > > pass the > > > > value of the textbox in [postMessage.cfm] from javascript into > > the > > > > coldfusion array using arrayAppend() somehow. > > > > > > > > > > > > [Index.cfm] > > > > Holds the of the pages > > > > > > > > [messages.cfm] > > > > This is the chat window > > > > > > > > [postMessage.cfm] > > > > This holds the textbox for the person to submit their message. > > > > > > > > [whosOn.cfm] > > > > This holds a list of who is currently logged into the chat > > > > > > > > > > > > > > > > > > > > Douglas Brown > > > > Email: [EMAIL PROTECTED] > > > > > > > > > > > > > > > > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: end of month function
Good point! (stupid! stupid! stupid!) Try this.
DateAdd("d", -1, DateAdd("m", 1, CreateDate(Year(Now()), Month(Now()), 1)))
______
Bill Grover
Supervisor MIS Phone: 301.424.3300 x3324
EU Services, Inc. FAX:301.424.3696
649 North Horners Lane E-Mail: [EMAIL PROTECTED]
Rockville, MD 20850-1299WWW:http://www.euservices.com
__
> -Original Message-
> From: Pascal Peters [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 24, 2002 8:26 AM
> To: CF-Talk
> Subject: RE: end of month function
>
>
> I wouldn't try that in december.
>
> -Original Message-
> From: Bill Grover [mailto:[EMAIL PROTECTED]]
> Sent: woensdag 24 april 2002 14:17
> To: CF-Talk
> Subject: RE: end of month function
>
>
> I just had to do this on one of our sites. Here is the code I use:
>
> DateAdd("d", -1, CreateDate(Year(Now()), Month(Now()) + 1, 1))
>
> __
>
> Bill Grover
> Supervisor MIS Phone: 301.424.3300 x3324
> EU Services, Inc. FAX:301.424.3696
> 649 North Horners Lane E-Mail: [EMAIL PROTECTED]
> Rockville, MD 20850-1299WWW:http://www.euservices.com
> __
>
>
>
> > -Original Message-
> > From: Perez, Percy [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, April 23, 2002 11:33 AM
> > To: CF-Talk
> > Subject: end of month function
> >
> >
> > Hello all,
> >
> > Is there a End of month function in ColdFusion...
> > I am trying to get the end of month for a date.
> > excel has one, but I could not find one under the help files.
> > eg:
> > eomonth(1-15-2002) would return 1-31-2002
> > and of course, before I build one, I figure I ask first.
> >
> > Thanks
> >
> > Percy E Perez
> >
> >
> >
>
>
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: end of month function
I just had to do this on one of our sites. Here is the code I use:
DateAdd("d", -1, CreateDate(Year(Now()), Month(Now()) + 1, 1))
______
Bill Grover
Supervisor MIS Phone: 301.424.3300 x3324
EU Services, Inc. FAX:301.424.3696
649 North Horners Lane E-Mail: [EMAIL PROTECTED]
Rockville, MD 20850-1299WWW:http://www.euservices.com
__
> -Original Message-
> From: Perez, Percy [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 23, 2002 11:33 AM
> To: CF-Talk
> Subject: end of month function
>
>
> Hello all,
>
> Is there a End of month function in ColdFusion...
> I am trying to get the end of month for a date.
> excel has one, but I could not find one under the help files.
> eg:
> eomonth(1-15-2002) would return 1-31-2002
> and of course, before I build one, I figure I ask first.
>
> Thanks
>
> Percy E Perez
>
>
>
__
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Opinions/Experience with Webex?
We use Webex and are very happy with it and we use it for demo's and training. Our company specializes in printing, personalization and mailing. As such to assist our customers we maintain an inventory of their finished goods in our plant. We have developed a set of web pages that allow our clients to view what we have in inventory and request that we pull items from inventory and ship them to any give address. One of the primary places we use Webex is to setup a training with our clients on this feature. We will create a Webex meeting, bring the customer online and go through the system showing them how to use the system and answering any questions they have. Our clients have loved it because it allows us to provide solutions to them faster than if we had to travel to their site. Hope this helps. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Ken Wilson [mailto:[EMAIL PROTECTED]] > Sent: Monday, April 08, 2002 2:21 PM > To: CF-Talk > Subject: Opinions/Experience with Webex? > > > Anyone here have any experience with Webex > http://www.webex.com that you > could share? Or alternatives in the online meeting realm? > Webex appears to > suit our needs but would appreciate any feedback pro or con > that anyone > could share. Primary use will be for remotely training > personnel on several > CF-based web applications. > > Thanks, > > Ken > > > __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Foxpro issue
Yes it still works. When you create your DSN choose the free tables option and specify your directory. You can then just access the tables you wish. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Keith [mailto:[EMAIL PROTECTED]] > Sent: Saturday, March 30, 2002 4:18 PM > To: CF-Talk > Subject: Re: Foxpro issue > > > I believe you can access FP 2.x tables with the Visual FoxPro > ODBC driver if > you use the "Free Table Directory" option. I was using doing > that in 1999. > Hopefully it still works. > > [EMAIL PROTECTED] > > > - Original Message - > From: "Nathan Chen" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Friday, March 29, 2002 2:40 PM > Subject: OT: Foxpro issue > > > > Hi, All: > > Sorry for this OT, but I really need to know if there is an > ODBC driver > > available for Foxpro 2.6 database(I know it is very old). > I am trying > > to convert Foxpro 2.6 to SQL 7.0 and I can't find anything > on Microsoft > > web site. > > > > Nathan > > > > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > > > > > > > __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: One call for two pages?
Though I would wade in with my $.02 worth. I've written pages where I spew all of the HTML out and then at the very end (after the ) I add my JavaScript. Something like: document.form[0].field.value = 'something' This way the script won't run until after the whole page is created. You might be able to use this to create your page and then write the JavaScript to go to the parent frame, grab the values you want and then push them into the page where you want them displayed. The other option I can think of is to write your server page to generate the 2 output pages and save them disk using cfhttp. Then when you load your 2 frames have those pages cfinclude the generated pages. I know you are in a clustered environment so this may not be feasible, but just a thought. Good Luck! ______ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Dave Carabetta [mailto:[EMAIL PROTECTED]] > Sent: Friday, March 15, 2002 3:20 PM > To: CF-Talk > Subject: Re: One call for two pages? > > > >haha, i totally screwed up that post. > > > >instant replay > > > >this is kindof a wacky situation. as far as I know there > are few ways to > >make a "recordset", or data in general, available across frames. > > > >in this case I would use a wddx recordset. > >-i'd run the query in the upper frame > >-return it to the page as a wddx recordset to the page > >-onload of the upper i'd refresh the lower > >-onload of the lower have it look at the wddx recordset in > the upper and > >build your page from there > > > >kinda messy. interesting problem that i've never really seen a good > >solution to. > > > >you CAN refer to variables in other frames from the same domain. > > > >am i making sense here or am i speaking FridayAfternoonGettingTired > >language here? > > No, you're making sense. That's an interesting approach. The > one pitfall I > see is that in order to refer to the top frame's field, I'd > have to use > JavaScript to get the value (parent.topFrame.fieldname.value) > and then write > the bottom frame out entirely in JavaScript. Outside of that, > I don't see > how I could get at the value via JavaScript, set it to a CF > variable, and > then use the resulting CF variable to write the page using > standard markup. > > Does that make sense? > > Thanks for your reply, > Dave. > > _ > Send and receive Hotmail on your mobile device: http://mobile.msn.com > > __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL help please
If you do that select you will end up with EXACTLY the same data as you started with + a count column that will always be 1. The issue is that you kind of want to group the paycatid field within changes of the paycatid field. Therefore you have to process each record one at a time looking for a change and then returning the proper start and end dates for that "range". Therefore you have to use a cursor to process the records one by one. ______ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Thursday, March 14, 2002 11:06 AM > To: CF-Talk > Subject: Re: SQL help please > > > try > > select employeeid, startdate, enddate, count(*), paycatid > from X > group by employeeid, startdate, enddate, paycatid > > > > > > ksuh > > @shaw.ca To: CF-Talk > <[EMAIL PROTECTED]> > cc: > > 03/13/02 Subject: Re: SQL > help please > 04:51 PM > > Please > > respond to > > cf-talk > > > > > > > > > > Anyone? > > Bueller? Bueller? > > - Original Message - > From: [EMAIL PROTECTED] > Date: Wednesday, March 13, 2002 2:51 pm > Subject: SQL help please > > > Brain not working Must help... > > > > Here's my data set: > > > > employeeid startdate enddate paycatid > > --- --- --- --- > > 936 2002-02-08 2002-02-08 1 > > 936 2002-02-11 2002-02-11 1 > > 936 2002-02-12 2002-02-12 1 > > 936 2002-02-13 2002-02-13 11 > > 936 2002-02-14 2002-02-14 1 > > 936 2002-02-15 2002-02-15 1 > > 936 2002-02-18 2002-02-18 11 > > 936 2002-02-19 2002-02-19 11 > > 936 2002-02-20 2002-02-20 11 > > 936 2002-02-21 2002-02-21 11 > > 936 2002-02-22 2002-02-22 11 > > 936 2002-02-25 2002-02-25 7 > > 936 2002-02-27 2002-02-27 7 > > > > What I'm wondering is how do I get something like: > > > > employeeid startdate enddate same paycatid in a row paycatid > > --- --- --- --- -- > > 936 2002-02-08 2002-02-12 3 1 > > 936 2002-02-13 2002-02-13 1 11 > > 936 2002-02-14 2002-02-15 2 1 > > 936 2002-02-18 2002-02-22 5 11 > > 936 2002-02-25 2002-02-27 2 7 > > > > I'm using SQL Server 7. > > > > > > > > __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Query Analyzer
As Lon said check your Tools|Options setting. I believe the default for the maximum is ~250 characters and you can increase it. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Lon Lentz [mailto:[EMAIL PROTECTED]] > Sent: Thursday, March 14, 2002 5:59 PM > To: CF-Talk > Subject: RE: SQL Query Analyzer > > > How long is it? Under tools/options there is a "maximum > characters per column". > > > > -Original Message- > > From: Kahng, Lucius [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, March 14, 2002 3:12 PM > > To: CF-Talk > > Subject: SQL Query Analyzer > > > > > > I'm trying to retrieve a long text field from out > ColdFusion SQL database > > using SQL Query Analyzer, however, the program truncates the > > field contents. > > Is there a way to display the full contents of long text fields? > > (Instead of > > having to use CFML to output a the whole table's column contents!) > > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL help please
I'm not sure you can do it with a simple select statement. If I understand what you want you want to look at each entry and whenever the paycatid field changes report the first start and last end dates for that id. You will probably need to create and run a stored procedure. Your SP will need to create a cursor to process the records 1 by 1 looking for the paycatid field to change and then saving the start and end dates. Something like this (data types may vary depending on your actual data types). This routine is for a single employee but can be modified to work for multiple employees. CREATE PROCEDURE GetCatInfoForEmp @tnEmpIDsmallint AS SET NOCOUNT ON DECLARE @lnEmpIDsmallint, @lcStartDate varchar(10), @lcEndDatevarchar(10), @lcCatID varchar(2), @lcLastID varchar(2), @lnNumRec smallint, @lcLowStart varchar(10), @lcHighEndvarchar(10 DECLARE DataSet CURSOR FOR SELECT employeeid startdate enddate paycatid FROM sometable WHERE employeeid = @tcEmpID ORDER BY startdate, paycatid CREATE TABLE #PayCatSum (employeeid smallint, startdate varchar(10), enddatevarchar(10), paycatid varchar(2), entrycount smallint) OPEN DataSet FETCH NEXT FROM DataSet INTO @lnEmpID, @lcStartDate, @lcEndDate, @lcCatID SET @lcLastID = @lcCatID SET @lnNumRec = 0 SET @lcLowStart = @lcStartDate SET @lcHighEnd = @lcEndDate WHILE @@FETCH_STATUS = 0 BEGIN IF @lcLastID <> @lcCatID BEGIN INSERT INTO #PayCatSum VALUES (@lnEmpID, @lcLowStart, @lcHighEnd, @lcLastID, @lnNumRec) SET @lnNumRec = 1 SET @lcLastID = @lcCatID SET @lcLowStart = @lcStartDate SET @lcHighEnd = @lcEndDate END ELSE BEGIN IF @lcStartDate < @lcLowStart SET @lcLowStart = @lcStartDate IF @lcEndDate > @lcHighEnd SET @lcHighEnd = @lcEndDate SET @lnNumRec = @lnNumRec + 1 END FETCH NEXT FROM DataSet INTO @lnEmpID, @lcStartDate, @lcEndDate, @lcCatID END INSERT INTO #PayCatSum VALUES (@lnEmpID, @lcLowStart, @lcHighEnd, @lcLastID, @lnNumRec) SELECT * FROM #PayCatSum ______ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, March 13, 2002 6:10 PM > To: CF-Talk > Subject: Re: SQL help please > > > Nope, that doesn't work. > > - Original Message - > From: laszlo <[EMAIL PROTECTED]> > Date: Wednesday, March 13, 2002 4:06 pm > Subject: Re: SQL help please > > > select ... count(paycatid) as samepaycatid group by paycatid > > > > laszlo > > > > > > [EMAIL PROTECTED] wrote: > > > > > Anyone? > > > > > > Bueller? Bueller? > > > > > > - Original Message - > > > From: [EMAIL PROTECTED] > > > Date: Wednesday, March 13, 2002 2:51 pm > > > Subject: SQL help please > > > > > > > Brain not working Must help... > > > > > > > > Here's my data set: > > > > > > > > employeeid startdate enddate paycatid > > > > --- --- --- --- > > > > 936 2002-02-08 2002-02-08 1 > > > > 936 2002-02-11 2002-02-11 1 > > > > 936 2002-02-12 2002-02-12 1 > > > > 936 2002-02-13 2002-02-13 11 > > > > 936 2002-02-14 2002-02-14 1 > > > > 936 2002-02-15 2002-02-15 1 > > > > 936 2002-02-18 2002-02-18 11 > > > > 936 2002-02-19 2002-02-19 11 > > > > 936 2002-02-20 2002-02-20 11 > > > > 936 2002-02-21 2002-02-21 11 > > > > 936 2002-02-22 2002-02-22 11 > > > > 936 2002-02-25 2002-02-25 7 > > > > 936 2002-02-27 2002-02-27 7 > > > > > > > > What I'm wondering is how do I get something like: > > > > > > > > employeeid startdate enddate same paycatid in a row paycatid > > > > --- --- --- --- -- > > > > 936 2002-02-08 2002-02-12 3 1 > > > > 936 2002-02-13 2002-02-13 1 11 > > > > 936 2002-02-14 2002-02-15
RE: Truncating Logs
I picked up the following from SQL Magazine. This code if run in the Query
Analyzer window will eventually shrink the log file. Make sure you are in
the right database before executing the statements. I've had to let mine
run for a minute or so, but if you monitor the logfile size eventually you
will see it shrink. For more details I would check SQLMag's
(www.sqlmag.com) website. They give a good explanation as to why this needs
to be done.
/* Do the following select by itself first.
You will need the file ID for the logfile that is
returned for the rest of the routine
*/
SELECT fileid, name, filename
FROM sysfiles
DBCC shrinkfile(,notruncate)
DBCC shrinkfile(,truncateonly)
CREATE TABLE t1 (char1 char(4000))
GO
DECLARE @i int
SELECT @i = 0
WHILE (1 = 1)
BEGIN
WHILE (@i < 100)
BEGIN
INSERT INTO t1 values ('a')
SELECT @i = @i + 1
END
TRUNCATE TABLE t1
backup log with truncate_only
END
GO
______
Bill Grover
Supervisor MIS Phone: 301.424.3300 x3324
EU Services, Inc. FAX:301.424.3696
649 North Horners Lane E-Mail: [EMAIL PROTECTED]
Rockville, MD 20850-1299WWW:http://www.euservices.com
__
> -Original Message-
> From: Ian Tait [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 14, 2002 4:57 AM
> To: CF-Talk
> Subject: RE: Truncating Logs
>
>
> http://www.sqlserverfaq.com
>
> Has some useful info on this subject.
>
> One thing I did recently was to back up the database, detatch
> the db files
> using sp_detatch_db,
> and reattach just the data file using sp_attach_db, forcing
> it to create a
> new log file.
> This was for a log file that just would not shrink.
>
> No good if you want to keep the db on line though :-)
>
> HTH,
>
> Ian
>
> -Original Message-
> From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
> Sent: 13 March 2002 21:06
> To: CF-Talk
> Subject: SQL: Truncating Logs
>
>
> Does anyone know the TSQL for truncating a transaction log?
> Mind sharing?
>
> TIA,
> Duane
>
>
>
>
__
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFTransactions and SQL Transactions?
I agree. I try to avoid putting any data logic within the CF page wherever possible. In the case of my application I was being unsuccessful in calling my insert procedure with a variable number of parameters from CF. We had a page where our customers would answer some questions and then we would place the answers in a database. The answers were in the form of checkboxes. Since they might, or might not, check the box making the CF call using either or and setting the proper parameters was causing errors to be returned. That's why we ended up calling the insert procedure with the required fields and then making calls to an update SP where we could pass in the field to update and the value and the SP would update that field. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Shawn Grover [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, March 12, 2002 11:58 AM > To: CF-Talk > Subject: RE: CFTransactions and SQL Transactions? > > > In my experience, this would be better done in a single > stored procedure > call (which would then call any other required stored procs). > SQL Server > supports nested transactions, so each of your 'child' stored > procs can also > use transactions if required. > > If you are writing this from scratch, put as much logic as > you can into the > stored procs (afterall, the database server is meant to > handle data for you, > whereas your web server is meant to present web pages). > > As for CFTRANSACTION, we are unclear on how it could handle a > rollback if > you have stored procs within it that have committed their SQL > Transactions. > > Until I hear more, I'm recommending to my team to NOT use > CFTransaction for > that reason. The data for our current app is critical, and > we have to stick > with methods we know to work well. > > Let me know if you hear any more on this. I'm not getting > the impression > that I'll see lots on this from the list. > > Shawn Grover > > -Original Message- > From: Bill Grover [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, March 12, 2002 5:48 AM > To: CF-Talk > Subject: RE: CFTransactions and SQL Transactions? > > > Shawn, > > I don't have an answer but am anxiously awaiting one. > > I have a case where in order to get some records into our SQL > database I > execute a SP to enter a blank record and then call several > SP's to update > different fields in the record with values. I need to wrap this in a > and am just trying to gather some more > information before > doing it. > > __ > > Bill Grover > Supervisor MIS Phone: 301.424.3300 x3324 > EU Services, Inc. FAX:301.424.3696 > 649 North Horners Lane E-Mail: [EMAIL PROTECTED] > Rockville, MD 20850-1299WWW:http://www.euservices.com > __ > > > > > -Original Message- > > From: Shawn Grover [mailto:[EMAIL PROTECTED]] > > Sent: Monday, March 11, 2002 3:03 PM > > To: CF-Talk > > Subject: CFTransactions and SQL Transactions? > > > > > > This is a repost cuz I think I got lost in the shuffle on > > Friday, and no-one > > has responed yet. > > > > TIA. > > > > -Original Message- > > From: Shawn Grover [mailto:[EMAIL PROTECTED]] > > Sent: Friday, March 08, 2002 9:54 AM > > To: CF-Talk > > Subject: CFTransactions and SQL Transactions? > > > > > > I'm looking for more information about using . > > My personal opinion is that it's better to use SQL Server > transactions > > within our stored procedures (cuz we are using SQL 2000 as > > our back end), > > and transfer as much business logic as possible to the stored procs. > > > > However, in a few cases, we've seen the requirement for > > something like this: > > > > > > > > > > > > > > > > > > > > > > My concerns are that this may cause problems if the stored > procedures > > themselves contain transaction processing. And I need to make a > > recommendation based on solid information on whether to allow > > this process,
RE: Stored Procedure Help
The only thing that jumped out at me was the line: Shouldn't it read? Just my $.02 __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Ian Skinner [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, March 12, 2002 11:15 AM > To: CF-Talk > Subject: Stored Procedure Help > > > I'm trying to write my first Cold Fusion Stored Procedure. > And I have run into a problem. Can someone help explain > what this error means: "NULL Interface Ptr"? I've looked in > the online help documentation, and on Macromedia/Allair's > web site and there is absolutely no reference to this error, > incredibly. > > This is the cold fusion code I am using: > > > > > procedure="sp_ktChgsPmtsByDate" > datasource="Paragon" > provider="OLEDB" > providerdsn="Paragon" > DEBUG="YES"> > >VALUE="#SDate#" CFSQLTYPE="CF_SQL_DATE"> > >VALUE="#EDate#" CFSQLTYPE="CF_SQL_DATE"> > > > > > > > > > > > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFTransactions and SQL Transactions?
Shawn, I don't have an answer but am anxiously awaiting one. I have a case where in order to get some records into our SQL database I execute a SP to enter a blank record and then call several SP's to update different fields in the record with values. I need to wrap this in a and am just trying to gather some more information before doing it. ______ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Shawn Grover [mailto:[EMAIL PROTECTED]] > Sent: Monday, March 11, 2002 3:03 PM > To: CF-Talk > Subject: CFTransactions and SQL Transactions? > > > This is a repost cuz I think I got lost in the shuffle on > Friday, and no-one > has responed yet. > > TIA. > > -Original Message- > From: Shawn Grover [mailto:[EMAIL PROTECTED]] > Sent: Friday, March 08, 2002 9:54 AM > To: CF-Talk > Subject: CFTransactions and SQL Transactions? > > > I'm looking for more information about using . > My personal opinion is that it's better to use SQL Server transactions > within our stored procedures (cuz we are using SQL 2000 as > our back end), > and transfer as much business logic as possible to the stored procs. > > However, in a few cases, we've seen the requirement for > something like this: > > > > > > > > > > > My concerns are that this may cause problems if the stored procedures > themselves contain transaction processing. And I need to make a > recommendation based on solid information on whether to allow > this process, > or force the developers to take the time to wrap this logic within one > stored proc call. (of course, they can call existing stored > procs from > within a stored procedure, and check the return codes to > determine if a > rollback needs to happen before processing is complete). > > So, any suggestions? Thanks in advance. > > Shawn Grover > > > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Stored Procedure
2 points. First if SP-1 calls SP-2 SP-2 can see all temporary tables created by SP-1 BUT NOT VISA-VERSA. So if you are going to create a result set that you later want to access in the calling SP you have to "trick" the SP. The way we've done this is to create an empty table in the calling SP (SP-1) with the proper structure. Then call the SP (SP-2) passing in the table name. We code SP-2 to run in 2 modes. If a table name is passed then it creates the final result set it does it with a "INSERT INTO SELECT " command. Otherwise it just does a "SELECT " command. This way we can get the results passed back to the calling SP for it's use. Secondly, you can probably do the query you've given with 1 select statement. I use MS SQL Server and I've done queries like this several times. I've never worked with Oracle so all bets are off there. SELECT GRADES.*, STDNT.* FROM GRADES INNER JOIN (SELECT STUDENTS.*, schol.* FROM STUDENTS INNER JOIN (SELECT SchoolID, blah,blah FROM school WHERE SchoolID = #SchoolID#) schol ON STUDENTS.SchoolID = SCHOL.SchoolID WHERE gradeID=#gradeID#) STDNT ON GRADES.StudentID = STDNT.StudentID Hope this helped. ______ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Janine Jakim [mailto:[EMAIL PROTECTED]] > Sent: Thursday, March 07, 2002 2:49 PM > To: CF-Talk > Subject: OT:Stored Procedure > > > I have a report that has 6 queries to gather all the info > from the related > tables. I am in the process of turning these s into stored > procedures (SQL2000). > In CF I have things like > SELECT blah,blah > FROM SCHOOLS > WHERE SchoolID=#SchoolID# > > > SELECT * > FROM STUDENTS > WHERE SchoolID=#SchoolID# > AND gradeID=#gradeID# > > > > > SELECT * > FROM GRADES > WHERE StudentID=#StudentID# > > So query1 gets the schoolid- query2 gets all the students with that > schoolid/gradeID and then query3 is getting the grades for > those students. > > I'm wondering how to do this in stored procedures. I've > always learned to > keep the sp small so they can be reused. I was also told > that one stored > procedure can call another- so I guess I was wondering if one stored > procedure can pass a parameter to the next. (ie: so it knows > what students > to pull grades for) > If this is possible where or how would I put it in the stored > procedure? > ie: > one sp would be: > CREATE PROCEDURE GetSchools > @SchoolID int, > @GradeLevel int > AS > SELECT * > FROM Students > WHERE SchoolID=@SchoolID > AND GradeLevel=@GradeLevel > GO > So how would I filter the StudentId from this stored > procedure to put in the > next stored procedure: > > CREATE PROCEDURE GetReportCardMarks > @StudentID int > AS > SELECT Skill, StudentID, Grade, SchoolID > FROM Grades > WHERE StudentID=@StudentID > GO > > I hope I explained this sufficiently. > Thanks in advance, > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: whats wrong with DateFormat()
The reason is how dates are stored. Dates are stored as sequential numbers. You are passing the sequential number 5 into the routine which Dateformat thinks is something weird like 1/4/0001 or some such weird number. You need to pass the true datetime variable. Date format will only return the day portion anyhow, you don't need to pull the day out before formatting it. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Phillip Broussard [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, March 05, 2002 11:33 AM > To: CF-Talk > Subject: RE: whats wrong with DateFormat() > > > I can understand why the number 5 may not work but when I use > DateFormat(day(now()), 'dd') I still get a date of yesterday. > This just > doesn't seem right. > > Phillip > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, March 05, 2002 10:25 AM > > To: CF-Talk > > Subject: Re: whats wrong with DateFormat() > > > > The function day() returns a simple number between 1 and 31. It > > > > expects a date/time object. The number "5" is a date/time object, > > but > > > > it doesn't represent the day "4". > > > > The function dateformat expects a date/time object, a string that > looks > > > > > > like a date, or a numeric representation of a date object. > I guess t > > he > > > > number "5" has a day of "4". > > > > > > > > - Original Message - > > From: Phillip Broussard <[EMAIL PROTECTED]> > > Date: Tuesday, March 5, 2002 9:15 am > > Subject: whats wrong with DateFormat() > > > > > Ok I put DateFormat(day(now()), 'dd') on a page and instead of > > > > > returning05 it gave me 04. > > > > > If I put day(now()) on a page I get 5. > > > If I put day(5) on a page I get 4. > > > If I put DateFormat(now(), 'mmdd') on a page I get 20020305 > > > > > > > > > > Why? > > > > > > > > > > TAI > > > > > > > > Phillip Broussard > > > Tracker Marine Group > > > 417-873-5957 > > > > > > > > > > > > > ___ > > _ > > __ > > > Dedicated Windows 2000 Server > > > PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER > > > Instant Activation . $99/Month . Free Setup > > > http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona > > > > > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion > > com/ > > > Unsubscribe: http://www.houseoffusion.com/index.cfm?sideb > > ar=lists > > > > > > __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Server / IIS / SQL Server
Unfortunately there's no "one size fits all" answer. The books that were suggested should help you understand how Microsoft's security works. Your admin people probably install software using their admin accounts for the same reason we do here. We do not allow users rights to install software to their computers. There are several reasons for doing this. First we have to support the computers. If a user can install whatever they want whenever they want there is no telling what system, or work related, files they would corrupt. Then trying to diagnose the problem becomes impossible. You know the first thing that they will bring in is that virus ridden screen saver! Also if a user installs a piece of software, even if they use it for work, we become responsible to insure that the data is backed up. We do not backup local drives and configure all of our software to save files to network drives. If the software is not configured this way and their computer crashes we have just lost data. Finally there is the whole issue of licensing. If you bring software in how do we know you are not violating the license of the software. If it is critical to your job to use the software then we will provide it, and insure the proper licensing/number of copies are purchased. Having said that we configured our network as follows, and I'm sure it's not perfect but it works for us. IIS, CF and SQL all have their own domain users. These users are assigned rights to access just what is needed. On a workstation basis we avoid creating ODBC connections like the plague. We have some where it was unavoidable, but since 99% of all database access is to SQL Server we create connection strings in real-time based on INI files. This allows us to move applications between development, test and production with out changes. Where we do use ODBC connections is with CF. In this case we use CF's administrator page to create the ODBC connection and we have a single point of maintenance. For database permissions we create specific SQL users that have access to what is needed on the server. In general we create a SQL user per system. If this user needs access to a database other than the one for the system it was created for we grant them rights into the other databases. Also, as far as rights go, wither it is domain rights or SQL Server rights everything is done with groups. If a single user needs access to something the are either added to a group that already has the right or we create a new group and give the group the right. We have found the following to be true, that "if one person needs the right the 2nd person will be down tomorrow for the same right". Hope this helps. ______ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, February 20, 2002 10:48 AM > To: CF-Talk > Subject: CF Server / IIS / SQL Server > > > Hello, > > Ok, let me start by saying this is going to be a long email (my > apologies)... > I am at my wits end here with the admins on campus who can't > seem to figure > anything out. > > In terms of accounts and services, what is the best way to > setup IIS, SQL > 2K, and CF 5.0. I am > a novice when it comes to installing this stuff, however I am > trying to > assist the admins here on campus. > Basically, the admins on campus are in a group on the NT domain called > "admins" or something to that nature. > One server has IIS and CF on it, and the other server has SQL > 2K only. The > admins install stuff using their domain > admin acocunts... is this a good idea.. shouldn't all > software be installed > using a local system account? > > Another issue they (now trickleing down to web guys) have is ODBC > connections and setting them up. What is the best account to use > for this and what kind of permissions does that account need? > We have tried > setting up ODBCs using all kinds of logins and passwords, > but instead of guessing I want to know why and how this all works. > > Once IIS and CF are installed using the right acocunts (which I don't > believe they are now) and once SQL server is up and running > un der the right > account > what is the best practice for database permissions in terms > CF and SQL: > specifying a new user and pass for each database that people > will be using > in CF Apps? > > Man I am just at a loss here trying to figure this stuf
RE: Accessing FoxPro database
Unless your CF Service is running as the interactive user then CF will not see any drive letters, you will need to use UNC coding. Also, you need to make sure that whatever user CF is running as has rights to the file. In our case we ended up creating a special user that CF runs as that we can then give rights to specific information on other servers. So to summarize what we did was: 1) Created a CF user for the service to run as. 2) Granted rights to the CF User to the data that CF needed to access. 3) Created an ODBC connection to the directory where the FoxPro tables are using UNC coding. I.E. the path would be \\ServerB\TheShare\pro50\ARDATA 4) Do the following: SELECT custno FROM arcust10 That should do it. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Andres [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, February 19, 2002 12:15 PM > To: CF-Talk > Subject: Accessing FoxPro database > > > Hello All, > I am trying to access a foxpro database. This database is stored in > server A, while the Cold Fusion and web server is located in > server B. > Server B has all the odbc connections set to read and access > the foxpro > files in server A. > > When i try to run the following query i get an error: > > > SELECT custno FROM S:\pro50\ARDATA\arcust10.dbf > > > This is the error i get: > > ODBC Error Code = S0002 (Base table not found) > [Microsoft][ODBC Visual FoxPro Driver]File 'arcust10.dbf' does not > exist. > > The error occurred while processing an element with a general > identifier > of (CFQUERY), occupying document position (9:1) to (9:56). > > I've also tried these other ways: > SELECT custno FROM 'S:\pro50\ARDATA\arcust10.dbf' > and... > SELECT custno FROM arcust10.dbf > and... > SELECT custno FROM 'arcust10.dbf' > and... > SELECT custno FROM arcust10 > and... > SELECT custno FROM 'arcust10' > > I've also made sure the table DOES EXIST... and that i have access to > this mapped drive (s drive). I have also ensured that the > odbc settings > point to the right location. > > Any ideas will be most appreciated. > > __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Server on a separate machine
Thanks Mark and Dave! Boy am I red-faced now! One more thing to fix today. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 11, 2002 12:56 PM > To: CF-Talk > Subject: RE: SQL Server on a separate machine > > > Dave, > > Well ok, so you're right (dang it). I missed the word > "admin" > skipped right over it in good faith . sorry. And I agree > with you - bad > Idea. > > Mark > > -Original Message- > From: Dave Watts [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 11, 2002 7:25 AM > To: CF-Talk > Subject: RE: SQL Server on a separate machine > > > > I don't see him saying that this "user" is an > > administrator... you can do some things with a > > user that you can't do with a local system > > account - like explicitely deny access to something. > > While I'm certainly aware that you can configure CF to run as a > less-privileged user than SYSTEM (and cover this in Fig > Leaf's "Securing > ColdFusion Servers on Windows" course), here's what was in > the original > post: > > "What we have done is to create a specific domain admin user > for CF to run > under. > > > Again, yikes! > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > voice: (202) 797-5496 > fax: (202) 797-5444 > > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Server on a separate machine
Sorry to hear about your problems. What we have done is to create a specific domain admin user for CF to run under. Then we configured CF to start as this user. Whenever CF wants to access something (databases, files, sql server, anything) either locally or on the network it will access the information using whatever "user" it created the service as. By creating this user we set it up so that when CF wants to access something it has the rights to it. Then we create our ODBC connections through the administrator page we tell it to use a trusted connection. This allows CF to verify the connection and confirm that everything is running. However, when we write our pages that actually use the database we supply a user name and password that we want. This supplied user name and password overrides anything set when we created the connection. Hope this helps. ______ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Kay Smoljak [mailto:[EMAIL PROTECTED]] > Sent: Sunday, February 10, 2002 9:04 PM > To: CF-Talk > Subject: RE: SQL Server on a separate machine > > > > OK. At this point, I'd try the MDAC upgrade, personally. > > I just installed 2.7, and I'm still getting exactly the same error > message. > > > You should be able to connect with an SQL login - a username > > and password created within the SQL Enterprise Manager. That > > would be the ideal solution. If that doesn't work, and an > > MDAC upgrade doesn't work either, then you could create that > > new account. You'd only have to run the CF server within that > > account, and could leave the other services alone. > > I changed the account that the CF Server starts under to the network > administrator account - it couldn't even log in with mine, which has > most Administator privileges. Now it works. I realize it's not ideal, > but the CF Server on my machine is the Developer Edition, so > only my IP > is connecting anyway, and the service has to be started manually as I > don't require it all the time. And there's only six people in > the office > and we're all really nice, honest :) > > I wonder if this problem has something to do with Small > Business Server > - it's got some funny restrictions, we've found, as it's meant to be a > "one box does everything" solution. > > Thanks for all the help! > Kay. > __ > Kay Smoljak - ColdFusion Developer - PerthWeb Pty Ltd > > Level 9/105 St George's Terrace - Perth - Western Australia > Ph: (08) 9226 1366 Fax: (08) 9226 1375 www.perthweb.com.au > > http://developer.perthweb.com.au - Tools for Developers > cfx_pwcamtech | cfx_pwimageproc | cfx_pwcardcyrpt > > > > > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Cold Fusion and Visual Source Safe
We use VSS for all development. We develop in ColdFusion, Visual FoxPro, Visual Basic, SQL Server and a few more and all of it is in VSS. In fact when we write specification documents and prototype screens we store those in VSS. As far as CF development (or web development in general) we point all of our working directories to our development web server and do everything there. The only "rule" we have is if multiple developers are working on the same project you only check out what you are working on. The other benefit we found is that we have some standard files that we use in all CF applications (error trapping, common Java scripts, etc). In this case we shared these files between multiple projects so as we enhance the code all previous projects will be updated as well. We do everything with manual checkouts. We have tried integrating VSS with the various development packages and found that the automatic checkin/checkout seemed to slow everything to a crawl. We found it faster to just keep a copy of VSS running and Alt-Tab to it and checkout a file when we needed it. Supposedly there is an integration between SQL Server and VSS. I had one of my developers try to get it working. He sorta got it working but the way it is implemented just didn't fit how we work very well. You also end up needing to install a bunch of development tools on your SQL Server. If you want more information on this let me know and I'll get the information on how to do the integration. ______ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 29, 2002 4:35 PM > To: CF-Talk > Subject: RE: Cold Fusion and Visual Source Safe > > > We use VSS here. > > Integration wise things are pretty good... we have to > manually check files > in and out and it logs everything, which is the main reason > that it's usage > was implemented. It does also make things a bit less > confusing. We handle > a large number of projects, both large and small and new and > old... VSS > gives us one place to look for the source of any of it. It > has also helped > us locate those frustrating "what changed" problems. This > can be a pain for > us where we have 8 developers and multiple devel servers. > > The downside is that anyone with direct access to the server > can bypass it. > Oh, that plus the fact that there is no integration with MS > SQL Server. > > Good luck! > Hatton Humphrey > > > > -Original Message- > > From: Jaye Morris [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, January 29, 2002 4:28 PM > > To: CF-Talk > > Subject: Cold Fusion and Visual Source Safe > > > > > > Hope this is not too OT. Are there any dev teams uisng > Visual Source > > Safe for their code (or similar product)? Did you find it useful? > > > > > > // Jaye Morris, Multimedia Designer > > > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
