Message from nickr1977 Most recent post: 10/28/2007 4 authors and 7 replies. Has anyone ever written a CFML script to create a vCard from data returned from a database. For instance, we've our company intranet which runs on Cold Fusion which was designed by me. You can do a customer lookup by lastname, and it shows the customer data in a nicely layed out CFM page. Is there a way to auto-generate a vcard file from the returned data and make it a downloadable vcard with link? I am a novice when it comes to CFML so cannot figure it out on my own. Thanks for the help. Nick read more about Create vCard CFML?
Message from swap_18 Most recent post: 10/28/2007 3 authors and 3 replies. I am using ColdFusion 8 to develop forms. I need to check if user has entered a value of type "text". If not then a message has to Cfoutput. I am using the following code: <CFIF not isdefined("form.question")> <CFOUTPUT> Enter question </CFOUTPUT> </CFIF> The problem is even f nothing is entered in the Question Field, the message Enter question isn't being displayed. Its as is the <CFIF not isdefined("form.question")> isn't at all being recognised. I also tried <CFIF not isdefined("form.question_now")> Please help. read more about
Message from Flashcqxg Most recent post: 10/28/2007 4 authors and 11 replies. I have a list like: John#xyz#byby <CFOUTPUT>#ListGetAt("John#xyz#byby",2,"#")#</CFOUTPUT> This is error,how to get the list element??? Thanks a lot. read more about How to get the list element when # is the delimiters??
Message from ryansebiz Most recent post: 10/27/2007 4 authors and 6 replies. Is there a way in ColdFusion to capitalize the first letter of a word? read more about Capitalize the first letter?
Message from SonOfNels Most recent post: 10/27/2007 2 authors and 8 replies. The problem I have is I am using a somewhat normalized database and I am trying to enter multiple records from a form into a table called catfit. It also needs to add information to another table called prodmat and pull the id of the record I just added to the prodmat table and insert it into the catfit table in one shot. Promat - Holds all of the products columns in this table prodid mold desc features pic Catfit - Table that links Prodmat and Modcats columns in this table prodid catid modlid Now the form I have <form method="post" action="action.cfm"> <select name="modlid"> <option value ="#modlid#" selected="selected">#modlid#</option> <option value="1">Sewing Machines</option> <option value="9">Vacuums</option> <option value="12">Air Purifiers</option> </select> <select name="catid"> <option value ="#catid#" selected="selected">#catid#</option> <option value="None">None</option> <option value="1">Sewing Machines-Embroidery</option> <option value="2">Sewing Machines-Computerized</option> <option value="3">Sewing Machines-Professional</option> <option value="4">Sewing Machines-Quilting</option> [co read more about Insert Multiple Records and newest record id
Message from samie Most recent post: 10/26/2007 4 authors and 4 replies. Installed CF8 on my test server. I am try to populate a CFGRID with the following code: <CFFORM> <CFGRID format="html" name="grid01" pagesize=5 sort=true bind="cfc:places.getData({cfgridpage},{cfgridpagesize}, {cfgridsortcolumn},{cfgridsortdirection})" selectMode="row"> <CFGRIDCOLUMN name="customernumber" display=true header="Employee ID"/> <CFGRIDCOLUMN name="FirstName" display=true header="Name"/> <CFGRIDCOLUMN name="Email" display=true header="Email"/> </CFGRID> </CFFORM> Here is the CFC file places.cfc: <CFCOMPONENT> <CFFUNCTION name="getData" access="remote" output="false"> <CFARGUMENT name="page"> <CFARGUMENT name="pageSize"> <CFARGUMENT name="gridsortcolumn"> <CFARGUMENT name="gridstartdirection"> <CFQUERY name="list" datasource="xxxx"> SELECT customernumber, FirstName, EMail FROM customers </CFQUERY> <CFRETURN QueryConvertForGrid(list, page, pageSize)> </CFFUNCTION> </CFCOMPONENT> I get this message: 'exception thrown and not caught'. I look at the js debugger and this line is highligthed 'throw new SyntaxError("parseJSON");.' Any ideas? Thanks. Robert read more about CF8 CFGRID BIND ERROR
Message from gbrownuk Most recent post: 10/26/2007 2 authors and 3 replies. Can anyone advise how to automate the starting of a CFM programme. The intention is that the programme I have written with tidy up a database and collect CFPOP mail for nightly processing. I do not know where to start to look for help with this problem. Some help'd be much appreciated. Graham (UK) read more about Automate Calling a ColdFusion Scipt Help?
Message from wolfv Most recent post: 10/26/2007 2 authors and 3 replies. The attached code only prints the first record of q_1. Seems that the q_1 record counter is rest on every loop of q_2. Is there a way to turn off the reset? Thank you. <CFLOOP> query="q_1"> <CFLOOP> query="q_2"> ID1=<CFOUTPUT>#q_1.id#<CFOUTPUT>: <!--- only prints the first record of q_1 ---> ID2=<CFOUTPUT>#q_2.id#<CFOUTPUT>, </CFLOOP> <br /> </CFLOOP> read more about output in nested cfloop
Message from C-Rock Most recent post: 10/26/2007 4 authors and 8 replies. I'm very inexperienced with Cold Fusion so I apologize if this is simple. I'm using flash remoting to call a function which searches through a mysql database through a column called name and description for a "keyword". The script I have written works great except I get duplicate results of an id if the name and description column both contain the keyword. Here's my code, how do I fix this so only one id is returned if both columns have the keyword. Thanks, <!--Search --> <CFFUNCTION name="startSearch" access="remote" returnType="query"> <CFARGUMENT name="keywords" type="string" required="yes"> <CFQUERY name="startSearchQuery" datasource="housesmarts" username="housesmarts" password="Fa9293ff"> SELECT id, name, description, imageLink, videoSize FROM segments WHERE description LIKE '%#ARGUMENTS.keywords#%' OR name LIKE '%#ARGUMENTS.keywords#%' </CFQUERY> <CFRETURN startSearchQuery > </CFFUNCTION> read more about No duplicate result from DB...
Message from jkgiven Most recent post: 10/26/2007 3 authors and 4 replies. prior to calling the cfinvoke, I have coding that determins a variable "X" I need to pass X into a CFC so it can complete the query held there. So I tried <CFINVOKE component="name" method="comp_extList" searchBox="" returnvariable="phoneList"> <CFINVOKEARGUMENT name="abbrCode" value="#companyAbbrCode#" /> </CFINVOKE> read more about How to pass a variable into a cfc?
Message from WraithBudde Most recent post: 10/26/2007 2 authors and 2 replies. cftooltip doesn't work properly if placed inside of an 'embedded and repeating custom tag'. I have a 2 custom tags that are essentially a form builder. Outer tag creates the Form, inner tags create the rows with labels and fields. I wanted to add a CFTOOLTIP option per row so that it'd provide user help text. What I noticed is if I have any more than 1 row, all the CFTOOLTIPS have the same ID once they are outputted. If you need the custom tags I use, I am glad to provide it with an example. I posted this to the support site as well. Hope this gets addressed in one of the future hot fixes or patches. I am pulling this feature out of my custom tag since it breaks. read more about CF8 CFTOOLTIP bug
Message from kodemonki Most recent post: 10/26/2007 4 authors and 4 replies. I have a page with NO comments that output unicode in xml and sometimes it works, sometimes it says: Incorrect syntax was used in a comment. Error processing resource 'http://www.netspeaknow.com/gamers/flashCFM/getPopQuiz.cf... <!-- " ---></TD></TD></TD></TH></TH></TH></TR></TR></TR></TA... but there are no comments. Even if there were why'd this page only work about half the time? I have attached the code. Thanks for any help! <CFSETTING showdebugoutput="false"> <CFCONTENT type="text/xml; charset=utf-8" reset="true"><CFPROCESSINGDIRECTIVE pageencoding="utf-8" suppresswhitespace="Yes"> <CFSCRIPT> function ListRandomElements(theList, numElements) { var theDelim = ","; var final_list = ""; var x = 0; var random_i = 0; var random_val = 0; if(ArrayLen(Arguments) GTE 3) theDelim = Arguments[3]; if(numElements GT ListLen(theList, theDelim)) { numElements = ListLen(theList, theDelim); } for(x=1; x LTE numElements; x=x+1){ random_i = RandRange(1, ListLen(theList),"SHA1PRNG"); random_val = ListGetAt(theList, random_i); theList = ListDeleteAt(theList, random_i); final_list = ListAppend(final_list, random_val , theDelim); } return(final_list); read more about XML Syntax Error
Message from tclaremont Most recent post: 10/26/2007 3 authors and 8 replies. I need to start collecting information such as RAM, Operating System, etc on the computers in my organization. What I'd like to do is send an email to all users, asking them to merely click a button in my email. That button'd run a ColdFusion page that collects as much information as possible and logs the info into a database. We use IIS and authenticate against the domain, so I know this will work through ColdFusion for such information as login name, IP address (we use static IPs), operating system, etc, so I am looking for solutions that will tell me more. Can I get the RAM? Resolution (not that it has much value). How about (dare I ask) programs installed? Any suggestions appreciated. read more about Script to Collect Computer Info
Message from pnugent Most recent post: 10/26/2007 6 authors and 9 replies. I need to write an application that will allow the user to select all the contents of a directory on their local harddrive (or just point to the directory) and upload all the files in that directory to a location on a the web server. The user shouldn't have to point to a file, just select all the contents at once. Does anyone know how to to so this using CFFILE? We are using Cold Fusion 8. Thanks in Advance!! read more about Upload Entire Directory Using CFFILE
Message from cfdoogan Most recent post: 10/26/2007 3 authors and 4 replies. I am setting up our dev. server to emulate our production file system. To do so I need to change the server root to C:/websites/xxxxx/. How is this done using the built in webserver in CF7? I only know how to change the root relative to the wwwroot folder. read more about change server root to outside directory
Message from Henry K Most recent post: 10/26/2007 2 authors and 3 replies. I have a strange error that has occurred within the last month or so, but I have just encountered it today. CFFILE no longer recognizes the correct mime type of files. I'm running CFMX 7,0,1,116466 on Windows XP, Sun JM 1.4.2_05-b04 Code that worked a month ago, if not later (like a week ago) is now returning: The MIME type of the uploaded file "text/html" wasn't accepted by the server. Only files of type "application/pdf" can be uploaded. Verify that you are uploading a file of the appropriate type. Am I missing something here? I do not think so, because code that used to work is no longer working. I have attached some test code that will also result in error. test file 1, fileUploadTest.cfm: <form method="post" action="actFileUploadTest.cfm" name="uploadForm" enctype="multipart/form-data"> <input name="pdfFileToUpload" type="file"> <br> <input name="submit" type="submit" value="Upload File"> </form> post action file: <CFOUTPUT> <CFSET destinationDir = "/path/to/an/upload/directory" > <CFSET mimeAcceptList = "application/pdf"> <CFFILE action = "upload" fileField = "pdfFileToUpload" destination = "#destinationDir#" accept = "#mimeAcceptList#" nameConflict = "MakeUnique"> </CFOUTPUT> read more about CFFILE action=upload seeing application/pdf file as typetext/html
Message from Fordian-Slip Most recent post: 10/26/2007 5 authors and 5 replies. Hi folks - I was wondering has anybody been successful in implementing CFDOCUMENT with PDF and a web page using CSS 1 or CSS 2? When I display my web page in my browser (IE 6), it renders completely perfect. When I pushed it through CFDOCUMENT, it gets messed up when it is rendered. I am open to ideas, suggestions, and other creative solutions. I have already tried CFHTTP, and it won't work because of the tight environment we've in the office. I can post my code if requested. Thanks, Doug read more about CFDOCUMENT, PDF, and CSS
Message from ChennaiBhai Most recent post: 10/26/2007 3 authors and 3 replies. Hi, I am preparing for Cold Fusion MX7 Developer Certification. I'd like to know the procedure to appear for the certification in India. Do any of you've preparatory material on the above certification. How is Centrasoft's CFMX Exam Buster? Please help, Thanks, Cherry. read more about Cold Fusion MX7 Developer Certification
Message from capik79 Most recent post: 10/26/2007 2 authors and 3 replies. Hi All, I an issue regarding CFHTTP tag. My Code :- <CFHTTP url="#url_file#" method="GET" name="sapImport" throwonerror="yes" columns="project,project_name,vendor,vendor_name,po,sap_doc,vendor_doc,wbs,wbs_n ame,amount,d_c,period,year,posting_date,clearing_date" > </CFHTTP> I have no problem run this code at my server, but when I post it to another server with same ColdFusion Server Version(6.1) it return an error. But it only happened when I upload .csv file. No problem with .txt file. The error :"The value of the attribute query, which is currently "sapImport", is invalid." Any one face the same issue? Any setting to check for the other server? Almost no idea to solve... Shaffiq read more about CFHTTP problem
Message from Adomacro Most recent post: 10/26/2007 3 authors and 3 replies. Is it possible to wrap listbox content?. I got a really long value need to display in a listbox.....is it possible?. all other values are short...so I can't use any other method to display...just want wrag the content. read more about warp listbox content
Message from julio5 Most recent post: 10/26/2007 2 authors and 9 replies. CF7.0.2 update level hf702-65114.jar (Standalone server on Windows 2003) Type: SearchEngine Message: There was a problem executing the CFSEARCH tag with the following collections. Detail: Collection (status code): MyCollectionName (-1706) Since re-creating a set of about 12 collections in a different folder (same drive), I have been getting the above error the first time CFSEARCH is invoked following an update of *any* collection (not necessarily the one mentioned in the error. Re-indexing or re-creating the named collection does *not* fix the problem: CFSEARCH will continue to fail - so it's not corruption. Re-starting the ColdFusion Search Service however does fix it... until the next time one or more collections are updated. I am now auto-restarting the ColdFusion Search Service using CFEXECUTE after each update but this isn't ideal, and in fact just now it seems to have had no effect: the tag has errored again apparently in spite of the restart after the update. I have searched for Verity status code 1706 but can find nothing. Can anyone shed any light? read more about CFSEARCH error: status code -1706
Message from jeffromace Most recent post: 10/26/2007 3 authors and 3 replies. <CFIF len(ListFirst(CGI.SERVER_NAME, "."))> <CFSET UserName = ListFirst(CGI.SERVER_NAME, ".") /> <CFLOCATION url="http://mysite.com/index.cfm?method=profile&member=#UserName#" addtoken="no"> <CFABORT /> </CFIF> What I want it to do is see if a subdomain exists which'd be the username of a visitor. So for example if a domain is entered like this. http://superman.mysite.com It'd then become: http://mysite.com/index.cfm?method=profile&member=superman Usernames'd be no more than 12 characters. I have added a wildcard to my [def]DNS[/def] (Domain Name Service) and it still does not seem to be working.. Is there a better way of doing this? read more about Help find if subdomain exists, then redirect
Message from ironyx Most recent post: 10/26/2007 3 authors and 3 replies. Okay, I am running JFreechart (JAVA classes being called by Cold Fusion pages to render a chart). I am coming across the following error and was wondering if someone could give me a general idea of what I might be looking for (besides my brain). "Error","ExecuteThread: '22' for queue: 'weblogic.kernel.Default' ", date, time, applicatio name", "Object Instantiation Exception. An exception occured when instantiating a JAVA object. The cause of this exception was that: org/jfree/util/PublicCloneable. The specific sequence of files included or processed is: .... etc at Cold Fusion.runtime.CFPage.CreateObject(CFPage.JAVA:5129) Please excuse typos, I can not cut and paste the error... but I googled it and did not find much, now I am honestly not sure what I am looking for, so I might have typed the wrong combo of words to search. I appreciate any suggestions to point me in the right direction! Thanks as always! Va read more about help with JAVA error
Message from FunTommy Most recent post: 10/26/2007 7 authors and 20 replies. I am having a session issue with a handful of users, and I am pretty sure it is [b]not cookie related[/b]. They can login to my site with no problem (which sets a session variable to indicate they are logged in). However, as soon as they try to go anywhere in the site, their session seems to have expired, and they are taken back to the login page. They all have their browsers set to accept cookies. I even had one helpful user installed FireFox (most current version), and she still has the same problem. I also create 3 test pages to try and see what is going on. [u]1st test page[/u] Creates a cookie and a session variable using the following: <CFCOOKIE name="test" value="1"> <CFSET session.test = true> then, on the same page, it does an IsDefined for the fresh cookie and session variable. [b]Result on user's browser: both are defined.[/b] [u]2nd test page (which she links to from the first test page):[/u] simply does an IsDefined on the test cookie and test session (created on the first page). [b]Result on user's browser: cookie IS defined, session ISn't[/b] [u]3rd test page:[/u] simply expires the cookie and clears the session variables (<CFSET StructClear(Session)>) in case we want to retest. So, I do not think this is a cookie issue. She has even added my site (in IE7) to her "Trusted" sites list. Thoughts? BTW, I am running MX6.1, with plans to update to MX7 in the read more about session immediately timing out for some users
Message from trojnfn Most recent post: 10/25/2007 4 authors and 9 replies. In my cfform, I have three radio buttons : Priority <br> <CFINPUT type="radio" name="priority" value="1"> 1 <br> <CFINPUT type="radio" name="priority" value="2"> 2 <br> <CFINPUT type="radio" name="priority" value="3"> 3 <br> My action page takes the value of the priority and then does some cfsets, calculations, etc., then inserts into a table. So far so good. Now I get a requirement to replace the three radio buttons with three colored images (to make them stand out on the screen). So if I click on the first image that represents priority 1, then I need to capture that value and send to my action page for processing. If I click on image 2, then send value 2, etc. It needs to work exactly like the radio buttons so that only one value is selected and sent. Since the images will replace the buttons and text (1, 2, 3), I need to somehow indicate and/or display which image was selected. Is any of this possisble to do ? If yes, can somebody please show me how to do it ? thanks read more about Images for Radio Buttons
Message from Jatrix Most recent post: 10/25/2007 3 authors and 3 replies. Can CF8 be run on a virtual machine? if so, what'd the requirements be? read more about Can CF8 exist in an virtual machine environment
Message from joe2843 Most recent post: 10/25/2007 2 authors and 3 replies. I'm creating a form where one drop down menu will populate after the user selects something in the drop down menu before it. (If Menu A if they select x, Menu B will give the options of 1, 2, 3; if in Menu A they select y, Menu B will give the options of 4, 5, 6.) This isn't database driven. Could someone outline the steps I need to do this, or point to a good website which describes what I need to do? Thank you! read more about conditional forms fields
Message from ranger Most recent post: 10/25/2007 4 authors and 7 replies. I am creating an excel file in cf7 and all works well except when a part number begins with a 0 - I need the number to always have 5 digits as in 01234 or 12345. I have tried doing a Numberformat(partnum, '00000') to no avail. can I force using "TabChar" or something? noticed the the field in the created excel file won't accept a 0 even typed in manually. thanks in advance read more about CFCONTENT to excel
Message from drj85 Most recent post: 10/25/2007 6 authors and 7 replies. hey guys I was hoping someone could answer me a quick question. How do I access a hidden form's value from Cold Fusion? I have setup my hidden form using <input type="hidden" name="index_num" value="0" /> then I need to have Cold Fusion pull the value from that hidden input form. Any ideas? I tried to use FORM.index_num, but that gives an error... more in depth, I'm calling it from a JAVAscript function: function thisOne() { var #toScript ( myArray [ FORM.index_num ], "jsArray" ); } thanks alot read more about Access hidden form value?
Message from sbsmithfl Most recent post: 10/25/2007 3 authors and 5 replies. Greetings, I'm a low level ColdFusion newbie and have a simple question. How can I get the date of the database file located on my server. I'd like to report that on the page where the data is listed. I'm new, so please be simple. Here's some info: datasource = "mydata" file location: = /database/mydata.mdb thansk, Stephen read more about Getting Database file date
Message from Temega Most recent post: 10/25/2007 3 authors and 5 replies. I'm looking for a way to generically nest cfloops. See the CFLOOP part of the attached code for an example of hard coded nested cfloops. I'd like to achieve this generically. I'd like to be able to have a structure with an unlimited amount of nested arrays and be able to loop trough them and output them surrounded with some HTML for example. With this code I can have a maximum 2 sub levels and if I'd like to have more sub levels I'd have to nest more and more CFLOOP's. Please let me know if you've a good solution. Thanx. <CFSET menu = arrayNew(1)> <CFSET menu[1] = structNew()> <CFSET menu[1].title = "Home"> <CFSET menu[2] = structNew()> <CFSET menu[2].title = "About"> <CFSET menu[2].subs = arrayNew(1)> <CFSET menu[2].subs[1] = structNew()> <CFSET menu[2].subs[1].title = "about sub 1"> <CFSET menu[2].subs[2] = structNew()> <CFSET menu[2].subs[2].title = "about sub 2"> <CFSET menu[2].subs[3] = structNew()> <CFSET menu[2].subs[3].title = "about sub 3"> <CFSET menu[3] = structNew()> <CFSET menu[3].title = "Portfolio"> <CFSET menu[3].subs = arrayNew(1)> <CFSET menu[3].subs[1] = structNew()> <CFSET menu[3].subs[1].title = "project 1"> <CFSET menu[3].subs[2] = structNew()> <CFSET read more about Automated CFLOOP nesting
Message from MitchDW Most recent post: 10/25/2007 2 authors and 2 replies. Hello, I have just installed Cold Fusion 8 and Adobe CS 3 (in that order). I am goign through the documentation and it talks about the Login Wizard extension for Dreamweaver. I have opened the samples, made sure I had an active database connection, but still no Login Wizard. What am I missing? thanks, mitch read more about Dreamweaver Login Wizard for Cold Fusion 8
Message from Fvddungen Most recent post: 10/25/2007 2 authors and 2 replies. Hello all, Is it possible to overwrite the name of an attachment in CFMAIL using a certain CFMAILPARAM property or something? The files are stored on disk with an unique identifier as filename, but as soon as I'd like to send them via CFMAIL the file should've its original filename. I wonder if this is possible and if so how. Thanks in advance, Frank read more about Override filename in cfmail
Message from dlegate2 Most recent post: 10/25/2007 6 authors and 10 replies. In Cold Fusion 8, how can we insert custom ALT tag messages for CFIMAGE? I notice when I use it, it creates an empty alt tag (alt="") but I do not see where this can be controlled. I tried just adding: alt="my message" as an attribute to CFIMAGE, but it failed with a validation message. read more about ALT tags for CFIMAGE?
Message from bossep Most recent post: 10/25/2007 3 authors and 5 replies. Hello all, I have a my site under a directory outside the C:\InetPub\wwwroot ware CFIDE is stored. the site is under C:\Sites\mysite\html\ All is running fine except that cfmenu, etc dosent work. Same thing with debuging. This problem started when changing to CF8. I also tryed to copy the html directory to wwwroot and all works fine there. So it must be some problem with the mappings I belive. This is driving me crazy All the best BosseP read more about Mapping of Cold Fusion scripts
Message from rich.leach Most recent post: 10/24/2007 2 authors and 3 replies. Hi Gang- I'm working on not-enough-sleep here.... I installed a SSL cert, all is well in calling it and keeping a user in it during a transaction. After I complete the transaction what is an elegant way to get them back to "http" instead of them continuing to use "https"? I put a big "click here to continue" link that is hardcoded with the http but if they do not click that they're stuck in https. I have an event/page identified where I could run something in onRequestStart to run logic like "CFIF user came from this page, set cgi.https="off" /cfif. Anyone have something graceful for this? Thanks mucho in advance, Rich read more about HTTPS question
Message from Adomacro Most recent post: 10/24/2007 4 authors and 6 replies. I got a .Net application. Part of this application is written in Cold Fusion. How can I call Cold Fusion page from C# application?. Please post sample and code. read more about Can I call a Cold Fusion page from C# code?.
Message from semi star gazer Most recent post: 10/24/2007 2 authors and 3 replies. I am trying to run a query on an Access table that lists a series of events, both past and future. I'd like to be able to pull all of the records of past events by comparing the date field in the table to the current time. Is there any way to write this into the query? Something like... WHERE eventDate < #Now()#? Help! :) read more about Querying Dates in Access
Message from jkgiven Most recent post: 10/24/2007 3 authors and 9 replies. I want to be able to print out an employee phone directory. The results are driven from a loop of a query. Currently I get results like: Anderson, John Amaro, Luis Arnold, Ashley Black, Debbie Boyd, Larry Davenport, Mike David, Marsha Estrada, Paul etc. etc. But I'd like to insert a row that shows a letter " -A- , -B-, etc." when the first letter of the last name changes... thus: -A- Anderson, John Amaro, Luis Arnold, Ashley -B- Black, Debbie Boyd, Larry -D- Davenport, Mike David, Marsha -E- Estrada, Paul etc. How can I do this? read more about How to insert a TR row in a loop when needed
Message from Brandi L Most recent post: 10/24/2007 2 authors and 3 replies. Hello all! Is there a way to use Cold Fusion to display the schema of a table from a database done in Sybase? I tried doing an sp_help <table name> but it only gives me the table name, object type, and owner. I need to be able to see the different element names and types. I am displaying my output using cfdump. Thanks in advance for any assistance provided! read more about Database table schema with Cold Fusion?
Message from jeffromace Most recent post: 10/24/2007 3 authors and 10 replies. I started using CFMX 8 and love it. I am working with CFIMAGE now and need help with two things. One, what is the best way to find the accurate coordinate placement for text or images? Right now, I just keep changing the numbers 1 at a a time to find the right placement.. Is there an easy way? Also, how to I put in the coordiates to make sure that the text is anchored on the right side. So if I wan to make sure that a few things of text are right justified, how can I do that? read more about CFIMAGE Text/Image Placement
Message from frank_tudor Most recent post: 10/24/2007 3 authors and 5 replies. I have a query that pulls a set of values from a table. I need to create a loop that updates the values in another table based on some conditions. Some of the numbers have leading zeros that get truncated during the updated. How do I prevent this from happening? What function do I wrap around the variable to maintain leading zeros? Thanks, Frank read more about leading zero
Message from bpdevlin Most recent post: 10/24/2007 4 authors and 10 replies. I have a series of pages that perform the following functions: 1. Query the database and present a list of selectable items with checkboxes next to each item. The user selects any number of items to report on. 2. The selected items within the form are sent to a processing page that generate CFDOCUMENT pdf reports via a series of queries to the database for each item. The generated reports are saved to a temporary directory on the server and when the last report is created, they are zipped up and emailed to the user. All of this works quite well except that it can be a fairly long process especially if a fair number of items are selected. I can override the ColdFusion page timeout with the CFSETTING tag but there is an issue with the browser timing out. I had implemented a progress bar with a series of CFFLUSH commands to keep the browser receiving content, eliminating the browser timeout. However, the page now seems to ignore the flush commands and just displays it all at the end instead of incrementally. This seemed to happen when I changed the submitting form to one that posts the form data instead of calling the processing page with url variables. This was required when I went to a multiselect option. I'm not sure if this is the cause but I have tried everything I can to get the CFFLUSH flushing again to no avail. Is there a way to get the server to process the request in background mode? Since the user makes a request read more about Running long processes
Message from jarviswabi Most recent post: 10/24/2007 4 authors and 6 replies. I'm trying to optimize a batch process I have that runs nightly to repopulate our website's item database. It's currently running as an async process on CFMX7, and I'm benchmarking on on CF8 and trying to squeeze some more performance out of it. The basic flow is that the initial query grabs about 50,000 items, just getting their SKU, unique numeric ID and one other field. Then the program loops through those items one at a time, retrieves a bunch of additional data on each one, builds a structure containing all the data relevant to that item, appends that structure to another structure for a family of items, then sends that structure off to another async process that handles writing the family to the database. Once it does that, the structures are all reinitialized and reused (same variable names) for the next family in the loop. This whole process takes 5-6 hours as it is now. What's interesting to