cf_avery....
Has anyone used the cf_avery tag that is suppose to format the information into mailing labels? The directions sounded simple enough- so I did a simple query and set it out to display. I got an error. I can't even get their example.cfm page to work. Instead I get a pop up box claiming: IE cannot dowload blah blah- IE was not able to open this internet site. The requested site is either unavailable or cannot be found The site I'm trying to use it in is fb3, but that shouldn't make a difference. Thanks for any ideas. ~| 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:197875 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
SOT: Client Variable database
I am using client variables for some of my applications. I have done the recommended way and made a client variable database to store all the info. (on a MSSQL db) It is the only info stored there. I just noticed today that this db is over 10 gig big! It's not like there are many rows of informtaion. My other database that has millions of rows is 80% smaller than this database! This database is on the same maintenance plan as the other database. Any clues to why this is happening. Thanks, J ~| 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:184298 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
ot-quick javascript question
Archive: http://www.houseoffusion.com/lists.cfm/link=i:4:166634---I use some _javascript_ validation for one page where users can change account information. I want to add a validation that alerts them if the password is less than 6 characters long I have this but it doesn't work. Here's the chunk I added- any ideas why this doesn't work? I've tried it 2 different ways 1. like this where the theform.Password.length 2. I set as a var Pass=theform.Password var=Passlength=Pass.length thanks, j if (theform.Password.length<6){ alert("The password must be at least 6 characters long.") theform.Password.focus() return false; } [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMail Limit?
I have a conference application. On the admin page the user can send an email to notify the presenter on if their proposal has been accepted. It then shows in the database if the person was notified and the date. This piece doesn't seem to be working properly. What is working: The query pulls all the people up properly. I see all 100+ people who submitted proposals. The update query at the end that the person has been notified What is not working- the section of the page It DOES Work if there's only a few to mail (I've sent up to 10 or so) But seems to be choking on the number that needs sent out. Any ideas?? Thanks in advance for any help. J [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: activePDF
Phillip, I'd be glad to answer a few questions. We use activepdf for several projects. Feel free to contact me off list. Janine Subject: activePDF From: Phillip B <[EMAIL PROTECTED]> Date: Thu, 10 Jun 2004 10:01:32 -0500 Thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messages&threadid=0&f orumid=4#166130 Any one use this with CF and can answer a few questions for me? Phillip B. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF-Talk: Digest every hour
Subject: activePDF From: Phillip B <[EMAIL PROTECTED]> Date: Thu, 10 Jun 2004 10:01:32 -0500 Thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messages&threadid=0&f orumid=4#166130 Any one use this with CF and can answer a few questions for me? Phillip B. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Pages not showing in mx
I just set up a test mx box with a FB3 application. Used the analyzer to check my cf5 pages- all came up clean However, the browser is blank when I call the pages. Any ideas of what I missed when I did the setup? Thanks, J [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Strip ()-
On a phone number field I want to make sure that users haven't added ()-. I figure the easiest way is to strip it off before entering it into the database. How would I set that? Thanks, [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: Configure 1 box with sql/cf together
I've been asked if we can put sql/cfmx all on one box. This is to be set outside our company firewall. (We currently have a "best practices" case set up behind the firewall on our intranet. This 2nd one would be for non-sensitve database information) I need to make a reply/case/recommendation on this. My initial reaction is yes, technically it can be done. And no we should not do this. They don't want to compromise our firewall at all. Having everything in front of the firewall is their solution. I thought best practices was to have the database behind a firewall and have the webserver/cfserver make the call to it? Can someone clarify? I really didn't see the issue on macromedias site. TIA J [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Problems with Nulls
-Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: Monday, December 15, 2003 10:28 AM To: CF-Talk Subject: Problems with Nulls Hello All, I am running in to a problem on something that I do locally on our intranet. I query one database(SYBASE) then load the data that I need in to an access database for a CF app that I have created. There is section on the sysbase database where notes are entered then notes tables looks like this AccountNumber NoteDate Notetime Note Then I loop over all these records and insert them in to my access database it works fine until I hit a record that has no date I get this error Error Diagnostic Information ODBC Error Code = 22005 (Error in assignment) [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria _expression_. SQL = "Insert into Client_comm (AccountNumber, Act_date, Act_time, Comments) Values (1081729, '','', '+Match Search (by SIN Number)---')" In my access database the fields are as follows AccountNumber(Number), Act_date(date) Act_Time(text), Comments(text) My Insert statment looks like this Insert into Client_comm (AccountNumber, Act_date, Act_time, Comments) Values (#AccountNumber#, '#dateformat(act_date, "mm/dd/")#','#timeformat(act_time, "hh:mm:ss")#', '#comments#') Thanks Mike _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT:sql Row Error Msg?
Ok this is a new one for me! I have a table that users add plans to. Because each section of the plan can be extensive each field is 4000 characters long. I have one user who is having a problem. He said when he went to edit the last field e received the following error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot create a row of size 8063 which is greater than the allowable maximum of 8060. So this has to actually do with a SQL row character maximum? (Its' SQL2000) I retried entering the plan in the test environment and had the same issue. I then tried to do an edit from sql query analyzer and got the same message. Anyone know about this- how to work around it? Thanks, J [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SOT: In statement in stored proc
Hey is there a way to do a dynamic in statement for a stored proc in sql2000? I keep getting errors when I change my proc to a simple = to an in statement. (or more precisely when I choose more than 1 options from the select box) so I assume it's how it's being sent?? Maybe in the cf part of how to call a stored proc. I thought about making this into a loop list situation, but it's actually pulling a huge amount of data and don't like the overhead that the loop would add... Instead of giving my huge queries here's an example of what I'm doing. The ID is coming from a select box -- cf page VALUE="#Attributes.ID#"> [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Question
go to www.tek-tips.com look under sql they have a pretty decent keywork search. I've seen good stuff on their site dealing with these type of issues. I'd dig around and give specific data but have to go to a late meeting- -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2003 4:45 PM To: CF-Talk Subject: RE: SQL Question Looking at this as it comes back to me I realized this will only work if all the students in your table graduated in the 11th century or later. Watch out for that one ;) Adam. -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2003 3:08 PM To: CF-Talk Subject: RE: SQL Question UPDATE TopStudents SET studentdetails = left(studentdetails, length(studentdetails) - 12) WHERE 0 = 0 change the left and length functions according to your DB semantics. -Original Message- From: Srimanta B [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2003 1:54 PM To: CF-Talk Subject: SQL Question Hello, Can someone please help me. I wish to delete part of a text in "student" field keeping part of the text in the same field intact. Database: Access. Table name is: TopStudents The field names are: studentid, studentdetails, percentage, grade. The contents of the rows in the "studentdetails" field are similar to this: Student Name1 - Year 1950 Student Name2 - Year 1953 Student Name3 - Year 1953 Student Name4 - Year 1953 Student Name5 - Year 1954 I have about 500 rows of data in the table. What I wish to do is to keep the student names in the rows intact and delete everything on the righthand side from the -. Any help would be much appreciated. Regards SB _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Tool to move Access-to-MySQL
If you're using Access2000 you'll be able to use their uplink wizard. It allows you to move the tables to sql and to even keep them in your access database. Now last time I used this product was Sql 6.5- years ago. There was some weirdness that I would test for if I were you. Make a backup of a table then use the uplink mgr to test. 1. The y/n fields became bit fields. The bit fields could not be null. I'm pretty sure that doesn't do that anymore, but can't say for sure. Anyways that leads to problems-we were using that field with checkboxes- suddenly all my non checked boxes wigged out. 2. The database I was uplinking wasn't one I designed. The designer did some things that worked with Access/but not in sql at the time (ie: Field names with # or spaces other weirdness). Make sure your field names comply with SQL. 3. Most of the time sql does keep it pretty close, but I notice that sometimes it'll want to change a field type. Like a text field may become a nvarchar field. You'll want to go into the sql end and change those to varchar. Otherwise the uplink manager is easy to use. If you're using something lower than Access2000 you can get the uplink manager off of microsoft site. If you have access2000 it should be installed. Good luck. J -Original Message- From: Ketan Patel [mailto:[EMAIL PROTECTED] Sent: Thursday, November 20, 2003 10:30 AM To: CF-Talk Subject: Tool to move Access-to-MySQL Hi All, Does anybody know about free tools which will move Access-to-MySQL and which will not spoil or change the data structure. Ketan _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Quick question- give text area focus
I have a page that the users wanted multiple textarea fields that could be spell checked. They also wanted to be able to review all of their previous work as they were submitting it AND for the page to advance to the next box. To do that plus to keep it from being a mess of huge textarea boxes (2000 characters/each one) I made it so that it is a page of links Link1 blah blah info for users to read whats in this section Link2 blah blah info for users to read whats in this section Link3 blah blah info for users to read whats in this section Link4 blah blah info for users to read whats in this section If a user clicks on Link2- link2 becomes a textarea box while all the other links look exactly the same. (So only one thing is editable at a time). When the user saves the information in the textarea box of link2 it is saved then the user is returned to find Link3 now a textarea to be edited. Looks good/saves space/easy to use. 1 problem though. I'd like the cursor to automatically be in the textarea box. So they click save and the new textarea shows up- the cursor is there and they just have to start typing. Right now they have to always click in the box before typing. Is there any way to do that? TIA, J [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Users want to format text
That one doesn't show up on a mac either j -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 6:39 PM To: CF-Talk Subject: RE: Users want to format text why dont u do it in flash? or use a flash editor and i hope he could copy and paste it into the right place this one is fantastic http://www.joshdura.com/archives/000163.php > I'm having the same problem. One mac user (the site owner). I think > everyone else uses Windows. > > My biggest problem is that the editors are using a number of different > versions of MS Word to write up their content. Some versions convert > just fine (using FCKEditor - windows only) while others leave bad markup > and unprintable characters. > > Of course, we can't expect the end users to be careful :-) > > I'm looking at soEditor Pro 2.5 - has anyone used this with multiple > versions of MS Word? I know it won't work for the Mac user - he's ok > with that, but the MS Word support has to be top notch. > > Why can't they just learn a little HTML! Hehe > > > >> -Original Message- >> From: Janine Jakim [mailto:[EMAIL PROTECTED] >> Sent: Thursday, November 13, 2003 12:58 PM >> To: CF-Talk >> Subject: RE: Users want to format text >> >> >> Would be perfect if 90% of my users were not Mac users! >> Any good cross platform ones? >> >> -Original Message- >> From: Mickael [mailto:[EMAIL PROTECTED] >> Sent: Thursday, November 13, 2003 12:42 PM >> To: CF-Talk >> Subject: Re: Users want to format text >> >> >> Use HTMLEdit from http://www.interactivetools.com >> >> >> Easy use >> - Original >> Message - >> From: Janine Jakim >> To: CF-Talk >> Sent: Thursday, November 13, 2003 12:30 PM >> Subject: Users want to format text >> >> Have an application with a bunch of input boxes. The users >> want to be able >> to do snazzy things as if it's a word document- underline, >> bold, change font >> size and/or type for certain parts. >> Is this possible? >> They then want to output it to a word doc. (I do know that's doable) >> Thanks, >> J >> >> >> _ >> >> >> > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFINCLUDE within CFLOOP not working
My guess there's something wrong with this line This isn't a database command so you don't need a & to concatonate the 2 together. To check do a #theReport#/#ReportName# That'll probably show you the error as the report name probably isn't what you want it to be. good luck -Original Message- From: Sam Komolafe [mailto:[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 2:44 PM To: CF-Talk Subject: CFINCLUDE within CFLOOP not working Hi, How do I dynamically include files using CFINCLUDE within a CFLOOP statement: This does NOT WORK: Help will be appreciated. Thanks _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Users want to format text
Would be perfect if 90% of my users were not Mac users! Any good cross platform ones? -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 12:42 PM To: CF-Talk Subject: Re: Users want to format text Use HTMLEdit from http://www.interactivetools.com Easy use - Original Message - From: Janine Jakim To: CF-Talk Sent: Thursday, November 13, 2003 12:30 PM Subject: Users want to format text Have an application with a bunch of input boxes. The users want to be able to do snazzy things as if it's a word document- underline, bold, change font size and/or type for certain parts. Is this possible? They then want to output it to a word doc. (I do know that's doable) Thanks, J _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Users want to format text
Have an application with a bunch of input boxes. The users want to be able to do snazzy things as if it's a word document- underline, bold, change font size and/or type for certain parts. Is this possible? They then want to output it to a word doc. (I do know that's doable) Thanks, J [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL for duplicate entries
One way to view duplicates is by using a having clause in your query. It means that there's at least one id/something that will help you know that the record is a duplicate. An example of this sql is: select emp_ID, departmentid from employees GROUP BY emp_ID, departmentid having count(emp_ID)>=2 I had to do this for a database that I took over and didn't feel comfortable deleting any record until I knew that the one of them was verified as correct. J -Original Message- From: brob [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 04, 2003 3:09 PM To: CF-Talk Subject: SQL for duplicate entries Hey guys, i have a table with abot 4,000 records. Is there a special SQL that will return all records that are duplicates, or do I have to do it the old fashioned way? THanks _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Invalid character
Ok can someone help here. I'm getting the following error in my cf application log: "Error","1344","10/28/03","09:46:08",,"ODBC Error Code = 22005 (Error in assignment) [Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification SQL = ""storeproc_SaveComment"" ""Error","1344","10/28/03","09:46:08",,"172.16.91.52, Mozilla/4.0 (compatible; MSIE 5.17; Mac_PowerPC), ODBC Error Code = 22005 (Error in assignment) [Microsoft][ODBC SQL Server Driver]Invalid character value for cast specificationThe error occurred while processing an element with a general identifier of (CFSTOREDPROC), occupying document position (13:1) to (13:73).The error occurred while processing an element with a general identifier of (CFRETHROW), occupying document position (246:11) to (246:21).Date/Time: 10/28/03 09:46:08Browser: Mozilla/4.0 (compatible; MSIE 5.17; Mac_PowerPC)Remote Address: 172.16.91.52HTTP Referrer: http://k12.org/Grades.cfm?Fuseaction=RC.Comments String: fuseaction=RC.SaveComment" Sounds like a simple invalid character situation- but I figure out how to fix it. This stored procedure/query has 2 fields. The cf code looks like this: DATASOURCE="#Request.maindsn#"> VALUE="#Attributes.ComID#"> VALUE="#PreserveSingleQuotes(Attributes.Comment)#"> AND then the actual stored proc is: CREATE PROCEDURE storeproc_SaveComment @ComID INTEGER, @Comment varchar(2000)=Null AS UPDATE tbl_StudentComments SET [EMAIL PROTECTED] WHERE [EMAIL PROTECTED] GO I can't reproduce the error but it looks like one or two users had their information cut off. And not at an obvious place (ie: where the apostrophe is) Any ideas? I'm stumped. Thanks in advance! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ambiguous
Try not to use *, especially on multiple tables. And you need to link in your customers table somehow or you'll have a complete mess... Do something like SELECT Lastname, firstname, c.customerid, o.orderid, b.booktitle FROM customers c inner join orders o on c.customerid=o.customerid join bookinfo b on b.bookid=o.bookid This also leaves your where clause free for other types of filters (ie: where order date between Jan and june/etc...) if you use an alias there won't be any problems with ambiguous field names. Also, it easier 6 mo down the road when you revisit the issue... Good luck -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Monday, August 18, 2003 11:36 AM To: CF-Talk Subject: ambiguous I get a How do I fix this SQL error please? ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Ambiguous column name 'customerid' Both orders and customers have a customerid column My statement: SELECT * FROM bookinfo, orders, customers Where bookinfo.bookid = orders.bookid Thanks! Robert O HWW ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: PDF Question
Mark, What I did with something similar was to add them together for the ouput and set a character return between each paragraph.(in fact yours sounds a bit simpler since you have 3 distinct paragraphs- I had a multitude of various paragraphs with variable length! So do this: i think chr(10) is what works for carriage return... hope this helps. j -Original Message- From: Mark Stewart [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 3:43 PM To: CF-Talk Subject: PDF Question I currently use ActivePDF and It's been working great except for one problem... Example: I have a pdf with 3 paragraphs in it, the second paragraph being variable text that a user would enter through a textarea. The second paragraph in the pdf is a form field that I will populate through the ActivePDF api. So, the first paragraph is fixed height, the second is variable and the third is also fixed height. How would I make it so the area for the second paragraph would shrink, or grow, depending upon the amount of text in the second paragraph. I'm trying to eliminate the large gap between paragraph 2 and 3 if the user happened to enter something like, "Hello World!", for the second paragraph. If there is another product other than ActivePDF, I would be open to that. Thanks in advance for any help. Mark ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Returning value from a stored procedure?
Would help if I start reading the whole email before responding. I'm having a rough day here SET @AffiliateName = '' Why did you do this in your stored proc?? Won't this automatically always set it to ''? -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED] Sent: Thursday, July 03, 2003 10:16 AM To: CF-Talk Subject: RE: Returning value from a stored procedure? There's still a problem with the sp because when I execute it in query analyzer it prints a empty string. Some reason the query value is not getting put in the variable. -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED] Sent: Thursday, July 03, 2003 10:08 AM To: CF-Talk Subject: RE: Returning value from a stored procedure? Get rid of the null=yes. That is setting it to ''. -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED] Sent: Thursday, July 03, 2003 10:06 AM To: CF-Talk Subject: Returning value from a stored procedure? Are there any SQL guru's that can help me with this stored procedure? I'm trying to return '@AffiliateName' but it always returns ''. I know the query matches one record but the value is never saved to the Out variable '@AffiliateName'. -- -- CREATE PROCEDURE dbo.sp_test @ratecode char (10), @referringdomain varchar (100), @AffiliateName varchar (100) = NULL OUT AS DECLARE @affiliateID int, @ratecodeID int SET @AffiliateName = '' SELECT @affiliateID = A.AffiliateID, @ratecodeID = B.RateCodeID, @AffiliateName = A.AffiliateName FROM dbo.tbl_A A INNER JOIN dbo.tbl_B B ON A.AffiliateID = B.AffiliateID WHERE (A.ReferringDomain = '@referringdomain') AND (B.RateCode = '@ratecode') AND (B.ExpirationDate >= getdate()) IF @AffiliateName <> '' INSERT INTO dbo.tbl_C (affiliateID, ratecodeID) VALUES (@affiliateID,@ratecodeID) -- Regards, Dave Bosky HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Returning value from a stored procedure?
Ps. Guess I should have rewritten this for you for an out variable this is all you need- no dbvarname either- that goes with the in type. for type="in" you need dbvarname, value, cfsqltype. for type="out" use cfsqltype, variable. Also don't use the null=yes unless you KNOW for a fact that it will be null. So your stored proc rewritten would be #varType#=Form/session/attributes- whatever variable you are using. In your stored proc set that it can be null @Ratecode varchar(4)=Null, @referringdomain varchar(50)=Null, @AffiliateName varchar(30)=Null, etc -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED] Sent: Thursday, July 03, 2003 10:06 AM To: CF-Talk Subject: Returning value from a stored procedure? Are there any SQL guru's that can help me with this stored procedure? I'm trying to return '@AffiliateName' but it always returns ''. I know the query matches one record but the value is never saved to the Out variable '@AffiliateName'. -- -- CREATE PROCEDURE dbo.sp_test @ratecode char (10), @referringdomain varchar (100), @AffiliateName varchar (100) = NULL OUT AS DECLARE @affiliateID int, @ratecodeID int SET @AffiliateName = '' SELECT @affiliateID = A.AffiliateID, @ratecodeID = B.RateCodeID, @AffiliateName = A.AffiliateName FROM dbo.tbl_A A INNER JOIN dbo.tbl_B B ON A.AffiliateID = B.AffiliateID WHERE (A.ReferringDomain = '@referringdomain') AND (B.RateCode = '@ratecode') AND (B.ExpirationDate >= getdate()) IF @AffiliateName <> '' INSERT INTO dbo.tbl_C (affiliateID, ratecodeID) VALUES (@affiliateID,@ratecodeID) -- Regards, Dave Bosky HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Returning value from a stored procedure?
Get rid of the null=yes. That is setting it to ''. -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED] Sent: Thursday, July 03, 2003 10:06 AM To: CF-Talk Subject: Returning value from a stored procedure? Are there any SQL guru's that can help me with this stored procedure? I'm trying to return '@AffiliateName' but it always returns ''. I know the query matches one record but the value is never saved to the Out variable '@AffiliateName'. -- -- CREATE PROCEDURE dbo.sp_test @ratecode char (10), @referringdomain varchar (100), @AffiliateName varchar (100) = NULL OUT AS DECLARE @affiliateID int, @ratecodeID int SET @AffiliateName = '' SELECT @affiliateID = A.AffiliateID, @ratecodeID = B.RateCodeID, @AffiliateName = A.AffiliateName FROM dbo.tbl_A A INNER JOIN dbo.tbl_B B ON A.AffiliateID = B.AffiliateID WHERE (A.ReferringDomain = '@referringdomain') AND (B.RateCode = '@ratecode') AND (B.ExpirationDate >= getdate()) IF @AffiliateName <> '' INSERT INTO dbo.tbl_C (affiliateID, ratecodeID) VALUES (@affiliateID,@ratecodeID) -- Regards, Dave Bosky HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
low battery-page timeout doesn't work
On my pages I use timeout in 15 minutes if no activity Well on an IMac the battery died. The user decided to stop workingthe next day the IMac was plugged in and presto there was the page. Is there anyway around this?? Thanks, J ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Active PDF?
Josen, Your link would hit an action page that would pull up the report. One thing I would strongly recommend. Have your link open a new window. Depending on the browser it can/will get stuck in the pdf. A huge annoyance. Here is a quick example of how the action page works...Hope it helps -Original Message- From: Josen Ruiseco [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2003 9:05 AM To: CF-Talk Subject: Active PDF? I just purchased active Pdf and am having a rpoblem figuring out how to merge pdf docs together. I have contacted support and after three days they still have not helped me. Basically I have document names stored in a database. I want to pull those names and merge, then show a link to the merged document where the user can view it. Can someone post some code demonstrating this? Thanks, Josen ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
different type of display problem
I've been searching but haven't found the answer. I have some nested loops that cf doesn't seem to like- I've read about nested loops off their site, but still haven't found the answer that is a little more involved... I need to show data that loops through I think the best way to explain it is to show it 1st Query Main Topic shows here. There's only one Main Topic 1. 2ndQuery Output1- A subtopic of the Main Topic a.1 3rd query linked to 2nd query (output1) a.2. 3rd query link to 2nd query (output1) b.1. 4th query linked to 2nd query (output1) 2. 2ndQuery Output2 A subtopic of the Main Topic a.1 3rd query linked to 2nd query (output2) a.2. 3rd query link to 2nd query (output2) b.1. 4th query linked to 2nd query (output2) b.3. 4th query linked to 2nd query (output2) b.3. 4th query linked to 2nd query (output2) 3. 2ndQuery Output3 A subtopic of the Main Topic a.1 3rd query linked to 2nd query (output3) b.1. 4th query linked to 2nd query (output3) b.2. 4th query linked to 2nd query (output3) etc. The best I have been about to do is show all the correct information for the subtopics (1-3)of the Main Topics but can't get the a.1/b.1 to show the correct data- it always just shows the data for the first one (2ndQuery Output1) This is how I set up the output : #StemGet.Stem# Interpretations: #InterpretationsGet.Interpretation# Benchmarks: #BenchmarksGet.Benchmark# Any help will be greatly appreciated. I'm feeling like I'm going in circles- I can get the display to be correct only when I do it with one subtopic per page, however, they need to all show on one page. j ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Data getting truncated on select
Last time something like that happened to me I realized that in the stored proc I put in the wrong number of characters id: @MacroName VARCHAR(50) instead of @MacroName VARCHAR(500) -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 1:51 PM To: CF-Talk Subject: Data getting truncated on select Greetings, I am querying a row in a table bringing back a large about of html data from a column named RawData, data type TEXT, When outputting a lot of data is not getting output, this is really strange, But I went into query analyzer and updated the field with a really large text string, "data data etc... end" on outputting the data it was prove somehow on select its being truncated as "end" did not get output. My stored proc looks like this, CREATE PROCEDURE leo4_getScheduledData ( @customerID INT, @MacroName VARCHAR(50), @ContainerID INT ) AS SELECT * FROMSchedulesContainer WHERE [EMAIL PROTECTED] AND [EMAIL PROTECTED] AND [EMAIL PROTECTED] any ideas would be appreciated. J ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: printer friendly page break?
Is there an easy way to force a page break at certain sections? I have a huge page that people want to view as a long scrollable cfm page but when printed they want it to start a new page at certain points. (ie: there may be 5 lesson plans- they'd want each lesson plan on a separate page/etc.) There are going to be lots of different browser types/amt of info per page. Thanks for any/all help. j ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Loop using roman numerals??
I'm wondering if I can do this easily?? I need a numbered loop, but it needs to be roman numerals i, ii, iii, iv, v, vi, etc Is there anyway to do that easily or do I need to do the cfif recordcount blah blah. thanks, j ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL Question
SELECT * FROM product A,style B,quantity C WHERE A.product_id = B.product_id AND B.style_id = C.style_id AND ORDER BY A.product,B.style,F.productSize 1. You do not want to use * in this as it's going to pull all fields from all tables- you don't need the duplicates... 2. I don't know what id names your using/what tables need left joins so I'll say APrimary for primary key of table A/Product, etc SELEct blah blah from product A LEFT OUTER JOIN STYLE B on A.ProductID=B.ProductID LEFT OUTER JOIN Quantity C on B.Style_ID=C.Style_ID -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, June 02, 2003 11:57 AM To: CF-Talk Subject: Re: SQL Question How do I do that with multiple tables? All the examples I have onlu use 2 tables. BJ = = = Original message = = = try a LEFT OUTER JOIN. That should work for you. Jeff - Original Message - From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, June 02, 2003 8:47 AM Subject: SQL Question I have a MS_SQL query (simplified for this question): I have another table that contains images for some of the products. I would like to get back all the products that have or don't have images. I tried using a RIGHT JOIN but I couldn't get it working correctly. The images use the style_id to identify which style they belong to. So B.style_id = D.style_id (D being images) Thoughts? Thanks, BJ ___ Sent by ePrompter, the premier email notification software. Free download at http://www.ePrompter.com. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Intranet to internet and security
So far all of our applciations have run from our intranet. I just made a little app that needs to be open on the internet. When I talked to the system engineer she said: "I will want to investigate security options such as certificates or https. Once we configure a hole in the firewall, we have exponentially raised the risk that the data or systems will be compromised, so I will want to take any appropriate preventative measures." I'm wondering what others have done in similar circumstances. Is there a set "good practices" way to do this? And how much time would a good solution take? Thanks, J ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Quick question- get rid of 1st 2 characters
Thanks -Original Message- From: Bill Henderson [mailto:[EMAIL PROTECTED] Sent: Sunday, June 01, 2003 2:53 PM To: CF-Talk Subject: RE: Quick question- get rid of 1st 2 characters Sorry, brain fart, it's: newstring = right( string,( len( string ) - 2 ) ) -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED] Sent: Sunday, June 01, 2003 11:24 AM To: CF-Talk Subject: Quick question- get rid of 1st 2 characters I know I know this, yet the answer isn't coming immediately... I just need to strip the 1st 2 charaters off a field before sending it to the database. So if this is typed in LV1234 I only want the 1234. Left won't work because the part on right side can be a variable length thanks, j ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Quick question- get rid of 1st 2 characters
I know I know this, yet the answer isn't coming immediately... I just need to strip the 1st 2 charaters off a field before sending it to the database. So if this is typed in LV1234 I only want the 1234. Left won't work because the part on right side can be a variable length thanks, j ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: Make text look to the power of....
Sorry for the ot, but I'm assuming someone can answer this pretty quickly. How do I make the text of the html look like the traditional 10n power? Is it an ascii thing? thanks j ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
format excel
Can I format my excel sheet if I'm using cfcontent or cfheader? I want to add a word wrap featureI know I can do it in COM, but I don't want to re-write the page at this time. Is there anything I can add to make this work? Thanks, J ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT:Oraclequery-quick question on an insert
I have an insert query that I can't get to work... when I remove the top line and run it as a select statement it's fine. when I add the insert statement I get the error 'invalid number' job_ID is actually a varchar2 field- not a number field. here's the query INSERT INTO HR_DEPARTMENTS (DEPARTMENT_nAME, Mgr_Job_ID, LOCATION_ID) SELECT DISTINCT DEPTNAME, JOB_ID, LOCATION_ID FROM HR_TEMPDUMP T JOIN HR_lOCATIONS L ON T.cITY=L.CITY JOIN HR_JOBS J ON T.JOBTITLE=J.JOB_TITLE WHERE j.JOB_ID LIKE 'Mgr%' / any ideas? Thanks in advance. j ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cf_msmenu-open in new page
I really like the cf_msmenu tag- easy to work with/looks good in lots of different browsers and works well with Mac (have lots of mac users). but I'm wondering if there's a way to force this tag to open a page in a new browser window. I have reports that need to come up in a new window, but haven't been able to successfully do this. Anyone work with this tag and successfully do that? Thanks, j ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Q_Range of dates
Use between SELECT * FROM dbo.PaP WHERE test_date BETWEEN #CreateODBCDate (startDate)# AND #CreateODBCdate (endDate)# ORDER BY #sort# ASC -Original Message- From: Kennerly, Rick H CIV [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2003 10:17 AM To: CF-Talk Subject: Q_Range of dates I think I've got a handle on queries for output forms where they are passed a single month/year. However, what would a query for a range (such as JAN 2003 to MAR 2003 or JAN 2003 to DEC 2003) look like? Here's where I am. SELECT * FROM dbo.PaP WHERE test_date >= #CreateODBCDate (startDate)# AND test_date < #CreateODBCdate (endDate)# ORDER BY #sort# ASC Rick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: TSQL Script to replicate a db?
Save as a dts package and then you can edit the information. They have a visual interface- add dependencies/etc. I suggest making some db copies and play with it -Original Message- From: Dowdell, Jason G [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 9:47 AM To: CF-Talk Subject: TSQL Script to replicate a db? Hi All, I have a SQL2K db in a shared hosting environment at CFDynamics.com. Each time I need to duplicate the db (intranet db) for my clients I just use the export tool and export it to another client's db. The problem is that each time I do this I have to go back and set up the autonumber fields on every single table which takes a long time. Does anyone know of a way to take my existing db and use a wizard to create either a stored procedure or a bunch of sql statements that will recreate all of the tables and relationships of my db? Thanks, Jason ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL IN command
That depends- is it a number field or a character field? Number=no varchar=yes. -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED] Sent: Friday, March 14, 2003 3:10 PM To: CF-Talk Subject: SQL IN command Is it necessary to wrap the variable ProductsFound which is a list of ID numbers in single quotes? DELETE FROM tbl_products WHERE product_id IN ('#ProductsFound#') Regards, Dave Bosky Sr. Multimedia Web Designer Horry Telephone Cooperative, Inc. office: (843)369-8613 [EMAIL PROTECTED] HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: subquery and group by a non selected field
Did you find the answer yet? Why not shift the group by classid to the outside query? do you really need all the fields from 3 tables? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2003 4:49 PM To: CF-Talk Subject: RE: subquery and group by a non selected field Yes, that is the problem. I do have to have class_id in the SELECT clause, however in order for it to work with the main query the subquery cannot return multiple columns. Here is where my problem lies. How do I group by a column that I cannot have in my SELECT clause? DM = = = Original message = = = Don't you also need to have class_Id in your select clause? what error are you getting when you just run the subquery by itself? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2003 4:21 PM To: CF-Talk Subject: SQL: subquery and group by a non selected field I am trying to return a list of ids in a sub query but have them grouped by another column. View the subquery below. I am attempting to GROUP BY class_id because I need 1 session_id (the one with the MAX(endDate)) from each group of class_ids. SELECT * ~FROM courses A, classes B,sessions C ~WHERE A.course_id = B.course_id AND ~~ C.class_id = B.class_id AND ~C.session_id IN (SELECT session_id FROM sessions GROUP BY class_id HAVING MAX(endDate) BETWEEN '#url.minDate#' AND '#url.maxDate#') Any ideas on how to get this to work? DM ___ Sent by ePrompter, the premier email notification software. Free download at http://www.ePrompter.com. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: subquery and group by a non selected field
Don't you also need to have class_Id in your select clause? what error are you getting when you just run the subquery by itself? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2003 4:21 PM To: CF-Talk Subject: SQL: subquery and group by a non selected field I am trying to return a list of ids in a sub query but have them grouped by another column. View the subquery below. I am attempting to GROUP BY class_id because I need 1 session_id (the one with the MAX(endDate)) from each group of class_ids. SELECT * ~FROM courses A, classes B,sessions C ~WHERE A.course_id = B.course_id AND ~~ C.class_id = B.class_id AND ~C.session_id IN (SELECT session_id FROM sessions GROUP BY class_id HAVING MAX(endDate) BETWEEN '#url.minDate#' AND '#url.maxDate#') Any ideas on how to get this to work? DM ___ Sent by ePrompter, the premier email notification software. Free download at http://www.ePrompter.com. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Character count on record count??/
Running a cfoutput TotalLen/Narrative[I] looks fine on a regular display. I think it's the behavior of activepdf that is the problem. Each [i] must be identified/hardcoded on the pdf ie: Narrative1, narrative2, Narrative3, Narrative4 So on my action page up to 5000 characters may make Narrative1 equal Narrative1/Narrative2/Narrativd3 Does that make sense? -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 11:24 AM To: CF-Talk Subject: RE: Character count on record count??/ Why not just keep a running total inside the loop, as I thought I was demonstrating? Having never worked with ActivPDF, maybe I'm missing something, but why wouldn't you simply keep track of how many characters you've already added, rather than trying to re-calculate it each time? -- Ben Doom Programmer & General Lackey Moonbow Software, Inc : -Original Message----- : From: Janine Jakim [mailto:[EMAIL PROTECTED] : Sent: Wednesday, March 12, 2003 11:06 AM : To: CF-Talk : Subject: RE: Character count on record count??/ : : : Well the page part was easy enough to do. : It's the setting of the variable that I can't seem to get. I can set and : send the variable to a regular html page fine. It's the setting in : activePDF, which pulls the only the last : #NarrativeGet.EduLeveNarrative[i]# : (looks like each reiteration of the loop it resets it to the newest [i]) : I'm wondering how I can dynamically concatenate : #NarrativeGet.EduLeveNarrative[1]#+#NarrativeGet.EduLeveNarrative[2]# : +#NarrativeGet.EduLeveNarrative[3]# for activepdf...argh : Thanks for all the insight : j : -Original Message- : From: Ben Doom [mailto:[EMAIL PROTECTED] : Sent: Wednesday, March 12, 2003 9:48 AM : To: CF-Talk : Subject: RE: Character count on record count??/ : : : : : : #(Len(NarrativeGet.EduLevelNarrative[I])# : : : : Initialize a temp variable to 0. Let's call it "totalLen". : Also, you need : a counter to tell you what page you're on. Each time you are about to try : to add a page, do something like : : if (totalLen + len(NarrativeGet.EduLevelNarrative[i]) gt 5000) : { : totalLen = 0; : pageRef = pageRef + 1; : } : totalLen = totalLen + len(NarrativeGet.EduLevelNarrative[i]); : addToPage(pageRef, NarrativeGet.EduLeveNarrative[i]); : : where addToPage() represents whatever has to be done to add the thing to a : page. : : Please note that this is thrown together off the top of my head. But it : seems to me to be in the right direction. : : HTH. : : : -- Benjamin C. Doom : Programmer [EMAIL PROTECTED] : Moonbow Software, Inc. 606.864.0041x4 : : : : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Character count on record count??/
Well the page part was easy enough to do. It's the setting of the variable that I can't seem to get. I can set and send the variable to a regular html page fine. It's the setting in activePDF, which pulls the only the last #NarrativeGet.EduLeveNarrative[i]# (looks like each reiteration of the loop it resets it to the newest [i]) I'm wondering how I can dynamically concatenate #NarrativeGet.EduLeveNarrative[1]#+#NarrativeGet.EduLeveNarrative[2]# +#NarrativeGet.EduLeveNarrative[3]# for activepdf...argh Thanks for all the insight j -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 9:48 AM To: CF-Talk Subject: RE: Character count on record count??/ : : #(Len(NarrativeGet.EduLevelNarrative[I])# : Initialize a temp variable to 0. Let's call it "totalLen". Also, you need a counter to tell you what page you're on. Each time you are about to try to add a page, do something like if (totalLen + len(NarrativeGet.EduLevelNarrative[i]) gt 5000) { totalLen = 0; pageRef = pageRef + 1; } totalLen = totalLen + len(NarrativeGet.EduLevelNarrative[i]); addToPage(pageRef, NarrativeGet.EduLeveNarrative[i]); where addToPage() represents whatever has to be done to add the thing to a page. Please note that this is thrown together off the top of my head. But it seems to me to be in the right direction. HTH. -- Benjamin C. Doom Programmer [EMAIL PROTECTED] Moonbow Software, Inc. 606.864.0041x4 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Character count on record count??/
Maybe I'm making this harder than it is (that's usual for me) It sounds easy enough-but I am stuck- let me show you my code I have this: #(Len(NarrativeGet.EduLevelNarrative[I])# Thanks, j -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 5:17 PM To: CF-Talk Subject: RE: Character count on record count??/ : 2. count the characters used in each narrative. Retrieve the narratives and use len() on them. Probably add some to it to allow a break between narratives. : 3. Output the narratives in chuncks of 5000 characters. (or to the : narratives that come close to 5000) For example : narrative1=2000 characters : narrative2= 50 characters : narrative3=1000 characters : narrative4=2000 characters : so the page would only show the first 3 narratives Since you (apparently) want them to show up in order, look at the first. If it's length is less than 5000 (I assume it always will be, is this true?), add it to the 1st page and add its length to the total length of the first page. Repeat. If the total length of the page will exceed 5000, start a new page. : Make sense? doable?? Yes and yes, I think. :-) -- Ben Doom Programmer & General Lackey Moonbow Software, Inc ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Character count on record count??/
I have a page where teachers write narratives on students- this will be sent to a pdf. I'm wondering about all of the empty space- each page can hold 5000 characters. Depending on the teacher groups a student may have a 1 -6 page narrative...(ie: one teacher may write 200 characters/another 1500/etc...)What I want to do is figure out- how to put these narratives together without a bunch of space between the entries. (ie: we discussed blocks of 1250 characters, but that may look odd if teachers do not write much) 1. record count of narratives (know how to do that) 2. count the characters used in each narrative. 3. Output the narratives in chuncks of 5000 characters. (or to the narratives that come close to 5000) For example narrative1=2000 characters narrative2= 50 characters narrative3=1000 characters narrative4=2000 characters so the page would only show the first 3 narratives Make sense? doable?? thanks, j ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE:
The name needs to be the same with a different value Yes No -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 3:23 PM To: CF-Talk Subject: Yes No Currently I can click on both the "yes" and "no" and they both get selected. I don't want that to happen. The user should only be able to select one. How can I do this? I also have another list of radio buttons with 5 items but only want to allow the user to select one and NOT multiples. --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: possible to open new window on CF_MsMenu?
Is anyone using MsMenu? Is there a way to get the link to open a new window? I haven't had any luck doing it this way. I'm assuming that it can't be done since the tag is using js. Thanks, J ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Update query loop with checkboxes
I know checkboxes have been discussed many times- I searched the archives of hof and cf support and haven't quite found this issue with them so please forgive me if it's been discussed. i have a display page that shows about 80 checkboxes- set in a basic table format. It looks like so English Reading MathScience History Visual AidesX X X Large Print TestX X Math Aids x Etc I need these checkboxes to update in the database. Problem is using a loop causes errors with the checkboxes. So what I can do with an input box (ie: y/n) using #ListGetAt(Attributes.English, x)# Throws an error when there's a blank checkbox. All of my fields have the So my code works as long as I'm not using a checkbox! (And of course the users want checkboxes and they do look better with so much on the page). Thanks for any help. j Below is my query- the error I get is when an empty checkbox is encountered An error occurred while evaluating the expression: ListFindNoCase("#ListGetAt(Attributes.SOLWriting,x)#") Error near line 25, column 6. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: sql 2000 vs sql 2000 enterprise
Not much unless you are doing a bunch of data mining(OLAP) and Indexed views Here's the link http://www.microsoft.com/sql/evaluation/features/choosing.asp -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 05, 2003 1:38 PM To: CF-Talk Subject: sql 2000 vs sql 2000 enterprise can someone explain to me, very high level, what the difference is between sql server 2000 Standard Edition sql server 2000 Enterprise Edition we have 2000 ent edition on our servers now, however we are about to configure 2 new ones, and my software ordering guys, got us standard edition instead of what we already have, which is enterprise edition. thank you ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping & reporting www.navtrak.net 410.548.2337 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
how do I grab this record??
Ok- I know this is easy. I have a PrimaryID that is varchar (it's imported from another database) My program uses this unique identifier then concatenates other nesseary info to make a new unique number for the student in other tables. ie: PrimaryID + SchoolID + SchoolYear Because it's a varchar I use the trim function to get rid of the extra spaces. HOwever, to get demographics I need just the initial primaryID. But now my trim function is not allowing me to pull the info correctly. For example before I decided to add trim I would do this to connect the tables. (LEFT(PrimaryIDSchoolIDSchoolYear, 16) But because the spaces are now trimmed (the primaryids have anywhere from 8-16 spaces used) this of course doesn't work because it is now pulling part of the schoolid/schoolyear as part of the number Any way around it?? Thanks, ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MS SQL 2000 :: How to print table data>
I find the easiest and quickest way is togo to SQL manager and open the table in design view. Click on the Print Screen button. paste pic onto word doc. Use format Picture to trim the extra space from the pic. I like the visual of this way- I get all the design info in a quick easy to read format. I also like grouping tables this way- I can often get several related tables on one page. Hope this helps. J -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 8:52 AM To: CF-Talk Subject: MS SQL 2000 :: How to print table data> How can I print out all table data - fieldname/datatypes of a specific database in MS SQL 2000? Is there a stored procedure I should use? Thank You, Dave Bosky ~Sr. Multimedia Web Designer ~HTC Web Services ~[EMAIL PROTECTED] ~office: 843.369.8613 HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Pdfs not showing on new webserver
So if not configured right would it lead to some being able to open it some not being able to open it??? Thanks, j -Original Message- From: webguy [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 10:44 AM To: CF-Talk Subject: RE: Pdfs not showing on new webserver > Webstar- for OSX > a mac thing shudder LOL quick google... www.webstar.com/support/technotes/suffixmapping.html www.webstar.com/products/webstar/docs/ws4manual.34.html WG > > -Original Message- > From: webguy [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 16, 2002 10:30 AM > To: CF-Talk > Subject: RE: Pdfs not showing on new webserver > > > You need to register the mime type. > What webserver? > > WG > > > -Original Message- > > From: Janine Jakim [mailto:[EMAIL PROTECTED]] > > Sent: 16 December 2002 15:13 > > To: CF-Talk > > Subject: OT: Pdfs not showing on new webserver > > > > > > Sorry for the ot. > > We put up a new webserver and suddenly having problems with > > opening pdfs in > > the web browser. All the machines have adobe reader or writer. > > These same > > users could open these same pdfs fine on the old webserver. > > Is there a setting or something that we're missing on the webserver? > > Thanks, > > J > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Pdfs not showing on new webserver
Webstar- for OSX a mac thing -Original Message- From: webguy [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 10:30 AM To: CF-Talk Subject: RE: Pdfs not showing on new webserver You need to register the mime type. What webserver? WG > -Original Message- > From: Janine Jakim [mailto:[EMAIL PROTECTED]] > Sent: 16 December 2002 15:13 > To: CF-Talk > Subject: OT: Pdfs not showing on new webserver > > > Sorry for the ot. > We put up a new webserver and suddenly having problems with > opening pdfs in > the web browser. All the machines have adobe reader or writer. > These same > users could open these same pdfs fine on the old webserver. > Is there a setting or something that we're missing on the webserver? > Thanks, > J > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
OT: Pdfs not showing on new webserver
Sorry for the ot. We put up a new webserver and suddenly having problems with opening pdfs in the web browser. All the machines have adobe reader or writer. These same users could open these same pdfs fine on the old webserver. Is there a setting or something that we're missing on the webserver? Thanks, J ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Wuick question: if odd/if even-1 more time!
OOPs My field isn't an integer- it's a string. It isn't just a year 2002/ but set as a school year 2002-2003 2003-2004 So the school year that ends in 2003 I want blue and the school year that ends in 2004 I want in purple... -Original Message- From: webguy [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 8:44 AM To: CF-Talk Subject: RE: Wuick question: if odd/if even yeap, here u go if (year mod 2) year even else year odd you can use IIF like this too, but the above is easier to read... WG > -Original Message----- > From: Janine Jakim [mailto:[EMAIL PROTECTED]] > Sent: 12 December 2002 13:32 > To: CF-Talk > Subject: Wuick question: if odd/if even > > > I Know this is easyIwant a different background depending on the year > chosen by the user- basically if it ends as an odd number make background > blue if year ends with even number make background green. Is > there a better > way than saying (Right(#Year#, 1) EQ 5) or (Right(#Year#, 7) EQ 1)etc. > Thanks, > j > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: OT-Another quick question- float datatype
In the DB4 it is a "double" number field- when imported into SQL it changes to float. just like all the text fields become nvarchar and need changed to varchar. Thanks, j -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 9:16 AM To: CF-Talk Subject: RE: OT-Another quick question- float datatype Quoting Janine Jakim <[EMAIL PROTECTED]>: > > The data is generally an id of some sort- teacherid/etc. An integer (or at least an exact numeric) should be fine. Frankly, I am a bit surprised that they used an approximate numeric for an ID, which typically is something you use as PK/FK. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: OT-Another quick question- float datatype
The data is generally an id of some sort- teacherid/etc. -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 8:57 AM To: CF-Talk Subject: Re: OT-Another quick question- float datatype Quoting Janine Jakim <[EMAIL PROTECTED]>: > > I'm pulling from a DB4 db and dumping into a SQL db > Most of their numbers from the DB2 are formatted as float. > i remember being told to stay away from "float" as a datatype.Should > I make the datatype in the sql an integer instead? What does the data represent? Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
OT-Another quick question- float datatype
I'm pulling from a DB4 db and dumping into a SQL db Most of their numbers from the DB2 are formatted as float. i remember being told to stay away from "float" as a datatype.Should I make the datatype in the sql an integer instead? Thanks for any insight. j ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Wuick question: if odd/if even
Thanks- I knew it was super easy -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 8:38 AM To: CF-Talk Subject: RE: Wuick question: if odd/if even ODDEVEN -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: 12 December 2002 13:32 To: CF-Talk Subject: Wuick question: if odd/if even I Know this is easyIwant a different background depending on the year chosen by the user- basically if it ends as an odd number make background blue if year ends with even number make background green. Is there a better way than saying http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Wuick question: if odd/if even
I Know this is easyIwant a different background depending on the year chosen by the user- basically if it ends as an odd number make background blue if year ends with even number make background green. Is there a better way than saying http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: loop query check??how to do this
A teacher needs to set up their classlists- both as the main teacher and peripheral teacher. Several teachers can have the same students. Maybe I'm blind but I don't see how to set it up in the gui. I had planned to have a select box that a teacher could use to pick multiple students at one time. Then I was going to have a check box to check if they are the main teache for the studens. Should I do 2 selects instead- one with students eligible to have a main teacher and the other for those who can only be chosen as a 2ndary teacher...or should I "separate out the pages"- have 2 different links going onto the page- one if they are going in to make their list as a main teacher and the other if they are going to make their secondary list. -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 11, 2002 12:47 PM To: CF-Talk Subject: RE: loop query check??how to do this The GUI should not allow you to choose to be the mainteacher for students who already have one... It seems to me that the error lies in the GUI and should be fixed there, not behind the scenes. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ "...'If there must be trouble, let it be in my day, that my child may have peace'..." - Thomas Paine, The American Crisis "Let's Roll" - Todd Beamer, Flight 93 -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 11, 2002 9:02 AM To: CF-Talk Subject: loop query check??how to do this I have a table- that users can add to their classlist. When adding they can choose multiple students. I can easily do that loop. My prob. Each student will have only one MainTeacher and many peripheral teachers So before a student is added to a classlist it would need to be checked if there's any conflict- that 2 teachers are claiming to be the MainTeacher. So what should happen if 1. one of the 10 students I chose and checked as MainTeacher is already in the db as having a different MainTeacher? How does that fit into the loop?? Thanks ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
loop query check??how to do this
I have a table- that users can add to their classlist. When adding they can choose multiple students. I can easily do that loop. My prob. Each student will have only one MainTeacher and many peripheral teachers So before a student is added to a classlist it would need to be checked if there's any conflict- that 2 teachers are claiming to be the MainTeacher. So what should happen if 1. one of the 10 students I chose and checked as MainTeacher is already in the db as having a different MainTeacher? How does that fit into the loop?? Thanks ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Dynamic Drop Down Menu Bar
http://www.dynamicdrive.com http://www.milonic.co.uk/menu/ Some very cool stuff at those two sites. -Original Message- From: Alford, Sean [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 10, 2002 8:27 AM To: CF-Talk Subject: Dynamic Drop Down Menu Bar Hello Everyone, I need a drop down menu bar that I can add items and sub items to dynamically within CF. Dose anyone know where I might find such a widget??? Thanks, Sean ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Client Variable Question
I generally make client variables those that aren't going to change while the user is logged in. (ie:Group type=admin/etc) I have an app that will have several different forms per student. (some with one to many relationships/some with one to one). If a case manager says the forms are complete =All forms except one becomes read only. If the case manager says they are not complete = All forms can be edited by a variety of users. I'm wondering what type of variable this Complete=Y/N should be... It will have to follow each student through all the forms, but reset when a new student is chosen. I'm assuming client variable isn't appropriate for this Thanks for the input. j ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: OT: Database design question
No it's individual students with individual goals. Thanks- I figured it was the best way, but it's getting cold and rainy here and I think my brain is starting to hibernate for the winter... j -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 21, 2002 4:10 PM To: CF-Talk Subject: Re: OT: Database design question Janine Jakim wrote: > 1. One student can be working on many goals so I have 1 one to many > relationships. > 2. Each goal needs graded every marking period (up to 6 times a > year)- these are not traditioanl grades but a long comments piece) So > goals have a one to many relationship with the grades. > I'm thinking the best way to handle it is to break it into 3 tables > table one student info table 2 all the goals for the students hooked > to students with the studentid table 3 all the grades for the goals > hooked to goals by goalID Will students be cooperating on these goals and be graded together? If so, you actually have a many-to-many relationship. If not, your model is OK. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
OT: Database design question
hmmm- I am very into keepting my database relational, but am wondering what the best route for thi particular issue is... Heres' the scoop 1. One student can be working on many goals so I have 1 one to many relationships. 2. Each goal needs graded every marking period (up to 6 times a year)- these are not traditioanl grades but a long comments piece) So goals have a one to many relationship with the grades. I'm thinking the best way to handle it is to break it into 3 tables table one student info table 2 all the goals for the students hooked to students with the studentid table 3 all the grades for the goals hooked to goals by goalID My other option is to have 2 tables table one student info table two goals + 6 grading periods comment sections Thanks in advance for any input. j ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: CF SQL problem
Test the page- comment out the loop/query and put a #ListLen(Form.EmpID_Muster)#--#empID_muster#, #emp_status# This will show you how it's trying to update the database- and Jim is probably right that it's trying to do something like EmpID/Emp_Status 123/1,1,1,1,1,1,1,1,1 Instead of what you want, which is 123/1 124/1 193/1 203/1 blah/blah/blah/blah Maybe you should use a different field to use with listlen?? I guess I just neveruse an autonumber type id with my loops. -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED]] Sent: Monday, November 18, 2002 11:12 AM To: CF-Talk Subject: RE: CF SQL problem > I've never seen this message before. Any ideas would be appreciated. > > Here's the code from the Action page: > > > tablename="muster" formfields="empID_muster, emp_status"> > > > And here's the info I get back from CF Debug > > Error Executing Database Query. Invalid data > 1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1 for > CFSQLTYPE CF_SQL_NUMERIC. Well - it looks like you're trying to pass a list into a numeric column. My guess is that you've got several form fields named the same - so that the browser is sending one name as a list of all the values rather than one value for each. Jim Davis ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Server Error-Urgent
Mark, Generally I'd agree with you about queries needing to do the work/calculations...However, this is just basic selects. And so each student has 60+ per quarter. I don't see how to get it to print out one student per page if there are 60+ entries per student. Putting it all in one query makes it come out at 25 x 60. I don't see how to get around this- especially will all of the data I need to gather from the different tables. Unless I'm missing something?? I used to work with Access extensively and when it got to that type of grouping it was in the presentation layer(reports) and not in the actual query --you did it by subqueries/subreports/group by functions in the report. -Original Message- From: Mark A. Kruger - CFG [mailto:mkruger@;cfwebtools.com] Sent: Sunday, November 03, 2002 3:50 PM To: CF-Talk Subject: RE: Server Error-Urgent Janine, The trick is to get the "calculation" to happen on the DB platform and returned as a part of the query. Perhaps the stored proc would be the best place to do this. Grouping requries some practic - trial and error, but it really is the best way to accomplish what you are trying to do here. -mk -----Original Message- From: Janine Jakim [mailto:jjakim@;albemarle.org] Sent: Saturday, November 02, 2002 10:41 AM To: CF-Talk Subject: RE: Server Error-Urgent Right but I'm not sure how grouping would work for this. I originally tried grouping but couldn't get it to output correctly. The master stored procedure pulls information from all the tables that have a one to one relationship with a student. (school/attendance/teacher/studentinfo) So the master includes 4 tables The nested stored procedure holds all the data for each quarter (each quarter a student is graded on at least 60+ "skills") + each quarter there are comments for each student. The nested queries will run for each student and there may be 25 students pulled up at one time. So there's a total of 6 tables involved. Two of which have the multiple records Like I mentioned the queries themself run very quickly- it's when I add the loops for the output that they slow down. How can I re-arrange this? Thanks again -Original Message- From: Mark A. Kruger - CFG [mailto:mkruger@;cfwebtools.com] Sent: Friday, November 01, 2002 3:40 PM To: CF-Talk Subject: RE: Server Error-Urgent Janine, Yes - IMO this is pretty inneficient. If I'm looking at this correctly, You are using a master query (studentinformation) followed by one or more sub-queries - one for each row in the master query. This can probably be boiled down to a single query with a group by statement. This would eliminate the need for a nested loop (a cfoutput followed by query looping code). It would be usefule to see how many iterations (total) the inner loop create, then multiply it times the outer recordcount. -mk -Original Message- From: Janine Jakim [mailto:jjakim@;albemarle.org] Sent: Friday, November 01, 2002 1:22 PM To: CF-Talk Subject: RE: Server Error-Urgent Activepdf is a good product- I agree. But the info it needs to spit out is pretty large- the stored procedures grab all the demographic data than all of the grades for each quarter. I have set up a on the page in question. This particular section (and there are 4 of them- one for each quarter)is what seems to do it: blah/blah Is this code inefficient? Is there a betterway for me to do the same thing? -Original Message- From: Mark A. Kruger - CFG [mailto:mkruger@;cfwebtools.com] Sent: Friday, November 01, 2002 12:08 PM To: CF-Talk Subject: RE: Server Error-Urgent Janine, Active PDF is a COM and reputedly a good one - but it still introduces an external process into your page request. I'd start there. Why don't you post the code (or the cfoutput/looping part of it). -mk -Original Message- From: Janine Jakim [mailto:jjakim@;albemarle.org] Sent: Friday, November 01, 2002 10:42 AM To: CF-Talk Subject: RE: Server Error-Urgent I have a page that the queries run really quickly but when I set them to cfoutput loop/cfset to set for activepdf they slow to a crawl. I've been trying to figure out how to speed up this page. -Original Message- From: [EMAIL PROTECTED] [mailto:Douglas.Knudsen@;alltel.com] Sent: Friday, November 01, 2002 10:50 AM To: CF-Talk Subject: RE: Server Error-Urgent yes. Check your app. Do you have ultra long queries running? CFX tags? COM calls? I've seen this occuring when my Oracle server went down. Each request to the DB server eats up a thread until CF gets a response. Depending on your CF Admin settings, after x number of these unresponsive threads, your CF service gets restarted. Check your CF logs. Doug >-Original Message- >From: Janine Jakim [mailto:jja
RE: Server Error-Urgent
Right but I'm not sure how grouping would work for this. I originally tried grouping but couldn't get it to output correctly. The master stored procedure pulls information from all the tables that have a one to one relationship with a student. (school/attendance/teacher/studentinfo) So the master includes 4 tables The nested stored procedure holds all the data for each quarter (each quarter a student is graded on at least 60+ "skills") + each quarter there are comments for each student. The nested queries will run for each student and there may be 25 students pulled up at one time. So there's a total of 6 tables involved. Two of which have the multiple records Like I mentioned the queries themself run very quickly- it's when I add the loops for the output that they slow down. How can I re-arrange this? Thanks again -Original Message- From: Mark A. Kruger - CFG [mailto:mkruger@;cfwebtools.com] Sent: Friday, November 01, 2002 3:40 PM To: CF-Talk Subject: RE: Server Error-Urgent Janine, Yes - IMO this is pretty inneficient. If I'm looking at this correctly, You are using a master query (studentinformation) followed by one or more sub-queries - one for each row in the master query. This can probably be boiled down to a single query with a group by statement. This would eliminate the need for a nested loop (a cfoutput followed by query looping code). It would be usefule to see how many iterations (total) the inner loop create, then multiply it times the outer recordcount. -mk -Original Message- From: Janine Jakim [mailto:jjakim@;albemarle.org] Sent: Friday, November 01, 2002 1:22 PM To: CF-Talk Subject: RE: Server Error-Urgent Activepdf is a good product- I agree. But the info it needs to spit out is pretty large- the stored procedures grab all the demographic data than all of the grades for each quarter. I have set up a on the page in question. This particular section (and there are 4 of them- one for each quarter)is what seems to do it: blah/blah Is this code inefficient? Is there a betterway for me to do the same thing? -Original Message- From: Mark A. Kruger - CFG [mailto:mkruger@;cfwebtools.com] Sent: Friday, November 01, 2002 12:08 PM To: CF-Talk Subject: RE: Server Error-Urgent Janine, Active PDF is a COM and reputedly a good one - but it still introduces an external process into your page request. I'd start there. Why don't you post the code (or the cfoutput/looping part of it). -mk -Original Message- From: Janine Jakim [mailto:jjakim@;albemarle.org] Sent: Friday, November 01, 2002 10:42 AM To: CF-Talk Subject: RE: Server Error-Urgent I have a page that the queries run really quickly but when I set them to cfoutput loop/cfset to set for activepdf they slow to a crawl. I've been trying to figure out how to speed up this page. -Original Message- From: [EMAIL PROTECTED] [mailto:Douglas.Knudsen@;alltel.com] Sent: Friday, November 01, 2002 10:50 AM To: CF-Talk Subject: RE: Server Error-Urgent yes. Check your app. Do you have ultra long queries running? CFX tags? COM calls? I've seen this occuring when my Oracle server went down. Each request to the DB server eats up a thread until CF gets a response. Depending on your CF Admin settings, after x number of these unresponsive threads, your CF service gets restarted. Check your CF logs. Doug >-Original Message- >From: Janine Jakim [mailto:jjakim@;albemarle.org] >Sent: Friday, November 01, 2002 10:20 AM >To: CF-Talk >Subject: Server Error-Urgent > > >Hey has anyone seen this error? It is coming up regularly. >Any ideas where I should start to track down the problem? >Thanks for any insight. >J >Event Type:Error >Event Source: Service Control Manager >Event Category:None >Event ID: 7031 >Date: 10/31/2002 >Time: 6:00:50 PM >User: N/A >Computer: SCHOOLS >Description: >The Cold Fusion Application Server service terminated >unexpectedly. It has >done this 80 time(s). The following corrective action will be >taken in 0 >milliseconds: No action. > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Server Error-Urgent ps
The error I am seeing now in the CF log is about Windows NTerror number 232 occurred. Error 1500 number 232 occurred attempting to close connection to web server and Windows NT error number 232 occurred. Error 1664 number 232 occurred while attempting to write the reply to the web server. -Original Message- From: Mark A. Kruger - CFG [mailto:mkruger@;cfwebtools.com] Sent: Friday, November 01, 2002 12:08 PM To: CF-Talk Subject: RE: Server Error-Urgent Janine, Active PDF is a COM and reputedly a good one - but it still introduces an external process into your page request. I'd start there. Why don't you post the code (or the cfoutput/looping part of it). -mk -Original Message----- From: Janine Jakim [mailto:jjakim@;albemarle.org] Sent: Friday, November 01, 2002 10:42 AM To: CF-Talk Subject: RE: Server Error-Urgent I have a page that the queries run really quickly but when I set them to cfoutput loop/cfset to set for activepdf they slow to a crawl. I've been trying to figure out how to speed up this page. -Original Message- From: [EMAIL PROTECTED] [mailto:Douglas.Knudsen@;alltel.com] Sent: Friday, November 01, 2002 10:50 AM To: CF-Talk Subject: RE: Server Error-Urgent yes. Check your app. Do you have ultra long queries running? CFX tags? COM calls? I've seen this occuring when my Oracle server went down. Each request to the DB server eats up a thread until CF gets a response. Depending on your CF Admin settings, after x number of these unresponsive threads, your CF service gets restarted. Check your CF logs. Doug >-Original Message----- >From: Janine Jakim [mailto:jjakim@;albemarle.org] >Sent: Friday, November 01, 2002 10:20 AM >To: CF-Talk >Subject: Server Error-Urgent > > >Hey has anyone seen this error? It is coming up regularly. >Any ideas where I should start to track down the problem? >Thanks for any insight. >J >Event Type:Error >Event Source: Service Control Manager >Event Category:None >Event ID: 7031 >Date: 10/31/2002 >Time: 6:00:50 PM >User: N/A >Computer: SCHOOLS >Description: >The Cold Fusion Application Server service terminated >unexpectedly. It has >done this 80 time(s). The following corrective action will be >taken in 0 >milliseconds: No action. > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Server Error-Urgent
Activepdf is a good product- I agree. But the info it needs to spit out is pretty large- the stored procedures grab all the demographic data than all of the grades for each quarter. I have set up a on the page in question. This particular section (and there are 4 of them- one for each quarter)is what seems to do it: blah/blah Is this code inefficient? Is there a betterway for me to do the same thing? -Original Message- From: Mark A. Kruger - CFG [mailto:mkruger@;cfwebtools.com] Sent: Friday, November 01, 2002 12:08 PM To: CF-Talk Subject: RE: Server Error-Urgent Janine, Active PDF is a COM and reputedly a good one - but it still introduces an external process into your page request. I'd start there. Why don't you post the code (or the cfoutput/looping part of it). -mk -Original Message----- From: Janine Jakim [mailto:jjakim@;albemarle.org] Sent: Friday, November 01, 2002 10:42 AM To: CF-Talk Subject: RE: Server Error-Urgent I have a page that the queries run really quickly but when I set them to cfoutput loop/cfset to set for activepdf they slow to a crawl. I've been trying to figure out how to speed up this page. -Original Message- From: [EMAIL PROTECTED] [mailto:Douglas.Knudsen@;alltel.com] Sent: Friday, November 01, 2002 10:50 AM To: CF-Talk Subject: RE: Server Error-Urgent yes. Check your app. Do you have ultra long queries running? CFX tags? COM calls? I've seen this occuring when my Oracle server went down. Each request to the DB server eats up a thread until CF gets a response. Depending on your CF Admin settings, after x number of these unresponsive threads, your CF service gets restarted. Check your CF logs. Doug >-Original Message----- >From: Janine Jakim [mailto:jjakim@;albemarle.org] >Sent: Friday, November 01, 2002 10:20 AM >To: CF-Talk >Subject: Server Error-Urgent > > >Hey has anyone seen this error? It is coming up regularly. >Any ideas where I should start to track down the problem? >Thanks for any insight. >J >Event Type:Error >Event Source: Service Control Manager >Event Category:None >Event ID: 7031 >Date: 10/31/2002 >Time: 6:00:50 PM >User: N/A >Computer: SCHOOLS >Description: >The Cold Fusion Application Server service terminated >unexpectedly. It has >done this 80 time(s). The following corrective action will be >taken in 0 >milliseconds: No action. > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Server Error-Urgent
I have a page that the queries run really quickly but when I set them to cfoutput loop/cfset to set for activepdf they slow to a crawl. I've been trying to figure out how to speed up this page. -Original Message- From: [EMAIL PROTECTED] [mailto:Douglas.Knudsen@;alltel.com] Sent: Friday, November 01, 2002 10:50 AM To: CF-Talk Subject: RE: Server Error-Urgent yes. Check your app. Do you have ultra long queries running? CFX tags? COM calls? I've seen this occuring when my Oracle server went down. Each request to the DB server eats up a thread until CF gets a response. Depending on your CF Admin settings, after x number of these unresponsive threads, your CF service gets restarted. Check your CF logs. Doug >-Original Message- >From: Janine Jakim [mailto:jjakim@;albemarle.org] >Sent: Friday, November 01, 2002 10:20 AM >To: CF-Talk >Subject: Server Error-Urgent > > >Hey has anyone seen this error? It is coming up regularly. >Any ideas where I should start to track down the problem? >Thanks for any insight. >J >Event Type:Error >Event Source: Service Control Manager >Event Category:None >Event ID: 7031 >Date: 10/31/2002 >Time: 6:00:50 PM >User: N/A >Computer: SCHOOLS >Description: >The Cold Fusion Application Server service terminated >unexpectedly. It has >done this 80 time(s). The following corrective action will be >taken in 0 >milliseconds: No action. > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Server Error-Urgent
it's empty. I don't use the mail stuff.. -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:Neil.Robertson-Ravo@;csd.reedexpo.com] Sent: Friday, November 01, 2002 10:25 AM To: CF-Talk Subject: RE: Server Error-Urgent Check your CFusion\Mail ubdeliverable folder... delete all its contents -Original Message----- From: Janine Jakim [mailto:jjakim@;albemarle.org] Sent: 01 November 2002 15:20 To: CF-Talk Subject: Server Error-Urgent Hey has anyone seen this error? It is coming up regularly. Any ideas where I should start to track down the problem? Thanks for any insight. J Event Type: Error Event Source: Service Control Manager Event Category: None Event ID: 7031 Date: 10/31/2002 Time: 6:00:50 PM User: N/A Computer: SCHOOLS Description: The Cold Fusion Application Server service terminated unexpectedly. It has done this 80 time(s). The following corrective action will be taken in 0 milliseconds: No action. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Server Error-Urgent
Hey has anyone seen this error? It is coming up regularly. Any ideas where I should start to track down the problem? Thanks for any insight. J Event Type: Error Event Source: Service Control Manager Event Category: None Event ID: 7031 Date: 10/31/2002 Time: 6:00:50 PM User: N/A Computer: SCHOOLS Description: The Cold Fusion Application Server service terminated unexpectedly. It has done this 80 time(s). The following corrective action will be taken in 0 milliseconds: No action. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Strange menu behavior
Mosh- I think you're right! I just checked some of the people that I know have trouble and low and behold they have used ' . (This is grouping on what the user defined) I've have problems with ' before with cf/the database. But the context was so different I didn't even think it of it this tiime around. I'll try to compensate for the ' and see if that works. Thanks for jogging the memory!! j -Original Message- From: Mosh Teitelbaum [mailto:mosh.teitelbaum@;evoch.com] Sent: Friday, October 25, 2002 9:58 AM To: CF-Talk Subject: RE: Strange menu behavior Perhaps one of the values for that field has an illegal character in it? Or something to that effect. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ > -----Original Message- > From: Janine Jakim [mailto:jjakim@;albemarle.org] > Sent: Friday, October 25, 2002 9:06 AM > To: CF-Talk > Subject: RE: Strange menu behavior > > > I'll keep looking. I originally thought it was the javascript/html but I > could replace that one little piece and presto it worked for everyone. > Literally taking out #NameOfGroup# out of the tag made the menu > work for everyoneI'll comb the html/js > > > -Original Message- > From: Mosh Teitelbaum [mailto:mosh.teitelbaum@;evoch.com] > Sent: Friday, October 25, 2002 1:17 AM > To: CF-Talk > Subject: RE: Strange menu behavior > > > If the menus aren't showing up or are displaying incorrectly, > it's probably > the result of invalid HTML/JavaScript. It may be generated > incorrectly due > to a problem with the data but your best bet is to find the problem in the > HTML/JavaScript and than figure out how that problem got there. > > -- > Mosh Teitelbaum > evoch, LLC > Tel: (301) 625-9191 > Fax: (301) 933-3651 > Email: [EMAIL PROTECTED] > WWW: http://www.evoch.com/ > > > > -Original Message- > > From: Janine Jakim [mailto:jjakim@;albemarle.org] > > Sent: Thursday, October 24, 2002 10:09 PM > > To: CF-Talk > > Subject: Strange menu behavior > > > > > > Ok this is odd. I have a 4 section navigation menu. Each section is > > dynamically filled in by th database. It works great for 90% of > > the people. > > > > For the other 10% the menus don't even show up. I have narrowed > > it down to > > one section of the menu and to one query (actually to one field in the > > query- the necessary field!). Take that piece out and everyone has a > > working menu. > > I can't figure out why this one section doesn't work for those folks/and > > whacks out the whole menu. > > In my tests when I run the query by itself without the menus > > everyone's info > > shows up. > > I checked the database to see if there's any missing/incongruent data. > > I have outputted the query on the screen- it shows up > > Nothing jumps out at me! > > Any ideas on where I should look next? > > Thanks, > > j > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Strange menu behavior
I'll keep looking. I originally thought it was the javascript/html but I could replace that one little piece and presto it worked for everyone. Literally taking out #NameOfGroup# out of the tag made the menu work for everyoneI'll comb the html/js -Original Message- From: Mosh Teitelbaum [mailto:mosh.teitelbaum@;evoch.com] Sent: Friday, October 25, 2002 1:17 AM To: CF-Talk Subject: RE: Strange menu behavior If the menus aren't showing up or are displaying incorrectly, it's probably the result of invalid HTML/JavaScript. It may be generated incorrectly due to a problem with the data but your best bet is to find the problem in the HTML/JavaScript and than figure out how that problem got there. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ > -Original Message----- > From: Janine Jakim [mailto:jjakim@;albemarle.org] > Sent: Thursday, October 24, 2002 10:09 PM > To: CF-Talk > Subject: Strange menu behavior > > > Ok this is odd. I have a 4 section navigation menu. Each section is > dynamically filled in by th database. It works great for 90% of > the people. > > For the other 10% the menus don't even show up. I have narrowed > it down to > one section of the menu and to one query (actually to one field in the > query- the necessary field!). Take that piece out and everyone has a > working menu. > I can't figure out why this one section doesn't work for those folks/and > whacks out the whole menu. > In my tests when I run the query by itself without the menus > everyone's info > shows up. > I checked the database to see if there's any missing/incongruent data. > I have outputted the query on the screen- it shows up > Nothing jumps out at me! > Any ideas on where I should look next? > Thanks, > j > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Strange menu behavior
Ok this is odd. I have a 4 section navigation menu. Each section is dynamically filled in by th database. It works great for 90% of the people. For the other 10% the menus don't even show up. I have narrowed it down to one section of the menu and to one query (actually to one field in the query- the necessary field!). Take that piece out and everyone has a working menu. I can't figure out why this one section doesn't work for those folks/and whacks out the whole menu. In my tests when I run the query by itself without the menus everyone's info shows up. I checked the database to see if there's any missing/incongruent data. I have outputted the query on the screen- it shows up Nothing jumps out at me! Any ideas on where I should look next? Thanks, j ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
CF to excel formatting questions
I'm using the basic call to excel (as explained by BF in his book) because I do know that all my users have excel. My questions: 1. Can you add an excel toolbar- I want the users to be able to sort the information on any of the columns. 2. Is there any way to get it so that the headings can wrap. Some of my headings are long so instead of making a long stretchy heading. Thanks in advance for any help. J ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: supposedly simple query
run a test on your query page do than your then #Url.thread#/#threadnumber# see what values come back j ps Your url link in your email says it's outputtin formthread. do you mean thread -Original Message- From: Jeremy Bunton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 4:23 PM To: CF-Talk Subject: supposedly simple query I have this VERY simple query like select * from message where thread = #threadnumber# where #threadnumber# is set by coming from a If I hard code in a number no problem it works but for some odd reason using the above I get [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'thread = 45'. Both fields are intergers. What ya think. Jeremy ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
OT: Open new window for info
I'm using a script from javascript that opens a new window and populates the new page. This is great for working with pdfs. I decided to add it to a page that has a CF_TwoSelectsRelated tag and a cf_autofill tag. The variables will not pass in the url(makes sense as the variable isn't defined yet). (The variables do pass fine with submit buttons). I'm wondering if there's a way to get this to work- either sending it through the url or modifying it somehow to be sent with the submit button. Or is there a better way to open a new window with the submit button/is there a way to add the javascript there? "> then my link that doesn't work is the following. The TeacherId is used in the CF_TwoSelectsRelated tag (first the user picks a grade than teacher). The school id is the current schoolid- the school that the user is admin at. View Class Report Cards Any ideas would be great. thanks, j ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: milonic menus questionRESOLVED
I've decided that it just doesn't work correctly with milonic menus. I found an hvmenu from dynamicdrive.com - it worked immediately and is stable with macs! Thanks for all the help. J -Original Message----- From: Janine Jakim Sent: Wednesday, September 25, 2002 3:49 PM To: CF-Talk Subject: RE: milonic menus question your right- I actually use attributes.variable for this not any form variables. (that's what I get for asking a question while multi tasking). but do you know if there is any limitations about url variables in milonic. j -Original Message- From: David Hannum [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 12:01 PM To: CF-Talk Subject: Re: milonic menus question I think you're trying to pass "URL" scope on your variables, not "FORM". Dave ----- Original Message - From: "Janine Jakim" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, September 25, 2002 11:19 AM Subject: ot: milonic menus question Quick question. I'm having problems passing a variable with the milonic menus. In my testing I've found that CLIENT variables pass fine- it's my attributes.variable or form.variable that doesn't pass. Can milonic only pass client or session variables? Thanks for any insight. Janine __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: milonic menus question
The attributes.variable is made when a teacher chooses a student's name. (My page has the menu for subjects/navigation then underneath the menu is the class list- each student with a link. Once a subject is chosen the teacher can hit any student link and see the grades for that subject). I want the teacher to use the menu to go through all the subjects for that student. This I can't get to work with the milonic menu. Right now when I click on a different subject I am sent to that subject but am sent to a "default page- on that page I then need to pick a student's name- it doesn't pass the info that I want to keep with the same student). Like I said I've had it working in other menus but they have proved unstable. The attributes.variable = studentID that the teacher chooses from their class list. This class list is generated by a query. I have tested to make sure that the attributes.variable is seen. For example on the menu link I added Reading #attributes.variable.#. When I use the menu I see Reading and the correct studentID for the current student. If I then click on Reading I am sent to the reading page as if there was no student picked. Does that make sense? (sorry if I'm babbling today- too little sleep and coffee) Here's the section from the menu that is suppose to be the link. (I left my test there: #attributes.variable#. I'm starting to believe that milonic menu only passes more global variables because it will pass everything but addmenu(menu=[ "subjectbook", 25, // Menu Top - The Top position of this menu in pixels 114, // Menu Left - The Left position of this menu in pixels 140, // Menu Width - Menus width in pixels 2,// Menu Border Width , EasySampleStyle, 0, , , 0, 0, 0, , , 0, 0, , , 0, , ,"Reading<CFOUTPUT>ap:#Attributes.StudentID#-</CFOUTPUT>","<CFOUTPUT>Index.c fm?Fuseaction=SeeCourse1&#URLToken#&Attributes.StudentID=#Attributes.Student ID#&CLIENT.ClassID=#CLIENT.ClassID#&Course=1</CFOUTPUT>",,, ,"Writing","<CFOUTPUT>Index.cfm?Fuseaction=SeeCourse3&#URLToken#&CLIENT.Clas sID=#CLIENT.ClassID#&Course=3&StudentID=#StudentID#</CFOUTPUT>",,, ,"Word Study","<CFOUTPUT>Index.cfm?Fuseaction=SeeCourse2&#URLToken#&CLIENT.ClassID= #CLIENT.ClassID#&Course=2&StudentID=#Attributes.StudentID#</CFOUTPUT>",,, ,"Math","<CFOUTPUT>Index.cfm?Fuseaction=SeeCourse5&#URLToken#&CLIENT.ClassID =#CLIENT.ClassID#&Course=5&StudentID=#StudentID#</CFOUTPUT>",,, ,"Science","<CFOUTPUT>Index.cfm?Fuseaction=SeeCourse6&#URLToken#&CLIENT.Clas sID=#CLIENT.ClassID#&Course=6&StudentID=#StudentID#</CFOUTPUT>",,, ,"Social Studies","<CFOUTPUT>Index.cfm?Fuseaction=SeeCourse4&#URLToken#&CLIENT.ClassI D=#CLIENT.ClassID#&Course=4&StudentID=#StudentID#</CFOUTPUT>",,, ,"Technology","<CFOUTPUT>Index.cfm?Fuseaction=SeeCourse7&#URLToken#&CLIENT.C lassID=#CLIENT.ClassID#&Course=7&StudentID=#StudentID#</CFOUTPUT>",,, ,"Social Development/Citizenship","<CFOUTPUT>Index.cfm?Fuseaction=SeeCourse8&#URLToke n#&CLIENT.ClassID=#CLIENT.ClassID#&Course=8&StudentID=#StudentID#</CFOUTPUT> ",,, ,"Work Habits","<CFOUTPUT>Index.cfm?Fuseaction=SeeCourse9&#URLToken#&CLIENT.ClassID =#CLIENT.ClassID#&Course=9&StudentID=#StudentID#</CFOUTPUT>",,, ,"Comments","<CFOUTPUT>Index.cfm?Fuseaction=SeeCourse10&#URLToken#&CLIENT.Cl assID=#CLIENT.ClassID#&Course=10&StudentID=#StudentID#</CFOUTPUT>",,, ,"View All Grades for Student","<CFOUTPUT>Index.cfm?Fuseaction=SeeCourseAll&#URLToken#&CLIENT.Clas sID=#CLIENT.ClassID#&PERMNUM=#PERMNUM#</CFOUTPUT>",,, ]) -Original Message- From: David Hannum [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 26, 2002 8:37 AM To: CF-Talk Subject: Re: milonic menus question I guess I don't understand. How are you populating the attributes.variable? How about some code. Dave - Original Message - From: "Janine Jakim" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, September 26, 2002 8:03 AM Subject: RE: milonic menus question It's the #attributes.variable# only--the one the user chooses. (this same thing has workded on other menus fine but not this one- but the other menus aren't good they "run away" from the user). It works fine with client variables (ie: #URLToken#/#Client.SchoolID#) Janine -Original Message- From: David Ha
RE: milonic menus question
It's the #attributes.variable# only--the one the user chooses. (this same thing has workded on other menus fine but not this one- but the other menus aren't good they "run away" from the user). It works fine with client variables (ie: #URLToken#/#Client.SchoolID#) Janine -Original Message- From: David Hannum (Ohio University) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 10:49 PM To: CF-Talk Subject: Re: milonic menus question Milonic is simply a DHTML menu. I have used them several times. Appending variables to the URL is not a problem. Are you hand coding the URL's or generating them dynamically? Either way, make sure your spelling is correct. Dave - Original Message - From: "Janine Jakim" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, September 25, 2002 3:48 PM Subject: RE: milonic menus question > your right- I actually use attributes.variable for this not any form > variables. (that's what I get for asking a question while multi tasking). > but do you know if there is any limitations about url variables in milonic. > j > > -Original Message- > From: David Hannum [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 25, 2002 12:01 PM > To: CF-Talk > Subject: Re: milonic menus question > > > I think you're trying to pass "URL" scope on your variables, not "FORM". > > Dave > > > - Original Message - > From: "Janine Jakim" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, September 25, 2002 11:19 AM > Subject: ot: milonic menus question > > > Quick question. I'm having problems passing a variable with the milonic > menus. In my testing I've found that CLIENT variables pass fine- it's my > attributes.variable or form.variable that doesn't pass. Can milonic only > pass client or session variables? > Thanks for any insight. > Janine > > > __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: milonic menus question
your right- I actually use attributes.variable for this not any form variables. (that's what I get for asking a question while multi tasking). but do you know if there is any limitations about url variables in milonic. j -Original Message- From: David Hannum [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 12:01 PM To: CF-Talk Subject: Re: milonic menus question I think you're trying to pass "URL" scope on your variables, not "FORM". Dave - Original Message - From: "Janine Jakim" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, September 25, 2002 11:19 AM Subject: ot: milonic menus question Quick question. I'm having problems passing a variable with the milonic menus. In my testing I've found that CLIENT variables pass fine- it's my attributes.variable or form.variable that doesn't pass. Can milonic only pass client or session variables? Thanks for any insight. Janine __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ot: milonic menus question
Quick question. I'm having problems passing a variable with the milonic menus. In my testing I've found that CLIENT variables pass fine- it's my attributes.variable or form.variable that doesn't pass. Can milonic only pass client or session variables? Thanks for any insight. Janine __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Links from js sending info.
Ok I have a link from a menu that doesn't seem to send the one attribute-the studentID. It sends the urltoken and the teacher id. When I test (ie add the teacherid to the link name) the studentID shows up ok so does anyone know why this won't work? Index.cfm?Fuseaction=Course1URLToken#&Attributes.StudentID=#Attr ibutes.StudentID#&CLIENT.TchrID=#CLIENT.TchrID#&Course=1" If I click on this link my new page shows the TchrID/CourseID/URLToken but nothing for the StudentID Any insight would be greatly appreciated. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Format js
I'm using one of the cool pop up menus from dynamic drive. My topics are listed on the side of the webpage. Topic1 Topic2 Topic3 Topic 4 The only thing the users don't like is that when the menu pops up it covers ALL the other menus. (so if I choose Topic 3 the links under Topic 3 cover up all the other Topics). I'm not sure what to change to make the menus just drop down under the chosen Topic. If it covers anything it only covers the Topics below the choosen topic. (So if I choose Topic 3 I can still see Topic 1/Topic2.) I'm adding all the code that I think effects the vertical/horizontal aspect. TIA J //Find out how close the mouse is to the corner of the window var rightedge=ie4? document.body.clientWidth-eventX : window.innerWidth-eventX var bottomedge=ie4? document.body.clientHeight-eventY : window.innerHeight-eventY //if the horizontal distance isn't enough to accomodate the width of the context menu if (rightedgehttp://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Run a check before an insertRESOLVED
Duh- darn loops- just needed one for both queries. Thanks for all the help. -Original Message- From: Janine Jakim Sent: Friday, September 20, 2002 11:10 AM To: CF-Talk Subject: RE: Run a check before an insert Sorry for the delay- been running some traingings. Here's the real scoop (more complicated then my example) Teachers can schedule students from the grade and subject that the admin has set up. If the grade or subject has not been chosen by the admin than they can't schedule that student(s) This is what I have working: 1st query runs check. 2nd query (stored proc) runs insert It works ok now until I try to add one more loop before the stored procedure. I need it to have the ability to insert several valid subjects. Right now mine only allows the insert of one subject. It's when I try to do another loop that it becomes the insert all the students no matter if they can be scheduled/ or insert no students problem... Hope I'm making sense. j Grade:#GRADE#// SELECT cc.SchoolID, ecl.CourseID, cc.Grade, ecl.TeacherType, S.StudentID FROM Students S, ElementaryCourseList ecl INNER JOin ClassChanges cc on ecl.CourseID =cc.CourseID WHERE S.StudentID='#LEFT(StudentGrade, 12)#' and ((cc.SchoolID= #CLIENT.SchoolID#) AND (cc.CourseID=ecl.CourseID)AND (cc.Grade='#Right(StudentGrade, 2)#') AND (ecl.TeacherType='#ListGetAt(Attributes.TeacherType, x)#')) ORDER BY cc.CourseID, cc.Grade -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 1:27 PM To: CF-Talk Subject: RE: Run a check before an insert LEAVE OUT THE TV No way, throw some eggs in there and you've got some pancakes :OD Show us some code Ade -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: 19 September 2002 17:55 To: CF-Talk Subject: Run a check before an insert Ok I need to make a check on one table before I do an insert into another table. (Kind of similar to a login where the 1st query checks the username/2nd query checks the group). But I want to be able to have the 1st table be able to check for several rows in the first query and only insert the matches into the second query. So an example is: I am restricted to only ordering food items. I order sugar, milk, a tv and flour. I want the first query to look at the order then send to the 2nd query the order for sugar, milk and sugar, leaving out the tv. (and maybe sending a message to the user...sorry you can't order that...) I can't seem to get my loops right on this one- I either seem to be able to add all or nothing. Thanks in advance, Janine __ 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: Access Question
Usually when I get a message like that in sql it usually means I forgot something simple like a comma. Are you inserting several things? -Original Message- From: Greg Luce [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 1:06 PM To: CF-Talk Subject: RE: Access Question I tried that also and I get crazy things like " {08A95C45-4CEE-4A86-9B18-13DA30C013C9}" inserted as the subdir_id if I have the fieldsize set as "Replication ID", or " -2138072423" if I have it set for "Long Integer". -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 12:27 PM To: CF-Talk Subject: RE: Access Question > I'm having a tough time with an access query. I'm sure > it's something simple, but I had shoulder surgery > yesterday so I have a ball pumping goodies into the > shoulder at it's own discretion. :-) > > INSERT INTO subdir > VALUES ('#good#') > > And the table is: > subdir_id (autonumber) > subdir (text) > > The error says: > ODBC Error Code = 21S01 (Insert value list does not > match column list) > > [Microsoft][ODBC Microsoft Access Driver] Number of > query values and destination fields are not the same. > > SQL = "INSERT INTO subdir VALUES ('')" Add the field name to the query: INSERT INTO subdir (subdir) VALUES ('#good#') Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 : dream :: design :: develop : MXDC 02 :: Join us at this all day conference for designers & developers to learn tips, tricks, best practices and more for the entire Macromedia MX suite. September 28, 2002 :: http://www.mxdc02.com/ (Register today, seats are limited!) :: __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Run a check before an insert
Sorry for the delay- been running some traingings. Here's the real scoop (more complicated then my example) Teachers can schedule students from the grade and subject that the admin has set up. If the grade or subject has not been chosen by the admin than they can't schedule that student(s) This is what I have working: 1st query runs check. 2nd query (stored proc) runs insert It works ok now until I try to add one more loop before the stored procedure. I need it to have the ability to insert several valid subjects. Right now mine only allows the insert of one subject. It's when I try to do another loop that it becomes the insert all the students no matter if they can be scheduled/ or insert no students problem... Hope I'm making sense. j Grade:#GRADE#// SELECT cc.SchoolID, ecl.CourseID, cc.Grade, ecl.TeacherType, S.StudentID FROM Students S, ElementaryCourseList ecl INNER JOin ClassChanges cc on ecl.CourseID =cc.CourseID WHERE S.StudentID='#LEFT(StudentGrade, 12)#' and ((cc.SchoolID= #CLIENT.SchoolID#) AND (cc.CourseID=ecl.CourseID)AND (cc.Grade='#Right(StudentGrade, 2)#') AND (ecl.TeacherType='#ListGetAt(Attributes.TeacherType, x)#')) ORDER BY cc.CourseID, cc.Grade -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 1:27 PM To: CF-Talk Subject: RE: Run a check before an insert LEAVE OUT THE TV No way, throw some eggs in there and you've got some pancakes :OD Show us some code Ade -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: 19 September 2002 17:55 To: CF-Talk Subject: Run a check before an insert Ok I need to make a check on one table before I do an insert into another table. (Kind of similar to a login where the 1st query checks the username/2nd query checks the group). But I want to be able to have the 1st table be able to check for several rows in the first query and only insert the matches into the second query. So an example is: I am restricted to only ordering food items. I order sugar, milk, a tv and flour. I want the first query to look at the order then send to the 2nd query the order for sugar, milk and sugar, leaving out the tv. (and maybe sending a message to the user...sorry you can't order that...) I can't seem to get my loops right on this one- I either seem to be able to add all or nothing. Thanks in advance, Janine __ 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
Run a check before an insert
Ok I need to make a check on one table before I do an insert into another table. (Kind of similar to a login where the 1st query checks the username/2nd query checks the group). But I want to be able to have the 1st table be able to check for several rows in the first query and only insert the matches into the second query. So an example is: I am restricted to only ordering food items. I order sugar, milk, a tv and flour. I want the first query to look at the order then send to the 2nd query the order for sugar, milk and sugar, leaving out the tv. (and maybe sending a message to the user...sorry you can't order that...) I can't seem to get my loops right on this one- I either seem to be able to add all or nothing. Thanks in advance, Janine __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: TextArea & MS Word
We have tried lots of fonts etc for the same problem (we use activepdf) We have found the only solution is to have the person type the information in Notepad(PC) or Simpletext(Mac). I worked extensively with the support from Activepdf on this problem and couldn't come up with a solution. One work about-if the user wants to use some word features such as spell check (warning: this will drive some folks nuts) is to type it in Notepad first then paste in Word. It will keep the apostrophes intact. (assuming you don't type any new ones) Wish I had a better answer to give... -Original Message- From: Randell B Adkins [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 10:00 AM To: CF-Talk Subject: TextArea & MS Word Here is a quick question: Using MS Word 2000 or even 97, copying information from a document and pasting it into a TEXTAREA box will lose the formatting such as apostrophes. I am not concerned with the BOLD or Italicize but the apostrophes, commas, and quotes I am concerned about. With the TEXTAREA if I manually type the apostrophes, commas, and quotes, then it is retained when saving to the database. But if Pasted from MS Word, it transforms the apostrophe into a little square box. Any suggestions on why this occurs? We are looking at ActiveEdit or soEditorLite to handle this but baffles me why I can manually type it and it is retained verses pasting it into the field and then it is converted. TIA! __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Delete query that doesn't delete (inside a loop)
Does it work without the trim? Try WHERE email='#i#' -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 04, 2002 8:04 PM To: CF-Talk Subject: Delete query that doesn't delete (inside a loop) So, why doesn't this work DELETE FROM emp_jobs WHERE email = '#trim(i)#' No error message. The query is good. I can plug in a static e-mail address and it works. I can run it staticly through Query Analyzer just fine. But if I run this in a CFTemplate, no records get deleted. I'm stumped. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT quick javascript question
Is there a way to anchor how a javascript menu popsup on a mouseover? I'm using some dynamic menues- they do fine if everything is on the same page but not well when used with a page with frames. I'd like it so the menu always shows to the right when there's a mouseover Thanks in advance, J __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SOT: simple table format question
Ok it's definitely Monday. here's the problem. I have a query outputting for some checkboxes. They look pretty ugly right now as they all run together. This is the code #CourseName# This puts almost all the courses on one line-2 don't fit and are moved to the next line. My question- how can I get this to nicely format with some space between each checkbox and maybe spread them between two lines. Thanks, J __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfinput" message on error question
did you do a ?? -Original Message- From: mark brinkworth [mailto:[EMAIL PROTECTED]] Sent: Sunday, August 18, 2002 9:11 PM To: CF-Talk Subject: Re: cfinput" message on error question Not sure, but in both cases I got the expected pop up message. Cheers, Mark >Is this the "expected" behaviour, or a bug (CFMX)? > >If NOT required: > > > >Will simply return an error "Error in MonthlyIncome" (or something like >that...) rather than using the defined message. > > >If required: > > > >It will use the defined message. > > >To prevent errors, I need to be sure the user only enters valid numbers >into >all such fields, however, all fields are not required. May have to go with >JavaScript Validation instead... > >Thoughts? __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists