includes and cfc's

can u include an include in a cfc? ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=36 Message:

RE: includes and cfc's

-Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Friday, October 29, 2004 1:38 AM To: CF-Talk Subject: includes and cfc's can u include an include in a cfc? You can, but it's better to pretend you can't. There's a nasty little side effect of CFINCLUDE in CFCs: when you

RE: includes and cfc's

well here is the reason why i ask (raymond hasnt blogged about using the ini method yet) i was thinking that since u cant call some variables such as your datasourse names outta your Application.cfm file, that you could just include them, so u didnt have to (lazily) manually change them. know

RE: includes and cfc's

Not really... you can definitely call variables out of application.cfm in several ways: 1) You could pass the variables into the CFC as arguments. This probably the best way in that the CFC remains self-contained and it's clear from the invocation code what it needs. 2) You could assign your

RE: includes and cfc's

hum, we had discussed parts of this before and it was said that couldnt be done but i'll give it a shot! thanks im actually diggin up raymonds galleon and gunna check out his method too -- Original Message -- From: Jim Davis [EMAIL PROTECTED] Reply-To:

RE: OT- SQL copy over

There is a couple of tools by Redgate Software that will do what you need. They are SQL Compare and SQL Data Compare. They will compare two SQL Server database and display a list of differences. You can then choose which items to synchronise. It even generates a script which you can archive. I've

RE: CFFILE copy, but with MakeUnique like upload?

Use FileExists to determine if the filename already exists. If it doesn't, keep the original name, if it does, create a new file name with a UUID. Pascal -Original Message- From: Anders Green [mailto:[EMAIL PROTECTED] Sent: 29 October 2004 04:28 To: CF-Talk Subject: CFFILE copy, but

RE: request scope question

request.queryName becomes a pointer to the queryName recordset. You can now access and modify anything in queryName through the reference request.queryName. SO yes, you can access request.queryName.column1 (and it is identical to queryName.column1) Pascal -Original Message- From: G

Re: OT: editors, back to HomeSite+ for me

Larry, Here's my blog entry relating to HE3 not starting (and it was the same fix for cfeclipse): http://gregs.tcias.co.uk/mach-ii/he3_first_steps.php If you need more help drop me a line. After a little fiddling with both of the plugins I can only say that they are awesome (especially once you

Re: error Cannot create cookie: path = /

My server is now running around 425 mbs in the windows task manager. Do you think I should raise the heap size higher then 512mbs (maybe to 640 mbs or 768 mbs)? Right now the machine as a whole is using about 800mbs and I have 2 gigs of ram on the server. Rich On Sat, 23 Oct 2004 19:14:07

Java Question

I am using the following java code to get a image from a external server. where Arguments.FileLoc would be something like http://www.sitename.com/imagedir/imagename.jpg cfset jFileIn = createObject(java,java.net.URL).init(ARGUMENTS.FileLoc) cfset inP =

Re: Java Question

Why not use cfif FileExists() first? Doug Chad McCue wrote: I am using the following java code to get a image from a external server. where Arguments.FileLoc would be something like http://www.sitename.com/imagedir/imagename.jpg cfset jFileIn =

Re: Java Question

