RE: Submit after Page loads

() { parent.frames['framea'].submitbutton.enable = true; } /script body onload=LoadEnable(); ... Anyhow, my $.02 worth. __ Bill Grover Manager, Information SystemsPhone: 301.424.3300 x3324 EU Services, Inc

RE: 100% CPU

:/EUColor.gif Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com/ http://www.euservices.com

RE: 100% CPU

as having the slow page response, or the page never coming up at all. __ file:///E:/EUColor.gif Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: mailto

RE: 100% CPU

. Our names are not FQDN but are not IP addresses either.We just use the server name (sql-server).I'll play with the host file. __ file:///E:/EUColor.gif Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc

RE: 100% CPU

. Our names are not FQDN but are not IP addresses either.We just use the server name (sql-server).I'll play with the host file. __ file:///E:/EUColor.gif Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc

RE: stored procedures

faster. __ file:///E:/EUColor.gif Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] Rockville, MD 20850-1299

RE: Screen and Print question.

. __ file:///E:/EUColor.gif Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW

RE: Screen and Print question.

Thanks for the feedback!I'll look for some other possibilities. __ file:///E:/EUColor.gif Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: mailto

RE: Find out table names and fields?

ight not help! __ file:///E:/EUColor.gif Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] Rockville, MD 20850-12

RE: Backup SQL Server Users

several times without a problem. __ file:///E:/EUColor.gif Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED

RE: Is Parallel Processing Possible With CF?

:/EUColor.gif Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com/ http://www.euservices.com

RE: Emailing Form.FieldNames results via looping?

Sorry but maybe 4.5 and up.If you try it in 4.01 form was not a structure, you had to do the evaluate.Believe me I wanted it to work when we were on that version prior to our upgrade. __ file:///E:/EUColor.gif Bill Grover Manager

RE: Quick SQL Question...

:///E:/EUColor.gif Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com/ http://www.euservices.com

RE: CFMX 6.1 VFP ODBC Resolved

to access. __ file:///E:/EUColor.gif Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] Rockville, MD 20850-1299

RE: Which is quicker

it this way is much more readable in my code then using CFIF and having to code the almost identical INPUT tag twice with only the CHECKED option in or out. __ Bill Grover Manager, Information Systems Phone:301.424.3300 x3324 EU Services, Inc. FAX

RE: Which is quicker

. __ file:///E:/EUColor.gif Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com/ http

RE: List ? in a CFIF

that a value of any value other than zero is true and zero is false, which can be used to great advantage. __ file:///E:/EUColor.gif Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696

RE: Two Destinations for POST form?

ues.submit(); /script So now your localpage will submit on to the SMS page which will still display to the user what it usually does. __ file:///E:/EUColor.gif Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services,

RE: Get URL

) and if they select their bookmark the system will try to go there, switch to my login page, log them in then continue to the page they requested. __ file:///E:/EUColor.gif Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU

RE: How do I access COM Object properties in CF

just cfset objref.parm = some value and to read a value you cfset parmvalue = objref.parm.To call a method you can cfset result = objref.method() __ file:///E:/EUColor.gif Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 E

RE: CFFunction Question - SOLVED

! So I changed the cffunction to have output=no, loaded the HTML I wanted to output into a variable in the UDF then did a cfreturn of that variable.This works like a champ! Once again, thanks for all the help. __ Bill Grover Manager, Information

CFFunction Question

gram fails with the message: Missing Argument Name.How do I call the fuction and only pass the 3 arguments I want to? __ file:///E:/EUColor.gif Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696

RE: CFFunction Question

__ file:///E:/EUColor.gif Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com/ http://www.euservices.com

RE: CFFunction Question

If I use the code I just e-mailed in response to Raymond's answer but drop the REQUEST. I get LCLink is underfined __ file:///E:/EUColor.gif Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX

RE: CFFunction Question

It should have been on the line directly below the cffunction tag. cffunction name=fImageCol output=Yes cfargument name=tcItemNumberrequired=No default= __ file:///E:/EUColor.gif Bill Grover Manager, Information Systems Phone

RE: CFFunction Question

