Hi,
I have a bookings table containing details of guests who have stayed rooms within a hotel I am wanting to output the table grouping the data into room number and then sorting the bookings by arrival date. All that is easy However I am wanting the output to be stored in one single excel spreadsheet where the each room number has its own tab (workbook) within the single spreadsheet file and then the bookings relevant to each room number appear within each workbook Kind Regards Claude Raiola B.Econ(Acc.); B.Hotel Mngt. Mobile: 0414 228 948 Phone: 07 3666 0981 Fax: 07 3319 6444 Websites: <http://www.websitesolutions.com.au/> www.WebsiteSolutions.com.au <http://www.australianaccommodation.com/> www.AustralianAccommodation.com <http://www.accommodationnewzealand.com/> www.AccommodationNewZealand.com <http://www.hospitalitypurchasing.net/> www.HospitalityPurchasing.net <http://www.samaris.net/> www.Samaris.net From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Georgiou Sent: Tuesday, 15 January 2008 7:52 AM To: [EMAIL PROTECTED] Subject: Re: [coldfusion-howto] SQL Statement needs a line break? thanks all! I will try all these suggestions and let you know.. George On Jan 14, 2008 1:46 AM, Hank Miller <[EMAIL PROTECTED] <mailto:hankcfman%40yahoo.com> > wrote: > You can try... > > USE [mydb]; > SET ANSI_NULLS ON; > SET QUOTED_IDENTIFIER ON; > SET ANSI_PADDING ON; > CREATE TABLE [dbo].[tbl_test]( > > Get rid of the "GO"s. > > -hankcfman > > ----- Original Message ---- > From: George Georgiou <[EMAIL PROTECTED] <mailto:george1977%40gmail.com> <george1977%40gmail.com>> > To: [EMAIL PROTECTED] <mailto:coldfusion-howto%40yahoogroups.com> <coldfusion-howto%40yahoogroups.com> > Sent: Sunday, January 13, 2008 1:47:29 PM > Subject: [coldfusion-howto] SQL Statement needs a line break? > > Hi there, > > I am an experienced coldfusion developer (7 years now). This is the first > time i see this. I am trying to create a table from a CFQuery. I have > something like : > > <cfquery .... > > USE [mydb] > GO > SET ANSI_NULLS ON > GO > SET QUOTED_IDENTIFIER ON > GO > SET ANSI_PADDING ON > GO > CREATE TABLE [dbo].[tbl_test]( > . > .... etc etc etc > > If I paste this in the query analyzer it works great. If I run this > through > a cfquery I get an error like [Macromedia][SQLServer JDBC > Driver][SQLServer]Incorrect syntax near 'GO'. > > The problem is that it seems that coldfusion sends the sql statement as a > single line (i.e. no line-breaks). > > Is there any way to add a 'line-break' to the cfquery after each sql-line? > I > have tried using the #chr(10)#, the #chr(13)# (and also the <br>) but it > does not work. In other words I have tried something like: > > USE [mydb] #chr(10)# > GO#chr(10)# > SET ANSI_NULLS ON #chr(10)# > GO #chr(10)# > SET QUOTED_IDENTIFIER ON #chr(10)# > GO #chr(10)# > > etc.... > > but still, this doesn't work :-( > > Any ideas on how to do this ? > > thanks, > George > > [Non-text portions of this message have been removed] > > ~~~~~~~~~ > *** Yahoo's No. 1 and the biggest group of ColdFusion Developers > > ColdFusion MX Hosting - 250 MB Space/5 GB monthly Bandwidth for just > $19.99/year. Free Setup, ASP.NET <http://asp.net/>, HELM Control Panel. > http://www.hostingatoz.com. We also offer ColdFusion Reseller Hosting > Plans. > > Post message: [EMAIL PROTECTED] <mailto:coldfusion-howto%40yahoogroups.com> <coldfusion-howto%40yahoogroups.com> > Subscribe: [EMAIL PROTECTED] <mailto:coldfusion-howto-subscribe%40yahoogroups.com> <coldfusion-howto-subscribe%40yahoogroups.com> > Un-Subscribe: [EMAIL PROTECTED] <mailto:coldfusion-howto-unsubscribe%40yahoogroups.com> <coldfusion-howto-unsubscribe%40yahoogroups.com> > > ... > > Yahoo! Groups Links > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed] __._,_.___ Messages <http://groups.yahoo.com/group/coldfusion-howto/message/42344;_ylc=X3oDMTM2a m9qaWRqBF9TAzk3MzU5NzE0BGdycElkAzE0MDAxMzgEZ3Jwc3BJZAMxNzA1MTE1MzYxBG1zZ0lkA zQyMzUyBHNlYwNmdHIEc2xrA3Z0cGMEc3RpbWUDMTIwMDM0NzU0MAR0cGNJZAM0MjM0NA--> in this topic (7) <http://groups.yahoo.com/group/coldfusion-howto/post;_ylc=X3oDMTJxZDk4dTU5BF 9TAzk3MzU5NzE0BGdycElkAzE0MDAxMzgEZ3Jwc3BJZAMxNzA1MTE1MzYxBG1zZ0lkAzQyMzUyBH NlYwNmdHIEc2xrA3JwbHkEc3RpbWUDMTIwMDM0NzU0MA--?act=reply&messageNum=42352> Reply (via web post) | Start <http://groups.yahoo.com/group/coldfusion-howto/post;_ylc=X3oDMTJlcXQ0cG9uBF 9TAzk3MzU5NzE0BGdycElkAzE0MDAxMzgEZ3Jwc3BJZAMxNzA1MTE1MzYxBHNlYwNmdHIEc2xrA2 50cGMEc3RpbWUDMTIwMDM0NzU0MA--> a new topic Messages <http://groups.yahoo.com/group/coldfusion-howto/messages;_ylc=X3oDMTJlcGVncT FuBF9TAzk3MzU5NzE0BGdycElkAzE0MDAxMzgEZ3Jwc3BJZAMxNzA1MTE1MzYxBHNlYwNmdHIEc2 xrA21zZ3MEc3RpbWUDMTIwMDM0NzU0MA--> | Files <http://groups.yahoo.com/group/coldfusion-howto/files;_ylc=X3oDMTJmdTNkdW1mB F9TAzk3MzU5NzE0BGdycElkAzE0MDAxMzgEZ3Jwc3BJZAMxNzA1MTE1MzYxBHNlYwNmdHIEc2xrA 2ZpbGVzBHN0aW1lAzEyMDAzNDc1NDA-> | Photos <http://groups.yahoo.com/group/coldfusion-howto/photos;_ylc=X3oDMTJlZnN1YzB1 BF9TAzk3MzU5NzE0BGdycElkAzE0MDAxMzgEZ3Jwc3BJZAMxNzA1MTE1MzYxBHNlYwNmdHIEc2xr A3Bob3QEc3RpbWUDMTIwMDM0NzU0MA--> | Links <http://groups.yahoo.com/group/coldfusion-howto/links;_ylc=X3oDMTJmcjVvdm82B F9TAzk3MzU5NzE0BGdycElkAzE0MDAxMzgEZ3Jwc3BJZAMxNzA1MTE1MzYxBHNlYwNmdHIEc2xrA 2xpbmtzBHN0aW1lAzEyMDAzNDc1NDA-> | Database <http://groups.yahoo.com/group/coldfusion-howto/database;_ylc=X3oDMTJjdDM5aW UxBF9TAzk3MzU5NzE0BGdycElkAzE0MDAxMzgEZ3Jwc3BJZAMxNzA1MTE1MzYxBHNlYwNmdHIEc2 xrA2RiBHN0aW1lAzEyMDAzNDc1NDA-> | Polls <http://groups.yahoo.com/group/coldfusion-howto/polls;_ylc=X3oDMTJmYWg4bWlwB F9TAzk3MzU5NzE0BGdycElkAzE0MDAxMzgEZ3Jwc3BJZAMxNzA1MTE1MzYxBHNlYwNmdHIEc2xrA 3BvbGxzBHN0aW1lAzEyMDAzNDc1NDA-> | Calendar <http://groups.yahoo.com/group/coldfusion-howto/calendar;_ylc=X3oDMTJkZzAwdD YzBF9TAzk3MzU5NzE0BGdycElkAzE0MDAxMzgEZ3Jwc3BJZAMxNzA1MTE1MzYxBHNlYwNmdHIEc2 xrA2NhbARzdGltZQMxMjAwMzQ3NTQw> ~~~~~~~~~ *** Yahoo's No. 1 and the biggest group of ColdFusion Developers ColdFusion MX Hosting - 250 MB Space/5 GB monthly Bandwidth for just $19.99/year. Free Setup, ASP.NET, HELM Control Panel. http://www.hostingatoz.com. We also offer ColdFusion Reseller Hosting Plans. Post message: [EMAIL PROTECTED] Subscribe: [EMAIL PROTECTED] Un-Subscribe: [EMAIL PROTECTED] ... MARKETPLACE _____ Earn <http://us.ard.yahoo.com/SIG=12mqstrv5/M=571476.12066680.12490312.11509771/D =groups/S=1705115361:MKP1/Y=YAHOO/EXP=1200354741/A=5086951/R=0/SIG=12k8pu1n3 /*http:/college-finder.net/index.cfm?key=yahoo_colfngrouptxt_12066680&c=CA15 2932587> your degree in as few as 2 years - Advance your career with an AS, BS, MS degree - College-Finder.net. <http://groups.yahoo.com/;_ylc=X3oDMTJkaTFmaGpyBF9TAzk3MzU5NzE0BGdycElkAzE0M DAxMzgEZ3Jwc3BJZAMxNzA1MTE1MzYxBHNlYwNmdHIEc2xrA2dmcARzdGltZQMxMjAwMzQ3NTQw> Yahoo! Groups Change <http://groups.yahoo.com/group/coldfusion-howto/join;_ylc=X3oDMTJmcGM4ZjduBF 9TAzk3MzU5NzE0BGdycElkAzE0MDAxMzgEZ3Jwc3BJZAMxNzA1MTE1MzYxBHNlYwNmdHIEc2xrA3 N0bmdzBHN0aW1lAzEyMDAzNDc1NDA-> settings via the Web (Yahoo! ID required) Change settings via email: Switch <mailto:[EMAIL PROTECTED]:%20 Digest> delivery to Daily Digest | Switch <mailto:[EMAIL PROTECTED] ry%20Format:%20Traditional> format to Traditional Visit <http://groups.yahoo.com/group/coldfusion-howto;_ylc=X3oDMTJkc3NjdDhvBF9TAzk 3MzU5NzE0BGdycElkAzE0MDAxMzgEZ3Jwc3BJZAMxNzA1MTE1MzYxBHNlYwNmdHIEc2xrA2hwZgR zdGltZQMxMjAwMzQ3NTQw> Your Group | Yahoo! Groups <http://docs.yahoo.com/info/terms/> Terms of Use | Unsubscribe <mailto:[EMAIL PROTECTED]> Recent Activity . 4 New <http://groups.yahoo.com/group/coldfusion-howto/members;_ylc=X3oDMTJmNjhjYW5 xBF9TAzk3MzU5NzE0BGdycElkAzE0MDAxMzgEZ3Jwc3BJZAMxNzA1MTE1MzYxBHNlYwN2dGwEc2x rA3ZtYnJzBHN0aW1lAzEyMDAzNDc1NDA-> Members Visit <http://groups.yahoo.com/group/coldfusion-howto;_ylc=X3oDMTJlbzZiNDZyBF9TAzk 3MzU5NzE0BGdycElkAzE0MDAxMzgEZ3Jwc3BJZAMxNzA1MTE1MzYxBHNlYwN2dGwEc2xrA3ZnaHA Ec3RpbWUDMTIwMDM0NzU0MA--> Your Group Yahoo! News Odd <http://us.ard.yahoo.com/SIG=12jmaudti/M=493064.12016309.12445701.8674578/D= groups/S=1705115361:NC/Y=YAHOO/EXP=1200354741/A=3848614/R=0/SIG=12t4qk00m/*h ttp:/news.yahoo.com/i/757;_ylt=A9FJqYzfwK5EFCQAswis0NUE;_ylu=X3oDMTA3NW1oMDR pBHNlYwM3NTc-> News You won't believe it, but it's true New web site? Drive <http://us.ard.yahoo.com/SIG=12joukc8b/M=493064.12016308.12445700.8674578/D= groups/S=1705115361:NC/Y=YAHOO/EXP=1200354741/A=3848642/R=0/SIG=131eshi2t/*h ttp:/searchmarketing.yahoo.com/arp/srchv2.php?o=US2004&cmp=Yahoo&ctv=Groups3 &s=Y&s2=&s3=&b=50> traffic now. Get your business on Yahoo! search. Drive Traffic Sponsored <http://us.ard.yahoo.com/SIG=12jkip99t/M=493064.12016255.12445662.8674578/D= groups/S=1705115361:NC/Y=YAHOO/EXP=1200354741/A=4025338/R=0/SIG=12jnci1fd/*h ttp:/us.rd.yahoo.com/evt=44092/*http:/searchmarketing.yahoo.com/srch/index.p hp> Search can help increase your site traffic. . <http://geo.yahoo.com/serv?s=97359714/grpId=1400138/grpspId=1705115361/msgId =42352/stime=1200347540/nc1=3848614/nc2=3848642/nc3=4025338> __,_._,___ --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