FileExists() isn't working for me when all I have is a Http:// address and don't have the absolute address. - Original Message - From: Doug James [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, October 29, 2004 8:24 AM Subject: Re: Java Question Why not use cfif

Re: OT: dummy frame?

On Thursday 28 Oct 2004 17:46 pm, Damien McKenna wrote: Why would they bother with the dummy frame, why would it be needed? Tracking hits at the 'real' host is what springs to mind first. And is it a common practice in the JSP world to put spaces as the first character of every attribute

Re: synching local database with web

Good look Joe but how to 'sync that 2 DB using MM Central? Cheers Marco On Thu, 28 Oct 2004 15:50:01 -0400, Joe Rinehart [EMAIL PROTECTED] wrote: One thing you may want to look at doing is developing the salesperson app in Macromedia Central. It's made to do occaisionally connected apps

RE: Java Question

I'm sure you could interrogate jFileIn to see if the URL was valid, but short of that, cfhttp to see if the file is there. Ade -Original Message- From: Chad McCue [mailto:[EMAIL PROTECTED] Sent: 29 October 2004 13:32 To: CF-Talk Subject: Re: Java Question FileExists() isn't working for

OT: Macromedia Central

hi all does anyone know where i can download the Central Desktop App? im trying to from the website, and it tells me that my pre-release version has expired, and that i should right click on something and get the new one... :( i cannot find that app on my machine @ all, and dont know where to

RE: Java Question

Is there any reason why you couldn't wrap it in a try/catch and then interrogate the error thrown? Kola -Original Message- From: Chad McCue [mailto:[EMAIL PROTECTED] Sent: 29 October 2004 12:14 To: CF-Talk Subject: Java Question I am using the following java code to get a image

Re: OT: Homesite - disabling Browse feature and Edit/Browse tabs?

Patrick Hardy wrote: View - Ressource windows, just uncheck everything! Actually, I meant the Edit/Browse tabs, I'd like to only have the Edit window and not see the tabs above them. -- *Damien McKenna* - Web Developer - [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The Limu Company -

Attend MAX for $250

I've just found out that I will not be able to attend MAX this year. If anyone is interested in attending at short notice, I can transfer my registration over to you and probably switch my hotel reservations to you (I haven't checked on that one). I have a room at the Emabassy Suites hotel for

Re: OT: Homesite - disabling Browse feature and Edit/Browse tabs?

Damien McKenna wrote: Patrick Hardy wrote: View - Ressource windows, just uncheck everything! Actually, I meant the Edit/Browse tabs, I'd like to only have the Edit window and not see the tabs above them. I'm not sure that you can. They aren't a massive annoyance and removing

Re: OT? Passing comma delimited list to where clause in stored procedure

The stored procedure query looks like the following: select pet_stuff1, pet_stuff2 from mypettable where pet_type in (inTypeOfPets) The problem is even though my input string looks like 'Dogs','Cats','Horses' the ticks are getting stripped out of the variable (Dogs,Cats,Horses), how do

nvarchar Insert

Hi, Having trouble with this one. SQL 2000 and the field datatype is nvarchar set to 300 chars. Insert Statement: INSERT INTO tblMyTable (txtField) VALUES ('#frmTxtField#') '#frmTxtField#' comes from a textarea form element. Sometimes I get a truncate data error from the database. Sometimes

Re: nvarchar Insert

Guy, I'd double check your column definition to make sure it's set to 300 and not 30...I've been known to do things like this from time to time. -joe On Fri, 29 Oct 2004 10:12:56 -0400, Guy McDowell [EMAIL PROTECTED] wrote: Hi, Having trouble with this one. SQL 2000 and the field

RE: nvarchar Insert

From: Guy McDowell [mailto:[EMAIL PROTECTED] SQL 2000 and the field datatype is nvarchar set to 300 chars. Insert Statement: INSERT INTO tblMyTable (txtField) VALUES ('#frmTxtField#') '#frmTxtField#' comes from a textarea form element. Sometimes I get a truncate data error from the

Re: OT: Find out my IP

On Thursday 28 Oct 2004 17:51 pm, Paul Vernon wrote: It's unlikely that you ever got a truly public IP using NTL cable however I I had a mail and web server on the end of it that worked fine :-) -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED]

RE: nvarchar Insert

cfqueryparam ?? -Original Message- From: Guy McDowell [mailto:[EMAIL PROTECTED] Sent: 29 October 2004 16:13 To: CF-Talk Subject: nvarchar Insert Hi, Having trouble with this one. SQL 2000 and the field datatype is nvarchar set to 300 chars. Insert Statement: INSERT INTO

RE: Attend MAX for $250

Do you still have this available? Tyler -Original Message- From: Bickham, Randy [mailto:[EMAIL PROTECTED] Sent: Friday, October 29, 2004 9:00 AM To: CF-Talk Subject: Attend MAX for $250 I've just found out that I will not be able to attend MAX this year. If anyone is interested in

RE: Attend MAX for $250

Sorry all...didn't mean to post to list- -Original Message- From: Bickham, Randy [mailto:[EMAIL PROTECTED] Sent: Friday, October 29, 2004 9:00 AM To: CF-Talk Subject: Attend MAX for $250 I've just found out that I will not be able to attend MAX this year. If anyone is interested in

Re: OT: editors, back to HomeSite+ for me

Hi Dave, Why did you give up on it? At the minute we're trying to look at ways to make transition to cfeclipse simpler. Anyone who has tried it and no longer uses it can help us in that respect, so your comments would be appreciated. Spike dave wrote: i gave up on cfeclipse --

Re: nvarchar Insert

Yep, double checked that. Now I'm using cfqueryparam, and the insert is working flawlessly. However the output is truncated to less than 30 characters. When I insert: Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Sed ultrices iaculis erat. Phasellus nisl magna, sollicitudin a,

cf-talk at MAX?

so, we gonna pick a spot to meet, greet, and put some faces behind the emails? Maybe hold a cf-talk pit, eh? I hear Mike D is gonna be layin down some beats in another legendary release of Community Suite somewheres. guess we could all wear some nerdy t-shirt or sign. hehe! -- Douglas

RE: nvarchar Insert

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] CAST(pl.txtDescription AS nvarchar) AS txtDescription snipped from books-on-line nvarchar(n) Variable-length Unicode character data of n characters. n must be a value from 1 through 4,000. Storage size, in bytes, is two times the number of

Re: nvarchar Insert

If the data is in the DB correctly, then the problem has to be in the output, and most likely in how or where the output is being displayed. Are you displaying the output in a textarea? in a textbox? And for sheer curiosity's sake, that looks like latinwatcha storing latin for? -

Re: nvarchar Insert

Yep, it's Latin. In design circles it's known as the Lorem Ipsum text and has been the standard place-holder text since about the 1500's. I think it's a piece by Cicero on human suffering and the pursuit of pleasure. My latin's not so good anymore. Thanks Michael for On Line Books tip. Should

Re: nvarchar Insert

Booyah! It Works. Thanks again, wise ones. Truly, Guy McDowell Web Developer [EMAIL PROTECTED] - Magma Communications Ltd. t: 613.228.3565 x6348 f: 613.228.8313 http://websites.magma.ca This e-mail message is confidential, may be privileged and is intended for the exclusive use of the

Re: cf-talk at MAX?

ill be poppin in the suite... btw, mike d, directions posted somewhere? tw On Fri, 29 Oct 2004 10:33:56 -0400, Douglas Knudsen [EMAIL PROTECTED] wrote: so, we gonna pick a spot to meet, greet, and put some faces behind the emails? Maybe hold a cf-talk pit, eh? I hear Mike D is gonna be

Re: Dates in Queries - Again

You may want to consider using CreateODBCDateTime(Now()). When you use CreateODBCDate(Now()), the time portion is returned as 00:00:00, and if you have stored data for a future date with a time specified (i.e., 09:38:22), then you may not get a match as that datetime will be beyond the maximum

Re: OT: editors, back to HomeSite+ for me

Spike, Why did you give up on it? At the minute we're trying to look at ways to make transition to cfeclipse simpler. Anyone who has tried it and no longer uses it can help us in that respect, so your comments would be appreciated. I quite like cfeclipse, but there were two major stumbling

RE: cf-talk at MAX?

Right across the street from the convention center: Hampton Inn and Suites 1201 Convention Center Blvd. New Orleans, LA 70130 United States We'll have a room number once we get there and will print up business cards (there has to be a kinkos near there) with the room number and all. We do have

Access column names

I saw this question earlier, but I don't think it was answered. Is there a syntax that you can pass to a MS Access Db to get a list of column names for a particular table? ~| Protect your mail server with built in anti-virus

Re: cf-talk at MAX?

damn. do you need any xbox controls or games? i have a couple. tw On Fri, 29 Oct 2004 11:11:30 -0400, Michael Dinowitz [EMAIL PROTECTED] wrote: Right across the street from the convention center: Hampton Inn and Suites 1201 Convention Center Blvd. New Orleans, LA 70130 United States

Re: cf-talk at MAX?

does anyone know where the actual CONFERENCES will be? tw On Fri, 29 Oct 2004 11:27:58 -0400, Tony Weeg [EMAIL PROTECTED] wrote: damn. do you need any xbox controls or games? i have a couple. tw On Fri, 29 Oct 2004 11:11:30 -0400, Michael Dinowitz [EMAIL PROTECTED] wrote:

Re: OT: editors, back to HomeSite+ for me

Stephen Moretti (cfmaster) wrote: Spike, Why did you give up on it? At the minute we're trying to look at ways to make transition to cfeclipse simpler. Anyone who has tried it and no longer uses it can help us in that respect, so your comments would be appreciated. I quite like

Re: Access column names

On Fri, 29 Oct 2004 11:26:07 -0400, Daniel Farmer wrote: Is there a syntax that you can pass to a MS Access Db to get a list of column names for a particular table? I'm not sure about actually within access, but you could always do this: cfquery name=myquery datasource=dsn maxrows=1 SELECT *

Re: Re: cf-talk at MAX?

MAX (Nov 1 - 4): Convention Center CFUnderground (Oct 31): Pan American Conference Center (601 Poydras Street - 11th floor) Mini MAX (FREE - Nov 1 at 7 PM): LSU Medical Center (Bolivar and Perdido Streets) ~Simon does anyone know where the actual CONFERENCES will be? tw On Fri, 29

RE: cf-talk at MAX?

I bought an Xbox with an extra controller and a few games (xbox sponsored by RUWebby). We'll be raffling off the whole thing on the last day of MAX and will accept raffle tickets over the net. Games are: Dead or Alive 3 Starwars: Battlefront Burnout 3: Takedown

Re: Access column names

Does Access maintain systables and syscolumns tables? If so, you can join those together to get a list of the columns in a table, assuming your stats are up to date on the DB. - Original Message - From: Daniel Farmer [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, October

RE: Access column names

Daniel Do you mean from within cf? If you are only interested in the column names (and not the datatypes) cfquery name=getColumnList datasource=dsn Select * from mytable where id = 0 /cfquery cfset tableList = getColumnList.columnList There are also some system tables you can

RE: cf-talk at MAX?

Across the street from the suite. :) Actually, the MM site has all the info and you can visit the conference center site at: http://www.neworleanscvb.com/ For a map: http://www.neworleanscvb.com/new_site/visitor/vismapsflash.cfm# does anyone know where the actual CONFERENCES will be? tw

Re: cf-talk at MAX?

sounds like you got it covered... however ill prolly bring a controller with me so people can play four at a time, and get it back from you on the last day, cool? tw On Fri, 29 Oct 2004 11:39:45 -0400, Michael Dinowitz [EMAIL PROTECTED] wrote: I bought an Xbox with an extra controller and a

RE: Access column names

There are also some system tables you can query which will give you the names but the names escape me, have a look inside the database. Its been a long time since I've used access but I believe there is a setting which you can enable to view the system tables. Click on Tools Options,

RE: cf-talk at MAX?

You're not going to include it in the raffle? :-) John -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Friday, October 29, 2004 11:58 AM To: CF-Talk Subject: Re: cf-talk at MAX? sounds like you got it covered... however ill prolly bring a controller with me so

RE: cf-talk at MAX?

Works for me, thanks. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Friday, October 29, 2004 10:58 AM To: CF-Talk Subject: Re: cf-talk at MAX? sounds like you got it covered... however ill prolly bring a controller with me so people can play four at a time,

Re: cf-talk at MAX?

sure, and my wife too! jk. im taking her home with the controller, its a 1 time use controller, it explodes in 4 days ... :) me On Fri, 29 Oct 2004 12:02:34 -0400, Burns, John D [EMAIL PROTECTED] wrote: You're not going to include it in the raffle? :-) John -Original

RE: cf-talk at MAX?

Raffle is for the Xbox, Extra controller and all games. The auction is for all the books in the reading library. For those who remember the last one, it'll be great. Hell, I may even auction myself off or maybe Judith. :) You're not going to include it in the raffle? :-) John -Original

RE: Access column names

Does Access maintain systables and syscolumns tables? If so, you can join those together to get a list of the columns in a table, assuming your stats are up to date on the DB. - Yes it does, or tables with the same purpose. I don't have my access books to hand, so I can't tell you their

OT: Networking

Does anyone know of a good resource online for networking? I'm having some issues and would like to try to resolve them myself. Or does anyone mind answering questions via email. Either way - please respond off list so this post doesn't drive everyone nuts. Thanks! --

RE: Java Question

I am using the following java code to get a image from a external server. where Arguments.FileLoc would be something like http://www.sitename.com/imagedir/imagename.jpg cfset jFileIn = createObject(java,java.net.URL).init(ARGUMENTS.FileLoc) cfset inP =

Next Version Pricing?

Anyone know if NEW purchases of 6.x will qualify for free updates to Blackstone? I am putting together next year's budget and need to make an allocation one way or the other, and we just purchased 6.1 last month. TIA Tim ~|

Cfheader and browser window name

Hi, I was wondering if it is possible to change ( or hide) the name of the actual file (displayed at the top of the browser window) when the new browser window is called like: cfheader name=Content-Type value=application/vnd.ms-excel cfheader name=Content-Disposition value=inline;

RE: Next Version Pricing?

No pricing has been announced yet. But if you bought subscription you'll definitely get the update. --- Ben -Original Message- From: Claremont, Timothy [mailto:[EMAIL PROTECTED] Sent: Friday, October 29, 2004 1:19 PM To: CF-Talk Subject: Next Version Pricing? Anyone know if NEW

RE: Networking

Does anyone know of a good resource online for networking? I'll answer on-list, since this is something that comes up a lot. Here's a good introduction to TCP/IP, written by Daryl Banttari of Macromedia: http://www.ipprimer.com/ Here's a good list o' links:

Re: Next Version Pricing?

Macromedia is being very blunt about the fact that they have no plans to tell anyone about pricing at this time...That being said you can safetly assume you are not getting anything free Adam H On Fri, 29 Oct 2004 13:19:04 -0400, Claremont, Timothy [EMAIL PROTECTED] wrote: Anyone know if

RE: Next Version Pricing?

That's a little harsh ... Macromedia is being very blunt about the fact that they have no plans to tell anyone about pricing at this time... FWIW, there are rules that govern what can be announced and said when, this is not something we control unfortunately. This is not a matter of trying to

Application.cfm update question

Running CF5 or CFMX6.1, if I make a change to Application.cfm and update that file on the server, the change doesn't seem to take effect until I cycle the CF service. Is this to be expected? Is there a way to force changes to Application.cfm to take effect without cycling the CF service?

CFMX Security Best Practices

Sorry if this is a duplicate, it did not appear that my first message went through. I am moving froma shared hosting environment to my own dedicated server, so all the sudden I have to start worrying about how to best setup and secure CFMX on a Windows 2003 box. Does anybody have any resources

Re: Application.cfm update question

Do you have trusted cache turned on? If it's on, that's the expected behaviour. cheers, barneyb On Fri, 29 Oct 2004 13:45:44 -0400, Stephen Hait [EMAIL PROTECTED] wrote: Running CF5 or CFMX6.1, if I make a change to Application.cfm and update that file on the server, the change doesn't seem

Session Variables SNAFU

Hi All, I am having a severe problem with session variables in an order management application I am working on. The application stores a rather large order object (cfc) in the SESSION scope and modifies it as changes are made via methods of the CFC. For some reason at random times the order

Re: Application.cfm update question

could be session issue. you shouldn't need to do anything chack your settings in your administrator for cf variables and such. ~| This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable

Re: Application.cfm update question

Changes to the Application.cfm file should take effect immediately - even if you don't restart CFMX. This is because (unless you're runniing pre-compiled cfm files) all CFM pages are compiled at runtime. So, if you make a change to one, that change should take effect the next time you hit the