B is defined in all cases. __ file:///E:/EUColor.gif Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED

RE: CFFunction Question

Tried various combinations of #'s and still get the same message. __ file:///E:/EUColor.gif Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: mailto

RE: CFMAIL vs. CDO

to MX 6.0 it would take hours to run.We ended up rewritting the application to directly write files to CF's mail spool folder. Bill Grover Manager, Information Systems EU Services, Inc. 649 N Horners Ln Rockville, MD 20850 Phone: 301-424-3300 x3324 Fax: 301-424-3696 E-Mail: [EMAIL PROTECTED

RE: CFMAIL vs. CDO

One other point I just thought of, if memory serves me correctly I believe there is a memory leak in CDO so that if you use it a lot it has a tendency to use memory without releasing it. Bill Grover Manager, Information Systems EU Services, Inc. 649 N Horners Ln Rockville, MD 20850 Phone: 301

RE: cflogin vs. GetAuthUser

to let the page load, otherwise I reprompt the user for their information. Hope that helped. Bill Grover Manager, Information Systems EU Services, Inc. 649 N Horners Ln Rockville, MD 20850 Phone: 301-424-3300 x3324 Fax: 301-424-3696 E-Mail: [EMAIL PROTECTED] At 07:33 AM 12/30/2003 -0500, you wrote

RE: cflogin vs. GetAuthUser

Application.cfm page I have the following lines: CFIF GetFileFromPath(GetBaseTemplatePath()) NEQ Login.cfm CFINCLUDE TEMPLATE=/MyEU/Login.cfm /CFIF Login.cfm is the following: !--- Page:Login.cfm Function: Processes a users login to the MyEU site. Created by: Bill Grover --- cfif NOT IsDefined(SESSION.nUserID

RE: Ektron CMS

but the RFQ, MyEU and phone directory lookup pages are powered by emPower. __ file:///E:/EUColor.gif Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail

RE: Query to Stored Proc

:///E:/EUColor.gif Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com/ http://www.euservices.com

RE: Query to Stored Proc

__ file:///E:/EUColor.gif Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com

RE: (CF 6 reliability) from Re: Memory Leak on Win2k/CMX6.1

. __ file:///E:/EUColor.gif Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com

RE: using CONNECT STRING with CFMX

The string should be: dsn=dsn;uid=uname;pwd=pword I've made the same mistake forgetting that it isn't username but uid. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX

RE: whitespace is breaking my javascript

as // return message return this.lang_data[_block][arguments.message]; causing it to treat it as a comment. Just my $.02 worth. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc

RE: SQL aggregate question

Try this: select count(ptssn) as numid, sum(sumar) as totalar from (select ptssn, sum(arbalancedue) as sumar from ga_temp group by ptssn having sum(arbalancedue) 50 ) arsum __ Bill Grover

RE: Return Subquery as text string? MSSQL

@Worklist END GO __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299

RE: Return Subquery as text string? MSSQL

It might have help to show how to use it. Assuming you named your function f_OrderList: select UserID, Name, dbo.f_OrderList(UserID) as Orders From Users __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324

RE: SQL aggregate question

Your welcome, I saw Jochem's solution after I sent mine. I had sorted my messages by subject and his answer was in a different location than your message so I didn't realize he had answered it. No harm done. __ Bill Grover Supervisor

RE: Updating MDAC

. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com

RE: Brain Teaser2

.record_id = dt2.record_id __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850

RE: SQL: Brain Teaser

What there are others!!! :-)) __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD

RE: Brain Teaser2

ON dt1.record_id = dt2.record_id __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD

RE: SQL: Brain Teaser

I like your solution Tony. We had an occurrence yesterday where that would have been handy and I didn't think of it. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX

RE: SQL Question...

. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com

RE: Brain Teaser2

In fact, as long as the user you use in the cfquery tag has access to the databases none of the databases referenced in the select statement have to match the database in the cfquery tag. __ Bill Grover Supervisor MIS

RE: SQL: Brain Teaser

@lrFinalComments __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299

