RE: Storing Credit Cards
Jeff I would also be interested in knowing if anyone is aware of a third party clearing house or payment processor that can provide a very secure credit card storage service. Check out WorldPay's FuturePay service: http://www.worldpay.com/sg/products_services/product_selection/billing.shtml See it in action *and* make a donation to protect the world's rainforests and the people who live in them :-) http://www.rainforestfoundationuk.org/tFundraising.htm The idea is that your site never even sees the credit card details. The customer gets sent to WorldPay's site to perform the credit card authorisation, then they get sent back to a designated page on your site (you can customise the appearance of the WorldPay page to make it look like part of your site.) They only have to do this once and WorldPay remember the details for use in future months. You pay a slice of every transaction to WorldPay, but you might decide it's worth it for the peace of mind and convenience. Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ 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: XML-XSL-CF_SOXML
Timur What are other ways to transform XML and XSL into HTML using Cold Fusion and MSXML DOM object. If you're using CF5, there is a UDF at CFLib.org that does this. I haven't used it myself. http://www.cflib.org/udf.cfm?ID=147 Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ 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: break
Aidan It's based on 'C' syntax, which itself isn't very far removed from machine code - the switch statement is really just a glorified set of goto statements. If you don't put the break in, it drops through to the next case. But it can be useful sometimes if you want to do some processing for case A and then some processing for case A or B - though making use of that results in very un-maintainable code. It's certainly a rich source of bugs, whatever language you're using. Nick -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 27, 2001 10:19 AM To: CF-Talk Subject: break Is there any good reason why CFSCRIPT requires the inclusion of a break; statement at the end of each case? It took me a while after looking at Advanced CFWACK 4 (where break; doesn't appear) and digging around the archives to find out that it's needed. And it just left me thinking... why? Aidan -- Aidan Whitehall [EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental +44 (0)1695 51775 ~~ 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: break
every other bit of CFML is geared towards making it a simple language I agree, but the idea of CFScript on the other hand is to be as close as possible to JavaScript - except where that was too difficult to implement. Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ 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: SQL- Column datatype on an empty table
Bill I'm needing to get a list of the datatypes and maxlength properties of the columns of an empty table Something like this: select column_name, data_type, character_maximum_length from information_schema.columns where table_name = 'whatever' Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ 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: perl function for round-up
what's the perl function to round up a decimal value? ceil() rounds up to the next integer. It's in the POSIX module. ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ 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: MODIFY sql command
Will I need to modify a table on one of my Databases - to add 2 Yes/No fields. The DB is Access, and the table name Pending. alter table pending add column col1 yesno, col2 yesno; Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ 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: MODIFY sql command
Will, Sorry, what do you mean by it isn't - just says the format is blank? Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ 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: SQL question about JOIN
There is no reason to, unless you need to make sure that you will get all the relevant records from one or more of the tables regardless of whether they have corresponding records in the other tables. That's what an outer join is for. If you put a row into JOBINFO with no corresponding rows in the ACTIVITYLOG, the 2 queries will return different data. If that's an impossible situation, then the second query is fine. Nick -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 18, 2001 6:45 PM To: CF-Talk Subject: SQL question about JOIN The first query takes 9seconds to process, the 2second query takes 1seconds to process. They return the same data. Why should you use an LEFT OUTER JOIN, or any JOIN for that matter when you can say WHERE JOBINFO.JOBNUM = ACTIVITYLOG.JOBNUM??? cfquery name=ACTIVITIES datasource=servalent dbtype=ODBC SELECT JOBINFO.JOBNUM, JOBINFO.JOBNAME, JOBINFO.COMPANYNAME, ACTIVITYLOG.LOGIN, ACTIVITYLOG.LOGOUT, ACTIVITYLOG.EMPLOYEENAME, ACTIVITYLOG.EMPLOYEENUM, ACTIVITYLOG.ACTIVITYDESCRIPTION FROM JOBINFO LEFT OUTER JOIN ACTIVITYLOG ON JOBINFO.JOBNUM = ACTIVITYLOG.JOBNUM WHERE ACTIVITYLOG.EMPLOYEENUM = #EMPLOYEENUM# AND ACTIVITYLOG.LOGOUT is null AND ACTIVITYLOG.LOGIN is not null ORDER BY JOBINFO.JOBNUM, ACTIVITYLOG.LOGIN /cfquery cfquery name=ACTIVITIES datasource=servalent dbtype=ODBC SELECT JOBINFO.JOBNUM, JOBINFO.JOBNAME, JOBINFO.COMPANYNAME, ACTIVITYLOG.LOGIN, ACTIVITYLOG.LOGOUT, ACTIVITYLOG.EMPLOYEENAME, ACTIVITYLOG.EMPLOYEENUM, ACTIVITYLOG.ACTIVITYDESCRIPTION FROM JOBINFO, ACTIVITYLOG WHERE JOBINFO.JOBNUM = ACTIVITYLOG.JOBNUM AND ACTIVITYLOG.EMPLOYEENUM = #EMPLOYEENUM# AND ACTIVITYLOG.LOGOUT is null AND ACTIVITYLOG.LOGIN is not null ORDER BY JOBINFO.JOBNUM, ACTIVITYLOG.LOGIN /cfquery ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ~~ 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: CFQUERYPARAM and version
Aidan, Yes, it was new in 4.5. Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ~~ 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: .biz domains ... what are the issues?
.biz domains are global, so when you've got a name you've got it worldwide, whereas .com, .co.nz, .com.au, .co.uk etc aren't. com is supposed to be global. Isn't it? Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ~~ 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: ColdFusion license agreement
You know what? I hadn't tried setting up a new datasource since I installed it. You're right, it doesn't work. (NT4.0 here) IO Error on server communication hmm... need to have a look around... Nick -Original Message- From: Freddy [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 06, 2001 12:20 AM To: CF-Talk Subject: Re: ColdFusion license agreement what did you do to get the browse function to work for setting up datasources et al? I have installed numerous times on multiple boxes (all with win 2000 pro) and can not get the browse applets functioning even with an service contract and numerous calls to our allaire support guy. Thanks, GFrederic DeVoil, Nick wrote: Anything I should be aware of when installing CF Server 5 on NT with Apache?? No, I have that combination right here it's fine. Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ 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: SQL SERVER Usage Question
It's a small record set. As long as the queries are designed properly and it's indexed you'll be fine with a shared SQL Server - unless you mean *really* intensive. The size of the database isn't really as significant as the number of concurrent accesses. Nick -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 7:56 PM To: CF-Talk Subject: SQL SERVER Usage Question I have a client who's new site will have a 20,000 record song catalog. The site is search intensive. Is this a small record set? Should I consider a dedicated SQl Server or can I use a shared SQL server without a huge impact on the SQL Server usage. The SQL Server is 7,0, 1 gig of ram and a dual 550 processor with RAID 1. Thanks for the advise, I realize the question is a little vague. ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ 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: ColdFusion license agreement
Anything I should be aware of when installing CF Server 5 on NT with Apache?? No, I have that combination right here it's fine. Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ 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: Quick format question
How is it done in the sql statement. As always with anything to do with string functions or date functions, the answer is, it depends what DBMS you're using. Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ 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: help with moving from access to sql server
Why do you need the GROUP BY clause at all? I don't see any aggregate functions (COUNT, SUM etc) Also, which column is a bit column and does it really need to be? Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ 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: ColdFusion license agreement
If not, how do I get around the problem with out having to buy a copy? If you have CF Studio, you can use the single-user version that comes with that. I think that has all the tags. Unless you want Server 5, that is, in which case you have to wait for Studio 5. ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ 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: CF5 Pro SN
and me! If only they were that efficient about sending the fleeces from the Server 5 beta Giveaway ;-) Did *anyone* get one? Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ 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: Catching page timeouts
Can I catch the page timeout error at all ? I haven't tried it myself but the list of Advanced Exception Types includes COM.Allaire.ColdFusion.Request.Timeout Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ 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: Catching page timeouts
What if you put that code on your custom error page? -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Monday, September 03, 2001 2:39 PM To: CF-Talk Subject: RE: Catching page timeouts COM.Allaire.ColdFusion.Request.Timeout Yeah, I have cftry at the top of the page, and a closing /try at the end, with a catch of type=COM.Allaire.ColdFusion.Request.Timeout, but the error normal error is still printed to the page instead of mine. ~~ 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: CF5 Pro SN
Call me sceptical, but I don't think someone called Mr Warez is likely to be in the business of making honest mistakes. ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ 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: MS SQL 7/2k File Size
Does anyone know of a way in SQL (as opposed to enterprise manager) to get the file size of a MS SQL database? sp_helpdb() Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ 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: ms sql to ms access
Lorenzo i have a sql script and i wont this to became an access db Can you post the script? ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ 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: Looping through lists
Chris, This isn't what you want to hear, but really your database design needs changing so that each keyword is in a separate row. If that's not an option, you could read the list of keywords and do a ListFindNoCase() on it. That will be incredibly slow though, if you do it for every entry in a large database. Nick -Original Message- From: Chris Geanious [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 22, 2001 5:01 AM To: CF-Talk Subject: Looping through lists Greetings, Am constructing a db search using (among other things) a form text area for keywords. In the data base there is a KeyWords field which contains a comma delimited list of keywords for each entry. I have a query which loops over the form text box entries. How do I then loop over the database keyword fields to check for a match? I am a little stuck. Any suggestions, code snippets, links to sites would be greatly appreciated. TIA, Chris == Chris Geanious Support Systems Analyst Senior Institute For Human Development Northern Arizona University ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ 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: db structure question
Paul, wouldn't it be just as fast to stick the actual unique value of the look up table into the tbl_Mast_Table? Yes it would. However, I find that using a unique autonumber ID for every single table makes coding more standardised therefore faster. Don't quite understand your second point. Why does the app have to throw an error if the empoyee is misssing - can't it just handle that? Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ 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: ms sql to ms access
Something like this should work. 1. Make the following changes to the script: Take out statements like the first one. Remove all the square brackets Change IDENTITY(...) to int Change smalldatetime to date Change varchar () to text (Also if there are any text fields change them to memo... there are some other SQL Server datatypes that Access doesn'tunderstand as well) 2. Create an empty database. 3. Run the script (Query-New-SQL) 4. Manually change the int keys to autonumbers 5. If you want any constraints, set these up in the Relationships view Nick -Original Message- From: Lorenzo Imperatrice [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 22, 2001 10:42 AM To: CF-Talk Subject: RE: ms sql to ms access if exists (select * from dbo.sysobjects where id object_id(N'[dbo].[UserProfiles]') and OBJECTPROPERTY(id, N'IsForeignKey') 1) ALTER TABLE [dbo].[Invoices] DROP CONSTRAINT UserProfiles GO CREATE TABLE [dbo].[UserProfiles2] ( [UserID] [int] IDENTITY (100, 1) NOT NULL , [CompanyID] [int] NOT NULL , [Username] [varchar] (50) NULL , [Password] [varchar] (50) NULL , [Datestamp] [smalldatetime] NULL , [Email] [varchar] (255) NULL , [TaxID] [varchar] (20) NULL , [Hourly] [int] NULL , [Percentage] [int] NULL , [Payroll] [decimal](18, 0) NULL , [PayrollStart] [datetime] NULL , [PayrollEnd] [datetime] NULL , [SocialSecurityTax] [money] NULL , [FederalTax] [money] NULL , [StateTax] [money] NULL , [Company] [varchar] (255) NULL , [PrimaryAcct] [int] NULL , [FirstName] [varchar] (255) NULL , [LastName] [varchar] (255) NULL , [Address1] [varchar] (255) NULL , [Address2] [varchar] (255) NULL , [City] [varchar] (100) NULL , [State] [varchar] (50) NULL , [Zip] [varchar] (15) NULL , [Phone] [varchar] (50) NULL , [Fax] [varchar] (50) NULL , [Browser] [varchar] (100) NULL , [Description] [text] NULL , [Image] [varchar] (50) NULL , [LeftOver] [money] NOT NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO this a part of the script L -Original Message- From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] Sent: mercoledì 22 agosto 2001 11.26 To: CF-Talk Subject: RE: ms sql to ms access Lorenzo i have a sql script and i wont this to became an access db Can you post the script? ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ 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: History table
Can anyone advise if its possible to extract the page title from the browser history table No, it's not possible (for security reasons). Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ 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: SQL Syntax - table structure
Try sp_columns() Nick -Original Message- From: Mak Wing Lok [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 1:46 AM To: CF-Talk Subject: OT: SQL Syntax - table structure hi, this might sound stupid but i have forgotten the command. does anyone know the command to view a table structure on a database for SQL/Sybase? ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ 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: Database query question
What do you mean by output a single row? You mean sth like FoodName MoreFoodInfo Nutrient1 Value Nutrient2 Value. - - - - Name more stuff ENERGY-SOA 191.574 PROT FAT where the number of columns is controlled by the number of rows in NIP_Nutrient for that food? If so, you can't do it in one SQL statement. Presumably you are doing this in CF though, in which case you can just join the tables: SELECT F.col1, F.col2 N.value, N.nutrient FROM NIP_FOOD F, NIP_Nutrient N WHERE F.FOOD_ID = N.FOOD_ID and then use CFML to build up the display row by looping through the 7 dataset rows returned. Nick -Original Message- From: Tilbrook, Peter [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 1:38 AM To: CF-Talk Subject: Database query question I've been given a massive (130Mb) Access database with two tables. NIP_FOOD and NIP_Nutrient. NIP_FOOD contains a unique ID field which is Alphanumeric (eg: 01A10014). NIP_Nutrient contains a field called FOOD_ID which is seven seperate rows of the same value as ID (but not linked). eg: FOOD_ID VALUE NUTRIENT 01A10014191.574 ENERGY-SOA 01A100140.4 PROT 01A100140 FAT 01A100140 TOTSATFD 01A100142.492 CHO-SOA 01A100140 TOTSUG 01A1001410 NA-SOA What would be the way to retrieve all of the fields from both tables using the value (eg: 01A10014) but have it output a single row? It will stay in Access until I can get IT to port it to SQL Server or Oracle. Thanks! Peter Tilbrook ColdFusion Applications Developer Australia New Zealand Food Authority Boeing House 55 Blackall Street BARTON ACT 2600 Ph: +61-2-6271 2256 Fax: +61-2-6271 2278 http://www.anzfa.gov.au ** This transmission is intended only for the use of the addressee(s) and may contain confidential or legally privileged information. If you are not the intended recipient, you are notified that any use or dissemination of this communication is strictly prohibited. If you have received this transmission in error, please notify the ANZFA IT helpdesk prior to deleting all copies of this transmission together with any attachments. ANZFA helpdesk: E-mail: [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** ~~ 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: GTE problem
CF5 Pro, 2K - anyone got NT still ? Yes, it works for me on NT4.0 too. ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ 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
cfusion_dbconnections_flush() - is it safe?
I'm using cfset cfusion_dbconnections_flush() to unlock a database. Access 2000, NT4. The function does successfully delete the .ldb file and the .mdb file can then be re-opened OK. But afterwards, when I open the .mdb file using Access itself, on exiting Access I get an error message There was a problem sending the command to the program. So I'm worried that cfusion_dbconnections_flush() is doing something nasty to the database. Does anyone know if this function is safe or not? Thanks Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: XML db
I'd put XML documents into 2 categories - 1. Data-driven - containing a serialized version of some highly structured business data that might have come out of/be going into a relational DB, but is put in an XML form for standardized transport purposes; 2. Text-driven - where the data is much less structured and the emphasis is more on the markup aspect. Used in content management systems, for example. Seems to me that apps based on the latter sort of XML doc can benefit enormously from a native XML DBMS. You could envisage building an entire content management system without using an RDBMS at all (In fact I've done it with no DBMS of any description, just using XML text files CF, but I wouldn't recommend it!) But the first sort - more traditional apps - can really benefit more from all the advantages that a traditional RDBMS gives you. Maybe I'm wrong the XML technology is more mature than I think... Surely you will always get better performance from a traditional RDBMS for highly structured data. I believe that the market leading native XML DB is Software AG's Tamino? http://www.softwareag.com/tamino/ Nick -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 14, 2001 12:47 AM To: CF-Talk Subject: SOT: XML db A friend, who's technical expertise I greatly respect (He put me on to CF), has taken over as CEO of a company that makes an XML database engine. My first reaction was What good is that? The more I think about it, I can see some real uses and advantages over RDBMS for certain uses. It is written in Java 1.3, as a db server, with a Java API. The API is also accessible as a CORBA object. So far it is not installed anywhere where I can try to access it through CF. It is available as open source for installation on any machine with a stable JDK 1.3 - Windows, Linux, Mac OS X. I am trying to figure where it would be useful vis-a-vis standard RDBMS and the WDDX facilities within CF. Anyone have any thoughts or opinions on this? TIA Dick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: JavaScript
Jerry Something like document.forms[0].total.value = parseInt(document.forms[0].a.value) + parseInt(document.forms[0].b.value) + parseInt(document.forms[0].c.value); Nick -Original Message- From: Jerry Staple [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 9:33 AM To: CF-Talk Subject: JavaScript Hi, Could anyone inform me of any javascript function that takes the total of numbers entered into a textbox and displays them in another? eg form name=form1 Item a = 2 (number in text box) Item b = 3 Item c = 4 Total = 9 (this total is generated by adding the items in the textboxes above) /form Any help will much apreciated Jerry Staple Jerry Staple Web Applications Developer BizNet Solutions 133 - 137 Lisburn Rd Belfast BT9 7AG Tel: +44 (0)28 9022 3224 Fax: +44 (0)28 9022 3223 www.biznet-solutions.com ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF XML-RPC
OK, it's not on the web, but the new Wrox book Professional ColdFusion 5.0 has details on how to use SOAP with CF. Also (still not on the web) O'Reilly have a book on XML-RPC. But if it's SOAP you want, then why not go straight with SOAP? Nick -Original Message- From: Michael S. Kimmett [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 12, 2001 3:28 AM To: CF-Talk Subject: CF XML-RPC I am trying to learn how to make XML-RPC calls in Coldfusion. Is there anywhere on the web that I can l look at example code to learn how to make a XML-RPC call in Coldfusion. I want to use this as a base of knowledge to make a Coldfusion RPC call to a SOAP server. Thanks in advance. Michael ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Get Table names, and Field Names
Is there a SQL command, or CF Function that can get the names of all the tables in a database? Chad It depends what DBMS you're using. If it's Access, look here http://www.thenetprofits.co.uk/coldfusion/faq/#answer77 Otherwise I believe the following queries are mostly correct: Ingres:SELECT relname FROM iirelation Oracle:SELECT table_name FROM user_tables PostgreSQL:SELECT relname FROM pg_class MS SQL Server: SELECT name FROM sysobjects WHERE type = 'U' Informix: SELECT tabname FROM systables WHERE tabtype = 'T' Sybase SQL Server: SELECT name FROM sysobjects WHERE type = 'U' MySQL: Can't be done using simple SQL commands. Aidan, maybe you could add these to the FAQ? Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF XML-RPC
Michael The SOAP example in the book doesn't use any CF features that aren't in CF4.5, unless I'm missing something. The requester just uses the MS objects XMLHTTPRequest and XMLDOM via CFOBJECT. Nick -Original Message- From: Michael S. Kimmett [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 12, 2001 2:02 PM To: CF-Talk Subject: Re: CF XML-RPC All of the examples that I have seen on the web (Note: I have not seen one CF example yet) use a RPC call to a proxy server. The proxy server then translates the XML that I sent to the proxy server into the SOAP message. I know that this is not true SOAP, but it seems that this is the only solution that I have seen that works. I can not go to CF5.0. The client wants us to stay with 4.5. Any other suggestions out there? --Michael - Original Message - From: DeVoil, Nick [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, July 12, 2001 3:28 AM Subject: RE: CF XML-RPC OK, it's not on the web, but the new Wrox book Professional ColdFusion 5.0 has details on how to use SOAP with CF. Also (still not on the web) O'Reilly have a book on XML-RPC. But if it's SOAP you want, then why not go straight with SOAP? Nick -Original Message- From: Michael S. Kimmett [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 12, 2001 3:28 AM To: CF-Talk Subject: CF XML-RPC I am trying to learn how to make XML-RPC calls in Coldfusion. Is there anywhere on the web that I can l look at example code to learn how to make a XML-RPC call in Coldfusion. I want to use this as a base of knowledge to make a Coldfusion RPC call to a SOAP server. Thanks in advance. Michael ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Define and Call UD-Functions
Patrick You can certainly use the Caller scope in your custom tag. That will pick up a UDF defined in application.cfm. Nick -Original Message- From: Wagner Patrick [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 11, 2001 4:26 PM To: CF-Talk Subject: Define and Call UD-Functions Hi there! I just started playing around with the UserDefined-functions in CF5 and found a strange issue making it nearly impossible to get any value of it. For example when defining global-functions in the application.cfm there seems to be no way to use these in a sub-called customtag. Is there a possiblity to reference the function created on top within the customtag without defining it new? Or simply, is there a way to make the functions available in the request-(scope)? Best Regards Patrick Wagner Application Engineer conceptware ag ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
WOT: Flash questions
I've asked this on a couple of Flash lists but I guess the question is so badly framed that no-one knows what I'm on about. But I know you guys are patient some of you are pretty good with Flash so I'll try here. I am designing a database-driven web app which has 2 particular features: - some of the content is defined in an XML format where some elements are chunks of raw HTML, some are more abstract elements which have to be turned into HTML by a JSP. The idea is that the JSP goes through the XML sequentially and throws the HTML onto the page, generating it where necessary. - some of the XML contains text items which have to be put on the page in such a way that they can be dragged dropped into various text boxes etc, and then the contents submitted to the server in an HTML form. This is fine in an HTML context. I can envisage writing a generic JSP to create the page out of any XML file that's in the right format. Now the customer says to me, how about building the user interface not in DHTML but in Flash? I'm not competent in Flash so I don't know if this is feasible or not. Specifically: - is it possible to have a Flash movie which presents a stream of generic text, not known until runtime, in the same sort of way that a browser processes HTML? - do objects all have to be positioned individually on the screen, or can they flow onto it as in HTML? - Is it possible to have a Flash movie that builds a drag-and-drop feature out of generic text or images which are not known until runtime? - Is it possible for the Flash movie not only to send information back to the server, but send back unpredictable information? I mean, in a CF page you can easily have processing which puts an unpredictable number of form fields onto the page, plus the associated processing - can you do that if you're using Flash? Do I need Generator to do any of this? Does WDDX help? Would really appreciate any insight here. Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL select all BUT
No. -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 28, 2001 5:21 PM To: CF-Talk Subject: ot: SQL select all BUT Is there a way to run a select statment that fetch ALL (*) colums BUT colum5,coulm6 something which is similiar to: SELECT colum1,colum2,colum3,colum4 ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Purchasing a copy of ColdFusion Server in the UK
Anyone know where I can purchase a copy of ColdFusion Server in the UK? http://www.highlander.co.uk Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Window Size to fit desktop area
James How about window.open('http://www.houseoffusion.com','x','width='+screen.availWidth+', height='+screen.availHeight+',top=0,left=0') Nick -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Monday, July 02, 2001 5:58 PM To: CF-Talk Subject: OT: Window Size to fit desktop area I believe this will get posted since the list seems to be working again. Still waiting for the dump of old messages. I wanted to know when opening a new window using javascript, is there a way for the window to be the size of the desktop area with out defining numeric values for width and height? I tried using * instead of numeric values, but the result I got was a smaller window than I originally had. Thanks in advance, James ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT Javascript question
Andy Does this work? function test(controlnum) { elt = document.forms[0][interest + interest]; elt.value = parseInt(elt.value) + 1; } Nick -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 24, 2001 12:18 PM To: CF-Talk Subject: OT Javascript question I'm having a mind blankarghhh. I'm trying to incremtnet the value of a control in a form by one where part of the controls name is poassed in as a variable. Probably best I explain with the code snippet: function test(controlnum) { document.forms[0].interest + interest + .value = eval(document.forms[0].interest + interest + .value) + 1; } I have tested using alert and the The RHS of the equation is computed correctly. I need to let javasript know that the LHS of the equation is an object in the page rather than just a string but I can't remeber how!anyone help ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Dynamic variable names
How about cfset thelist = cfloop from=1 to=3 index=id cfset thelist = ListAppend(thelist, Evaluate(form.fieldnum#id#)) /cfloop Nick -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 24, 2001 4:23 PM To: CF-Talk Subject: Dynamic variable names Can you have dynamic variable names in CF?e.g in an action page could you have something like - cfset thelist = cfloop from=1 to=3 index=id cfset thevalue = Evaluate(form.fieldnum #id#) cfset thelist = ListAppend(thelist, thevalue) /cfloop where there are form fileds fieldnum1, fieldnum2, and fieldnum3. I have tried this but it doesn't work.I thought you might be able to use the Evaluate function in this way as this works (from the Forta book): cfset x = Array cfset EVALUATE(p = x New(1)) This creates a new array stored in the variable p ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Self-referencing constraint in SQL Server 7
Aidan, Yes, I think you can have a FOREIGN KEY constraint referencing another column in the same table. NULL values are OK too. Nick -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 22, 2001 12:08 PM To: CF-Talk Subject: Self-referencing constraint in SQL Server 7 With this table CategoryID (PK) Category ParentCategoryID (NULL) is there any way within SQL Server 7 to create a constraint that checks on INSERT to see that the ParentCategoryID supplied is either NULL or exists as a value in the CateogoryID column? Thanks -- Aidan Whitehall [EMAIL PROTECTED] Netshopperuk Telephone +44 (01744) 648650 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Setting Dynamic Variables
How about cfset varName = form.Type GetInfo.CurrentRow cfset #varName# = Type Nick -Original Message- From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 2:27 PM To: CF-Talk Subject: Setting Dynamic Variables Trying to create a set of variables dynamically but cannot think of how to do it. Here is what I am trying to do: cfset Evaluate(form.Type GetInfo.CurrentRow) = Type It won't let me use the Evaluate() function on the left side though, does someone know of a way to do this? I can't think of anything. = Bernd VanSkiver [EMAIL PROTECTED] ColdFusion Developer ICQ UIN: 916324 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Server 7 book(s) recommendation
Aidan, I'm afraid this is a negative one as well, but on the strength of Amazon ratings I bought a very expensive M$ Press book called something like SQL Server 7.0 Database Implementation Kit which did include a 3-month eval of the DBMS but was very superficial. The only use I've found for it is that my 3-year-old daughter (4 tomorrow now I come to think of it) keeps some treasured belongings inside the box cover. For MS-SQL reference purposes I use the Books Online, which really is excellent, and/or the M$ web site. I believe the O'Reilly SQL book does a good job of explaining different SQL dialects a lot of people here have recommnded Joe Celko's SQL for Smarties and also one by Ben in the past.. haven't looked at any of them though. Nick -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 1:52 PM To: CF-Talk Subject: Re: SQL Server 7 book(s) recommendation I bought Lan Times Guide to SQL, and it was a good book to get my feet wet. It doesn't get into anything SQL Server specific though, and sticks to the standards. I also got the black Using SQL Server 7 from Que. I was totally underwhelmed, stay away from it. I now have 2 of the SQL Server 2000 Complete Reference books from Osborne which are great but 2000 specific so they wont help you. I'm not much help, but more info never hurts... jon - Original Message - From: Aidan Whitehall [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 15, 2001 8:28 AM Subject: OT: SQL Server 7 book(s) recommendation My SQL is a bit ropey and I want a decent book or two to plough through. I'm going to be working with SQL Server 7, so it would be great if anyone can recommend a book that covers both standard SQL (not necessarily from ground zero) and T-SQL as well. If not, are there two separate books you can recommend? I've bought SAMS Teach Yourself SQL in 21 days and am not all that impressed... Any thoughts? Thanks -- Aidan Whitehall [EMAIL PROTECTED] Netshopperuk Telephone +44 (01744) 648650 ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: query error
This message is usually caused by a permissions problem with the database. Is it set to read-only? Also suggest making that thread_time field an ODBC date/time. Nick -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 12:36 PM To: CF-Talk Subject: query error Hello, Must be having a brain spasm todayI am getting this error message: Message: ODBC Error Code = S1000 (General error) Error Code: -3035 SQL State: S1000 Detail: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. SQL = INSERT INTO tbl_threads (operaID, thread_title, thread_body, thread_author, thread_time) VALUES (32, 'hhdf', 'hsdfhdfh', 1, 14/05/01); This is the query that seems to be causing the problem: cfquery name=addthread datasource=#APPLICATION.chatdsn# INSERT INTO tbl_threads (operaID, thread_title, thread_body, thread_author, thread_time) VALUES (#url.operaID#, '#Form.thread_title#', '#Form.thread_body#', #checkauthor.authorID#, #dadate#); /cfquery Any ideas anyone? TIA Will ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFHTTP and port numbers
Thanks a lot Jeff, Yes it is rather simple once you RTFM realise there's a port number attribute... blush It's not in Ben's book for some reason, which is what I usually use for reference. Thanks Nick -Original Message- From: Garza, Jeff [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 4:24 AM To: CF-Talk Subject: RE: CFHTTP and port numbers Nick, This might sound rather simple, but are you using the port attribute of CFHTTP or typing it into the address line? cfhttp url=http://foo.bar.com; method=GET port=6660 resolveurl=true /cfhttp I don't think that http://foo.bar.com:6660 will work in the address line. Jeff -Original Message- From: DeVoil, Nick To: CF-Talk Sent: 5/10/01 1:07 AM Subject: CFHTTP and port numbers It seems that CFHTTP cannot connect to an address of the form http://foo.bar.com:6660 Can anyone confirm this and/or tell me how I can make an HTTP request to an address like this? Thanks Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: New Cold Fusion book, O'riely Press
Jeff, I agree that O'Reilly books are usually excellent. I don't know anything about this one. But you might like to know that Wrox are also bringing out a CF5 book. http://www.wrox.com/Books/Book_Details.asp?section=1_2isbn=1861004540 Nick -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 1:24 PM To: CF-Talk Subject: New Cold Fusion book, O'riely Press Hello cf-talk, I just saw a not yet available book by Rob Brooks-Bilson on Amazon called Programming Cold Fusion. I generally like what O'Rielly Press puts out. Any one know anything about this book? Any reviews from anywhere yet? Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] Internet Guns For Hire (603) 356-0768 ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFHTTP and port numbers
It seems that CFHTTP cannot connect to an address of the form http://foo.bar.com:6660 Can anyone confirm this and/or tell me how I can make an HTTP request to an address like this? Thanks Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: [Object Oriented CFML]
Can you call a JSP page as an object, pass parameters to it, have its variables and such encapsulated, etc? You can't do this with a JSP per se, but you can call Java classes from within a JSP. You can do it with a servlet. A servlet is a Java class. A JSP interpreter such as JRun turns JSP's into servlets. You can write servlets directly without the JSP stage. JRun also provides the servlet engine, i.e. the other Java classes you need to actually run the servlet. Neo, on the other hand, also turns CFML templates into Java servlets... which I think is pretty interesting. Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ASP NumberFormat
WTF? Is this a joke? -Original Message- From: Chris Maloney [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 8:04 PM To: CF-Talk Subject: RE: ASP NumberFormat Nathan, At first only your newsletters made me wonder about your lack of professionalism. Chris -Original Message- From: Nathan Stanford [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 10:58 AM To: CF-Talk Subject: RE: ASP NumberFormat Your treading on THIN ICE mentioning that COMPETITOR... grin Nathan Stanford Senior Programmer/Analyst [EMAIL PROTECTED] -Original Message- From: Bernd VanSkiver [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 10:23 AM To: CF-Talk Subject: OT: ASP NumberFormat Sorry about bringing ASP in to the list but am having troubles finding the solution and was hoping someone here might know the answer. I am needing a way to format a number in ASP similar to the CF function NumberFormat() Is there a function or something in ASP for this? I'm not sure if ASP even has built in support for this. I am programming the ASP in VBScript. = Bernd VanSkiver [EMAIL PROTECTED] ColdFusion Developer ICQ UIN: 916324 ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: MS Access JOIN Error
Does this work? FROM [MPA log] LEFT JOIN [52 log] ON [MPA log].[MPA #] = [52 log].[MPA #] Those table names and field names are pretty confusing. Is it an option for you to change the names so that they do not contain spaces, pound signs etc? Nick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 3:37 PM To: CF-Talk Subject: MS Access JOIN Error I'm getting the following error when trying to do a left join from an Access database from CF. I really don't know what I'm doing. Any clues would be appreciated Error Diagnostic Information ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver] Join expression not supported. SQL = SELECT MPA Log.Service/FCP/TL AS Service, MPA Log.MPA # AS MPAnumb, MPA Log.Position Title AS PositionTitle, MPA Log.Series, MPA Log.Grade, MPA Log.MPA Posted AS Open, MPA Log.Closing Date AS Close, MPA Log.Panel Reuired AS Panel, MPA Log.Cert Issued AS Cert, MPA Log.Status/Comment AS Comment, 52 log.Supervisor AS Supervisor FROM MPA log LEFT JOIN 52 log ON 'MPA log.MPA #' = '52 log.MPA #' Data Source = HRTRACKER The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (3:1) to (4:32). Date/Time: 05/09/01 10:06:18 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) Remote Address: 10.3.193.44 Thanks in Advance Doug Kronenberger OI National Training and Education Office Depatment of Veterans Affairs 440-526-3030 x7776 [EMAIL PROTECTED] ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: using WDDX for next 'n' style browsing
I guess you mean the database server. You're still making a trip to the *web* server for every page - and sending a lot of data. Without knowing exactly what you're trying to achieve, I'd guess cacheing the query would be better, yes. Nick -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 11:53 AM To: CF-Talk Subject: using WDDX for next 'n' style browsing I am passing a query object which consists of 1000 records in a hidden form field between pages as a WDDX packet, are there any reasons why this is a bad idea, such as limits to the amount of data which can be held in a form field or passed in a form? The reason for this is to save a trip to the server for each page of result. Are there any better solutions, would cacheing the query and executing it again for every page be more efficient than trying to offload the processing onto the client's machine? Thanks Kola ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: using WDDX for next 'n' style browsing
Right, that's exactly what cacheing the query will do for you. Nick -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 12:15 PM To: CF-Talk Subject: RE: using WDDX for next 'n' style browsing Nick yes, you're right the page still has to download with all the extra data, in addition to this turning the wddx packet into a javascript object (to be displayed)is adding extra processing to the page the page takes an average of 200 milliseconds. What i'm trying to acheive is an alternative to re-executing a query on every page request as a user browses through results returned from a search KOla -Original Message- From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] Sent: 08 May 2001 12:05 To: CF-Talk Subject: RE: using WDDX for next 'n' style browsing I guess you mean the database server. You're still making a trip to the *web* server for every page - and sending a lot of data. Without knowing exactly what you're trying to achieve, I'd guess cacheing the query would be better, yes. Nick -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 11:53 AM To: CF-Talk Subject: using WDDX for next 'n' style browsing I am passing a query object which consists of 1000 records in a hidden form field between pages as a WDDX packet, are there any reasons why this is a bad idea, such as limits to the amount of data which can be held in a form field or passed in a form? The reason for this is to save a trip to the server for each page of result. Are there any better solutions, would cacheing the query and executing it again for every page be more efficient than trying to offload the processing onto the client's machine? Thanks Kola ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfpop - how to display html content properly?
Try replacing with lt; and with gt; That does it for me. Nick -Original Message- From: Rudy Rustam [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 1:41 PM To: CF-Talk Subject: cfpop - how to display html content properly? Here is my scenario: Go to any website with a complex html like www.cnn.com or www.cnet.com Sent the page (not the link) to your popmail account. Use cfpop to retrive it. - The Problem (my problem) The mail doesn't show the html format properly, it's a mess html page. Is it possible that cfpop do some conversion to the mail content? All ideas are welcome. Thank in advance Regards, - Rudy ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: WDDX shows all the data!!!
If you convert it to JavaScript and send it to the browser, then of course you can see the data. If there's data you want to hide, don't send it to the browser. Nick -Original Message- From: Akbar Pasha [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 3:03 PM To: CF-Talk Subject: WDDX shows all the data!!! Hi all, is there a way to hide all the javascript that CFWDDX tag generates when action is CFML2JS its not only annoying but also shows up all the sensitive data that comes into it. Gosh now thats bad. any ideas?? TIA ::akbar ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ASP NumberFormat
http://msdn.microsoft.com/scripting/default.htm?/scripting/vbscript/doc/vsfc tFormatNumber.htm ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfmodule oddness
I guess nor does it try to find CFML tag variables means you also have to prefix attribute scope variables as well. It's not very clear, is it? I took it to mean ERROR returned by CFERROR, CFFTP returned by CFFTP etc. As opposed to FILE returned by CFFILE, CFHTTP. Of course, you're right that Attribute and Caller variables need prefixing too. Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Large recordset = large whitespace???
Have you got a p or br lurking around somewhere in the table, not correctly enclosed in td/td and tr/tr ? Nick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 2:43 PM To: CF-Talk Subject: Large recordset = large whitespace??? I have a query that can return several thousand records. When I run a query that only returns a small number ( lets say 15 or so, which is what I have seen), the page behaves fine, displays fine, etc. HOWEVER if I return a large number of records (1020, which is what I have seen), there is a huge amount of white space (like 2 page down's worth on a 1024 X 768 resolution) displayed before the table of results... in effect, making it look as if there was nothing returned, and all there is showing initially is the page header graphics. I've made sure everything that can be set to 0 is (margins, cellpadding, etc.) and that all the table elements are valigned to TOP... any other suggestions? Gina Shillitani ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Storing structures in a DB
as for normalizing; with a globally designed DB - it is not necessary; the logic is ported into the App. Well, sorry to bore people with this now slightly OT thread, but there's the rub - by storing all the data in one table you have thrown away all the inherent business-modelling capability of a relational database and made far *more* work for the developers, not less. Not only that, but you lose the ability of the DB design to serve as a central authoritative design document describing the enterprise rules. Not to mention performance and the fact that the database is now practically un-optimisable by the DBMS and un-tunable by the DBA. I worked on a client-server project exactly 10 years ago where the database designer tried the same approach. It didn't work. Obviously times have changed but.. the upside needs to be pretty good to outweigh all that. Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: slightly OT ADO vs DAO
DAO is a dead-end. ADO is more future-proof. Nick -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 10:51 AM To: CF-Talk Subject: slightly OT ADO vs DAO Hi all, I know this is slightly OT, but I wanted to get peoples opinions about ADO vs DAO in ACCESS2000. It's not something I'd looked at before to be honest, so was looking for general feedback, info on each etc, TIA Will ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is CF still relevant?
I shudder to recall those heady days when the popular challenge was I can write that APL program in 1 line but I don't remember what it does... and can't figure out how it does it! Unfortunately those days have not gone, on the contrary... s/APL/Perl/gi Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Storing structures in a DB
Darren The question isn't as simple as all that - the subject line says DB but the body says array. In both cases the answer is yes, but the details depend on what exactly you're trying to do. One way of storing a structure in a DB is to put it in a WDDX packet put that in a large text field. Otherwise of course you can have a table with one column for each field in the struct. Nick -Original Message- From: Darren Adams [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 9:39 AM To: CF-Talk Subject: Storing structures in a DB Hello, Just a simple question that probably has a simple answer. Can a structure be stored in an array so that it can be referrence at a later date ? Darren Adams Web Developer Marketing Department Systems Union Office: 01252 55 6220 Mobile: 07714 817 038 Email: [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Storing structures in a DB
I think you'll save yourself a lot of trouble later if you do a normalised database design with all necessary tables, columns etc and access them individually. Nick -Original Message- From: Darren Adams [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 10:13 AM To: CF-Talk Subject: RE: Storing structures in a DB I would normally use columns in a database and not worry about structures but, from the looks of the spec that I have got there is more of a complicated structure. basically it is a company information section for our intranet. Within the Slow_stream table there will be coluimns for Company info, financial info and sales office info The later column has to contain; Direct Sales: location, size VARs location, Size, other products International Presense Key Markets Market Share I was thinking about using a structure for the direct sales and VAR sections so I can store the extra details. Is it as simple creating a structure then inserting it into a DB field. When I want to display the data for a user can I query the database then access the structure as I normal ? -Original Message- From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] Sent: 25 April 2001 09:54 To: CF-Talk Subject: RE: Storing structures in a DB Darren The question isn't as simple as all that - the subject line says DB but the body says array. In both cases the answer is yes, but the details depend on what exactly you're trying to do. One way of storing a structure in a DB is to put it in a WDDX packet put that in a large text field. Otherwise of course you can have a table with one column for each field in the struct. Nick -Original Message- From: Darren Adams [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 9:39 AM To: CF-Talk Subject: Storing structures in a DB Hello, Just a simple question that probably has a simple answer. Can a structure be stored in an array so that it can be referrence at a later date ? Darren Adams Web Developer Marketing Department Systems Union Office: 01252 55 6220 Mobile: 07714 817 038 Email: [EMAIL PROTECTED] ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Storing structures in a DB
How does that speed up development time though? -Original Message- From: Neil Clark [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 11:25 AM To: CF-Talk Subject: RE: Storing structures in a DB Well, data either stored as XML or defined by XML is the way DB's are going, there is not question about that. N !- Neil Clark Senior Web Applications Engineer Spectra / CF / XML MCB Digital Premier Macromedia Partner Tel: 020 8941 3232 Fax: 020 8941 4333 e-mail: [EMAIL PROTECTED] ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: It's not big and it's not clever...
And pretty bad news for anyone called John, Dick, Bob, Jay etc... -Original Message- From: Jon Gage [mailto:[EMAIL PROTECTED]] Sent: Monday, April 23, 2001 5:15 PM To: CF-Talk Subject: RE: It's not big and it's not clever... If you use the library below however, you may encounter words like bass that have ass in them... -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: Monday, April 23, 2001 11:59 AM To: CF-Talk Subject: RE: It's not big and it's not clever... I need a list of swear words to validate user input against. Anyone have such a beast? Here's the best slang dictionary I've seen... and you can pick from about 120 languages, so as not to leave out our non-English speaking frieds. WHOOPS... here's the URL: http://www.notam.uio.no/~hcholm/altlang/stat.html Thanks for that. For all those interested, the list of English swear words (bad language) I've ended up with is below. I never realised how few words I knew... ;-) !! !! !!! !!! DO NOT SCROLL TO THE BOTTOM OF THIS E-MAIL !!! !!! IF YOU ARE OFFENDED BY BAD LANGUAGE!!! !! !! !!! You have been warned... arse,arse bandit,arsehole,arvo,ass,ass boy,assfuck,asshole,asswipe,aunty,ball,baltic,bang,basket,bastard,baths the,be on the rag,bear,beast with two backs,beat off,beaver,beef,beef curtains,bell end,berk,bi,biatch,biffy,bitch,bloody hell,blow job,blow your wad,blowjob,bob,boiler,boink,bollocks,bollocks bollicks,bondage,boner,boob,breasts,brown,buddy,bugger,buggery,bui lt like a brick shithouse,bull dyke,bumbandit,bunghole,buns,bush boogie,butch,cacker,camel toes,can,cancer stick,carpet muncher,cathouse,cherry,chicken,chicken hawk,chicken queen,chief,choad,chocolate cha cha,chode or chode,choke the chicken,chow box,christacrutchian,chubby chaser,chuck,circle jerk,clap the,clipped,clit,clit fight,closet,closet queen,cock,cock ring,cocksmoker,cocksucker,come,come stain,coon,cornhole,cotton picker,crabs,cracker,crap,crapper,cream ones jeans,cum,cunt,curry queen,cut,darky,dick,dickwad,diddle,diesel dyke,dildo,dingleberry,dink,dipshit,doesnt know shit from shinola,dong,doodoo,dork,drag,drag queen,dutch or dutch fuck,dyke,eat shit,eddress,fag,fag hag,fag stag,faggot,fairy,fart,fart along,fart around,felch,feltch,finger fuck,fingering,fish,fist fuck,fisting,flange,flash your gash,foursome,french kiss,french tickler,fruit,fruit fly,fuck,fuck around,fuck me harder,fuck off,fuck oneself,fuck up,fucked,fucked up,fucker,fucking,fugly,gangbang,gangsta bitch,get bent,get it on,get it up,get laid,get off,get ones shit together,give a shit,glory hole,go down on,gob the knob,god damn,golden shower,gook,greek,groe,grostulation,gummer,hair pie,hardcore,hardon,have,head,herb,hershey highway,hodgie,honkey,hork,hows your hammer hangin,hummer,hung,itchy eye,jack off,jackal,jackshit,jay,jerk off,jesus h christ,jizz,jizzum,john,jugs,jungle fever,kike,knock up,knockers,know ones shit,krunk,lace curtains,libido,loo,loose,lop cock,love juice,lucky pierre,masturbation,meat,meat puppet,meatrack,morning wood,mother fucker,mother fucking,muff diver,nellie,nfg,nigga,nigger,nipples,nookey,noonan,nooner,nudger,nut,oh shit,old fart,on the blob,ones tits in a knot,ones tits on,orlando,pain in the ass,pearl necklace,pecker,pecker cheese,pecker tracks,peckerwood,pee,peepee,penis,period,phungky,piece of ass,pillow biter,pinch one off,piss,piss ant,piss flappers,piss off,piss up a storm,pissed,pissed to the gills,pitch a tent in your shorts,plow,pocket pool,poon tang,poop,poop chute,pooperscooper,poopshoot,poor white trash,porch monkey,porn,postal,prick,pubes,pull ones pud,pull the pin,pussy,quad,queef,queen,queer,quim,quim nuts,rack,rag week,rainbow kiss,ranch,rape,red tide,red wings,redneck,reestie,rice queen,riding the porcelain bus,rim,rim job,rimming,rumpshaker,sausage jockey,scallywag,scat,screw,sex,sex fight,sex fighter,shit,shit on a shingle,shit out of luck,shitcan,shitfaced,shitfit,shithead,shithouse,shitlist,shits,s hitstain,s hoot off,shoot ones load,shoot ones wad,sissy,sister,sixtynine,skull fuck,slant,slapper,slut,snatch,sod off,son of a bitch,spank the monkey,spear chunker,sperm,spooge,spunk,squirt n spurt,stiffy,suck a fatty,swedish,sweet fa,sweet fucking jesus,take a crap,take a dump,take a piss,take a shit,tar baby,tea bagging,tea room,telesis,the dogs bollocks,the shit hit the fan,threesome,threeway woman,tinkle,tit,tit in a wringer,tits,tittie,titty,titty fuck,to dog,to swain,toss my salad,tosser,trailer trash,trick,trippingtrippin,tubs the,turd,turd burglar,twat,twink,up shit creek,up yours,vertical bacon sandwich,wad,wanker,wasted,water sports,wax the
RE: Access/SQL/hosting question
Vernon, That is too much traffic to expect Access to handle. IMO you will possibbly get more performance improvement from going to SQL Server than going to a dedicated server. The amount of Access database activity done by other users on the server you're using shouldn't affect you that badly. The dedicated DB server sounds like overkill. Nick -Original Message- From: Vernon Horn [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 24, 2001 7:46 AM To: CF-Talk Subject: Access/SQL/hosting question I'd appreciate any and all advice and comments on the following situation. I work for a non-profit membership association (translation, not a huge budget, but web stuff is getting to an important means of communication with the membership.) We've been running our web site on a shared server set up, but for a variety of reasons are pretty sure that we want to move to a dedicated server. Currently we are serving 20-40,000 pages on a good day, around half involve database queries, and there are a couple of hundred credit card transactions per day also. Most of our traffic is concentrated during standard business hours. So, here is the question, one consultant has recommended that we not only move to a dedicated server, but also upsize the databases to SQL, and get a dedicated database server as well. This seems like a fairly drastic leap, and I'm wondering if our relatively low volume really demands this? I know Access gets a lot of flack, but is it reasonable to expect it to perform better on a dedicated server? Any recommendations for what the most cost effective solution for us would be greatly appreciated. Thanks in advance, Vernon Horn Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: populating the query result to IFRAME
Paul Not sure exactly why you get that message but try replacing div id =thesection onClick = noSection(thesection) STYLE=display:none with div id =thesection onClick = noSection() style=visibility:hidden and a href=javascript:noSection(thesection) Close/a with a href=javascript:noSection() Close/a and the 2 JS functions with function doSection() { sec = getElementById(thesection); sec.style.visibility = visible; } function noSection (secNum) { sec = getElementById(thesection); sec.style.visibility = hidden; } or something like that Nick -Original Message- From: paul . [mailto:[EMAIL PROTECTED]] Sent: Monday, April 23, 2001 8:48 PM To: CF-Talk Subject: RE: populating the query result to IFRAME well I do get an error saying style is not an object guys please help -paul -- ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: graphing
Which, running CF5 in production, or expiring? The beta licenses expire on May 1 according to the docs. Nick -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: Monday, April 23, 2001 1:24 AM To: CF-Talk Subject: RE: graphing I am doing so already :-) -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 22, 2001 4:27 PM To: CF-Talk Subject: RE: graphing The thought had crossed my mind. I wasn't sure about the release date. What are your thoughts on running the Beta in a production environment? Does the beta expire? Brook ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: caller scope
Bryan I do it this way Calling page: cf_getResult queryname=qry cfoutput query=qry /cfoutput Tag: cfquery name=thisQuery. select * from someTable /cfquery cfset Caller.#Attributes.queryname# = thisQuery This uses one more assignment than strictly necessary, but it just seems neater that way. Nick -Original Message- From: Bryan LaPlante [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 24, 2001 2:16 PM To: CF-Talk Subject: caller scope Going nuts friends, I could swear that I have used this syntax in the past, but I can not get it to work now. In custom tag getResult.cfm there is a query that uses the caller scope to make the query result set available to the calling page. cfquery name=caller.qry. select * from someTable /cfquery In the calling page I output cfoutput query=qry /cfoutput Error message says that the value of the output tag does not refer to the name of an available query. I also tried to cfset caller.qry = qry setting the name value for cfquery name=qry and that fails too. Any idea's. Bryan LaPlante 816-347-8220 [EMAIL PROTECTED] http://www.netwebapps.com Web Development ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Date Difference
Select DateDiff(d, GETDATE(), expdate) from ... where... -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 24, 2001 1:52 PM To: CF-Talk Subject: Date Difference cf talk. I want to find out the difference in days between select getdate() - expdate which is a date stored in a table. Of course getdate pulls the date of the sql server. I need to do this in a select statement. Can anyone help me. I could also do this somewhere else but I need to be able to include it in my cfoutput query. If anyone knows the correct structure to make this happen in dts please let me know because I can run it in dts and have it update my table. Joshua Tipton ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How to get Julian Date
Julian dates are normally based on something in the distant past, so if you want it to work with existing data you need to make sure the base date is the same. I think that the base date can be configured within Informix. Nick -Original Message- From: Paul Sizemore [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 12, 2001 1:31 PM To: CF-Talk Subject: RE: How to get Julian Date Thanks for the help. I'm rewriting some Informix 4gl's in CF. -Original Message- From: Adrian Cesana [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 11, 2001 4:43 PM To: CF-Talk Subject: RE: How to get Julian Date cfset JulianDate = "#numberformat(dayofyear(Now()), 000)#" This should do it, Adrian -Original Message- From: Paul Sizemore [mailto:[EMAIL PROTECTED]] How would I get the julian date for today, besides using the CF_Julian tag? Paul ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Passing a structure to JavaScript with wddx
Marius Looks like you have a structure member called "3" which is not a valid JavaScript variable name. The strange thing is, it's not a valid CF variable name either so I'm not sure how it got there. ? Nick -Original Message- From: Marius Milosav [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 10, 2001 2:12 AM To: CF-Talk Subject: Re: Passing a structure to JavaScript with wddx Thanks Chris, the problem is only related if I use action cfml2js. Is working fine if I pass the structure to another page using cfml2wddx. The error pops up when it tries to create the JavaScript object stMsg=new Object(); stMsg.3=new Object(); It complains about missing ; between stMsg and .3 Marius Milosav www.scorpiosoft.com It's not about technology, it's about people. Virtual Help Desk Demo (VHD) www.scorpiosoft.com/vhd/login.cfm - Original Message - From: "Chris Michl" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, April 09, 2001 8:46 PM Subject: RE: Passing a structure to JavaScript with wddx Marius, Here's some sample code. I'm dumping the WDDX packet into a client variable which is used in another frame. cfscript Basket=StructNew(); rc=StructInsert(Basket, "Item", "#Trim(getPartInfo.item_no)#"); rc=StructInsert(Basket, "Description", "#Trim(getPartInfo.item_desc_1)#"); rc=StructInsert(Basket, "Price", "#Trim(NumberFormat(getPartInfo.Price,'9.99'))#"); rc=StructInsert(Basket, "Prod_cat", "#Ucase(getPartInfo.prod_cat)#"); rc=StructInsert(Basket, "Std_cost", "#Trim(NumberFormat(getPartInfo.std_cost,'9.99'))#"); rc=StructInsert(Basket, "DiscRate", "#Trim(Variables.DiscRate)#"); rc=StructInsert(Basket, "DiscPrice", "#Trim(Variables.DiscPrice)#"); rc=StructInsert(Basket, "PriceBreakQty", "#Trim(Variables.PriceBreakQty)#"); rc=StructInsert(Basket, "PriceBasis", "#Trim(Variables.PriceBasis)#"); rc=StructInsert(Basket, "PriceCodeType", "#Trim(Variables.PriceCodeType)#"); /cfscript cfwddx action="CFML2WDDX" input="#Basket#" output="ItemInfo" cfset Client.ItemInfo=ItemInfo cfwddx action="WDDX2CFML" input="#Client.ItemInfo#" output="wddxBasket" cfoutput #wddxBasket.Item# #wddxBasket.Description# ETC. /cfoutput Regards, Chris -Original Message- From: Marius Milosav [mailto:[EMAIL PROTECTED]] Sent: Monday, April 09, 2001 7:42 PM To: CF-Talk Subject: Passing a structure to JavaScript with wddx If anybody passed successfully a structure with wddx can you please let me know how. cfwddx action="cfml2js" input="#myST#" toplevelvariable="stMsg" gives a JavaScript error. : ; expected It works fine if I pass arrays or queries. myST is a valid structure and is populated Thanks Marius Milosav www.scorpiosoft.com It's not about technology, it's about people. Virtual Help Desk Demo (VHD) www.scorpiosoft.com/vhd/login.cfm ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Java CFX tags
Does anyone know when support for Java CFX introduced and where it is documented? It was new in 4.5. There is some stuff in chapter 18 of Developing Web Apps with CF. Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Oracle Auto-Increment
WIth Oracle you can set up a "sequence" which gives you the same kind of functionality. eg CREATE SEQUENCE mytab_seq ON mytab INCREMENT BY 1; then in your insert statement you can say INSERT INTO mytab() VALUES (mytabseq.nextval, ) Nick -Original Message- From: Jamie Symonds [mailto:[EMAIL PROTECTED]] Sent: Monday, April 02, 2001 2:37 PM To: CF-Talk Subject: Oracle Auto-Increment Hi - I am inserting results of a form into an Oracle 8 database - in the past, while using Access, I would set the first field of the table ("id") to "auto-number" for my primary key. Oracle does not have an auto-increment feature - how do I go about this? Thanks. ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: [Oracle Auto-Increment]
Just specify the column as an IDENTITY in your CREATE TABLE statement. -Original Message- From: Arden Weiss [mailto:[EMAIL PROTECTED]] Sent: Monday, April 02, 2001 2:58 PM To: CF-Talk Subject: RE: [Oracle Auto-Increment] What about SQL Server -- how to auto-increment?? ^ / \__ (@\___ / O /(_/ /_/ Whoof... 410-757-3487 ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: multilanguage site
Chad There have been 1 or 2 good threads on this, try starting at http://www.mail-archive.com/cf-talk@houseoffusion.com/msg16575.html -Original Message- From: chad jackson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 6:22 AM To: CF-Talk Subject: multilanguage site Hi guys, Our client has requested that we do our website in several languages... however I am unsure how to go about it regarding the database structure I thought that the user could select their language which would set a session variable ie session.language = english So now that I have gotten this far, how should I set the database up so that my existing queries dont have to be totally rewritten... Should I different tables for each language? Or should I have one table, but different language columns? Or totally different databases? The info will be identical across all the different sites.. so maintaining the structure is imperative (ie newsID 40 always has to be the same across all languages). I am really stuck here, and have no idea on the best way to go, and appreciate your help and any tips you can provide. kind regards chad jackson ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: javascript add problem
Multiply each number by 1 first. Then the JS interpreter will know they're numbers not strings. Nick -Original Message- From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 5:13 PM To: CF-Talk Subject: OT: javascript add problem Sorry about the OT question, but am stumped as to why this won't work. Trying to use JavaScript to add the numbers in form fields together, instead of adding them, it is appending them to each other. Here is my code: script language="JavaScript" function AddToBasket() { OrderBooks.TotalQty.value = 0 OrderBooks.TotalQty.value = eval(OrderBooks.SW.value + OrderBooks.SP.value) } /script It is taking the value of OrderBooks.SP.value and apending it to OrderBooks.SW.value instead of adding them. For example, OrderBooks.SW.value = 3 and OrderBooks.SP.value = 5, I am getting 35 instead of 8. Have tried it without the eval() in there and have set each form value equal to a javascript variable also with no change in results. Bernd VanSkiver [EMAIL PROTECTED] ColdFusion Developer ICQ #: 916324 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Converting CFML to WML
It's the HTML you convert, not the CFML. Yes it is quite easy, depending on how clean the code was in the first place. However, you probably need to redesign the user interface, which may not be so easy. Nick -Original Message- From: Jason Lees (National Express) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 2:20 PM To: CF-Talk Subject: OT:Converting CFML to WML Hi All, Is it an easy job to convert CFML pages to WML? Jason Lees National Express Email : [EMAIL PROTECTED] ### This document is intended for, and should only be read by, those persons to whom it is addressed. Its contents are confidential and if you have received this message in error, please notify us immediately by telephone on 0121 609 6301 and delete all records of the message from your computer. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without our prior written consent is strictly prohibited. Neither the author of this message nor their employers accept legal responsibility for the contents of the message. Any views or opinions presented are solely those of the author. If you have any queries please contact [EMAIL PROTECTED] ## ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT CSS
How many of you are using external CSS in your apps and can anyone recommend a good reference book on CSS? I almost always use them Danny Goodman's Dynamic HTML book (O'Reilly) works for me. Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Converting CFML to WML
No, you shouldn't need to change that at all. You're just delivering content to a different client. There are some examples somewhere on the Allaire site. The only reason you would need to change anything on the server is if the limitations of that client make your existing design unworkable. For example, too much text, pretty much any graphics etc. Nick -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 4:07 PM To: CF-Talk Subject: Re: Converting CFML to WML What about existing database queries - can they remain as is, or would they need modifying too? Will -- [EMAIL PROTECTED] -=- www.lukrative.com Local-Advertising -=- www.localbounty.com It's the HTML you convert, not the CFML. Yes it is quite easy, depending on how clean the code was in the first place. However, you probably need to redesign the user interface, which may not be so easy. Nick -Original Message- From: Jason Lees (National Express) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 2:20 PM To: CF-Talk Subject: OT:Converting CFML to WML Hi All, Is it an easy job to convert CFML pages to WML? Jason Lees National Express Email : [EMAIL PROTECTED] ### This document is intended for, and should only be read by, those persons to whom it is addressed. Its contents are confidential and if you have received this message in error, please notify us immediately by telephone on 0121 609 6301 and delete all records of the message from your computer. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without our prior written consent is strictly prohibited. Neither the author of this message nor their employers accept legal responsibility for the contents of the message. Any views or opinions presented are solely those of the author. If you have any queries please contact [EMAIL PROTECTED] ## ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: session variable storage
And also it works with clustering. The downside is that it must tend to be slightly slower. Nick -Original Message- From: Bob Silverberg [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 5:15 PM To: CF-Talk Subject: RE: session variable storage I believe you mean Client variables, and database is preferable, IMHO, for a number of reasons including, but not limited to: - the ability to read the info from the db using standard SQL - do you really want ColdFusion constantly messing with your Registry? Bob -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: March 27, 2001 10:46 AM To: CF-Talk Subject: session variable storage registry or database? which is better and why? ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Status in UK
There are UK-based CF contracts every week on www.jobserve.com. There was a thread on CF status in the UK on the list a while back, you should be able to find it in the archives. Basically with your experience you shouldn't have any problems if your company know what they're doing. Also, try the cf-jobs list which is more appropriate for this subject. Good luck Nick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 9:44 AM To: CF-Talk Subject: CF Status in UK Hi, Could anybody tell me how is ColdFusion doing in UK? Is it not in demand here now? Actually, I came here in UK from India on 29th Jan., 2001 as a Software Consultant through NovaSoft Info. Tech. (Europe) Ltd. (http://www.novasoftinfo.co.uk and http://www.novasoftinfo.com). They hire Software Professionals from India and place them here on Contract basis. My main skills are ColdFusion. I am having 2 yrs exp. in ColdFusion with SQL, Access, JavaScript, HTML, and Dreamweaver etc. I have developed 10 sites using ColdFusion. Now almost two months have been completed and I am still on Bench. Not only myself, there are other 4 ColdFusion professionals they are also on bench. NovaSoft is not able to place anybody. What they are saying is that there is no market for ColdFusion in UK now and the situation will remain same for next 5-6 months atleast. I have already wasted almost 2 months for the process for coming to UK and 2 months on bench and if the situation is going to remain for next 5-6 months, it is going to spoil my career very badly. Moreover, company might take some harsh decisions also. I am in great dilemma now-a-days. Could you please tell me the status of ColdFusion in UK or could anybody guide me overcoming this problem? Any kind of help/suggestion is welcome. Thanks and Regards, Rajesh Kumar ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: any way to retrieve the actual SQL used
Why not write the query text into a session variable when you execute it the first time? Nick -Original Message- From: Chris Phillips [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 10:51 AM To: CF-Talk Subject: any way to retrieve the actual SQL used Hi all Is there any way to retrieve the actual SQL (rather than the records returned) by a dynamic query? ie I have a page that bases its query on the form fields filled in on the previous page. I want to actually use the SQL statement for sth else. It comes out if you turn debugging on, but is it accessible eg as a variable of some sort? Any thoughts are welcome Many thanks in advance Chris chris phillips communisis one plc multimedia team 0113 225 5373 mailto:[EMAIL PROTECTED] http://www.communisis-one.co.uk ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Textbox validation
Really the best way is *both*. JavaScript is much nicer from a user interface point of view. But if the validation is important you need to do it again on the server, because you can't guarantee the user has JavaScript running in their browser. Nick -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 12:39 AM To: CF-Talk Subject: Textbox validation Hi, On one textbox I need to prohibit users entering more than one word - I don't want them to enter a space. What's the best way of doing this - Javascript, or Cold Fusion after the form has been posted? Thanks. Will -- [EMAIL PROTECTED] -=- www.lukrative.com Local-Advertising -=- www.localbounty.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF and ORACLE
http://technet.oracle.com ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: XML
Let me point out a very good reason NOT to use CF for XML. When you get XML, you have to compare it to your DTD and then parse it to get the data out. Pedantic point: you only have to look at the DTD if you need to validate the XML. No need to otherwise. As regards parsers, I've used MSXML with CF quite a bit and it works fine. Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Need some quick help
apache on NT -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: Friday, March 16, 2001 3:22 PM To: CF-Talk Subject: OT: Need some quick help Hi all, I need some quick help from developers using anyone the following with CF (I need one of each): - Netscape Enterprise Server on NT - Netscape Enterprise Server on Solaris - Apache on NT - Apache on Linux - Apache on Solaris - Anyone using CF via the CGI interface (on any platform) I won't take much of your time, I'll need you to run a single CFM request and forward some results to me. Please reply to me directly (off list). Thanks! --- Ben == Ben Forta - Allaire Corporation E-Mail: [EMAIL PROTECTED] Phone:(248)424-8420 Fax: (248)424-8421 Allaire: http://www.allaire.com/ Personal: http://www.forta.com/ WAP is hot! Want to know more? You need "The WAP Book" - go to http://www.thewapbook.com/ for more info! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: XML
This is right, but you don't have to use a different *parser* to turn your XML into HTML, WML, etc. You can use XSLT (XML style sheet transformation) with different XSL stylesheets for each target format. The XML can be as complex as you like. Nick -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 14, 2001 12:49 PM To: CF-Talk Subject: RE: XML Just to add to this As I understand it XML is independent of the "end product". i.e If you build a site using XML it is not "tied in" to HTML in that you could view it via an HTML page or a WAP page etc just by using different XML parsers. Although I gues your XML structure would have to be quite simple to accomodate both although I haven't tried it ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Using javascript to create an Undo - the return
I think you would need to trap every key depression and mouse click while they were in the textarea. The problem is, you would need to know where the text pointer was at any moment, and I don't see how you could do that reliably if they used the mouse to reposition it. Nick -Original Message- From: James Maltby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 14, 2001 1:37 PM To: CF-Talk Subject: Using javascript to create an Undo - the return Hi - posted this recently but still no resolution: Have a cf forum we have written, with javascript "Word" like buttons that output html for b, i and u in the input textarea - would like to include an "undo" function with acts like ctrl+Z from the keyboard - in that it will remove either the last piece of text written, or the inputted b/b (etc) tags - any suggestions? James ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Accessing field names dynamically
This does it for me cfloop list="#queryname.columnlist#" index="fieldname" tdcfoutput#fieldname#/cfoutput/td /cfloop Nick -Original Message- From: Lockie Martin [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 2:36 AM To: CF-Talk Subject: Accessing field names dynamically This question comes into the category of I've seen it somewhere! I have a crosstab query in Access and as you will be aware the column headings in that kind of query come from the data and of course will be variable in name and number. Is there any way of accessing the field names for the columns from the query. Perhaps looping through them to present them on the screen. I know I have seen it somewhere! Thanks in advance --- Lockie Martin [EMAIL PROTECTED] http://www.keystone-solutions.com/ http://marquee/ http://www.keystone-support.net PER [EMAIL PROTECTED] MSN [EMAIL PROTECTED] ICQ 19741013 +64-9-357 0408 x339 (work) +64-2-174 3910 (cell) +64-9-357 0414 (work fax) ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: curly queries
Toby Something like this will get you n rows per poem where n is the number of options, filtering out the hidden ones. Assuming each poem must have options - otherwise you need an outer join. select p.poem_id, p.poem_title, d.option_name, o.setting from poem p, poem_option o, poem_option_def d where p.poem_id = o.poem_id and d.option_id = o.option_id and poem_id in (select p.poem_id from poem p, poem_option o, poem_option_def d where p.poem_id = o.poem_id and d.option_id = o.option_id and d.option_name = 'hidden' and d.setting = 'off') You could use cfoutput group="poem_id" in CF to "group" the output, but actually you want everything on one line, so I think you'll have to do something along the lines of cfset current_id = "" cfoutput query=... cfif poem_id is not current_id !--- New poem, so new line poem id/title--- br #poem_id# #poem_title# cfif !--- option details --- #option_name#=#setting# current_id = #poem_id# /cfoutput I can't think of a way of doing headers like your example, if you dont want to hardcode the options. None of this tested I'm afraid ;-) Nick -Original Message- From: Toby Tremayne [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 07, 2001 3:47 AM To: CF-Talk Subject: curly queries I've got a tricky problem that I just can't figure out. I'm outputting a list of poems fomr a database (just the titles.) Each poem has several "options" such as hidden, hilite etc. As I output the titles in a list, I need to be able to run conditional checks against each option (IE if hilite is "on" then display markers next to the title.) The tables are set up like so: - poem - poem_id numeric poem_title varchar - - poem_option - poem_id numeric option_id numeric setting varchar - - poem_option_def - option_id numeric option_name varchar - you can see my problem (hopefully). To start with I'm getting each poem_title repeated once for every option that exists. In the query I need to select all this information for only the poems whose "hidden" option has a setting of "off", then I need to output the title only once obviously, at that time check each of it's options. This doesn't quite work because while what I NEED is this: one record: - poem_id | poem_title | hidden | hilite | spellcheck | - 01"my poem" "off""on" "on" instead, I have this: one record: - poem_id | poem_title | option_name | setting | - 01 "my poem" "hidden" "off" 01 "my poem" "spellcheck" "on" 01 "my poem" "hilite" "on" as you can see this makes it difficult to do a cfif hilite is "on" img src="hiliter.gif" /cfif can anyone help me with this please? i know it's going to be a combination of writing the correct query and grouping the output - it's just eluding me utterly. I can't / don't want to hardcode each option into the queries etc, because obivously the number and names of options will evnetually grow... help - anyone? Toby Tremayne Code Poet and Zen Master of the Heavy Sleep Show Ads Interactive 359 Plummer St Port Melbourne VIC 3207 P +61 3 9245 1247 F +61 3 9646 9814 ICQ UIN 13107913 ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: curly queries
OK, hold the messages about basic CFML errors... cfset current_id = "" cfoutput query=... cfif poem_id is not current_id !--- New poem, so new line poem id/title--- br #poem_id# #poem_title# /cfif !--- option details --- #option_name#=#setting# cfset current_id = poem_id /cfoutput ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Help, Please
If they leave at 22:00 and get back at 20:00 the next day, and you are only storing the *time*, not the date and time, then they are indeed getting back 2 hours earlier than they left. Nick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 07, 2001 1:42 PM To: CF-Talk Subject: RE: SQL Help, Please Philip, Thanks for the help. Unfortunately, that didn't do the trick. The query returns a -2. I've put in test records to this point, so I know that the return should be 22. Any other ideas? Thanks, Scott ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Converting Microsoft Publisher/QuarkXpress to PDF
Kind of related to the Word/Powerpoint thread... Does anyone have any idea how to convert documents in the above 2 formats to PDF? Not automatically using CF, but manually on a PC. I'm being asked have no clue about this stuff. I believe there is a plugin for QuarkXpress that does this? As for MS Publisher, I have no idea but I bet it's nasty... Thanks Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Another SQL statement question...
how about SELECT TextID, IFNULL(TextColumn1, '') + IFNULL(TextColumn2, '') AS AllTextColumns FROM Table1 -Original Message- From: river [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 07, 2001 3:53 PM To: CF-Talk Subject: Another SQL statement question... It's off-topic, but I know people here are experienced with SQL, so... I am using SQL 7.0 and CF 4.5. I am trying to combine two ntext field columns to one field in a query, but I have a problem when one of the fields contains 'NULL' value. I am trying: SELECT TextID, TextColumn1 + TextColumn2 AS AllTextColumns FROM Table1 But when either TextColumn1 or TextColumn2 has the 'NULL' value, the resulting column, AllTextColumns, shows as empty even if the other column has a text string in it. Is there a way to prevent this? ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Another SQL statement question...
Yes, my bad, isnull not ifnull -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 07, 2001 4:24 PM To: CF-Talk Subject: RE: Another SQL statement question... It's off-topic, but I know people here are experienced with SQL, so... I am using SQL 7.0 and CF 4.5. I am trying to combine two ntext field columns to one field in a query, but I have a problem when one of the fields contains 'NULL' value. I am trying: SELECT TextID, TextColumn1 + TextColumn2 AS AllTextColumns FROM Table1 But when either TextColumn1 or TextColumn2 has the 'NULL' value, the resulting column, AllTextColumns, shows as empty even if the other column has a text string in it. Is there a way to prevent this? Use isNULL() isNULL(TextColumn1,'') Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Multiple Query Problem
Why not do a join ? cfquery name="get_prod_with_variants" datasource="#dsnvar#" dbtype="#dsntype#" SELECT * FROM prod p, variants v WHERE p.cat_id = '1' AND p.active = '1' AND p.prod_id = v.prod_id ORDER BY p.prod_priority /cfquery Nick -Original Message- From: Chris Poole [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 06, 2001 10:57 AM To: CF-Talk Subject: Multiple Query Problem To anyone who can help, I am trying to output a list of records on a page, also nested in this list are individually populated drop down boxes which has values determined by the parent record. But before I get to this stage I can't get the query syntax right. I can't quite get the query syntax right, below is what I have tried but I only seem to get 1 variant and no more. All the records are there but can't seem to output them. I have also tried cfx_dumpquery tag but still can't get any more than one row out of get_variants. cfquery name="get_prod" datasource="#dsnvar#" dbtype="#dsntype#" SELECT * FROM prod WHERE cat_id = '1' AND active = '1' ORDER BY prod_priority /cfquery cfquery name="get_variants" datasource="#dsnvar#" dbtype="#dsntype#" Select * From variants WHERE prod_id = #get_prod.prod_id# /cfquery Am probably being stuuupid due to sleep depravation. If anyone can help I would appreciate it. Cheers Chris. --- Chris Poole Development Engineer --- e-mango.com ltd Tel: 01202 587 400 Lansdowne Place Fax: 01202 587 401 17 Holdenhurst Road Bournemouth Mailto:[EMAIL PROTECTED] BH8 8EW, UK http://www.e-mango.com --- ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DHTML
OK, then just be aware that DHTML that works on N4 doesn't work on N6 or IE5 without tweaking. As the others have said, there's no CF problem. Nick -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Friday, March 02, 2001 6:27 PM To: CF-Talk Subject: Re: DHTML We will be using Netscape 4.74 "DeVoil, Nick" wrote: The only issue is cross-browser compatibility, particularly if you have to support Netscape 4. Nick -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Friday, March 02, 2001 5:04 PM To: CF-Talk Subject: OT: DHTML Anybody having issues with CF and DHTML? I am considering it for a new app that we will be developing. Purpose being to get around using frames since we can't. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists