VTML edit tag dialogs: attributes with no value?
Hi all, I hope I can explain this well enough... I am playing with editing VTML files, and I have a perplexing problem. I am trying to create one for our CFX_PWIMAGEPROC. This tag has true/false attributes that do not require values, ie if TEXT_BOLD is present, any text the tag draws is bold. If it's not there, the text drawn is not bold. It's ok in the drop downs within Studio, but I'm trying to make an edit tag dialog. If I use a checkbox and no value is selected, the attribute is not included. If the checkbox is checked, TEXT_BOLD=true is included in the output. That's OK, because the tag will ignore the =true part and make any text bold. If the checkbox is set to true and then changed to be false, rather than removing the attribute completely, it sets it to TEXT_BOLD=false. This won't work because the tag is ignoring the value of the attribute and applying the effect if the attribute is present, which is obviously not going to give the correct results. Radio buttons are no good because you can't deslect the value once it is selected. Multi-select listboxes won't work. I'm tearing my hair out! I guess someone is going to say don't write tags like that, hey. K. __ Kay Smoljak - ColdFusion Developer - PerthWeb Pty Ltd Internet Solutions for your business! Level 9/105 St George's Tc - Perth - Western Australia Ph: (08) 9226 1366 Fax: (08) 9226 1375 Mobile : 0419 949 007 Visit Perth online! : www.perthweb.com.au Tools for developers: http://developer.perthweb.com.au -- cfx_pwimageproc: image processing tool -- cfx_pwcardcrypt: credit card validation and encryption Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: the big export...ColdFusion.NET?
C# is really more along the lines of Java than C, actually a lot closer. If you look at the syntax, it's almost exactly java with a few MS specific things thrown in, that look to make the language a little more approachable. Not to mention it runs on what Microsoft calls a Common Language Runtime. Which is basically just like java's JRE. This is the essence of dotNet. All five of Microsofts major languages( C#, C++, JScript, VB, ASP) will be able to take advantage of it. All of them have seperate compilers except asp of course, but still run on top of the runtime. There are already existing programs that convert C# programs into Java and back again...What makes this really interesting to me is that if Macromedia extends CF to C#, the possibilities for easy access to the dotNet runtime with CF would be very powerful. Actually now that I think about it, as the MS world migrate to XP, dotNet and beyond, it almost seems to be a necessity... MS seems to be trying the same strategy against Sun, that they so successfully used against Netscape. I dont know where I stand, but I'll develop in Java for now. I do know one thing though. Microsoft knows how to write documentation better than anyone around. Their sdk docs blow away the ancient looking docs that come with Sun's JDK. jon - Original Message - From: John McKown [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, May 20, 2001 8:12 PM Subject: RE: the big export...ColdFusion.NET? Pronounced C Sharp, I think it is the successor to C++. John McKown, Owner Delaware.Net, Inc. 30 Old Rudnick Lane, Suite 200 Dover, DE 19901 phone: 302-736-5515 toll free: 888-432-7965 fax: 302-736-5945 e-mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] icq: 1812513 -Original Message- From: Paul Mone [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 7:01 PM To: CF-Talk Subject: RE: the big export...ColdFusion.NET? What is C#? -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 7:36 AM To: CF-Talk Subject: Re: the big export...ColdFusion.NET? Michael, before you go and learn VB, realize that vb is morphing into vb.net. Although the syntax is similar, the changes/improvements are quite drastic. You may want to skip picking up a book on the old VB and concentrate on learning the new stuff. Microsofts site is a great place to start though. bigfatsegue The whole dotNet thing is very interesting... Microsofts try at interpreted code, like java. Which leads me to think back to Macromedia's repeatedly saying dotNet in the press release that they were commited to dotNet. It isn't too far of a stretch to say that Neo may be ported to dotNet, and specifically C#, which is basically java anyway. The more I think about it, the more I think it's a no brainer for Macromedia to do a C# port. It will probably run much faster on Windows. The only risk would be confusing the users as to which is better. That's my random Friday thought. Anyone have any comments? /bigfatsegue jon - Original Message - From: Michael Lugassy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 18, 2001 10:57 AM Subject: Re: the big export thanks for the tip, paul! I keep seeing this learn VB tips and I was wondering - are there any good and quick resources on learning VB on the net? something you know about?? Michael. - Original Message - From: Paul Mone [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 18, 2001 12:49 AM Subject: RE: the big export This is definately something I would consider off-line processing. In most cases, CF is not suitable for these types of tasks, espcially if it's a task that you'll have to repeat on scheduled basis. If this is a one-time event (are you sure? :) ) then you can way the time for development vs. time of processing. one time operation? Developing it in CF is probably the quickest solution. Won't be the quickest app in the world. recurring task? Do it in C, or even better, VB. It would be quicker to develop this in VB than C, and the performance increase that C would give you is probably negligible. Writing an offline recurring task like this in CF would be a mis-use of your CFServer's resources. --- Paul Mone Ninthlink Consulting Group [EMAIL PROTECTED] 619.222.7082 -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 9:49 AM To: CF-Talk Subject: the big export I need the fastest way to export 100s of 1000s of text files into a database. I need each file in a a new row like this: file1name, file1content file2name, file2content CF is too slow for this, what can I use? Thanks, -=Michael. ~~ Structure your ColdFusion code with
Re: What a task!
Thanks all, here is what I found on the subject: html2jpg sounded great, but it's not automatic - i need to load each page myself and click capture image if there was a command line syntax or some other batch mode way to do it - it would be nicer. html2ps doesn't help much and it's too complex, I don't want to maintain links and tables, I just need a low-medium quality snapshot (capture) of the website page. as for one of the suggestions, to minimize table heights and font sizes into mini version of the sites - it's not doable and looks TOO complex. Imagefolio promises loads of features but I can seem to find out an evaluation version to check it out. I'm not willing to pay 189$ for a program that creates thumbnails from everything - what, where, which, how? god knows!! so, if anyone had ANY experince with imagefolio or other automated program that captures webpages AUTOMATICLLY, I'm hearing. thanks alot for your participation in this. Thanks, Michael Lugassy - Original Message - From: Rey Bango [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 21, 2001 4:06 AM Subject: Re: What a task! One solution might be to take a look at ImageFolio. It seems to do everything that Michael wants. http://www.imagefolio.com Rey... Team Allaire... - Original Message - From: Raymond B. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, May 20, 2001 9:36 PM Subject: RE: What a task! Haven't really been following this thread, but at it's highest level your problem seems to break down into these three steps. (If you want quick fixes skip to the bottom.) 1. Render the HTML 2. Convert rendered screen to image 3. Resize image RENDER THE HTML --- You might check out http://www.mozilla.org/ for mozilla's HTML rendering engine if you want something you can bring into your own code. There are some other engines that are open as well, I'll leave them to you to find. Alternately there's closed source such as the popular IE. Which you decide to use counts heavily on the next step. CONVERTING TO AN IMAGE -- The whole purpose of the exercise is to get the render (R) to output to a bitmapped image (I). Theoretically the easiest way would be get R I; somehow I doubt it's going to be as easy as a 'mozilla --url=www.foo.com bar.jpg' though. Given the mozilla source you may be able find where you could redirect the screen display though. I'm not overlly familiar w/ IE but it might have some COM objects accessable to pull the information from. RESIZE IMAGE So many programs and algorithms to accomplish this, choose whichever suites you (http://www.imagemagick.org/ is one of my favourite utils for this). CONCLUSSION --- I realise this isn't exactly detail specific, but if you were floating around wondering how to even begin tackling the problem this might provide some grounding. QUICK FIXES --- http://www.html2jpg.com has a win9x/IE5 specific program to accomplish step 1 and 2 if you're on that platform. http://www.tdb.uu.se/~jan/html2ps.html converts to PS, w/ http://www.imagemagick.org/ it's only a step away from a properly sized jpeg and it's not platform specific. (I don't have a clue how the html2ps script renders the HTML though) -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: May 18, 2001 19:28 To: CF-Talk Subject: Re: What a task! How many thumbnails are there going to be? It might be more cost effective to train a peon (no offense to any peons out there;-)) to use a screenshot program jon - Original Message - From: Michael Lugassy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 18, 2001 8:03 PM Subject: What a task! I got this assignment recently: I need to create a thumbnail view of the front/home page of a given site. that should be done automaticlly, ofcourse. for example: I run this: CF_THUMBSITE site=http://www.imvamp.com;; somehow I need to grab all of the site content and PICTURE IT as it were on a browser. this gots you thinking, ha? I know http://www.girafa.com does something similiar. if anyone can solve this, I'm hearing! :) Thanks, -=Michael ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
pearls of wisdom??
We use simple http requests to transfer data from the server to our special client (built with visual c++) for example: http://www.imvamp.com/action/register.cfm?username=davidpassword=123456 that will return this: OK or NO as a web page (html) the visual c++ client knows what to do on his side with every answer parsed. where this has served us very well in the past year, our information that is sent BACK to the client has turned very complexed and caused problems with special signs and characters. I'm searching for a diffrent way to pass information in and from the visual c++ client to the server. I've taught about WDDX has being the best option with CF but I was worrying to relay on that technology (lack of support, sdk from 98', etc.) - is it possible and advicable to useother XML generator/parser to help me in my client/server tasks? which are best from CF gallery? any help would be great! Michael. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: What a task!
That's the answer I got from Imagefolio, I guess this solution drops out too! :( ImageFolio Pro with the Batch Thumbnailer mod can help make the thumbnails if you already have the original screen shot images that you need thumbnails made out of... Curtis Garrison ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IE5.5 Client Variable Problem
I have the same problem with IE5.5. I understand that this version of the browser re-introduced an old bug that they had fixed in earleier versions of the browser. -Original Message- From: Malcolm Taylor [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 20, 2001 04:56 To: CF-Talk Subject: IE5.5 Client Variable Problem I have a problem with a fairly significant CF application used by a number of our clients which runs under CF 4.51 and IIS4.0 on NT4.0 Server. Client variables are stored in an Access database file and all works well except when the application is accessed by IE5.5 from a machine other than the server. Normal behaviour is for authentication and the setting of miscellaneous client variables to occur in a single-frame window before moving to a multi-frame frameset. By looking at the CDATA table in my Access file, I can see that under normal circumstances, this writes a single record which stores client data to be accessed throughout the application, before or after the move to a frameset. Under IE5.5 running on a machine other than the server, I can see that creating the frameset generates new records within CDATA (one for each frame) and once I move to the frameset, client variables which were set prior to the move are no longer available to templates running within the frames and variables set within one frame are unavailable to templates running in the others. Can anyone please offer me any enlightenment, or at least point me in the right direction? Any help would be much appreciated. Many thanks, Malcolm ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: the big export...ColdFusion.NET?
C# is basically a new language developed by Microsoft that has the simplicity of Visual Basic but with all the power of C++. It is an OO language that offers garbage collection as Java does so no more I am assuming no more pointers. It also has simplified type declarations - a bool can be true or false but can't be converted into other types. ttfn Stephen -Original Message- From: Paul Mone [mailto:[EMAIL PROTECTED]] Sent: 19 May 2001 00:01 To: CF-Talk Subject: RE: the big export...ColdFusion.NET? What is C#? -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 7:36 AM To: CF-Talk Subject: Re: the big export...ColdFusion.NET? Michael, before you go and learn VB, realize that vb is morphing into vb.net. Although the syntax is similar, the changes/improvements are quite drastic. You may want to skip picking up a book on the old VB and concentrate on learning the new stuff. Microsofts site is a great place to start though. bigfatsegue The whole dotNet thing is very interesting... Microsofts try at interpreted code, like java. Which leads me to think back to Macromedia's repeatedly saying dotNet in the press release that they were commited to dotNet. It isn't too far of a stretch to say that Neo may be ported to dotNet, and specifically C#, which is basically java anyway. The more I think about it, the more I think it's a no brainer for Macromedia to do a C# port. It will probably run much faster on Windows. The only risk would be confusing the users as to which is better. That's my random Friday thought. Anyone have any comments? /bigfatsegue jon - Original Message - From: Michael Lugassy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 18, 2001 10:57 AM Subject: Re: the big export thanks for the tip, paul! I keep seeing this learn VB tips and I was wondering - are there any good and quick resources on learning VB on the net? something you know about?? Michael. - Original Message - From: Paul Mone [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 18, 2001 12:49 AM Subject: RE: the big export This is definately something I would consider off-line processing. In most cases, CF is not suitable for these types of tasks, espcially if it's a task that you'll have to repeat on scheduled basis. If this is a one-time event (are you sure? :) ) then you can way the time for development vs. time of processing. one time operation? Developing it in CF is probably the quickest solution. Won't be the quickest app in the world. recurring task? Do it in C, or even better, VB. It would be quicker to develop this in VB than C, and the performance increase that C would give you is probably negligible. Writing an offline recurring task like this in CF would be a mis-use of your CFServer's resources. --- Paul Mone Ninthlink Consulting Group [EMAIL PROTECTED] 619.222.7082 -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 9:49 AM To: CF-Talk Subject: the big export I need the fastest way to export 100s of 1000s of text files into a database. I need each file in a a new row like this: file1name, file1content file2name, file2content CF is too slow for this, what can I use? Thanks, -=Michael. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Querying by a date field.
Hi Folks, Got a problem with the online support knowledge bas on our intranet. Basically the date search for KB items does not seem to be getting the correct values. I noticed that the Access DB datasource has the date in a couple of formats, either dd/mm/yy or dd/mm/yy hh/mm/ss. The search form lets users enter values in dd/mm/ or with a 2 date year but, nothing seems to be happening. Heres the code: cfset today = #dateformat(now(),dd/mm/)# cfquery name=getdate datasource=suppkb dbtype=ODBC SELECT * FROM Main_Table WHERE Date_Entered BETWEEN #dateformat(date,dd/mm/)# and #today# /cfquery cfoutput query=getdate#date_entered#, #Record_id#br/cfoutput cfabort Can any eagle eyed code spot my flaw ? Cheers, Darren Adams Web Developer Marketing Department Systems Union Office: 01252 55 6220 Mobile: 07714 817 038 Email: [EMAIL PROTECTED] Data + Structure = INFORMATION ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Problem with cf_uicalender
I'm using the control as below, and the action page currently does nothing, except dump the form fields (using the debug option in the server). The trouble is, the variable 'form.dateis' is always blank ! Is this a bug, or am I missing something? My application.cfm has stformat described as: --snip: application.cfm-- cfscript stformat=structnew(); stformat.bdrstate=0; stformat.bgcolor=##ff; stformat.btnbdrcolor=##2020bb; stformat.btnbdrhicolor=##2020bb; stformat.btncolor=##2020bb; stformat.btnhicolor=##2020bb; stformat.btntextcolor=##ff; /cfscript --snip-- --snip: form.cfm-- cfform action=new_action.cfm cf_uicalendar height=250 width=250 popup=No formfield=dateis stformatting=#stformat# input type=submit name=save value=Save /cfform --snip-- Regards, Thomas Chiverton Intranet Architect and Desktop Analyst 01565 757 909 It's not a job, it's an adventure ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: the big export...ColdFusion.NET?
A bit OT but while we're on the subject does c# have anything to offer that existing languages do not have? Thanks KOla -Original Message- From: Stephen Galligan [mailto:[EMAIL PROTECTED]] Sent: 21 May 2001 10:35 To: CF-Talk Subject: RE: the big export...ColdFusion.NET? C# is basically a new language developed by Microsoft that has the simplicity of Visual Basic but with all the power of C++. It is an OO language that offers garbage collection as Java does so no more I am assuming no more pointers. It also has simplified type declarations - a bool can be true or false but can't be converted into other types. ttfn Stephen -Original Message- From: Paul Mone [mailto:[EMAIL PROTECTED]] Sent: 19 May 2001 00:01 To: CF-Talk Subject: RE: the big export...ColdFusion.NET? What is C#? -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 7:36 AM To: CF-Talk Subject: Re: the big export...ColdFusion.NET? Michael, before you go and learn VB, realize that vb is morphing into vb.net. Although the syntax is similar, the changes/improvements are quite drastic. You may want to skip picking up a book on the old VB and concentrate on learning the new stuff. Microsofts site is a great place to start though. bigfatsegue The whole dotNet thing is very interesting... Microsofts try at interpreted code, like java. Which leads me to think back to Macromedia's repeatedly saying dotNet in the press release that they were commited to dotNet. It isn't too far of a stretch to say that Neo may be ported to dotNet, and specifically C#, which is basically java anyway. The more I think about it, the more I think it's a no brainer for Macromedia to do a C# port. It will probably run much faster on Windows. The only risk would be confusing the users as to which is better. That's my random Friday thought. Anyone have any comments? /bigfatsegue jon - Original Message - From: Michael Lugassy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 18, 2001 10:57 AM Subject: Re: the big export thanks for the tip, paul! I keep seeing this learn VB tips and I was wondering - are there any good and quick resources on learning VB on the net? something you know about?? Michael. - Original Message - From: Paul Mone [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 18, 2001 12:49 AM Subject: RE: the big export This is definately something I would consider off-line processing. In most cases, CF is not suitable for these types of tasks, espcially if it's a task that you'll have to repeat on scheduled basis. If this is a one-time event (are you sure? :) ) then you can way the time for development vs. time of processing. one time operation? Developing it in CF is probably the quickest solution. Won't be the quickest app in the world. recurring task? Do it in C, or even better, VB. It would be quicker to develop this in VB than C, and the performance increase that C would give you is probably negligible. Writing an offline recurring task like this in CF would be a mis-use of your CFServer's resources. --- Paul Mone Ninthlink Consulting Group [EMAIL PROTECTED] 619.222.7082 -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 9:49 AM To: CF-Talk Subject: the big export I need the fastest way to export 100s of 1000s of text files into a database. I need each file in a a new row like this: file1name, file1content file2name, file2content CF is too slow for this, what can I use? Thanks, -=Michael. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Querying by a date field.
try using this: cfquery name=getdate datasource=suppkb dbtype=ODBC SELECT * FROM Main_Table WHERE convert(char(10),Date_Entered,101) BETWEEN #dateformat(date,dd/mm/)# and #today# /cfquery that will ensure Date_Entered is also in dd/mm/ format. works for me... let me know! Thanks, Michael Lugassy IT/WEB Specialist Interactive Music Ltd. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Querying by a date field.
Hello Michael, Just ran your code and got this message: Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Undefined function 'convert' in expression. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (3:1) to (3:58). Date/Time: 05/21/01 11:58:07 Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows 95; DigExt) Remote Address: 129.153.207.20 HTTP Referer: http://uk1web2:8070/supportkb/search.cfm Template: E:\Inetpub\infodesk\supportkb\search_result.cfm Any ideas ? -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: 21 May 2001 12:19 To: CF-Talk Subject: Re: Querying by a date field. try using this: cfquery name=getdate datasource=suppkb dbtype=ODBC SELECT * FROM Main_Table WHERE convert(char(10),Date_Entered,101) BETWEEN #dateformat(date,dd/mm/)# and #today# /cfquery that will ensure Date_Entered is also in dd/mm/ format. works for me... let me know! Thanks, Michael Lugassy IT/WEB Specialist Interactive Music Ltd. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Querying by a date field.
That's weird, what DB are u using? that's working for me on SQL 7/2000 note that Date_Entered must be the colum name, right? Anyhow, you can probarbly use this also: DATES ARE A MAJOR BAMMER cfset ddifer = DateDiff(d, CreateDATE(date), now()) cfquery name=getdate datasource=suppkb dbtype=ODBC SELECT * FROM Main_Table WHERE Date_Entered BETWEEN getdate(-#ddifer#) and getdate() /cfquery /DATES ARE A MAJOR BAMMER That will insert into ddifer the number of days diffrentiation between NOW() and what people chose in your form and run a query based on : [today-#ddfier# days] and today] you will need to complete the CreateDate(date) function yourself... But there probarbly other ways, better... sorry. Thanks, Michael Lugassy IT/WEB Specialist Interactive Music Ltd. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Querying by a date field.
Convert is a SQL function. I do not think Access recognizes it. -Original Message- From: Darren Adams [mailto:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 6:57 AM To: CF-Talk Subject: RE: Querying by a date field. Hello Michael, Just ran your code and got this message: Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Undefined function 'convert' in expression. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (3:1) to (3:58). Date/Time: 05/21/01 11:58:07 Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows 95; DigExt) Remote Address: 129.153.207.20 HTTP Referer: http://uk1web2:8070/supportkb/search.cfm Template: E:\Inetpub\infodesk\supportkb\search_result.cfm Any ideas ? -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: 21 May 2001 12:19 To: CF-Talk Subject: Re: Querying by a date field. try using this: cfquery name=getdate datasource=suppkb dbtype=ODBC SELECT * FROM Main_Table WHERE convert(char(10),Date_Entered,101) BETWEEN #dateformat(date,dd/mm/)# and #today# /cfquery that will ensure Date_Entered is also in dd/mm/ format. works for me... let me know! Thanks, Michael Lugassy IT/WEB Specialist Interactive Music Ltd. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Querying by a date field.
Ah ! That might explain it as it is an Access DB (although we do have SQL Server 7). IS there a way to do this in Access do you know off ? -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED]] Sent: 21 May 2001 12:27 To: CF-Talk Subject: RE: Querying by a date field. Convert is a SQL function. I do not think Access recognizes it. -Original Message- From: Darren Adams [mailto:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 6:57 AM To: CF-Talk Subject: RE: Querying by a date field. Hello Michael, Just ran your code and got this message: Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Undefined function 'convert' in expression. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (3:1) to (3:58). Date/Time: 05/21/01 11:58:07 Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows 95; DigExt) Remote Address: 129.153.207.20 HTTP Referer: http://uk1web2:8070/supportkb/search.cfm Template: E:\Inetpub\infodesk\supportkb\search_result.cfm Any ideas ? -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: 21 May 2001 12:19 To: CF-Talk Subject: Re: Querying by a date field. try using this: cfquery name=getdate datasource=suppkb dbtype=ODBC SELECT * FROM Main_Table WHERE convert(char(10),Date_Entered,101) BETWEEN #dateformat(date,dd/mm/)# and #today# /cfquery that will ensure Date_Entered is also in dd/mm/ format. works for me... let me know! Thanks, Michael Lugassy IT/WEB Specialist Interactive Music Ltd. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Querying by a date field.
It is a little wierd isnt it. The code looked allright to me. We are using SQL Server 7. I assume that getdate is an SQL function and would not be effected by the fact that we are using CF 4.0. -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: 21 May 2001 13:20 To: CF-Talk Subject: Re: Querying by a date field. That's weird, what DB are u using? that's working for me on SQL 7/2000 note that Date_Entered must be the colum name, right? Anyhow, you can probarbly use this also: DATES ARE A MAJOR BAMMER cfset ddifer = DateDiff(d, CreateDATE(date), now()) cfquery name=getdate datasource=suppkb dbtype=ODBC SELECT * FROM Main_Table WHERE Date_Entered BETWEEN getdate(-#ddifer#) and getdate() /cfquery /DATES ARE A MAJOR BAMMER That will insert into ddifer the number of days diffrentiation between NOW() and what people chose in your form and run a query based on : [today-#ddfier# days] and today] you will need to complete the CreateDate(date) function yourself... But there probarbly other ways, better... sorry. Thanks, Michael Lugassy IT/WEB Specialist Interactive Music Ltd. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Querying by a date field.
Sorry, although we do have SQL server it is an Access database that the Support KB is stored in. -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: 21 May 2001 13:20 To: CF-Talk Subject: Re: Querying by a date field. That's weird, what DB are u using? that's working for me on SQL 7/2000 note that Date_Entered must be the colum name, right? Anyhow, you can probarbly use this also: DATES ARE A MAJOR BAMMER cfset ddifer = DateDiff(d, CreateDATE(date), now()) cfquery name=getdate datasource=suppkb dbtype=ODBC SELECT * FROM Main_Table WHERE Date_Entered BETWEEN getdate(-#ddifer#) and getdate() /cfquery /DATES ARE A MAJOR BAMMER That will insert into ddifer the number of days diffrentiation between NOW() and what people chose in your form and run a query based on : [today-#ddfier# days] and today] you will need to complete the CreateDate(date) function yourself... But there probarbly other ways, better... sorry. Thanks, Michael Lugassy IT/WEB Specialist Interactive Music Ltd. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Checkboxes define tables...
I have a form with 13 checkboxes each named Services but with different values.. is there a way i can tell it to write something like 'on' in each services field that's checked from the form? Without alot of useless cfifs and stuff? Thanks, Tony Hicks ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Checkboxes define tables...
If each form field is named services then the value of Form.Services will be a list of all the checkboxes selected. So, if you had this: INPUT TYPE=checkbox NAME=Services VALUE=11 INPUT TYPE=checkbox NAME=Services VALUE=22 INPUT TYPE=checkbox NAME=Services VALUE=33 and the user selected 1 and 3, the value of Form.Services would be 1,3. Now, you ask, how can I tell it to write something like 'on' in each services field that's check. Are you asking about how to make them preselected when the form redisplays? Or how to save them to a DB? If you want to know how to make them preselected, simply... CFPARAM NAME=Form.Selected DEFAULT= INPUT TYPE=checkbox NAME=Services VALUE=1 CFIF ListFind(Form.Selected,1)CHECKED/CFIF1 INPUT TYPE=checkbox NAME=Services VALUE=2 CFIF ListFind(Form.Selected,2)CHECKED/CFIF2 INPUT TYPE=checkbox NAME=Services VALUE=3 CFIF ListFind(Form.Selected,3)CHECKED/CFIF3 and so on. Does this help? === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] ICQ UIN : 3679482 My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Tony Hicks [mailto:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 7:35 AM To: CF-Talk Subject: Checkboxes define tables... I have a form with 13 checkboxes each named Services but with different values.. is there a way i can tell it to write something like 'on' in each services field that's checked from the form? Without alot of useless cfifs and stuff? Thanks, Tony Hicks ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: VTML edit tag dialogs: attributes with no value?
You can do a conditional output by using WIZIF So, your VTML portion of the TAGLAYOUT portion can do this: mytag WIZIF fieldname EQ 'true'TEXT_BOLD = 1/WIZIF This way it would only show up if true, not false or not selected at all. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] ICQ UIN : 3679482 My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Kay Smoljak [mailto:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 2:25 AM To: CF-Talk Subject: VTML edit tag dialogs: attributes with no value? Hi all, I hope I can explain this well enough... I am playing with editing VTML files, and I have a perplexing problem. I am trying to create one for our CFX_PWIMAGEPROC. This tag has true/false attributes that do not require values, ie if TEXT_BOLD is present, any text the tag draws is bold. If it's not there, the text drawn is not bold. It's ok in the drop downs within Studio, but I'm trying to make an edit tag dialog. If I use a checkbox and no value is selected, the attribute is not included. If the checkbox is checked, TEXT_BOLD=true is included in the output. That's OK, because the tag will ignore the =true part and make any text bold. If the checkbox is set to true and then changed to be false, rather than removing the attribute completely, it sets it to TEXT_BOLD=false. This won't work because the tag is ignoring the value of the attribute and applying the effect if the attribute is present, which is obviously not going to give the correct results. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
rebuild laptop :: save cf server dsn's
ok, i am thinking about rebuilding my laptop. from winnt to win98 what can i do to save my mappings, data sources on my local box. any thing else i should think of doing before the f-disk? any advice would be great! thank you! -paul an unofficial user friendly signature... web developer, nbbj work: [EMAIL PROTECTED] 614 241-3534 fax:614 485-5534 home: [EMAIL PROTECTED] 614 449-1681 icq: 47658358 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Verity: Hair-Pulling Problem
I wasn't in this thread early, but as far as I know, you can also just DELETE individual keys. This means you don't have to worry about recreating. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] ICQ UIN : 3679482 My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Judith Taylor [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 20, 2001 1:15 PM To: CF-Talk Subject: RE: Verity: Hair-Pulling Problem The thing you have to be careful of with deleting as opposed to purging your collection is to make sure that you create the collection before updating it... ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: rebuild laptop :: save cf server dsn's
from NT to 98? errm... are you mental :-) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
What a task!
Hi, I have used PowerMapper before, it creates thumbnails in a clickable map as a site mapping tool. http://www.powermapper.com/products.htm There is a download eval and it costs $99. Chuck Rodgers Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: rebuild laptop :: save cf server dsn's
I was wondering why anyone would do the same myself :) I would never go back to win9x. --- Neil Clark [EMAIL PROTECTED] wrote: from NT to 98? errm... are you mental :-) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: What a task!
So NOT what I needed... :( You can create thumbnails automaticlly, you can't even decide on the thumnbail size. Thanks, Michael Lugassy IT/WEB Specialist Interactive Music Ltd. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Admin Fail ???
Error Diagnostic Information The encrypted template D:\INETPUB\WEBSTER\CFIDE\ADMINISTRATOR\APPLICATION.CFM contains invalid CFML syntax. Because the template has been encrypted, you cannot see the actual error message. You need to have access to an unencrypted version of the template to get detailed error information Does anyone know what this means??? I am getting this trying to access the admin? Thanks ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Transact SQL book
I seem to recall someone asking on here if anyone knew of a definitive Transact SQL reference book. I've stumbled across this one at Amazon called The Gurtu's guide to Transact SQL by Kenneth Henderson - anyone read it? http://www.amazon.co.uk/exec/obidos/ASIN/0201615762/qid=990451170/sr=1-29/20 2-5900567-1244606 -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Setting Dynamic Variables
Trying to create a set of variables dynamically but cannot think of how to do it. Here is what I am trying to do: cfset Evaluate(form.Type GetInfo.CurrentRow) = Type It won't let me use the Evaluate() function on the left side though, does someone know of a way to do this? I can't think of anything. = Bernd VanSkiver [EMAIL PROTECTED] ColdFusion Developer ICQ UIN: 916324 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Admin Fail ???
Is D:\INETPUB\WEBSTER\CFIDE\ADMINISTRATOR\INDEX.CFM not what you want ? - Original Message - From: Michael Ross [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 21, 2001 8:18 AM Subject: Admin Fail ??? Error Diagnostic Information The encrypted template D:\INETPUB\WEBSTER\CFIDE\ADMINISTRATOR\APPLICATION.CFM contains invalid CFML syntax. Because the template has been encrypted, you cannot see the actual error message. You need to have access to an unencrypted version of the template to get detailed error information Does anyone know what this means??? I am getting this trying to access the admin? Thanks ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Setting Dynamic Variables
How about cfset varName = form.Type GetInfo.CurrentRow cfset #varName# = Type Nick -Original Message- From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 2:27 PM To: CF-Talk Subject: Setting Dynamic Variables Trying to create a set of variables dynamically but cannot think of how to do it. Here is what I am trying to do: cfset Evaluate(form.Type GetInfo.CurrentRow) = Type It won't let me use the Evaluate() function on the left side though, does someone know of a way to do this? I can't think of anything. = Bernd VanSkiver [EMAIL PROTECTED] ColdFusion Developer ICQ UIN: 916324 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Transact SQL book
Yes. It's excellent, but I wouldn't call it a definitive Transact SQL reference book. It's more of an advanced SQL techniques book. It won't teach you the basics, but it will give you some really neat ideas if you have gotten past the basics. Bob -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 9:27 AM To: CF-Talk Subject: Transact SQL book I seem to recall someone asking on here if anyone knew of a definitive Transact SQL reference book. I've stumbled across this one at Amazon called The Gurtu's guide to Transact SQL by Kenneth Henderson - anyone read it? http://www.amazon.co.uk/exec/obidos/ASIN/0201615762/qid=990451170/sr=1-29/20 2-5900567-1244606 -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Setting Dynamic Variables
You've got the right idea, just the wrong syntax. Try: cfset Type#GetInfo.CurrentRow# = Type Bob -Original Message- From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 9:27 AM To: CF-Talk Subject: Setting Dynamic Variables Trying to create a set of variables dynamically but cannot think of how to do it. Here is what I am trying to do: cfset Evaluate(form.Type GetInfo.CurrentRow) = Type It won't let me use the Evaluate() function on the left side though, does someone know of a way to do this? I can't think of anything. = Bernd VanSkiver [EMAIL PROTECTED] ColdFusion Developer ICQ UIN: 916324 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Admin Fail ???
it is what I want. [EMAIL PROTECTED] 05/21/01 09:36AM Is D:\INETPUB\WEBSTER\CFIDE\ADMINISTRATOR\INDEX.CFM not what you want ? - Original Message - From: Michael Ross [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 21, 2001 8:18 AM Subject: Admin Fail ??? Error Diagnostic Information The encrypted template D:\INETPUB\WEBSTER\CFIDE\ADMINISTRATOR\APPLICATION.CFM contains invalid CFML syntax. Because the template has been encrypted, you cannot see the actual error message. You need to have access to an unencrypted version of the template to get detailed error information Does anyone know what this means??? I am getting this trying to access the admin? Thanks ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Transact SQL book
Cool thanks for the feedback Bob. I've come across numerous SQL Server books in the past but most have only briefly touched on Transact SQL. I've always used the books online and the SQL help files to solve any issues I've had over the years but it's good to know there is a decent book touching on advanced techniques..off to Amazon then Oh by the way...whilst I'm on the topic of books. Anyone passed the Microsoft exam 70-029 (Designing and Implementing SQL Server 7)? If so what study book did you use. I've been looking at the Readiness Review from Microsoft and the MCSE Fast Track: SQL Server 7 Database Design. Anyone have any views? -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Bob Silverberg [mailto:[EMAIL PROTECTED]] Sent: 21 May 2001 14:45 To: CF-Talk Subject: RE: Transact SQL book Yes. It's excellent, but I wouldn't call it a definitive Transact SQL reference book. It's more of an advanced SQL techniques book. It won't teach you the basics, but it will give you some really neat ideas if you have gotten past the basics. Bob -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 9:27 AM To: CF-Talk Subject: Transact SQL book I seem to recall someone asking on here if anyone knew of a definitive Transact SQL reference book. I've stumbled across this one at Amazon called The Gurtu's guide to Transact SQL by Kenneth Henderson - anyone read it? http://www.amazon.co.uk/exec/obidos/ASIN/0201615762/qid=990451170/sr=1-29/20 2-5900567-1244606 -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Setting Dynamic Variables
This is not guaranteed to work with future versions of CF. Look into the setVariable() function. jon - Original Message - From: Bob Silverberg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 21, 2001 9:46 AM Subject: RE: Setting Dynamic Variables You've got the right idea, just the wrong syntax. Try: cfset Type#GetInfo.CurrentRow# = Type Bob -Original Message- From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 9:27 AM To: CF-Talk Subject: Setting Dynamic Variables Trying to create a set of variables dynamically but cannot think of how to do it. Here is what I am trying to do: cfset Evaluate(form.Type GetInfo.CurrentRow) = Type It won't let me use the Evaluate() function on the left side though, does someone know of a way to do this? I can't think of anything. = Bernd VanSkiver [EMAIL PROTECTED] ColdFusion Developer ICQ UIN: 916324 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: rebuild laptop :: save cf server dsn's
oh i don't know. perhaps being able to use the ir port or the usb port would be nice. i may not do it, since i do have the production server mirrored on my laptop. just thinking about it. if it is a dumb idea, will stick to nt then. -paul an unofficial user friendly signature... web developer, nbbj work: [EMAIL PROTECTED] 614 241-3534 fax:614 485-5534 home: [EMAIL PROTECTED] 614 449-1681 icq: 47658358 -Original Message- From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 9:12 AM To: CF-Talk Subject: RE: rebuild laptop :: save cf server dsn's I was wondering why anyone would do the same myself :) I would never go back to win9x. --- Neil Clark [EMAIL PROTECTED] wrote: from NT to 98? errm... are you mental :-) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Setting Dynamic Variables
Eh? Is it marked for deprecation? If so, it's news to me. (Not saying your wrong, just wondering why you think this.) === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] ICQ UIN : 3679482 My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 9:56 AM To: CF-Talk Subject: Re: Setting Dynamic Variables This is not guaranteed to work with future versions of CF. Look into the setVariable() function. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Duplicate() ?
I've heard somewhere that by assigning a structure varialbe (or another complex variable) to a diffrent variable by using something like: CFSET copyofstruct=OldStructer I'm just assigning a pointer for that structure and To FULLY copy this variable I need to use some Duplicate() function. correct? what function exactly? and does Arrray consider complex variable too? Thanks, -=Michael. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: rebuild laptop :: save cf server dsn's
In regedit you can export your registry export: HKLM\Software\Allaire\ColdFusion\CurrentVersion and HKLM\Software\ODBC\ODBC.INI to save your datasources. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Duplicate() ?
I've heard somewhere that by assigning a structure varialbe (or another complex variable) to a diffrent variable by using something like: CFSET copyofstruct=OldStructer I'm just assigning a pointer for that structure and To FULLY copy this variable I need to use some Duplicate() function. Correct. To see this in action, do: CFSET A = StructNew() CFSET B = A CFSET A.foo = 1 CFOUTPUT#B.foo#/CFOUTPUT correct? what function exactly? and does Arrray consider complex variable too? To really copy A instead of creating a pointer, the correct code would be: CFSET B = Duplicate(A) Please note though that there is a small bug in Duplicate() for really complex vars. You can download a patch at Allaire.com. Does this apply to arrays? No for simple arrays. However, an array of structures would suffer from the same issue. You would want to use Duplicate() for those kind of variables. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] ICQ UIN : 3679482 My ally is the Force, and a powerful ally it is. - Yoda ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: QOT: Message Board Questions
I suppose this may or may not work for your particular situation, it seems to be a switch from what you have implemented (or was planning on implementing) Build it all as one application. And build a security scheme into the database, with users and groups (tables). Turn off (or on) navigational items based on the user sign in. In separate directories, use the application.cfm to check whether or not the user is in a group that has access to this directory. You can even take this a step further and create one discussion group code-base, and turn on and off all of the messages based on the user's groups. Take this scenario: I log in to your application. I click the discussion room link. I'm presented with a list of sections that I have access to (I.E. section 1, section 2, section 3, through section 11) Clicking the section will give me a list of all discussions in that topic. It should be easy enough to intersect a group table with a section table, and intersect the section table with discussion messages. Would that work? From a functional standpoint, it's a solution. However, politics may trash it. I can imagine people being offended that their discussion group is listed on the same page as another section's discussion group. (Corporate America--or wherever--gotta love it) It sounds like a flawed reason to allow anonymous posting, kind of like a solution to avoid the problem, not solve it. Can 'you' dymanically' name an application using the CFAPPLICATION tag? I've never even thought to try it before. Maybe you could use the same discussion group code, but automatically log people in by passing the application name as a variable into the template. (I.E. you'll have access to all the previous session / application / client variables) At 12:00 AM 05/21/2001 -0400, you wrote: Sorta quasi off-topic here... I've got an interesting situation. I'm working on a site that has a lot of politics involved. They want a message board for each of 11 different sections that is totally separated but they all use the same header and footer file combination. They also want something that looks like CF Forum 2000 or SMB, with the twist that they want anonymous posting capabilities added in (where they do not have to log in to post). The reason for the twist is the fact that there are going to be 11 different applications running and they do not share username and passwords... if each message board requires a log-in and a visitor has access to 5 boards and wants to post on all 5, then they would have to log in 11 times (one for the main site, then once again to gain access to the board to read message threads and one more time to post a thread). This is way too cumbersome. Does anyone know of a better concept of doing this. Right now what I'm pondering is 11 installations of the same message board and going through changing the application name to prevent session variable conflicts. It is absolutely vital that all 11 areas have their own message boards. They do not want any sharing of message topics/threads/posts across boards. TIA! Hatton Humphrey ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Setting Dynamic Variables
I'm just going by what I've seen posted here. I've never seen any documentation saying dynamic variables should be named this way, and there is a function to do specifically this. A little deduction leads me to believe that this is an unintended way to go about it. So if it goes away because the underlying way cfset works, kinda like the old 4.0 bad query of and access odbc datasource thing. You probably know better than me though...I'm doing a lot of assuming when it comes down to it ;-) jon - Original Message - From: Raymond Camden [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 21, 2001 10:01 AM Subject: RE: Setting Dynamic Variables Eh? Is it marked for deprecation? If so, it's news to me. (Not saying your wrong, just wondering why you think this.) === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] ICQ UIN : 3679482 My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 9:56 AM To: CF-Talk Subject: Re: Setting Dynamic Variables This is not guaranteed to work with future versions of CF. Look into the setVariable() function. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: What a task!
What about Windows? In explorer, under the view menu, there is an option called Thumbnails. Perhaps whatever is generating these thumbnails (an activex control?) could be called on the server to generate the thumbnail? Not sure if this is at all feasible, but just a thought. Matt -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 8:04 PM To: CF-Talk Subject: What a task! I got this assignment recently: I need to create a thumbnail view of the front/home page of a given site. that should be done automaticlly, ofcourse. for example: I run this: CF_THUMBSITE site=http://www.imvamp.com;; somehow I need to grab all of the site content and PICTURE IT as it were on a browser. this gots you thinking, ha? I know http://www.girafa.com does something similiar. if anyone can solve this, I'm hearing! :) Thanks, -=Michael ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: QOT: Message Board Questions
Would that work? From a functional standpoint, it's a solution. However, politics may trash it. I can imagine people being offended that their discussion group is listed on the same page as another section's discussion group. (Corporate America--or wherever--gotta love it) Tell me about it! This is for a group that has 9 different branches that don't have anything to do with each other with the exception that they all share the same parent group. Hence the reason that their message boards need to be separated. I wish I had the time on the project to rebuild the message forum but I don't, so I think I'm going to do some monkeying with what I've got already. It sounds like a flawed reason to allow anonymous posting, kind of like a solution to avoid the problem, not solve it. It's out of my control... but I agree wholeheartedly with you. Can 'you' dymanically' name an application using the CFAPPLICATION tag? I've never even thought to try it before. Maybe you could use the same discussion group code, but automatically log people in by passing the application name as a variable into the template. (I.E. you'll have access to all the previous session / application / client variables) I've never tried it either, but it does sound like something to play with. Thanks for the comments! Hatton Humphrey ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Adobe Acrobat - Batch HTML Thumbnails
Michael Lugassy was looking for a solution to batch processing thumbnails of web pages. Adobe Acrobat Version 5.0 appears to have many ways of doing this. It has automatic batch process run command, lots of file export options including JPG, HTML page conversion to PDF using URL or other methods, the ability to run Acrobat right inside a browser, ability to print to an Adobe printer driver, etc. I bought it for other reasons, but I think it will do what you want. -- Eric Root Environmental Management Systems Inc. Web Site: http://www.mountainmyst.com/emsi/emsi_home.htm Phone (Voice): (509) 548-0243 Phone (Fax): (509) 548-0244 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Best way to limit access to a specific template from only the previous template?
Thanks! I used Craig's suggestion and it works fine. CFIF cgi.http_referer does not contain template1.cfm H1Unauthorized host detected! Access denied!/H1 CFABORT SHOWERROR=You are not authorized to use this function! /CFIF I also augmented the header line with an a href back to the login screen. cfif cgi.http_referer does not contain login.cfm h2Unauthorized access method detected?br a href=http://129.174.xx.xxx/ssh/index.cfm; Please login/a/h2 cfabort showerror=You have to login first! /cfif ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Admin Fail ???
I had this message before -- I think you can get the error if you install a service pack or update and the cfide\administrator directory was changed during the install. Try reinstalling cf (or in my case, I installed the latest service pack 2) and that should fix it. Tim Painter - Original Message - From: Michael Ross [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 21, 2001 9:18 AM Subject: Admin Fail ??? Error Diagnostic Information The encrypted template D:\INETPUB\WEBSTER\CFIDE\ADMINISTRATOR\APPLICATION.CFM contains invalid CFML syntax. Because the template has been encrypted, you cannot see the actual error message. You need to have access to an unencrypted version of the template to get detailed error information Does anyone know what this means??? I am getting this trying to access the admin? Thanks ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: rebuild laptop :: save cf server dsn's
Do you have the option to put windows 2000 on it? If so, I would highly suggest you do that. IR and USB work great in 2000 and it is far more stable than Win9x and NT even. --- Paul Ihrig [EMAIL PROTECTED] wrote: oh i don't know. perhaps being able to use the ir port or the usb port would be nice. i may not do it, since i do have the production server mirrored on my laptop. just thinking about it. if it is a dumb idea, will stick to nt then. -paul an unofficial user friendly signature... web developer, nbbj work: [EMAIL PROTECTED] 614 241-3534 fax: 614 485-5534 home: [EMAIL PROTECTED] 614 449-1681 icq:47658358 -Original Message- From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 9:12 AM To: CF-Talk Subject: RE: rebuild laptop :: save cf server dsn's I was wondering why anyone would do the same myself :) I would never go back to win9x. --- Neil Clark [EMAIL PROTECTED] wrote: from NT to 98? errm... are you mental :-) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Slightly OT: UK Extended Fusebox Training
Hi, Sorry for the OT post, but I just wondered if any of you guys (and gals) were going to Hal Helms' Extended Fusebox Training Course in the UK on 16th July? Please mail me off-list if you are! Cheers Alistair Davidson Senior Web Developer Rocom New Media www.rocomx.net ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Adobe Acrobat - Batch HTML Thumbnails
Thanks for the nfo about Adobe Acrobat 5.0, but after looking into the features list I'm still not positive that this can help me out. Adobe Acrobat can capture the data alright, but as a PDF file. that's about the same as getting the HTML with CFHTTP and storing it locally on a html file. the tricky thing is to CAPTURE the html/pdf content into IMAGE and to do it on the fly and automaticlly. if you can try out Acrobat and see that you can do this please tell me. I will purchase the program. Thanks, Michael Lugassy IT/WEB Specialist Interactive Music Ltd. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Stripping wrapper quotes from all fields
I have a database in which all fields are wrapped by double quotes. I'd like to write a CF template that will strip all leading and ending quotes from all fields in the table; i.e., Hardwood Tile should become Hardwood Tile Any guidance? Thanks, Marc Garrett ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Page Refreshing
I need to force a refresh on a page when I return to it after doing a postcode lookup routine. I was wondering if there was a CF solution to this as I have tried JavaScript and using meta tags and they don't seem to work. Forgive me if this is an easy one for the list. TIA Kate ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Another Problem with cf_uicalender
The left most arrow (previous month) is ~one pixel lower than the month box. Anyone else seeing these problems ? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Stripping wrapper quotes from all fields
I would probably consider changing the database first. Outside of that, you can use regex: CFSET STR = Ray's world has quotes in it. CFSET STR = REReplace(STR,^,) CFSET STR = REReplace(STR,$,) This uses ^ to find a quote at the beginning, and $ to match at the end. This will keep the quotes in the middle of the string safe. If you are _sure_ that every string has .., you could also do: CFSET NewStr = Mid(STR,2,Len(STR)-2) Oh, you also may be able to use SQL to strip out the first and last character. Not 100% sure though. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] ICQ UIN : 3679482 My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Marc Garrett [mailto:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 11:55 AM To: CF-Talk Subject: Stripping wrapper quotes from all fields I have a database in which all fields are wrapped by double quotes. I'd like to write a CF template that will strip all leading and ending quotes from all fields in the table; i.e., Hardwood Tile should become Hardwood Tile ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Cfhttp
Can a text file be deleted from a server via cfhttp? Joshua Tipton ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Page Refreshing
Hello, You may wish to try using this snippet of code hth Stephen !--- NO cache --- CFSET gmt = gettimezoneinfo() CFSET gmt = gmt.utcHourOffset CFIF gmt EQ 0 CFSET gmt = CFELSEIF gmt GT 0 CFSET gmt = + gmt /CFIF CFHEADER NAME=Pragma VALUE=no-cache CFHEADER NAME=Cache-Control VALUE=no-cache, must-revalidate CFHEADER NAME=Last-Modified VALUE=#DateFormat(now(), 'ddd, dd mmm ')# #TimeFormat(now(), 'HH:mm:ss')# GMT#gmt# CFHEADER NAME=Expires VALUE=Mon, 26 Jul 1997 05:00:00 GMT -Original Message- From: Kate Hillier [mailto:[EMAIL PROTECTED]] Sent: 21 May 2001 16:59 To: CF-Talk Subject: Page Refreshing I need to force a refresh on a page when I return to it after doing a postcode lookup routine. I was wondering if there was a CF solution to this as I have tried JavaScript and using meta tags and they don't seem to work. Forgive me if this is an easy one for the list. TIA Kate ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Database Design Question
hey yall, I'm workin on this project where you can get answers to a certain exam (like if you're a teacher or instructor, u can use it to show to your students). All of the answers are multiple choices. Each exam has anywhere between 25 and 70 questions. I want to know the best way to store the answers. Currently I am approaching it with 2 tables. The first table has info about the exam (name, date, subject, etc) the second table contains the answers, and has the ExamID next to it (one row equals one answer). I was thinking that by doing that, I will get too many rows. like what if there are 500 exams. 25 times 500 is a lot of rows! i am concerned about the speed. Is there a way to store the answers? or is the DB good enough to handle that much stuff? i'm using SQL server 7.0, the box has 512mb and 900mhz processor (it's a dev box also). thank you! :) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Stripping wrapper quotes from all fields
cfset newvar = Trim(Replace(form.variablename, chr(35), , ALL)) -Original Message- From: Marc Garrett [mailto:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 11:55 AM To: CF-Talk Subject: Stripping wrapper quotes from all fields I have a database in which all fields are wrapped by double quotes. I'd like to write a CF template that will strip all leading and ending quotes from all fields in the table; i.e., Hardwood Tile should become Hardwood Tile Any guidance? Thanks, Marc Garrett ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Setting Dynamic Variables
Eh? Is it marked for deprecation? If so, it's news to me. (Not saying your wrong, just wondering why you think this.) I don't know whether it's marked for deprecation - for that to happen, it would have to be part of the documented, desired behavior of the language in the first place. To the best of my knowledge, it isn't - it's a trick of the language which just happens to work. On the other hand, there's a function called SetVariable, the behavior of which is documented and clear. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Cfhttp
Can a text file be deleted from a server via cfhttp? Not directly. CFHTTP only supports GET and POST requests. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Page Refreshing
Meta tags -Original Message- From: Kate Hillier [mailto:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 11:59 AM To: CF-Talk Subject: Page Refreshing I need to force a refresh on a page when I return to it after doing a postcode lookup routine. I was wondering if there was a CF solution to this as I have tried JavaScript and using meta tags and they don't seem to work. Forgive me if this is an easy one for the list. TIA Kate ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Cfhttp
Well, If you used CFHTTP to call a CFM file on a remote server that executed a script to delete a file, then yes you could... HTH, John -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 10:59 AM To: CF-Talk Subject: Cfhttp Can a text file be deleted from a server via cfhttp? Joshua Tipton ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Best way to limit access to a specific template from only the previous template?
Just as a precaution, though I'm sure many of you know this... Using CONTAIN when testing url strings is almost worthless - since a url like http://www.crackers.com/hackattempt/haha.html?fool=template1.cfm is completely valid... CFIF cgi.http_referer does not contain template1.cfm H1Unauthorized host detected! Access denied!/H1 CFABORT SHOWERROR=You are not authorized to use this function! /CFIF I also augmented the header line with an a href back to the login screen. cfif cgi.http_referer does not contain login.cfm h2Unauthorized access method detected?br a href=http://129.174.xx.xxx/ssh/index.cfm; Please login/a/h2 cfabort showerror=You have to login first! /cfif ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Missing Line Numbers
The line numbers in my copy of CFStudio 4.5.2 (under Win2K) have disappeared sometime recently. Toggling them in the control bar doesn't do anything. I figured I'd check here before I reinstall or whatever. Is this familiar to anyone? Thanks. ..jj.. - - - - - Get your free email account: [EMAIL PROTECTED] Sign up at http://www.alakazam.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Database Design Question
First 12.5k rows is not very many. I've worked on SQL Server apps with closer to 1 million rows. If you index the tables correctly and run reasonable queries, I'd be surprised if you taxed the server too much. As an alternate strategy though, you could do this with one table. Just create a field on your exam table like this... ANSWERS CHAR(25); Then store the answers in it like this... ABDCADACBDBDCADBCADBC or this... 432412341142314234143 Russell Conway HallofSports.com, Inc. 351 West 22nd Street New York, NY 10011 P (646) 638-2500 F (561) 423-2674 http://www.hallofsports.com .. . . where the legends live on -Original Message- From: Pooh Bear [mailto:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 12:15 PM To: CF-Talk Subject: Database Design Question hey yall, I'm workin on this project where you can get answers to a certain exam (like if you're a teacher or instructor, u can use it to show to your students). All of the answers are multiple choices. Each exam has anywhere between 25 and 70 questions. I want to know the best way to store the answers. Currently I am approaching it with 2 tables. The first table has info about the exam (name, date, subject, etc) the second table contains the answers, and has the ExamID next to it (one row equals one answer). I was thinking that by doing that, I will get too many rows. like what if there are 500 exams. 25 times 500 is a lot of rows! i am concerned about the speed. Is there a way to store the answers? or is the DB good enough to handle that much stuff? i'm using SQL server 7.0, the box has 512mb and 900mhz processor (it's a dev box also). thank you! :) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Database Design Question
If you want to store all of the answers (not just the correct one) for each question, I think you're actually looking at 3 tables: tblExam - ExamId(PK), ExamName, ExamDate, etc. tblQuestion - QuestionID(PK), ExamId(FK), QuestionText, etc. tblAnswer - AnswerId(PK), QuestionID(FK), AnswerText, IsCorrectFlag, etc. This will also allow you to support questions that have multiple answers. I don't think you'll run into performance issues with the setup that you described (at least not with this database - other things on the machine might affect it). SQL Server is designed to handle a lot more than a few thousand rows. HTH, Bob -Original Message- From: Pooh Bear [mailto:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 12:15 PM To: CF-Talk Subject: Database Design Question hey yall, I'm workin on this project where you can get answers to a certain exam (like if you're a teacher or instructor, u can use it to show to your students). All of the answers are multiple choices. Each exam has anywhere between 25 and 70 questions. I want to know the best way to store the answers. Currently I am approaching it with 2 tables. The first table has info about the exam (name, date, subject, etc) the second table contains the answers, and has the ExamID next to it (one row equals one answer). I was thinking that by doing that, I will get too many rows. like what if there are 500 exams. 25 times 500 is a lot of rows! i am concerned about the speed. Is there a way to store the answers? or is the DB good enough to handle that much stuff? i'm using SQL server 7.0, the box has 512mb and 900mhz processor (it's a dev box also). thank you! :) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
odbc error connecting to datasource
Greetings We are attempting to move the username/password from the cfadministrator and place it in application variables. When this is done, we are getting the following message ODBC Error Code = 08001 (Unable to connect to data source) [IBM][CLI Driver] SQL30082N Attempt to establish connection failed with security reason 0 (NOT SPECIFIED). SQLSTATE=08001 When the username and password are left in the administrator, there is no problems and everything seems to work well. Any suggestions? Thanx Bill ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Database Design Question
Your DB can probably handle that many rows as long as its properly indexed, but you should look at some database normalization techniques. A fully normalized design might have a table for... exams questions choices the correct answer should be a foreign key in questions table to the choices table. A good way to approach database design is to extract all nouns and make them entities. Then determine the relationships between the entities (one to many, many to many, or one to one). Pete Freitag ([EMAIL PROTECTED]) CFDEV.COM ColdFusion Developers Resources http://www.cfdev.com/ -Original Message- From: Pooh Bear [mailto:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 12:15 PM To: CF-Talk Subject: Database Design Question hey yall, I'm workin on this project where you can get answers to a certain exam (like if you're a teacher or instructor, u can use it to show to your students). All of the answers are multiple choices. Each exam has anywhere between 25 and 70 questions. I want to know the best way to store the answers. Currently I am approaching it with 2 tables. The first table has info about the exam (name, date, subject, etc) the second table contains the answers, and has the ExamID next to it (one row equals one answer). I was thinking that by doing that, I will get too many rows. like what if there are 500 exams. 25 times 500 is a lot of rows! i am concerned about the speed. Is there a way to store the answers? or is the DB good enough to handle that much stuff? i'm using SQL server 7.0, the box has 512mb and 900mhz processor (it's a dev box also). thank you! :) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: File Maker
Another option for working with FM is Lasso. See http://www.blueworld.com/blueworld/default.html Any CF programmer should be able to pick up Lasso pretty quickly, if needed. H. Howard Owens Internet Operations Coordinator www.insidevc.com [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Missing Line Numbers
Do you see the gray bar on the left? If not, that means that you have the gutter toggled off. Press the button above the line number toggle to turn the gutter back on. Craig -Original Message- From: Jay Jennings [SMTP:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 12:35 PM To: CF-Talk Subject: Missing Line Numbers The line numbers in my copy of CFStudio 4.5.2 (under Win2K) have disappeared sometime recently. Toggling them in the control bar doesn't do anything. I figured I'd check here before I reinstall or whatever. Is this familiar to anyone? Thanks. ..jj.. - - - - - Get your free email account: [EMAIL PROTECTED] Sign up at http://www.alakazam.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFLOCK with CF 5.0
is it important to use CFLOCK in CF 5.0 ? Hamid Hossain ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFLOCK with CF 5.0
is it important to use CFLOCK in CF 5.0 ? Hamid Hossain ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFLOCK with CF 5.0
is it important to use CFLOCK in CF 5.0 ? Hamid Hossain ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFLOCK with CF 5.0
is it important to use CFLOCK in CF 5.0 ? Hamid Hossain ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Bizarre Error: Server/Studio Duplicating Carriage Returns
I'm running the eval of Cold Fusion Server 4.5 Enterprise on Redhat 7.1. When I save a template through RDS, for every carriage return I enter as I code, I get two carriage returns on the saved document. Example: I write: html head titleHello/title /head When I re-open the file it looks like this: html head titleHello/title /head What's worse, If I make a little change, like, change the Hello to Hello, World and re-save the template, the next time I open it, it looks like this: html head titlehello, world/title /head Big problem. I've got a template with only about 20 lines of actual code on it, but it's up to about 14000 lines, due to this problem. I have studio on two different machines, and it doesn't seem to matter which I use. Also, this is not happening from the same two workstations if I write to an NT machine through RDS, or through windows networking. Any ideas? Willy ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Missing Line Numbers
Haven't seen that one yet, but have you seen the one where your folder explorer to the left displays each file two times? That happens from time to time for me... ~ Kevin Mansel Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 -Original Message- From: Jay Jennings [mailto:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 9:35 AM To: CF-Talk Subject: Missing Line Numbers The line numbers in my copy of CFStudio 4.5.2 (under Win2K) have disappeared sometime recently. Toggling them in the control bar doesn't do anything. I figured I'd check here before I reinstall or whatever. Is this familiar to anyone? Thanks. ..jj.. - - - - - Get your free email account: [EMAIL PROTECTED] Sign up at http://www.alakazam.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
fearing the failing scheduler
hi all, we have a scheduler which is configured to run every 60 mins. it was working fine until one fine day it decided to run every minute! we had to reboot the server to fix it. but even now, after looking thru all the forums and web sites i am not able to get hold of any good info regarding the misbehaviour of scheduler. can any one point out some links or give any info something like 10 things to do (not to do) with schedulers kinda stuff?? its scary to sit here and wonder when is it gonna strike again? i myself dont have much data to tell u why it occured. but in the log files i see something like TID= 1000 and 732 and 1004 and 1056 and 1044 and 2600 and 2616 and 2484 and so on. what does TID mean? the error code corresponding to SQL server? or cold fusion? i am running, win2k server with SQL 2000 as backend. any ideas. thanx in advance. ::akbar ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFLOCK with CF 5.0
is it important to use CFLOCK in CF 5.0 ? As far as I can tell, there haven't been any changes to how memory variables are handled in CF 5. So, the answer would be yes. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Create-edit-delete in Access - TAG
Does anyone know have a good tag that gives control to create, edit and delete rows and fields using an access database. Steph ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Missing Line Numbers
Do you see the gray bar on the left? If not, that means that you have the gutter toggled off. Press the button above the line number toggle to turn the gutter back on. Wow, I feel like a newbie. Really, I'm not! =:) I guess I forgot the gutter was seperate from the vertical control bar. Thanks! ..jj.. - - - - - Get your free email account: [EMAIL PROTECTED] Sign up at http://www.alakazam.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFLOCK with CF 5.0
AFAIK the same locking principle apply to cf5 as 4 so you must lock all application/session/server scoped variables HTH Mike -Original Message- From: Hamid Hossain [mailto:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 18:14 To: CF-Talk Subject: CFLOCK with CF 5.0 is it important to use CFLOCK in CF 5.0 ? Hamid Hossain ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Database Design Question
Oh, you see, this project does not display the choices for the question, nor does it displays the question. And there's only 1 answer for each question. so I think 2 tables is the best way to handle it. but I might consider putting the answers in one row for each exam like ABBCCCBBDDEEBDD, then just use some string functions on them! From: Pete Freitag [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: Database Design Question Date: Mon, 21 May 2001 13:10:13 -0400 Your DB can probably handle that many rows as long as its properly indexed, but you should look at some database normalization techniques. A fully normalized design might have a table for... exams questions choices the correct answer should be a foreign key in questions table to the choices table. A good way to approach database design is to extract all nouns and make them entities. Then determine the relationships between the entities (one to many, many to many, or one to one). Pete Freitag ([EMAIL PROTECTED]) CFDEV.COM ColdFusion Developers Resources http://www.cfdev.com/ -Original Message- From: Pooh Bear [mailto:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 12:15 PM To: CF-Talk Subject: Database Design Question hey yall, I'm workin on this project where you can get answers to a certain exam (like if you're a teacher or instructor, u can use it to show to your students). All of the answers are multiple choices. Each exam has anywhere between 25 and 70 questions. I want to know the best way to store the answers. Currently I am approaching it with 2 tables. The first table has info about the exam (name, date, subject, etc) the second table contains the answers, and has the ExamID next to it (one row equals one answer). I was thinking that by doing that, I will get too many rows. like what if there are 500 exams. 25 times 500 is a lot of rows! i am concerned about the speed. Is there a way to store the answers? or is the DB good enough to handle that much stuff? i'm using SQL server 7.0, the box has 512mb and 900mhz processor (it's a dev box also). thank you! :) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
quotes in text
When quotes are entered into a varchar column, the data gets stored properly. However, upon *re-displaying* the data is truncated at the quotes. Can some share the technique, please? Thanks, Bobby ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Bizarre Error: Server/Studio Duplicating Carriage Returns
There is an option in studio's settings under tools (F8) that will allow you to choose your file settings so that a saved document uses the OS type of document structure. Bryan LaPlante 816-347-8220 [EMAIL PROTECTED] http://www.netwebapps.com Web Development - Original Message - From: Willy Ray [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 21, 2001 12:17 PM Subject: Bizarre Error: Server/Studio Duplicating Carriage Returns I'm running the eval of Cold Fusion Server 4.5 Enterprise on Redhat 7.1. When I save a template through RDS, for every carriage return I enter as I code, I get two carriage returns on the saved document. Example: I write: html head titleHello/title /head When I re-open the file it looks like this: html head titleHello/title /head What's worse, If I make a little change, like, change the Hello to Hello, World and re-save the template, the next time I open it, it looks like this: html head titlehello, world/title /head Big problem. I've got a template with only about 20 lines of actual code on it, but it's up to about 14000 lines, due to this problem. I have studio on two different machines, and it doesn't seem to matter which I use. Also, this is not happening from the same two workstations if I write to an NT machine through RDS, or through windows networking. Any ideas? Willy ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Bizarre Error: Server/Studio Duplicating Carriage Returns
Willy Ray wrote: I'm running the eval of Cold Fusion Server 4.5 Enterprise on Redhat 7.1. When I save a template through RDS, for every carriage return I enter as I code, I get two carriage returns on the saved document. Example: Big problem. I've got a template with only about 20 lines of actual code on it, but it's up to about 14000 lines, due to this problem. I have studio on two different machines, and it doesn't seem to matter which I use. Also, this is not happening from the same two workstations if I write to an NT machine through RDS, or through windows networking. Any ideas? Check the Editor's file settings and see if its using PC line breaks. Perhaps the Linux machine is interpreting the CRLF setting on the PC as two carriage returns? -- Among modern occupations, only cult leaders and TV weathermen rival the technological visionary's ability to retain credibility despite all evidence to the contrary. Nathan Myhrvold email: [EMAIL PROTECTED] web: http://www.pixelgeek.com/ ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Bizarre Error: Server/Studio Duplicating Carriage Returns
Are you saving to a UNIX box? If so go to the Options menu in Studio, click on Settings then go to File Setting and there is an option under Format when saving you can select UNIX to keep this from happening. Thanks, Nathan Nelson ColdFusion Developer ..::[CFDynamics]::. www.cfdynamics.com [EMAIL PROTECTED] (801)621-8511 * * You've got to check this out! * * CFDCalendar http://demo.cfdynamics.com/cfdcalendar/ Online Personal Assistant -Original Message- From: Willy Ray [mailto:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 11:18 AM To: CF-Talk Subject: Bizarre Error: Server/Studio Duplicating Carriage Returns I'm running the eval of Cold Fusion Server 4.5 Enterprise on Redhat 7.1. When I save a template through RDS, for every carriage return I enter as I code, I get two carriage returns on the saved document. Example: I write: html head titleHello/title /head When I re-open the file it looks like this: html head titleHello/title /head What's worse, If I make a little change, like, change the Hello to Hello, World and re-save the template, the next time I open it, it looks like this: html head titlehello, world/title /head Big problem. I've got a template with only about 20 lines of actual code on it, but it's up to about 14000 lines, due to this problem. I have studio on two different machines, and it doesn't seem to matter which I use. Also, this is not happening from the same two workstations if I write to an NT machine through RDS, or through windows networking. Any ideas? Willy ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: fearing the failing scheduler
Akbar, Which version are you running? The scheduler uses cfhttp and there were a number of fixes to cfhttp in service pack 2 of 4.5.1. If you are not running it now, you may want to consider installing this. Tim P. - Original Message - From: Akbar Pasha [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 21, 2001 1:35 PM Subject: fearing the failing scheduler hi all, we have a scheduler which is configured to run every 60 mins. it was working fine until one fine day it decided to run every minute! we had to reboot the server to fix it. but even now, after looking thru all the forums and web sites i am not able to get hold of any good info regarding the misbehaviour of scheduler. can any one point out some links or give any info something like 10 things to do (not to do) with schedulers kinda stuff?? its scary to sit here and wonder when is it gonna strike again? i myself dont have much data to tell u why it occured. but in the log files i see something like TID= 1000 and 732 and 1004 and 1056 and 1044 and 2600 and 2616 and 2484 and so on. what does TID mean? the error code corresponding to SQL server? or cold fusion? i am running, win2k server with SQL 2000 as backend. any ideas. thanx in advance. ::akbar ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: fearing the failing scheduler
Akbar Pasha wrote: i am running, win2k server with SQL 2000 as backend. any ideas. thanx in advance. Have you considered using something like Cron to schedule the tasks instead? I use it on a remote machine to trigger CF pages. I haven't used it to do a page every single minute but it might be a way to avoid scheduler errors -- If you believe the doctors, nothing is wholesome; if you believe the theologians, nothing is innocent; if you believe the military, nothing is safe. Lord Salisbury email: [EMAIL PROTECTED] web: http://www.pixelgeek.com/ ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Create-edit-delete in Access - TAG
Not to sound like a smart-aleck, but that's what cfquery is for. You can run any sql statment there. Tim P. - Original Message - From: CF Crazy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 21, 2001 1:54 PM Subject: Create-edit-delete in Access - TAG Does anyone know have a good tag that gives control to create, edit and delete rows and fields using an access database. Steph ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Missing Line Numbers
Kevin, By chance, did you run the beta of service pack 2 of studio? I would see that all the time in the beta, but it cleared itself up when they released the final. If you don't have the final release of svc pack 2 installed, try that. HTH, Tim P. - Original Message - From: Kevin Mansel [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 21, 2001 1:15 PM Subject: RE: Missing Line Numbers Haven't seen that one yet, but have you seen the one where your folder explorer to the left displays each file two times? That happens from time to time for me... ~ Kevin Mansel Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 -Original Message- From: Jay Jennings [mailto:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 9:35 AM To: CF-Talk Subject: Missing Line Numbers The line numbers in my copy of CFStudio 4.5.2 (under Win2K) have disappeared sometime recently. Toggling them in the control bar doesn't do anything. I figured I'd check here before I reinstall or whatever. Is this familiar to anyone? Thanks. ..jj.. - - - - - Get your free email account: [EMAIL PROTECTED] Sign up at http://www.alakazam.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Create-edit-delete in Access - TAG
try this http://devex.allaire.com/developer/gallery/info.cfm?ID=44C495D9-35E9-11D 4-83D700508B94F85Amethod=Full the custom tag name is CF_ListTable ::akbar -Original Message- From: CF Crazy [mailto:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 1:54 PM To: CF-Talk Subject: Create-edit-delete in Access - TAG Does anyone know have a good tag that gives control to create, edit and delete rows and fields using an access database. Steph ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Create-edit-delete in Access - TAG
You mean other than CFQUERY ? :-) Sorry just had to ask. J. John Wilker Web Applications Consultant Macromedia Certified ColdFusion Developer www.red-omega.com http://www.red-omega.com Losing - If at first you don't succeed, failure may be your style. ~despair.com -Original Message- From: CF Crazy [mailto:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 10:54 AM To: CF-Talk Subject: Create-edit-delete in Access - TAG Does anyone know have a good tag that gives control to create, edit and delete rows and fields using an access database. Steph ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFLOCK with CF 5.0
So it sounds like CF 5 promises to be just as unstable when used in an environment with inexperienced developers. Most notably, shared hosting setups. Jim AFAIK the same locking principle apply to cf5 as 4 so you must lock all application/session/server scoped variables HTH Mike -Original Message- From: Hamid Hossain [mailto:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 18:14 To: CF-Talk Subject: CFLOCK with CF 5.0 is it important to use CFLOCK in CF 5.0 ? Hamid Hossain ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: quotes in text
One method would be to replace the quotes when they are inserted with the corresponding ASCII char. J. John Wilker Web Applications Consultant Macromedia Certified ColdFusion Developer www.red-omega.com http://www.red-omega.com Losing - If at first you don't succeed, failure may be your style. ~despair.com -Original Message- From: Bobby Olsen [mailto:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 10:19 AM To: CF-Talk Subject: quotes in text When quotes are entered into a varchar column, the data gets stored properly. However, upon *re-displaying* the data is truncated at the quotes. Can some share the technique, please? Thanks, Bobby ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: quotes in text
Try using the HTMLEditFormat function on your string. Bob -Original Message- From: Bobby Olsen [mailto:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 1:19 PM To: CF-Talk Subject: quotes in text When quotes are entered into a varchar column, the data gets stored properly. However, upon *re-displaying* the data is truncated at the quotes. Can some share the technique, please? Thanks, Bobby ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Bizarre Error: Server/Studio Duplicating Carriage Returns
In ColdFusion Studio, under Options\Settings\File Settings tab there is a Format when saving selection. Select Unix format. Marius Milosav www.scorpiosoft.com It's not about technology, it's about people. Virtual Help Desk Demo (VHD) www.scorpiosoft.com/vhd/login.cfm - Original Message - From: Willy Ray [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 21, 2001 1:17 PM Subject: Bizarre Error: Server/Studio Duplicating Carriage Returns I'm running the eval of Cold Fusion Server 4.5 Enterprise on Redhat 7.1. When I save a template through RDS, for every carriage return I enter as I code, I get two carriage returns on the saved document. Example: I write: html head titleHello/title /head When I re-open the file it looks like this: html head titleHello/title /head What's worse, If I make a little change, like, change the Hello to Hello, World and re-save the template, the next time I open it, it looks like this: html head titlehello, world/title /head Big problem. I've got a template with only about 20 lines of actual code on it, but it's up to about 14000 lines, due to this problem. I have studio on two different machines, and it doesn't seem to matter which I use. Also, this is not happening from the same two workstations if I write to an NT machine through RDS, or through windows networking. Any ideas? Willy ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Beta version of Cold Fusion for Linux
Last night I listened to the WebMonkey Radio interview of the MySQL developers at: http://hotwired.lycos.com/webmonkey/radio/monty_widenius.html If I heard them correctly, they said the Linux version of Cold Fusion has ODBC access to MySQL Server built in -- guess that means included in the ODBC pick list in the Administrator... Can anyone verify this? Also, do we know when it is expected to be released? ^ / \__ (@\___ / O /(_/ /_/ Whoof... 410-757-3487 -Original Message- From: Zac [SMTP:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 2:28 PM To: CF-Talk Subject:Re: Bizarre Error: Server/Studio Duplicating Carriage Returns Willy Ray wrote: I'm running the eval of Cold Fusion Server 4.5 Enterprise on Redhat 7.1. When I save a template through RDS, for every carriage return I enter as I code, I get two carriage returns on the saved document. Example: Big problem. I've got a template with only about 20 lines of actual code on it, but it's up to about 14000 lines, due to this problem. I have studio on two different machines, and it doesn't seem to matter which I use. Also, this is not happening from the same two workstations if I write to an NT machine through RDS, or through windows networking. Any ideas? Check the Editor's file settings and see if its using PC line breaks. Perhaps the Linux machine is interpreting the CRLF setting on the PC as two carriage returns? -- Among modern occupations, only cult leaders and TV weathermen rival the technological visionary's ability to retain credibility despite all evidence to the contrary. Nathan Myhrvold email: [EMAIL PROTECTED] web: http://www.pixelgeek.com/ ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: the big export...ColdFusion.NET?
Yuck. I would certianly hope that Macromedia doesn't consider using C# over Java. One of the most exciting prospects of CF6 is it's ability to run on any platform. I am willing to bet that the Common Language Runtime will _not_ run on any platform. It seems that Microsoft is taking another stab at killing Java, except this time on the server side. They released JDirect a few years ago, which was basically MFC for Java. What a mess. The company I was working for at the time wanted to look into JDirect and see if it was a worthwhile platform. IMO, it was completely worthless...An application written in JDirect wasn't any more portable than one written using MFC! I do love Microsoft products (I also have very little sympathy for Netscape), but I would hate to see Macromedia handcuff themselves. -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 20, 2001 11:58 PM To: CF-Talk Subject: Re: the big export...ColdFusion.NET? C# is really more along the lines of Java than C, actually a lot closer. If you look at the syntax, it's almost exactly java with a few MS specific things thrown in, that look to make the language a little more approachable. Not to mention it runs on what Microsoft calls a Common Language Runtime. Which is basically just like java's JRE. This is the essence of dotNet. All five of Microsofts major languages( C#, C++, JScript, VB, ASP) will be able to take advantage of it. All of them have seperate compilers except asp of course, but still run on top of the runtime. There are already existing programs that convert C# programs into Java and back again...What makes this really interesting to me is that if Macromedia extends CF to C#, the possibilities for easy access to the dotNet runtime with CF would be very powerful. Actually now that I think about it, as the MS world migrate to XP, dotNet and beyond, it almost seems to be a necessity... MS seems to be trying the same strategy against Sun, that they so successfully used against Netscape. I dont know where I stand, but I'll develop in Java for now. I do know one thing though. Microsoft knows how to write documentation better than anyone around. Their sdk docs blow away the ancient looking docs that come with Sun's JDK. jon - Original Message - From: John McKown [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, May 20, 2001 8:12 PM Subject: RE: the big export...ColdFusion.NET? Pronounced C Sharp, I think it is the successor to C++. John McKown, Owner Delaware.Net, Inc. 30 Old Rudnick Lane, Suite 200 Dover, DE 19901 phone: 302-736-5515 toll free: 888-432-7965 fax: 302-736-5945 e-mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] icq: 1812513 -Original Message- From: Paul Mone [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 7:01 PM To: CF-Talk Subject: RE: the big export...ColdFusion.NET? What is C#? -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 7:36 AM To: CF-Talk Subject: Re: the big export...ColdFusion.NET? Michael, before you go and learn VB, realize that vb is morphing into vb.net. Although the syntax is similar, the changes/improvements are quite drastic. You may want to skip picking up a book on the old VB and concentrate on learning the new stuff. Microsofts site is a great place to start though. bigfatsegue The whole dotNet thing is very interesting... Microsofts try at interpreted code, like java. Which leads me to think back to Macromedia's repeatedly saying dotNet in the press release that they were commited to dotNet. It isn't too far of a stretch to say that Neo may be ported to dotNet, and specifically C#, which is basically java anyway. The more I think about it, the more I think it's a no brainer for Macromedia to do a C# port. It will probably run much faster on Windows. The only risk would be confusing the users as to which is better. That's my random Friday thought. Anyone have any comments? /bigfatsegue jon - Original Message - From: Michael Lugassy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 18, 2001 10:57 AM Subject: Re: the big export thanks for the tip, paul! I keep seeing this learn VB tips and I was wondering - are there any good and quick resources on learning VB on the net? something you know about?? Michael. - Original Message - From: Paul Mone [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 18, 2001 12:49 AM Subject: RE: the big export This is definately something I would consider off-line processing. In most cases, CF is not suitable for these types of tasks, espcially if it's a task that you'll have to repeat on scheduled basis. If this is a one-time event (are you sure? :) ) then you can way the time for development vs. time of processing. one time operation? Developing it in CF is probably
Re: Create-edit-delete in Access - TAG
cf_sarcasm Correct me if I'm wrong about this but isn't CFQuery a good tag for this? /cf_sarcasm This is really basic stuff. regards, larry -- Larry C. Lyons ColdFusion/Web Developer EBStor.com 8870 Rixlew Lane, Suite 201 Manassas, Virginia 20109-3795 tel: (703) 393-7930 x253 fax: (703) 393-2659 http://www.ebstor.com http://www.pacel.com email: [EMAIL PROTECTED] Chaos, panic, and disorder - my work here is done. -- CF Crazy wrote: Does anyone know have a good tag that gives control to create, edit and delete rows and fields using an access database. Steph ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists