Re: Populating Options based on Option selected
You could try the tag. you can find it on allaires site. Doug - Original Message - From: "PHP" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, December 09, 2001 10:10 PM Subject: Populating Options based on Option selected > Hello, > > I am trying to dynamically populate the data from a table that is selected as part of an option in a cfselect statement. > > So far I have: > > > select id, name from category > order by name; > > > > > > > > > > > #cid# > > > > but this doesn't pass the id for the name selected in the option box along, ideally it would populate without having to submit > a form, but rather when the option is selected. Example being if a user was going to add a value to a database and wanted to add it to a certain table and field. First he would select the table name from the first option and then the fields would automatically populate in a second option. > > Any Ideas? > > thanks > > Dan > > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL Query Statement
Yeah you can do that. WHERE dateFormat(Now()) BETWEEN '#cal_date#' AND '#cal_date_end#' Doug - Original Message - From: "Mark Leder" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, December 09, 2001 9:51 PM Subject: SQL Query Statement > I have two date fields (cal_date_start and cal_date_end). The dates are > formatted as mm/dd/. > How would I write a WHERE clause when querying the db to retrieve the > records between the two dates (maybe using the "BETWEEN" statement)? > It's OK to get records on the actual start date and end date. - So if today > is 12/09/2001, its OK to retrieve records between 12/07/2001 and 12/16/2001. > > In other words: WHERE DateValue(Now()) BETWEEN cal_date_start AND > cal_date_end. > > Thanks, > Mark > ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Populating Options based on Option selected
Hello, I am trying to dynamically populate the data from a table that is selected as part of an option in a cfselect statement. So far I have: select id, name from category order by name; #cid# but this doesn't pass the id for the name selected in the option box along, ideally it would populate without having to submit a form, but rather when the option is selected. Example being if a user was going to add a value to a database and wanted to add it to a certain table and field. First he would select the table name from the first option and then the fields would automatically populate in a second option. Any Ideas? thanks Dan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Stoopid forms question
You can do it, but you have to use a group= or query= in your tag. Doug - Original Message - From: "Matt Robertson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, December 09, 2001 5:44 PM Subject: Stoopid forms question > Can I do this inside of a CFMAIL loop, when coming off of a form > submission? I'm looking to just drop the code in, and given the nature > of the template it'd be used on it would be a bit of a pain to set up a > test. Was hoping someone was immediately familiar with running CFLOOPs > inside of CFMAIL. > > > > FIELD=#ThisField#, VALUE=#Evaluate(ThisField)# > > > --Matt Robertson-- > MSB Designs, Inc. > http://mysecretbase.com > > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL Query Statement
I have two date fields (cal_date_start and cal_date_end). The dates are formatted as mm/dd/. How would I write a WHERE clause when querying the db to retrieve the records between the two dates (maybe using the "BETWEEN" statement)? It's OK to get records on the actual start date and end date. - So if today is 12/09/2001, its OK to retrieve records between 12/07/2001 and 12/16/2001. In other words: WHERE DateValue(Now()) BETWEEN cal_date_start AND cal_date_end. Thanks, Mark ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Scheduler Question
Bryan, you could always include in the scheduled template a quick "CFMAIL" to
yourself with the Date/Time the template was executed.
Quoting Bryant Tyson <[EMAIL PROTECTED]>:
> I have a scheduled task that was put into the scheduler around 10am
> that
> was set to go off at 6pm today. It's set to run once with no end date.
> Start date is today. The actual line from the scheduler is:
>
> send_newsletters
> HTTPRequest
> 12/09/2001 - INDEFINITELY
> One-time at 19:00:00.
> Run
>
> Now how can I tell if the event went off as scheduled? ('i'm not on
> that portion of the mailing list) And should it delete itself from the
> scheduler if it has already run the one time?
>
> Thanks.
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Accessing ColdFusion Execution Time Values
The best I think you can do is a tag like my gauge.cfm [#attributes.Label#: #tickTime#ms] Wrap around code you wish to gauge... === Efflare Systems :: http://efflare.com :: [EMAIL PROTECTED] cfx ImageCR :: http://efflare.com/products/cfx_imagecr/?sig cfx gFont :: http://efflare.com/products/cfx_gfont/?sig=== - Original Message - From: "Christopher Dawes" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, December 09, 2001 6:59 PM Subject: Accessing ColdFusion Execution Time Values > > Does anyone know of a way to access the coldfusion server execution > times or the processing time data? > > Christopher Dawes > Dawes International > > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Accessing ColdFusion Execution Time Values
If it's a query in question you can use cfquery.executiontime If you want to know how long an entire template took to process you can use gettickcount(). You can also turn on debugging in the CF Administrator for much more useful debugging info. Execution Time #exectime# MS Joseph DeVore VeloxWeb Technologies -Original Message- From: Christopher Dawes [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 09, 2001 5:00 PM To: CF-Talk Subject: Accessing ColdFusion Execution Time Values Does anyone know of a way to access the coldfusion server execution times or the processing time data? Christopher Dawes Dawes International FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Stoopid forms question
Can I do this inside of a CFMAIL loop, when coming off of a form submission? I'm looking to just drop the code in, and given the nature of the template it'd be used on it would be a bit of a pain to set up a test. Was hoping someone was immediately familiar with running CFLOOPs inside of CFMAIL. FIELD=#ThisField#, VALUE=#Evaluate(ThisField)# --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Scheduler Question
put a cfmail tag in your code that emails you when its run
On Sun, 9 Dec 2001, Bryant Tyson wrote:
> I have a scheduled task that was put into the scheduler around 10am that
> was set to go off at 6pm today. It's set to run once with no end date.
> Start date is today. The actual line from the scheduler is:
>
> send_newsletters
> HTTPRequest
> 12/09/2001 - INDEFINITELY
> One-time at 19:00:00.
> Run
>
> Now how can I tell if the event went off as scheduled? ('i'm not on
> that portion of the mailing list) And should it delete itself from the
> scheduler if it has already run the one time?
>
> Thanks.
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Scheduler Question
i guess you can check on the scheduler.log file
--- Bryant Tyson <[EMAIL PROTECTED]> wrote:
> I have a scheduled task that was put into the
> scheduler around 10am that
> was set to go off at 6pm today. It's set to run once
> with no end date.
> Start date is today. The actual line from the
> scheduler is:
>
> send_newsletters
> HTTPRequest
> 12/09/2001 - INDEFINITELY
> One-time at 19:00:00.
> Run
>
> Now how can I tell if the event went off as
> scheduled? ('i'm not on
> that portion of the mailing list) And should it
> delete itself from the
> scheduler if it has already run the one time?
>
> Thanks.
>
>
>
~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Accessing ColdFusion Execution Time Values
Does anyone know of a way to access the coldfusion server execution times or the processing time data? Christopher Dawes Dawes International FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Scheduler Question
I have a scheduled task that was put into the scheduler around 10am that
was set to go off at 6pm today. It's set to run once with no end date.
Start date is today. The actual line from the scheduler is:
send_newsletters
HTTPRequest
12/09/2001 - INDEFINITELY
One-time at 19:00:00.
Run
Now how can I tell if the event went off as scheduled? ('i'm not on
that portion of the mailing list) And should it delete itself from the
scheduler if it has already run the one time?
Thanks.
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF or Spectra vs. Broadvision
I don't know why any programmer would choose Broadvision. It seems like one of those way overpriced products that is usually sold to the exec's not IT departments. I dont have any real experience with Broadvision though, but this guy definately has an opinion. Perhaps you could shoot an email off to him for details. http://www.peterme.com/bvsucks/ jon John Allred wrote: >I have a new job in the Operations division of a large corporation. >Prior to my arrival, my group developed thousands of static pages for >store managers and district managers using Dreamweaver. We are the >conduit for directions coming out of the corporate office, and the >corporation decided within the last year to personalize the content, >based on job description. The idea was to simplify very complex pages >(suffering extreme information overload) into channels, where people see >what they need to see, without the clutter. District Managers should be >able to view the pages their store managers and the stores' department >managers see. In Operations, we should be able to create content and >specify who sees it and for how long. > >The IT department was asked to come up with a solution over a year ago. >They waited till almost the last minute, and they're now telling us that >they've selected Broadvision. They also tell us that they can't >implement our designs (which we think are very effective, BTW). I know >nothing of Broadvision, so I don't know whether the problem lies with >Broadvision or their limited understanding of its capabilities. > >Having said all that, I know that with a small group of CF programmers, >it would be possible to do this project right, with all of the features >we're being told can't be done by the IT folks. > >Could any of you with Broadvision knowledge or experience offer some >insights on this situation? This is an intranet that handles above a >million hits a day. Is Broadvision the tool? Or is there good info out >there that I could use to influence management on my side of the fence? >Is Spectra a viable alternative to Broadvision? Sorry. I don't know >which specific Broadvision product they're using. > > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFX error
did few time and still get the same error. --- Kevin Gilchrist <[EMAIL PROTECTED]> wrote: > Mak, > > Usually you will get this error when the webserver > cannot communicate > with the cfserevr process because it's down or hung. > Try restarting CF again... > > -Original Message- > From: Mak Wing Lok [mailto:[EMAIL PROTECTED]] > Sent: Saturday, December 08, 2001 02:30 > To: CF-Talk > Subject: Re: CFX error > > > hi, > > I've found out the error occured because i did not > restart CF server after i register the CFX tag, but > after i restart the CF server i get the error below, > why? > > Error Diagnostic Information > An error occurred while attempting to establish a > connection to the server. > > The most likely cause of this problem is that the > server is not currently running. Verify that the > server is running and restart it if necessary. > > Unix error number 2 occurred: No such file or > directory > > > > --- Mak Wing Lok <[EMAIL PROTECTED]> wrote: > > hi, > > > > can anyone tell me what caused the error below? > > > > > > Error loading CFX custom tag library > > > > The procedure associated with the custom tag > CFX_IVC > > (ProcessTagRequest) was not found in the library > > '/usr/lib/libiVerify.so'. > > > > Error: ld.so.1: /opt/coldfusion/bin/cfserver: > fatal: > > ProcessTagRequest: can't find symbol > > > > Please check the ProcedureName entry for this tag > in > > the custom tag database to verify that the > procedure > > listed there is exported by the custom tag > library. > > > > > > > > > > > > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: HTML okay in browser
Jochem, > But when is it chopped off? When cf writes the email to the > spoolfolder or when dart.dll takes it from the spool folder > to the SMTP server? I have no idea. How do I tell? All I know is that somewhere in the process chunks of the html code are just being left out. Paul > -Original Message- > From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] > Sent: Sunday, December 09, 2001 10:34 AM > To: CF-Talk > Subject: Re: HTML okay in browser > > > Paul Sinclair wrote: > > > Jochem, > > > > Thanks for your reply on this subject. > > > > > >>Can you see in the source of the email whether any HTML is > missing or > >>that it is just incompletely rendered by the email client? If it is > >> > > > > In the source of the email, the "chopped off stuff" is just > not there. > > It is not a problem of incomplete rendering. > > > But when is it chopped off? When cf writes the email to the > spoolfolder > or when dart.dll takes it from the spool folder to the SMTP server? > > Jochem > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SandBox Problem
Ok it has been a long time since I used siteminder under single sign on scenario! But can I ask is it required, to use siteminder that is. If it is to protect files from being downloaded etc then I think the best way would be to use CF mappings for data that you do not want to be guessed via the url. For example I did a porn site back in 1998 that has content that can only be viewed by members. But I did write my own form of Security Context tags that don't use CF Advanced Security, they do however keep control of who is logged in and what type of memebership they have as well as what they can view. The principle works the same as what siteminder offers, but without the added overheads that Siteminder adds to IIS!! -Original Message- From: Bastian Schmid [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 20 November 2001 9:47 AM To: CF-Talk Subject: SandBox Problem Hi, I'm running a ColdFusion Sandbox on our server and it works quite well. But the siteminder is so resource-intensive so that the loading of the websites so so terrible slow... The siteminder-service checks all of the files within a directory (including subdirs). Because of checking also the graphics and databases, wcich is absolutely not neccassary, the speed of our server is bloody slow. Can anybody give me a solution, how i can "tell" the siteminder-services only to check the .cfm/.cfml files? I know, that i can do this with *.cfm within one directory. But do i have to add every directory of my server to the security context to seperate the files or is there any possibility to do that instead of c:/xy/* like c:/xy/*/*.cfm? greez, Bastian ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SandBox Problem
Hi, I'm running a ColdFusion Sandbox on our server and it works quite well. But the siteminder is so resource-intensive so that the loading of the websites so so terrible slow... The siteminder-service checks all of the files within a directory (including subdirs). Because of checking also the graphics and databases, wcich is absolutely not neccassary, the speed of our server is bloody slow. Can anybody give me a solution, how i can "tell" the siteminder-services only to check the .cfm/.cfml files? I know, that i can do this with *.cfm within one directory. But do i have to add every directory of my server to the security context to seperate the files or is there any possibility to do that instead of c:/xy/* like c:/xy/*/*.cfm? greez, Bastian ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RDS-Security
Hi, i have a problem concerning the RDS-Security. I try to give everyone of my customers the chance to develope their application on the server directly. For that, i have to set up a RDS-Security, which assigns every customer exactly one directory (including subdirs). For example should customer a only be able to get into the dir c:\customers\a and customer b only into c:\customers\b. I have already a ColdFsuion Sandbox running on my server, which allows to set exactly this rules. But within this SandBox I can only assign one security context to the RDS-Security. Is it possible to set all this rules within only one security context or is there another way to protect the resources of the server while using RDS? greez, Bastian ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFGrid 5 problems.
Your problem might be that the applet itself isn't being loaded. By default the applet is called from /CFIDE/classes/ folder (check out the Source view on the page that is trying to show the applet). If this path is not accessible to the browser then the applet won't load. You need to either copy the CFIDE/classes folder to your web site's root or specify a mapping in your web server pointing to the right place. HTH, -Max ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfmodule issues
Shoot me :-) My mistake... ignore the post Benjamin - Original Message - From: "Benjamin Falloon" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, December 10, 2001 7:47 AM Subject: cfmodule issues > Hi all, > > Does anyone know what's wrong with this code... > > > > I'm including a customtag using cfmodule and I want to pass an attribute > called label to the customtag... > > I'm getting this error... > > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF and 2Checkout
I just started with them. I don't have a turnkey setup like you describe, but by tomorrow I should have something that passes an Order ID to them and passes back name/addr/etc. from their site (and is the reason I'm working on a Sunday). Let me know if you want the code. There won't be much as it's a simple url parm pass-to, and probably form parms passed back. Cheers, --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com -Original Message- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 08, 2001 7:53 PM To: CF-Talk Subject: CF and 2Checkout Hey everyone, Anyone using 2Checkout for e-com? If so, is there a custom tag out there to interact with it without going to their website to make the purchase then coming back to your site? Michael T. Tangorre Resident Assistant - Brick Web Applications Developer A.U. Webteam Slave :-) AIM: CrazyFlash4 ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfmodule issues
Hi all, Does anyone know what's wrong with this code... I'm including a customtag using cfmodule and I want to pass an attribute called label to the customtag... I'm getting this error... ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL server
>Access and SQL Server are two separate different products. Yes and no... Separate products, but one can interface with the other. I use access as an interface to our SQL server ALL the time... If you have it configured correctly it works quite nicely. It certainly loads a lot faster than enterprise manager. Create a new project (existing database), save it.. that will bring about the connection dialog box. In server name, enter the ip address of your SQL server. Enter all the login and password information, and then find the database, hit OK, and you're done. Works very similar to working with an actual Access database, however the design view is different - it is SQL Server-ish (different datatypes, etc.) -Bill brainbox - Original Message - From: "Fregas" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, December 09, 2001 2:30 PM Subject: Re: SQL server > Laurent, > > I'm not sure if I fully understood your question. It sounds like you are > tyring to get into SQL Server through Access or at least conscturct a SQL > Server database. To really do anything with SQL Server, you must install > the SQL Server 2000 software on your machine or the server you are working > on. I know access will let you "upgrade" your access database to a SQL > Server database, but you must actually connect to a machine that is running > the SQL Server software. Access and SQL Server are two seperate different > products. > > -Craig > > > - Original Message - > From: "laurent hsld" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Sunday, December 09, 2001 11:00 AM > Subject: SQL server > > > > Hey everyone, > > > > This is my first post in this list. > > > > I Know that maybe it's not the right list to ask such a question but as > > long as i know that some of you may have encountered the same problem. > > > > I have installed office XP (at first to work with access) and i find out > > that some sql server possibilities are in, the installation work fine but > i > > don't know how to get into, i mean construct a sql server db, i tried to > > get into by the osql utility but each time a password is required. After i > > have entered the password i always got the same error message : the user > is > > not associated with a secured connection... > > > > What can i do ? is there any other way to get into SQL server ? > > > > thanks for your help and once again sorry for this out of subject message. > > > > Laurent > > > > > > > > > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL server
Laurent, I'm not sure if I fully understood your question. It sounds like you are tyring to get into SQL Server through Access or at least conscturct a SQL Server database. To really do anything with SQL Server, you must install the SQL Server 2000 software on your machine or the server you are working on. I know access will let you "upgrade" your access database to a SQL Server database, but you must actually connect to a machine that is running the SQL Server software. Access and SQL Server are two seperate different products. -Craig - Original Message - From: "laurent hsld" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, December 09, 2001 11:00 AM Subject: SQL server > Hey everyone, > > This is my first post in this list. > > I Know that maybe it's not the right list to ask such a question but as > long as i know that some of you may have encountered the same problem. > > I have installed office XP (at first to work with access) and i find out > that some sql server possibilities are in, the installation work fine but i > don't know how to get into, i mean construct a sql server db, i tried to > get into by the osql utility but each time a password is required. After i > have entered the password i always got the same error message : the user is > not associated with a secured connection... > > What can i do ? is there any other way to get into SQL server ? > > thanks for your help and once again sorry for this out of subject message. > > Laurent > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFGrid 5 problems.
Ok..that was Not the problem. I updated a client machine with the latest JRE 1.3.1 or something, and it still is not loading the applet at all. I also applied the Hotfix. And someone tried to access the page remotely over the net, and they too are not getting the applet loading. So do I have to have specific values on the Java settings of the CF5 Administrator in order for this thing to work? -Gel -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED]] Looks like this is my problem here. Pulled from a Knowledge Base article: Internet Explorer browsers will not force a download of the 1.3 Java Runtime Environment (JRE) if an older version already exists on the client's machine. With Internet Explorer, the cfform tag does not distinguish the version of the JRE installed on the client's machine. As a result, cfform will not force a download of the 1.3 JRE if an earlier version is installed. This causes a variety of failures to occur when using thecfform tag. In particular, the applet, cfgrid will not display with a JRE prior to 1.3.0_01. Other applet controls will work with JRE versions prior to 1.3.0_01. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFGrid 5 problems.
Looks like this is my problem here. Pulled from a Knowledge Base article: Internet Explorer browsers will not force a download of the 1.3 Java Runtime Environment (JRE) if an older version already exists on the client's machine. With Internet Explorer, the cfform tag does not distinguish the version of the JRE installed on the client's machine. As a result, cfform will not force a download of the 1.3 JRE if an earlier version is installed. This causes a variety of failures to occur when using thecfform tag. In particular, the applet, cfgrid will not display with a JRE prior to 1.3.0_01. Other applet controls will work with JRE versions prior to 1.3.0_01. WorkAround Rename the original JRE folder to force Internet Explorer to download the correct plug-in on the client machine. Temporarily rename any existing subdirectories in C:\Program Files\JavaSoft\JRE. These subdirectories are named for the JRE versions they contain, such as 1.0.3 or 1.2.. Run the ColdFusion page containing the cfform tag, which will force the browser to download and install the new plug-in. After downloading and installing the plug-in, restore the original directory name(s). However...I can't access the directory to rename it. Heh heh. Saying Access Denied. Gosh I really need to learn about Java and Jscript ;-) Should I just download a new JRE from SUN and install it? Or will that totally screw things up? Incidentally this machine has Oracle 8i on it, I'm using it as a sort of localised development environment for a project at the moment. I can't afford installing the new JRE so I can develop with CFGrid, and then have the Oracle installation fail at this stage of the game... Any suggestions, hints..tips... :) -Gel -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 09, 2001 1:01 PM To: CF-Talk Subject: CFGrid 5 problems. Hey all, I'm getting lots of problems trying to use the CF5 JAVA Grid control. The applet refuses to initialise for some reason: java.lang.NullPointerException at allaire.controls2.CFGridApplet.adjustColumnWidths(CFGridApplet.java:295) at allaire.controls2.CFGridApplet.init(CFGridApplet.java:157) at sun.applet.AppletPanel.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Have any of you seen this before? How do you fix it? :) -Gel ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL server
Hey everyone, This is my first post in this list. I Know that maybe it's not the right list to ask such a question but as long as i know that some of you may have encountered the same problem. I have installed office XP (at first to work with access) and i find out that some sql server possibilities are in, the installation work fine but i don't know how to get into, i mean construct a sql server db, i tried to get into by the osql utility but each time a password is required. After i have entered the password i always got the same error message : the user is not associated with a secured connection... What can i do ? is there any other way to get into SQL server ? thanks for your help and once again sorry for this out of subject message. Laurent ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFGrid 5 problems.
Hey all, I'm getting lots of problems trying to use the CF5 JAVA Grid control. The applet refuses to initialise for some reason: java.lang.NullPointerException at allaire.controls2.CFGridApplet.adjustColumnWidths(CFGridApplet.java:295) at allaire.controls2.CFGridApplet.init(CFGridApplet.java:157) at sun.applet.AppletPanel.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Have any of you seen this before? How do you fix it? :) -Gel ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF or Spectra vs. Broadvision
I have a new job in the Operations division of a large corporation. Prior to my arrival, my group developed thousands of static pages for store managers and district managers using Dreamweaver. We are the conduit for directions coming out of the corporate office, and the corporation decided within the last year to personalize the content, based on job description. The idea was to simplify very complex pages (suffering extreme information overload) into channels, where people see what they need to see, without the clutter. District Managers should be able to view the pages their store managers and the stores' department managers see. In Operations, we should be able to create content and specify who sees it and for how long. The IT department was asked to come up with a solution over a year ago. They waited till almost the last minute, and they're now telling us that they've selected Broadvision. They also tell us that they can't implement our designs (which we think are very effective, BTW). I know nothing of Broadvision, so I don't know whether the problem lies with Broadvision or their limited understanding of its capabilities. Having said all that, I know that with a small group of CF programmers, it would be possible to do this project right, with all of the features we're being told can't be done by the IT folks. Could any of you with Broadvision knowledge or experience offer some insights on this situation? This is an intranet that handles above a million hits a day. Is Broadvision the tool? Or is there good info out there that I could use to influence management on my side of the fence? Is Spectra a viable alternative to Broadvision? Sorry. I don't know which specific Broadvision product they're using. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Creating dynamic images
Server side font rendering tag with automatic caching. Save to a variety of formats with a variety of options. http://efflare.com/products/cfx_gfont/?hf "E C HOF list" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I need to do some lite image generation taking a text > string and turning into a GIF or JPG. I am wondering > if there's any way to do this with the Macromedia > Generator code that's built into CF 5.0. If not, does > anyone have any recommendations for custom tags that > do the same. > > For instance, I want to take someone's name "Michael > Smith" and turn that into a JPG image--with some > control over font, font size, color, kerning... > > > > > ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: HTML okay in browser
Paul Sinclair wrote: > Jochem, > > Thanks for your reply on this subject. > > >>Can you see in the source of the email whether any HTML is missing or >>that it is just incompletely rendered by the email client? If it is >> > > In the source of the email, the "chopped off stuff" is just not there. > It is not a problem of incomplete rendering. But when is it chopped off? When cf writes the email to the spoolfolder or when dart.dll takes it from the spool folder to the SMTP server? Jochem ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: HTML okay in browser
Jochem, Thanks for your reply on this subject. > Can you see in the source of the email whether any HTML is missing or > that it is just incompletely rendered by the email client? If it is In the source of the email, the "chopped off stuff" is just not there. It is not a problem of incomplete rendering. > Does the malforming take place around weird characters (control > characters, maybe the high ASCII numbers)? Does it take place in long > lines? No - that's what I thought might be happening at first. No weird characters or anything. Lines aren't particularly long either. > Can you post a snippet which shows the malformed email? Here are code snippets of a VIEW SOURCE from a browser and from email client. The first snippet between ---'s is from a browser. This is the way the code SHOULD look. The second snippet between *'s is from Outlook 2002. --Browser Start in Nucor fell about 7 percent, or U.S. $2.41, to $34.59 in lunchtime trading. Steel shares have suffered as prolonged pricing difficulties and slow economic demand have not turned around as some expected. (Financial Times) 43. PALM REPORTS REVENUES FALL 47 PERCENT --Browser End **Outlook 2002 Start in Nucor fell about 7 percent, or U.S. $2.41, to $34.59 in lunc 43. PALM REPORTS REVENUES FALL 47 PERCENT **Outlook 2002 End As you can see, the email client for some reason clips off from the "c" in the word "lunchtime" and then picks up a couple of paragraph codes later. I have looked at this in a version mailed to a Hotmail account and I get the same clipping in the email sent there. Thanks for any ideas what could be causing this. Regards, Paul Sinclair > -Original Message- > From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] > Sent: Sunday, December 09, 2001 8:41 AM > To: CF-Talk > Subject: Re: HTML okay in browser > > > Paul Sinclair wrote: > > > I've got an application sending out a newsletter via > CFMail. The email > > that goes out is set to HTML. The items in the newsletter > are picked out > > dynamically from a db query. When I generate the > newsletter, I also save > > it to an outputted html file for browsing on the web. > > > > When I view the html file in a browser, it is fine. But > when it comes > > via email, there are places in the output where some of the html is > > missing. For example, a paragraph may be truncated in mid-paragraph. > > > Can you see in the source of the email whether any HTML is missing or > that it is just incompletely rendered by the email client? If it is > malformed in the source as well, can you send the newsletter to some > malformed address so it ends up in the undelivr dir and see > whether it > is already malformed there? > > Does the malforming take place around weird characters (control > characters, maybe the high ASCII numbers)? Does it take place in long > lines? Can you post a snippet which shows the malformed email? > > > > > I've looked at the db entries and there isn't anything > unusual about the > > records where the paragraphs are being truncated. I can't > figure out why > > these specific paragraphs are getting truncated, but it happens each > > time I generate the newsletter and in exactly the same place(s) > > everytime. > > > > Anything unusual about the cfmail function that might be > causing this? > > > It is known for not playing nice with long lines. > > Jochem > ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Custom Tag to resize JPG on the fly...
Professional high quality image convert/resize tags for jpg... http://efflare.com/products/cfx_jpg/?hf -or- http://efflare.com/products/cfx_imagecr/?hf - Original Message - From: "Jared Stark" <[EMAIL PROTECTED]> Newsgroups: cf-talk Sent: Friday, December 07, 2001 4:10 PM Subject: Custom Tag to resize JPG on the fly... > I have been looking on the Allaire website for a tag to thumbnail JPG > images on the fly. I've found one that does GIF, but I need JPG. > Anyone know of a good one that they can recommend? I must admit that > I'm tacaño(AKA cheap), and I'm looking for a free one. > > Thanks, > Jared > > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: HTML okay in browser
Paul Sinclair wrote: > I've got an application sending out a newsletter via CFMail. The email > that goes out is set to HTML. The items in the newsletter are picked out > dynamically from a db query. When I generate the newsletter, I also save > it to an outputted html file for browsing on the web. > > When I view the html file in a browser, it is fine. But when it comes > via email, there are places in the output where some of the html is > missing. For example, a paragraph may be truncated in mid-paragraph. Can you see in the source of the email whether any HTML is missing or that it is just incompletely rendered by the email client? If it is malformed in the source as well, can you send the newsletter to some malformed address so it ends up in the undelivr dir and see whether it is already malformed there? Does the malforming take place around weird characters (control characters, maybe the high ASCII numbers)? Does it take place in long lines? Can you post a snippet which shows the malformed email? > I've looked at the db entries and there isn't anything unusual about the > records where the paragraphs are being truncated. I can't figure out why > these specific paragraphs are getting truncated, but it happens each > time I generate the newsletter and in exactly the same place(s) > everytime. > > Anything unusual about the cfmail function that might be causing this? It is known for not playing nice with long lines. Jochem ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
