Re: [KCFusion] Database issue on development laptop
You can import the tables into ms access. Then have an odbc setup for the access database on your laptop. "Keith Purtell" <[EMAIL PROTECTED] To: "KCFusion (E-mail)" <[EMAIL PROTECTED]> emed.com> cc: Sent by: Subject: [KCFusion] Database issue on development laptop [EMAIL PROTECTED] fusion.org 03/21/03 11:09 AM Please respond to CF-List I'm setting up a Windows2000 laptop with CF developer version to work on a project while at home. The problem is, this project normally interacts with an MSSQL database only available inside our network. I need it to work at home without being connected to the internet, and it doesn't matter if I'm using the real data. The only changes I'm planning are in the CF application templates. Is there some quick way to duplicate the database setup without installing MSSQL on the laptop? Maybe have MSSQL output the relevant databases in some other format that I can load on the laptop? I've never attempted this before, so I'm open to suggestions. Keith Purtell, Web/Network Administrator VantageMed Operations (Kansas City) Email: [EMAIL PROTECTED] CONFIDENTIALITY NOTICE: This email 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 by reply email and destroy all copies of the original message. --- [This E-mail scanned for viruses by Declude Virus] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
Re: [KCFusion] CF hosting non-profit
very resonable. they have several packages to chose from. http://www.efree2net.com/item_detail.cfm?item_no=13 "Keith Purtell" <[EMAIL PROTECTED] To: "KCFusion (E-mail)" <[EMAIL PROTECTED]> emed.com> cc: Sent by: Subject: [KCFusion] CF hosting non-profit [EMAIL PROTECTED] fusion.org 03/14/03 09:35 AM Please respond to CF-List I have my own private domain name with two sites; my family genealogy and a catch-all site with articles on various topics. I've been paying $200/year for CF hosting (one of the sites uses some CF). The host company wants to raise that to $300/year. I can either find a much cheaper company or give up the minimal CF functions (small bulletin board, etc). Suggestions? Keith Purtell, Web/Network Administrator VantageMed Operations (Kansas City) Email: [EMAIL PROTECTED] CONFIDENTIALITY NOTICE: This email 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 by reply email and destroy all copies of the original message. --- [This E-mail scanned for viruses by Declude Virus] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] Simple Query Question
Depend on what the data type of the field you are calling from the table. If it is a numeric field you will not need to have any ' around the numeric values, but if the data type is varchar / char then you will have to have ' around the string. varchar/char select * from table where field1='value1' AND field2 IN ( 'a','b','c') select * from table where field1='value1' AND field2 IN (1,2,3,4) Chris Holdman <[EMAIL PROTECTED] To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> KS.ORG>cc: Sent by: Subject: RE: [KCFusion] Simple Query Question [EMAIL PROTECTED] fusion.org 03/13/03 04:35 PM Please respond to CF-List I am not receiving any errors but I am not receiving any records and when I do a record count I get 0. Also, why couln;t I just skip the and put #form.value2# instead of #hlist#. Christopher V. Holdman Webmaster - City of Olathe (913) 971-6286 (913) 238-4681 Cell [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2003 4:11 PM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] Simple Query Question not setup exactly like you have it but you can use the IN sql statment with your list of variables it does not require you to split it up select * from table where field1='value1' AND field2 IN ( ' #hlist# ' ) Chris Holdman <[EMAIL PROTECTED] To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> KS.ORG>cc: Sent by: Subject: [KCFusion] Simple Query Question [EMAIL PROTECTED] fusion.org 03/13/03 03:58 PM Please respond to CF-List I have a form with a multiple select box that I am want to build a query from, but am having problems. I set up an index loop with an OR statement, but I have obviously set it up wrong beacuase it is adding an OR to the end of the query. How do I set it up to not put an OR after the last index? select * from table where field1='value1' AND ( field2='#index#' OR ) Christopher V. Holdman Webmaster - City of Olathe (913) 971-6286 (913) 238-4681 Cell [EMAIL PROTECTED] -Original Message- From: Dunwiddie, Bruce [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 3:16 PM To: '[EMAIL PROTECTED]' Subject: RE: [KCFusion] Printer Friendly Directory Listing style="page-break-after: always" if you say apply that to a tag, and then have multiple tables each having that style, it will have a page break between them. of course, I'm sure it's only ie, but better than nothing. -Original Message- From: Chris Holdman [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 3:03 PM To: '[EMAIL PROTECTED]' Subject: [KCFusion] Printer Friendly Directory Listing I have a directory listing pulling from a database and sorting by departments. Everything work great online, but some people are wanting to print it out...when they do sometimes the page break for printing occurs in the middle of a department listing and the second page does not have the department title. Is there a way
Re: [KCFusion] Simple Query Question
not setup exactly like you have it but you can use the IN sql statment with your list of variables it does not require you to split it up select * from table where field1='value1' AND field2 IN ( ' #hlist# ' ) Chris Holdman <[EMAIL PROTECTED] To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> KS.ORG>cc: Sent by: Subject: [KCFusion] Simple Query Question [EMAIL PROTECTED] fusion.org 03/13/03 03:58 PM Please respond to CF-List I have a form with a multiple select box that I am want to build a query from, but am having problems. I set up an index loop with an OR statement, but I have obviously set it up wrong beacuase it is adding an OR to the end of the query. How do I set it up to not put an OR after the last index? select * from table where field1='value1' AND ( field2='#index#' OR ) Christopher V. Holdman Webmaster - City of Olathe (913) 971-6286 (913) 238-4681 Cell [EMAIL PROTECTED] -Original Message- From: Dunwiddie, Bruce [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 3:16 PM To: '[EMAIL PROTECTED]' Subject: RE: [KCFusion] Printer Friendly Directory Listing style="page-break-after: always" if you say apply that to a tag, and then have multiple tables each having that style, it will have a page break between them. of course, I'm sure it's only ie, but better than nothing. -Original Message- From: Chris Holdman [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 3:03 PM To: '[EMAIL PROTECTED]' Subject: [KCFusion] Printer Friendly Directory Listing I have a directory listing pulling from a database and sorting by departments. Everything work great online, but some people are wanting to print it out...when they do sometimes the page break for printing occurs in the middle of a department listing and the second page does not have the department title. Is there a way to determine where a printing page break will occur and force the follwoing page to repeat the department title. Below is an example of what I mean and the code I currently use. Department A address phone # - name phone # - name phone # - name Department B address phone # - name phone # - name phone # - name phone # - name phone # - name phone # - name phone # - name phone # - name phone # - name [page break] Department B address phone # - name phone # - name phone # - name Department C address phone # - name phone # - name phone # - name #Department# #building# #Ext# - #Name# Christopher V. Holdman Webmaster - City of Olathe (913) 971-6286 (913) 238-4681 Cell [EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http
RE: [KCFusion] Problems creating SQL Server datasource
When you were creating the did you create the data source in the ColdFusion administrator? Connecting to a data source with ODBC Socket In ColdFusion 5, an ODBC Data Source Name (DSN) entry that was created with the ODBC Data Source Administrator would automatically show up in the list of data sources in the ColdFusion Administrator. It does not in ColdFusion MX; you must manually add the ODBC DSN entry. To manually add the ODBC DSN entry: 1. In the ColdFusion Administrator, select Data & Services > Data Sources. 2. In the Add New Data Source Name box, do the following: a. In the Data Source Name text box, enter the data source name. You can use the same name as the ODBC DSN entry. b. In the Driver drop-down list box, select ODBC Socket. c. Click Add. 3. In the ODBC DSN drop-down list box, select the ODBC DSN name. 4. Click Submit. "Cold Fusion" <[EMAIL PROTECTED] To: [EMAIL PROTECTED] com> cc: Sent by: Subject: RE: [KCFusion] Problems creating SQL Server datasource [EMAIL PROTECTED] fusion.org 03/05/03 03:01 PM Please respond to CF-List Sorry for the vagueness of my earlier message. I find errors in two places. First, there is the error that CFAdmin throws when it can't verify the datasource. Connection verification failed for data source: MYDSN []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. Also, I found the following errors on the machine that is running ColdFusion Server. The description for Event ID ( 0 ) in Source ( ColdFusion MX ODBC Agent ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: ColdFusion MX ODBC [EMAIL PROTECTED],ErrorCode=3012,ErrorMessage=Configuration file was changed by someone else.,ClientHost=10.110.71.24,Session=33. The description for Event ID ( 0 ) in Source ( ColdFusion MX ODBC Agent ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: ColdFusion MX ODBC [EMAIL PROTECTED],ErrorCode=3012,ErrorMessage=Configuration file was changed by someone else.,ClientHost=10.110.71.24,Session=5,ClientUserName=Domain\User. The description for Event ID ( 0 ) in Source ( ColdFusion MX ODBC Server ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: ColdFusion MX ODBC [EMAIL PROTECTED],ErrorCode=2310,ErrorMessage=TCP/IP, connection reset by peer. I don't see any messages in the CF Server log or SQL Server Event Viewer. Phil _ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail __
RE: [KCFusion] file property
How is the data file being created? Is is being exported from another DBMS? Is it getting generated through a program? "Dunwiddie, Bruce" To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> Subject: RE: [KCFusion] file property Sent by: CF-List-owner@kcf usion.org 01/24/03 03:42 PM Please respond to CF-List There's got to be something else, something akin to file attributes. -Original Message- From: Keith Purtell [mailto:[EMAIL PROTECTED]] Sent: Friday, January 24, 2003 3:37 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] file property If there is no special header, then the only way Windows knows how to handle a file is by looking at the file name extension (doc, html, pdf, cfm, etc.). Of course that can vary from one machine to another. Keith Purtell, Web/Network Administrator VantageMed Operations (Kansas City) Email: [EMAIL PROTECTED] CONFIDENTIALITY NOTICE: This email 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 by reply email and destroy all copies of the original message. > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > Behalf Of Dunwiddie, Bruce > Sent: Friday, January 24, 2003 1:50 PM > To: '[EMAIL PROTECTED]' > Subject: RE: [KCFusion] file property > > > In hex edit mode, the files are the exact same as far as I > can see, but I > still need to spend some more time comparing, but definitely > no headers at > the beginning of the data. That's why I'm assuming it's > something more low > level. > > -Original Message- > From: Keith Purtell [mailto:[EMAIL PROTECTED]] > Sent: Friday, January 24, 2003 1:12 PM > To: [EMAIL PROTECTED] > Subject: RE: [KCFusion] file property > > > Is there a section near the top that might be a header > containing that kind > of information? > > Keith Purtell, Web/Network Administrator > VantageMed Operations (Kansas City) > Email: [EMAIL PROTECTED] > > CONFIDENTIALITY NOTICE: This email 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 by reply email and destroy all copies of > the original > message. > > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > Behalf Of Dunwiddie, Bruce > Sent: Friday, January 24, 2003 12:13 PM > To: '[EMAIL PROTECTED]' > Subject: [KCFusion] file property > > > I've got a problem that is currently just beyond my knowledge of file > properties and encoding types and all that fun. I've got a > data file that > needs to be imported into sql server and sql server doesn't > like it for some > odd reason. After playing around with it a bit, we've found > that if we open > it up in a plain text editor and copy/paste the contents over > to another > plain text file and save that file, it works just fine. Also, if the > original file is opened in UltraEdit, it's by default being > opening in hex > edit mode as opposed to plain text mode which is how the > second file gets > opened and how most plain text files get opened in UltraEdit. > What is it > about this file that is causing this? Is it some form of file property
[KCFusion] coldfusion mx tags
I recently purchased the MX Studio, but I am not liking the Dreamweaver MX tool. I was wondering two things: 1) Is there a way I can place the new ColdFusion MX tags (.vtm files) into the ColdFusion 5 Studio tag definitions folder. 2)How would I do that so ColdFusion 5 Studio would recognize the new tags? Matt Bassham __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
Re: [KCFusion] error var
What is the error type you are catching. #Error.template# is correct a variable but it can only be use on Request, Exception and Monitor error types. It is not available for Validation error types. matt "Adaryl Wakefield" To: <[EMAIL PROTECTED]> <[EMAIL PROTECTED] cc: > Subject: [KCFusion] error var Sent by: CF-List-owner@kc fusion.org 11/26/02 02:40 PM Please respond to CF-List I set it up so I get an email when ever one of my apps tosses an error. Except it seems that #error.template# is not working. I got that variable from a WROX professional book . Before I go digging around the discussion boards anybody know off the top of their head what the right variable is supposed to be? Im using CF 5. A. __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]