RE: T-SQL division drops the decimal?

will to an implicit type conversion of all the numbers and return the fraction part. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane

RE: Virtual directories and UNC paths not working on CFMX?

worked fine. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299

RE: Includes inside a CFOUTPUT problem...

Yeah, I've had the same experience. I've ended up getting in the habit of putting a cfoutput block in almost all my files that I cfinclude. I skip the ones I know are not doing any output (db processing ect). __ Bill Grover Supervisor

RE: Unusual SQL error

. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http

RE: Returning value from a stored procedure?

Maybe try spelling out the word OUTPUT in your stored procedure instead of OUT? Just a thought. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649

RE: Unusual SQL error

That should fix it. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850

RE: Unusual SQL error

question. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW

RE: visual fox pro db?

of the tables you want to import. Hope that helps. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED

RE: visual fox pro db?

free we might think of converting them as well, but they work so we aren't going to break the wheel. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696

RE: visual fox pro db?

Tony, We use FoxPro here all the time and have successfully migrated many systems to SQL. What is the issue/errors you are seeing? __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc

RE: Refresh a frame

I've used the following JavaScript function to change/refresh a frame from another frame: function ChangeFrame(toFrame, tcLocation) { toFrame.location.href = tcLocation; } HTH __ Bill Grover Supervisor MIS

RE: CFDIRECTORY over a LAN

. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com

RE: Is there SQL equivalent to CF's ListGetAt function??? Please help!

dbo.f_reuParseList(@tclist, ',') ON mytable.keyfield = ListID For what you want you can do something like SELECT listitem FROM f_reuParseList(field, '|') where ListID = 5 to get the 5th item in the list. __ Bill Grover Supervisor MIS

RE: Multi Site Installation (Was: Quick note from the CF Team.... )

. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com

RE: i think im gettin hacked

worth. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW

RE: FoxPro databases: does CF use indexes?

it in FoxPro and while it was every bit as slow. As others have said, all CF does is pass the query off to the FoxPro ODBC driver you have installed on your server. It's up to that driver to insure the performance. __ Bill Grover Supervisor

RE: Multiple Mail Attachments with CF 4.0

interface directly into it. You may be able to do it even if you have a MAPI client (like Outlook) on the server. With MAPI you could create a mail object and add attachments to it then send the mail. __ Bill Grover Supervisor MIS

RE: Multiple Mail Attachments with CF 4.0

In 4.0 you could only attach 1 file at a time. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL

RE: stupid newbie tricks

practices in it! __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299

RE: CFLOGIN (Was: stupid newbie tricks)

. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com

RE: CFLOGIN (Was: stupid newbie tricks)

your presentation from DevCon'02 and noticed that you added a point to one of the slides. What you added said Roles-caching Bug / Timeout Issue. What is the bug/issue? Thanks. __ Bill Grover Supervisor MIS Phone

RE: Experiences with VisualSourceSafe?

is missing it becomes very apparent and we can get it added. Just my $.02 __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane

RE: Stored Proc list input

SET @lcListWork = '' END INSERT INTO @ParsedList VALUES (@lcItem) END RETURN END GO __ Bill Grover Supervisor MIS

RE: Primary Keys Duplicate Values

defined a case where a combination of fields should be unique we've ended up with a situation where we needed to add a duplicate for some reason. Just my humble $.02 worth. __ Bill Grover Supervisor MIS Phone: 301.424.3300

RE: Returning columns with null values when specific columns are unknown at runtime

'' END + '0 AS DummyField ' + 'FROM tablename WHERE primarykey = ' + CAST(@tnPrimaryKey AS varchar) FROM tablename WHERE primarykey = @tnPrimaryKey EXEC (@lcSQL) __ Bill Grover

RE: List to stored proc

SET @lcListWork = '' END INSERT INTO @ParsedList VALUES (@lcItem) END RETURN END GO __ Bill Grover Supervisor MIS

RE: bug tracking software.

be downloaded from Microsoft. We looked at it some months ago and have thought about switching but what we are using works great for us and we just haven't decided to spend the time. __ Bill Grover Supervisor MIS Phone