Re: Next Version Pricing?

yea amnesty is a great thing. We bought CF5 and then 3 months later cfmx came out. Thanks to amnesty we upgraded and didn't have to play with cf5 for very long :) ERJ On Fri, 29 Oct 2004 13:33:29 -0400, Ben Forta [EMAIL PROTECTED] wrote: That's a little harsh ... Macromedia is being very

Re: Next Version Pricing?

I can top that...at an old employer, we bought Generator1 month later MM announced they would no longer support it...so we got 2 free 'upgrades' to CF5, shortly after that MX cmae out and we got upgraded to that as well. On Fri, 29 Oct 2004 13:55:33 -0400, jonese [EMAIL PROTECTED] wrote:

Re: Application.cfm update question

Are you by any chance branching around the changes? ie. cfif not isDefined('application.xxx') ..changes. /cfif - Original Message - From: Stephen Hait [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, October 29, 2004 1:45 PM Subject: Application.cfm update

Re: Next Version Pricing?

That's a little harsh ... I didn;t mean for it to have the negtive spin I think you got from it. I was just trying to convey that everytime it is brought up y'all are very quick to the pouint that it is not being discussed..I guess more than anything I am jsut sick and tired of people asking

Re: Application.cfm update question

what kind of changes are there between the two files? issue might be that the application vars from the original are still valid. you can force the application scope to be cleared with a cfset structClear(application). if you add that little line of code to the new Application.cfm the first

RE: Next Version Pricing?

Hey, we try to keep customers happy when we can. And no, am I not making any promises as to what we'll do with Blackstone. You're going to have to wait for that one. Sorry. --- Ben -Original Message- From: Scott Stroz [mailto:[EMAIL PROTECTED] Sent: Friday, October 29, 2004 2:01 PM

RE: Application.cfm update question

Any chance this might be a problem with the application timeout? I think I had a problem with this on some previous projects. I reset the timeout to 0 and then executed a page and then reset the timeout to what it was. Not sure if that could be it, but just in case. John -Original

OT: backing up SQL Server DB across the network

I have a NAS unit and am trying to use it to backup SQL Server DB at night. I'm using a UNC path as part of the maintenance plan. The problem is it seems I can not complete a backup. The backups always fail with this error message: BackupDiskFile::RequestDurableMedia: faulre on backup device

Re: backing up SQL Server DB across the network

Do you have SQL Server running under a non-system account with access rights to the remote NAS? Regards, Howie --- On Friday, October 29, 2004 3:07 PM, Brook Davies scribed: --- I have a NAS unit and am trying to use it to backup SQL Server DB at night. I'm using a UNC path as part of the

Web Server vs. DB Server

I have two servers available to me. A brand new, latest and greatest dual proc. 3.2 GHz machine with 2.5 gb Ram, and a lowly dual processor 550 mhz with 1 GB Ram. My app will be doing a LOT of db calls/queries/updates. With SQL and FoxPro database backends, should I put the dbs on a separate

Re: Access column names

See CFX_ODBCinfo here: www.contentbox.com/claude/customtags/tagstore.cfm It returns column names in a table with data types plus many more. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to

access memo to sql

I'm not sure what to do on this one. I have an access database populated with data that has 5-6 memo fields. I'm trying to move the database to SQL 2k and I'm having a problem with the memo field. At first I thought I would just make it a varchar but they have limits of 8000 characters and when I

OT mssql sp

Hi, I have to generate a list of changes whenever someone updates an entry on certain tables. I'm thinking a triger would be the best spot. Anybody got some code that would do this? Or perhaps a link to a good sql2000 list? Thanks -- DRE www.webmachineinc.com www.theanticool.com

Re: access memo to sql

text or ntext Marius - Original Message - From: Coleman, Brian [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, October 29, 2004 4:12 PM Subject: access memo to sql I'm not sure what to do on this one. I have an access database populated with data that has 5-6 memo

RE: OT mssql sp

Sounds like you need an audit trail. Here is something I used you can get started with it and build on it from there CREATE TRIGGER u_Eagles ON tblEagle FOR UPDATE AS DECLARE @inserted int, @deleted int, @type varchar(6) SELECT @Inserted = COUNT(*) FROM inserted

RE: access memo to sql

text -Original Message- From: Coleman, Brian [mailto:[EMAIL PROTECTED] Sent: Friday, October 29, 2004 3:13 PM To: CF-Talk Subject: access memo to sql I'm not sure what to do on this one. I have an access database populated with data that has 5-6 memo fields. I'm trying to move the

Re: backing up SQL Server DB across the network

Yes, it does have access. Since the transaction logs are backed up with no problem, and only the large complete DB backup fails, I don't think it is a permission problem... Brook At 12:14 PM 10/29/2004, you wrote: Do you have SQL Server running under a non-system account with access rights to

Re: Web Server vs. DB Server

I'd use the old one as the DB server. We've got three identical machines, two web/app server and one DB server (white lie). Even whent he app servers were running full-bore during load testing, the DB server was still at very low utilization. YMMV, of course, but DBs are insanely optimized for

Dumb Registry question

I have been reviewing the setting for W2k and IIS on this page: http://www.macromedia.com/support/coldfusion/ts/documents/tn17277.htm Where is says to set various values in the registry, these are Decimal settings not hexidecimal right? - Alex

RE: Cfheader and browser window name

I was wondering if it is possible to change ( or hide) the name of the actual file (displayed at the top of the browser window) when the new browser window is called like: cfheader name=Content-Type value=application/vnd.ms-excel cfheader name=Content-Disposition value=inline;