RE: formatting with commas
Not quite sure I know what you mean but if the checkboxes are all named the same with different values, then the form scope already holds a comma delimited list of selected items Eg... input type=checkbox name=chk value=1 checked input type=checkbox name=chk value=2 checked input type=checkbox name=chk value=3 checked If that were submitted then form.chk would be '1,2,3' The checkboxes each have a separate name in the db input type=checkbox name=chkDVD value=1 checked input type=checkbox name=chkLCD value=2 checked input type=checkbox name=chkTV_Vcr value=3 checked They were separated out so that we could query/group them in different ways. Now on the report the info needs printed out (vs being a checkbox)as This person needs DVD,Tv,LCD. Right now it prints like DVD TV LCD ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206523 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
formatting with commas
On an input page the user has a group of related check boxes that they can mark. (ie: type of eqp needs: dvd/projector/smartboard/etc). The user can check as many as needed. On the report this info will be dumped into one column titled EqpNeeds. I set it so that if there's a 1 in the field it'll write out the type of eqp. (dvd smartboard) What I now want to do is add commas. However because there are 6 choices and 0 to 6 may be marked I can't think how to add a comma without it possibly looking funny (ie: the last item-or the only item- lists with a comma behind it.) tia. j ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206354 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SQL Join Challenge
I'm confused about what exactly you want From your original email I get that you want 1. All the rows from lessons 2. Any rows from students table that matches lessons on the lessonid 3. A where clause to narrow down the students who are listed. However in your comment to John you said that you need all the students who have a s.lessonid=l.lessonid match listed. I'm not sure why you would need the AND statement. According to your reply to John it sounds like you really don't need a where clause because all the students with a matching lessonid will already be listed. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198694 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
activepdf and cf
For those of you who use activepdf, a quick question. According to the docs you can put an image into the setformfield tag I tried their code, but no luck. Not only does the image not show up, but if I open the final pdf and click to view the fields- the field doesn't even transfer to it Anyone do this at all? CFSET Lhead=Tlkt.SetFormFieldData(Lrhead,Letterhead2.jpg ,-995) Thanks, J ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198702 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfstoredproc changes every accent character to '?'
I assume that you are talking about just a couple of problem characters. Once identified you can do a replace and replace the offending character with the ascii equivalent. Once you've run the replace they should go in the database ok. Hope that helps. j ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197868 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cf_avery....
Nope, word isn't on the server. I didn't see anything in the documentation that it needed to be installed. Will install and try again. Thanks. J Do you have M$ Word installed? The avery tag uses word to do all the formatting, from what I remember. If it isn't installed, it probably will throw an error. Ray At 02:23 PM 3/8/2005, you wrote: ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197887 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Upload file...in reverse
Quick question about uploading files. We have a department that has an access database- they have over 20 different sites. Because of wan speed issues they can't all be on the main db, instead they each have a local copy of the data. So each day the user goes in and pulls a new zipped copy of the dbs needed to make it run (there's 3 that are needed so they are all zipped up and downloaded to a special folder in the document folder.) I've been asked if I could make a page that would allow them to download the databases into their document folder and the shortcut database to their desktop. (they want to avoid all the zipping etc) Thanks, J ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197100 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: adding table to Query?
This solution will work IF you always have an entry in the fields categories_tb.IDC and the number_tb.IDN Is that the case or is there occasion where this is left blank. If either of these fields are left blank they will not show up in your query results. If you want them to show up in your results simply replace the inner join with a left outer join (The left outer join basically says still bring the info from the categories table even if the field IDC is blank. So basically it will bring all the same records as your inner join) Make sense? Here's the change you'll want to make: SELECT words_tb.word, words_tb.pronunciation, meanings_tb.shortMeaning, categories_tb.category, number_tb.number FROM ((words_tb INNER JOIN meanings_tb ON words_tb.word = meanings_tb.wordFK) LEFT OUTER JOIN categories_tb ON categories_tb.IDC = meanings_tb.IDCFK) LEFT OUTER JOIN number_tb ON number_tb.IDN = meanings_tb.IDNFK WHERE words_tb.word = '#form.word#' Thanks, that worked. I had tried a few combinations before but could not just hit the right syntax. Here's the resulting code from DW (with parentheses for Access): SELECT words_tb.word, words_tb.pronunciation, meanings_tb.shortMeaning, categories_tb.category, number_tb.number FROM ((words_tb INNER JOIN meanings_tb ON words_tb.word = meanings_tb.wordFK) INNER JOIN categories_tb ON categories_tb.IDC = meanings_tb.IDCFK) INNER JOIN number_tb ON number_tb.IDN = meanings_tb.IDNFK WHERE words_tb.word = '#form.word#' ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196780 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SQL Problem
The problem is you have session.division='ss'do you mean division='ss'?? What is the database field name, not the session variable name? Hi Can anybody help on why the following query is returning the error missing expression shown below ? If I remove the AND session.division='ss' the query works fine ? Any ideas ? CFQUERY DATASOURCE=#Application.DSN# NAME=update SELECT docid, doctitle, docdate FROM doc WHERE username ='#Session.Fname# #Session.Lname#' AND directorate='team' AND session.division='ss' ORDER BY docid desc, docdate desc /CFQUERY Error Executing Database Query. [Macromedia][Oracle JDBC Driver][Oracle]ORA-00936: missing expression The error occurred in \publishing\doclisting.cfm: line 16 14 : SELECT docid, doctitle, docdate 15 : FROM docs 16 : WHERE username ='#Session.Fname# #Session.Lname#' 17 :AND 18 : directorate='ssh' TIA ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195899 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
PreserveSingleQuotes In search page
I have a page for users to search what is in the database. There are a half dozen different things they can search on. Title/Author/Genre/Etc My action page pulls all the chosen criteria together and sends it to a stored procedure. It is not working when a user types in a ' into a title. I've added the PreserveSingleQuotes to the title piece: CFSET TitleSearch=Where (Title Like '#PreserveSingleQuotes(Attributes.Title)#%' I added it to the code that pulls all the criteria together: CFSET SearchThis=#PreserveSingleQuotes(Title)# #Genre# #Grade# #Voice# #Type#) And lastly I added it to the stored procedure. However, the ' still whacks it all out. CFPROCPARAM TYPE=IN CFSQLTYPE=CF_SQL_VARCHAR VALUE=#SearchThis# DBVARNAME=@SearchThis Any ideas? Thanks, J ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193058 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Client Variable database
That was my initial reaction. But the maintanance plan that this database uses is suppose to shrink the log/ remove old files after a certain amount of time. All the other databases under this maintenance plan have not balloned like this one. It's strange that it's only happening on this particular database ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184317 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: Sql insert from one db to another
INSERT INTO tableName (field1, field2) SELECT field1,field2 FROM DatabaseName.dbo.TableName ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=36 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183139 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
SMTP-cfmail
We have set the SMTP service on our test coldfusion box to send emails.(our actual mail servers only allow me to send mail that is part of our intranet). Now when I try to send automated msgs to an outside email acct (ie: [EMAIL PROTECTED]) it doesn't work.In the log there is the message Error,1368,09/01/04,08:07:17,,Failed to send the spooled mail file,SMTP server replied 4.3.1 Out of memory Moved file to Has anyone seen this/know a remedy? Thanks!! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SQL search query
I am now in the habit of putting all my cfif/else statements before the query because I actually never use cfquery.I put everything in stored procedures.So I either put it before the stored proc or sometimes do a case/if/then in the proc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ot-quick javascript question
Archive: http://www.houseoffusion.com/lists.cfm/link=i:4:166644---You want Password.value -dov Nope that didn't work. Plus isn't value used differently. I use value to check for nulls/if there's @/. in email addresses, etc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: sql question...
Archive: http://www.houseoffusion.com/lists.cfm/link=i:4:166649---You are getting multiple records because your tables are probably set up as one to many relationships and there is 2/more records being pulled from the table. For example if an account is hooked to more than 1 payment plan or the debtor has more than 1 account.These will bring up multiple records because you are not pulling anything unique from those tables. To test try adding the primary key/unique identifier for the different tables to your query/group by statement. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL search query
Robert First off you need to get rid of the where 0=0 in the where clause and use some logic to set how you really want your where statement to look. Ive found that the easier way to handle these is to do it all in an cfif statement before the actual query.That way you dont have to do all of the logic in the query. Ive found it more readable and easy to use. For example CFPARAM NAME= FORM.ponumber DEFAULT= CFPARAM NAME=FORM.invoicenumber DEFAULT= CFPARAM NAME=FORM.vendor DEFAULT= CFPARAM NAME=SearchAll DEFAULT= CFIF Form.ponnumber neq CFSET Searchpon=Where ponumber like %#Form.ponumber#% CFIF FORM.invoicenumber neq CFSET SearchInv=And invoicenumber LIKE'%#FORM.invoicenumber#%' /CFIF CFIF FORM.vendor neq CFSET Searchven= And vendor LIKE '#trim(FORM.vendor)#' /CFIF CFSET SearchAll=#SearchPon##SearchInv##SearchVen# CFELSEIF Form.Ponnum is and Form.Invoicenumber NEQ CFSET SearchInv=WHERE invoicenumber LIKE'%#FORM.invoicenumber#%' CFIF FORM.vendor neq CFSET Searchven= And vendor LIKE '#trim(FORM.vendor)#' /CFIF CFSET SearchAll=#SearchInv##SearchVen# CFELSEIF Form.Ponnum is and Form.Invoicenumber is and Form.vendor NEQ CFSET SearchVendor= Where vendor LIKE '#trim(FORM.vendor)#' CFSET SearchAll=#SearchVendor# /CFIF CFQUERY NAME=Getpo datasource=purchaseorders SELECT * FROM purchaseorders p, itemsordered I inner join p.CommonID=i.CommonID #SearchAll# You also need to connect the tables in your from clause.Your current from would list out a record for each record from both tables. (ie:if you have 10 in the I table and 7 in table P youd have 70 records that show). I added an inner join, just add whatever id hooks the 2 tables. I hope that you did a select * just for the example here and that you are not using it for the actual query.You should only select what you really need. The * is going to pull every single field from both tables- do you really need/want all that info. (and do you want your database chugging away on all that unwanted stuff?) Hope this gets you started. J [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Pages not showing in mx
the view source comes up blank.So I'm missing what? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Pages not showing in mx-Is there a new FB pg?
When I run the debug I see that it goes through the pages and then says startup, parsing, compiling, loading shutdown That happens right after it goes through my page that holds the fb logic on which pages to use. This is the last page that's processed.Has this page been changed for mx? is that the prob? cflock type=READONLY name=#server.coldfusion.productVersion# timeout=10 cfset variables.fuseboxVersion=Replace(Replace(ListDeleteAt(server.coldfusion.productVersion,4)all), ,,all) cfset variables.fuseboxOSName=server.os.name /cflock cfif variables.fuseboxVersion lt 450 cfinclude template=fbx_fusebox30_CF40.cfm cfelseif variables.fuseboxVersion lt 500 cfif variables.fuseboxOSName contains Windows cfinclude template=fbx_fusebox30_CF45.cfm cfelse cfinclude template=fbx_fusebox30_CF45_nix.cfm /cfif cfelseif variables.fuseboxVersion lt 600 cfif variables.fuseboxOSName contains Windows cfinclude template=fbx_fusebox30_CF50.cfm cfelse cfinclude template=fbx_fusebox30_CF50_nix.cfm /cfif /cfif [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Pages not showing in mx
Ok I'm getting closerNow I have an error tag for the cfswitch tag in my fbx_switch file.Where I start the switch cfswitch _expression_=#fusebox.fuseaction# I've looked in all the fbx files/application/etc looking for some variable that needs changed, but no luck. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Pages not showing in mx
hmm and when I add a simple ending to the default page ie: index.cfm?fa=con.Main the page comes up blank but all the source code is there. No errors on the debugging page. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: 2003 MAX Conference Registration System
(I can't believe I am doing this) I used to work for a place that did that - the app is not for sale but you can use the service - it's called Regweb, and if you want to use it let me know off list and I'll get you in touch with the right people. Cheers, Rob Rob can you contact me about this app also. (Can't seem to get your email from the archives so sorry about the email to all). Thanks, J [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Configure 1 box with sql/cf together
Well the original solution included 2 new boxes outside the company firewall. One for a database one for the web server. We can find the money to do it. I then received an email saying to make it easier on everyone can we do it this way-one box with everything. I'm thinking that this may not be easier in the long run. Our long term goal is to provide more applications via internet. This project starts us in that direction and gives us a test case in security without compromising sensitive data. (how easy is it to attack our pages from the outside?) I guess I'm trying to make the case that if we're going to do this we shouldn't cut corners, that we should set up for the real world from the beginning. I admit I don't know much about the hardware issue.But I thought that it was recommended to keep webserve/database separate. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Configure 1 box with sql/cf together
I agree that we should go with 2 boxes. What I'm looking for is concrete reasons to give for the 2 box recommendation vs all on one box. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]