RE: extra blank lines problem

My guess is you are correct. What happens if you leave the cfset's where they are and just remove the cfoutput from around them? I believe the page should still work and you won't get the extra lines. Just my thoughts. __ Bill Grover

RE: OT: Using JS to skip a Tab index?

The only other thought I have would be to put some code in the onFocus event. But if the -1 option works it would be much cleaner. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc

RE: How do i pass FORM variables from one action page to another one ?

No it won't work in v4.01. Believe me I've tried. Prior to v4.5 form fields were a pseudo-structure. The only way I've gotten anything to work is by evauating the form.fieldname. __ Bill Grover Supervisor MIS Phone

RE: transact-sql datediff function

difference between the 2 dates is the count of how many times you go past January 1. Each time you pass Jan 1 it adds 1 year. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc

RE: Passing values between frames

on the parent page we do a parent.formname.submit() - i.e. parent.DataForm.submit() __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane

RE: end of month function

I just had to do this on one of our sites. Here is the code I use: DateAdd(d, -1, CreateDate(Year(Now()), Month(Now()) + 1, 1)) __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc

RE: end of month function

Good point! (stupid! stupid! stupid!) Try this. DateAdd(d, -1, DateAdd(m, 1, CreateDate(Year(Now()), Month(Now()), 1))) __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc

RE: Opinions/Experience with Webex?

the system showing them how to use the system and answering any questions they have. Our clients have loved it because it allows us to provide solutions to them faster than if we had to travel to their site. Hope this helps. __ Bill Grover

RE: Foxpro issue

Yes it still works. When you create your DSN choose the free tables option and specify your directory. You can then just access the tables you wish. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU

RE: One call for two pages?

the 2 output pages and save them disk using cfhttp. Then when you load your 2 frames have those pages cfinclude the generated pages. I know you are in a clustered environment so this may not be feasible, but just a thought. Good Luck! __ Bill

RE: SQL Query Analyzer

As Lon said check your Tools|Options setting. I believe the default for the maximum is ~250 characters and you can increase it. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc

RE: SQL help please

for a change and then returning the proper start and end dates for that range. Therefore you have to use a cursor to process the records one by one. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services

RE: Truncating Logs

INSERT INTO t1 values ('a') SELECT @i = @i + 1 END TRUNCATE TABLE t1 backup log db_name with truncate_only END GO __ Bill Grover

RE: SQL help please

* FROM #PayCatSum __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299

RE: Stored Procedure Help

The only thing that jumped out at me was the line: CFSET ImportCount = CFSTOREDPROC.STATUSCODE Shouldn't it read? CFSET ImportCount = YestPayments.STATUSCODE Just my $.02 __ Bill Grover Supervisor MIS Phone

RE: CFTransactions and SQL Transactions?

procedure with the required fields and then making calls to an update SP where we could pass in the field to update and the value and the SP would update that field. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324

RE: CFTransactions and SQL Transactions?

and am just trying to gather some more information before doing it. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E

RE: Stored Procedure

WHERE SchoolID = #SchoolID#) schol ON STUDENTS.SchoolID = SCHOL.SchoolID WHERE gradeID=#gradeID#) STDNT ON GRADES.StudentID = STDNT.StudentID Hope this helped. __ Bill Grover

RE: whats wrong with DateFormat()

the day portion anyhow, you don't need to pull the day out before formatting it. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane

RE: CF Server / IIS / SQL Server

this helps. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW

RE: Accessing FoxPro database

are using UNC coding. I.E. the path would be \\ServerB\TheShare\pro50\ARDATA 4) Do the following: cfquery datasource=foxprodsn name=getsodata debug SELECT custno FROM arcust10 /cfquery That should do it. __ Bill

RE: SQL Server on a separate machine

Thanks Mark and Dave! Boy am I red-faced now! One more thing to fix today. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane

RE: SQL Server on a separate machine

. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http

RE: Cold Fusion and Visual Source Safe

the integration. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299

  1   2   >