I was trying to use the archives.
I don't know my user name/password for this. So I tried to sign up and was
told my email is already in the database (message below)
"Your email information is already in the database and you must sign in with
your username/password. If you have forgotten it, ple
Never mind
I find the links on left. Just me not paying attention.
Was only looking for underlined links
Thanks
Rodney
-Original Message-
From: Bruce, Rodney S HQISEC/Veridian IT Services
[mailto:Rodney.Bruce@;HQISEC.ARMY.MIL]
Sent: Thursday, November 07, 2002 8:21 AM
To: CF-Talk
Hello all
I am trying to call a storedproc from an SQL 7 db.
and I get this error. Does anyone know what it means.
ODBC Error Code = S1C00 (Driver not capable)
[Microsoft][ODBC SQL Server Driver]Optional feature not implemented
I have tested the connection through CF admin and it tests ok
eaver@;Limitedbrands.com]
Sent: Thursday, November 07, 2002 10:07 AM
To: CF-Talk
Subject: RE: Stored proc help
make sure that your date CFPROCPARAMS use the SQLDATESTAMP type and use
CreateODBCDateTime(your date). i get this often on date formats
-----Original Message-
From: Bruce, Rodney
now I get:
ODBC Error Code = 22005 (Error in assignment)
[Microsoft][ODBC SQL Server Driver]Invalid character value for cast
specification
SQL = "sp_psactualsbyweek"
-Original Message-
From: S. Isaac Dealey [mailto:info@;turnkey.to]
Sent: Thursday, November 07, 2002 10:22 AM
To: CF-T
rom: Weaver, Anthony [mailto:AWeaver@;Limitedbrands.com]
Sent: 07 November 2002 17:07
To: CF-Talk
Subject: RE: Stored proc help
make sure that your date CFPROCPARAMS use the SQLDATESTAMP type and use
CreateODBCDateTime(your date). i get this often on date formats
-Original Message-
From: Br
Subject: RE: Stored proc help
Ive found better results using CF_SQL_TIMESTAMP in conjunction with
createodbcdate and createodbcdatetime
HTH
-Original Message-
From: Bruce, Rodney S HQISEC/Veridian IT Services
[mailto:Rodney.Bruce@;HQISEC.ARMY.MIL]
Sent: Thursday, November 7, 2002 17:23
To
.com
-
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com
- Original Message -
From: "Bruce, Rodney S HQISEC/Veridian IT Services"
<[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursda
brands.com]
> Sent: 07 November 2002 17:07
> To: CF-Talk
> Subject: RE: Stored proc help
>
>
> make sure that your date CFPROCPARAMS use the SQLDATESTAMP type and use
> CreateODBCDateTime(your date). i get this often on date formats
>
> -Original Message-
> From:
Hello all
I am trying to create a table on the fly in Access
I have:
CREATE TABLE #newname# ( res_name text, proj_name text, HOURS
number, TASK_NAME text, WORK_DAY datetime)
Which works, but I need the number field to be decimal, currently it
defaults to double and rounds the n
Janine
one question: would the goals be the same for all the students?
I would go with 3 tables
1. Student info
2. Goal info
3. link table with fk from student/goal tables and comments(grades)
something like
Table1
Studentid StudentName
Table2
Goalid GoalName
Table3
Studen
Hello all
Sorry I know it is probably in the archives, but my search logic is
not working.
We are having an issue with the ColdFusion Service Stopping and
Starting. But the messages in the event logs don't give details, just say
that the service has been stopped/Started.
te http://www.webapper.com
Downey CA Office
562.243.6255
AIM - webappermb
Web Application Specialists
-Original Message-
From: Bruce, Rodney S HQISEC/Veridian IT Services
[mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 9:20 AM
To: CF-Talk
Subject: CF Service Starting/Stopping
Jochem
thanks for info
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 12:42 PM
To: CF-Talk
Subject: Re: CF Service Starting/Stopping
Bruce, Rodney S HQISEC/Veridian IT Services wrote:
>
> and many of the following &qu
being closed (from MS KB).
no real details
Thanks
-Original Message-
From: Bruce, Rodney S HQISEC/Veridian IT Services
[mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 1:06 PM
To: CF-Talk
Subject: RE: CF Service Starting/Stopping
Jochem
thanks for info
-Original
sorry did a bad cut and paste below
the error reads:
Error number 232 occurred while attempting to write the reply to the web
server.
-Original Message-
From: Bruce, Rodney S HQISEC/Veridian IT Services
[mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 3:02 PM
To: CF-Talk
er
Blog http://www.webapper.net
Web site http://www.webapper.com
Downey CA Office
562.243.6255
AIM - webappermb
Web Application Specialists
-Original Message-----
From: Bruce, Rodney S HQISEC/Veridian IT Services
[mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 2:05 PM
To: CF-Talk
S
This is something I have used, with a little JS to reset the or
input box
just doing a quick type, so sorry for any typos.
Select
option
#text#
Then on the action p
hi all
Does anyone have any experience with ODBC Data Source [Merant dBase/FoxPro
Driver] in CF admin?
I haven't used it before and cant seem to find any examples.
I have tried the simple queries:
SELECT STATION, ORG_ELMT
FROM t16101;
DELETE t16101.*
FROM t161
Have you tried:
checked>
or
checked>
-Original Message-
From: Kennerly, Rick H CIV [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 27, 2003 11:39 AM
To: CF-Talk
Subject: RE: Dynamic Insert/Update - Still not working
Have you tried a bit of logic like:
checked>
Rick
~~~
Ignore my last msg, miss read this one
-Original Message-
From: Kennerly, Rick H CIV [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 27, 2003 11:39 AM
To: CF-Talk
Subject: RE: Dynamic Insert/Update - Still not working
Have you tried a bit of logic like:
checked>
Rick
~~~
Hoping someone might be able to shed some light on an issue we are having
with files in a directory not processing the
Application.cfm file.
There is no code in the Application the file to redirect. we even just made
it display "application for this dir".
But some files fill not process it and w
Give them the same name with different values
Yes
No
-Original Message-
From: FlashGuy [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 11, 2003 1:23 PM
To: CF-Talk
Subject: Yes
No
Currently I can click on both the "yes" and "no" and they both get selected.
I don't want tha
Simple check out the symbol on 9
that is the one that will come up, and it changes everytime.
you will see that same symbol on any number you end up with.
-Original Message-
From: sebastian palmigiani [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 11, 2003 2:32 PM
To: CF-Talk
Subject:
Hi
I have a page that uses to invoke an excel object.
It was working before, now I am getting this error.
Error trying to create object specified in the tag.
COM error 0x800401F3. Invalid class string
The error occurred while processing an element with a general identifier of
(CFOBJECT), o
Thane
You might want to look into Fusionscript at www.fusionscript.com
With this you can do calls back to the database without refreshing your
page.
This is an example of a FS function:
">
Dept2
oops, maybe I read your post wrong.
If you are looking at setting all the selects to the same option try
something like this:
Don't know how you have your selects named now but if they are in order
like:
MySelect1 OnChange="resetlists(1)"
MySelect2 OnChange="resetlists(2)"
MySelect3 OnChange="r
Hello all
Hope someone can help with a problem I am having calling excel.
This code was working. I ran it a number of times. I then made changes to
the page. Nothing to change the call, I just added a few lines to display
information from another query. even undid all the changes and it still
-Original Message-
From: Bruce, Rodney S HQISEC/Veridian IT Services
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 22, 2003 11:51 AM
To: CF-Talk
Subject: CFOBJECT to Excel
Hello all
Hope someone can help with a problem I am having calling excel.
This code was
Is everyone stumped??
-Original Message-
From: "Bruce>,Rodney S HQISEC/Veridian IT Services"
<[EMAIL PROTECTED] [mailto:"Bruce>,Rodney S HQISEC/Veridian
IT Services" <[EMAIL PROTECTED]]
Sent: Tuesday, January 28, 2003 11:45 AM
To: CF-Talk
Subject: Us
Guess that would all depend on what you are trying to do?
are you trying to read from a spreadsheet into a CF page?
Do you have these numbers in a query output and just need to reproduce the
formula in your CF page?
Could use a little more detail ;o)
-Original Message-
From: Jillian Ca
you can look here and see if its any help
http://www.cfcomet.com/excel/
-Original Message-
From: Jillian Carroll [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 31, 2003 1:17 PM
To: CF-Talk
Subject: Excel 'Lookup' Function
I'm really stumped here.
Can anybody tell me how to turn thi
Hi all
I am trying to remove commas from numbers being inputted by user like 3,333
changed to .
This works:
tempstring = tempstring.replace(/[^0-9]/g,"");
but it removes periods 3.33, which I want to keep.
so I tried:
tempstring = tempstring.replace(/^\.[^0-9]/g,"");
but this doesn't
Thanks
That worked.
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 21, 2003 10:23 AM
To: CF-Talk
Subject: Re: numbers only
Bruce, Rodney S HQISEC/Veridian IT Services wrote:
>
> I am trying to remove commas from numbers being input
not as good ;o)
but good
[EMAIL PROTECTED]
http://groups.yahoo.com/group/JS-Jive
-Original Message-
From: Greg McDaniel [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 21, 2003 10:29 AM
To: CF-Talk
Subject: OT: Javascript List?
Could someone please recommend a Javascript List that i
on the same side ;o)
My ratings:
Economic Left/Right: -5.62
Authoritarian/Libertarian: -2.51
Right about were Gandhi is.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, February 24, 2003 1:31 PM
To: CF-Talk
Subject: political leanings test
http://www
Hi all
We are just starting to work with CACs.
We found the below code in ASP, but so far nothing for CF.
We can get this to work, but would like it in CF if possible.
There seems to be three parts to the CACs:
Encryption Certificate
USERNAME-Identity
Signature Certificate
And this code onl
ArrayClear(LoginArray[ArrayRows] )
If I remember correctly a 2d arrray is just an array of arrays so this
should work.
-Original Message-
From: Matt Robertson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 10, 2003 2:50 PM
To: CF-Talk
Subject: ArrayDeleteAt for a 2d array?
How do you loo
sorry this will leave the array row there, but empty.
works better with
ArrayDeleteAt( LoginArray,ArrayRows)
which will completely take that row out of the array
-Original Message-
From: Bruce, Rodney S HQISEC/Veridian IT Services
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 10, 2003 3
Hi all
Is there a way when using to get CF to drop the mail into a
diffrent dir then ../mail/spool?
Thanks
Rodney
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.co
-
From: Bruce, Rodney S HQISEC/Veridian IT Services
[mailto:[EMAIL PROTECTED]
Sent: Friday, June 27, 2003 2:16 PM
To: CF-Talk
Subject: CFMail
Hi all
Is there a way when using to get CF to drop the mail into a
diffrent dir then ../mail/spool?
Thanks
Rodney
a spool dir inside of it (ie: don't
point it straight to another spool dir, but to a dir with spool dir
inside it).
~~
Stephenie Hamilton
Macromedia Certified ColdFusion Professional
CFXHosting
-Original Message-----
From: Bruce, Rodney S HQISEC/Veridian IT Services
[mailto:[EMAIL
Hi all
We are finally tring to upgrate from Access to SQL 2000.
I am working on making the necessary changes to the queries.
One I am having a problem with is were the WHERE statement is:
WHERE (proj_name = '#Qgetinfo.proj_name# ') and(datepart('M',work_day) =#m#)
m=number for the month: m=5.
always seem to miss the simple stuff.
removing the ' worked.
Thanks for the help
Rodney
-Original Message-
From: Bruce, Rodney S HQISEC/Veridian IT Services
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 22, 2003 3:10 PM
To: CF-Talk
Subject: SQL help
Hi all
We are finally tri
Was in the Army and lived a total of 9 yrs in Europe. I loved it.
3 in Germany and 6 in Netherlands.
Wish I could have spent more time there.
Would recommend it to anyone that can live on food other than American Pizza
and Cheeseburgers ;o)
-Original Message-
From: Kris Pilles [mailto:[
That is why I did specify American Pizza ;o)
and the beef is just different not better or worse just different
-Original Message-
From: Massimo Foti [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 17, 2003 9:21 AM
To: CF-Talk
Subject: Re: advice
> Would recommend it to anyone th
I had a similar issue, but quite as bad, but an MS access db would grow to
2GB in about a week or less depending on the activity.
I solved (if you call it that) the issue by doing an automatice compression
of the db everynight.
Let me know and I will email you the code off list.
I got the orig
Ben
If I understand correctly you want to delete the column in the excel
worksheet before you change it to a csv file.
Below code does this thru a com object.
Haven't played around with it much but this will delete a column from an
excel worksheet.
oops ;o)
cut and paste will get me everytime
in previous email part of the code I sent was:
objSheet = objSheets.Item("wptotals");
wptotals = Your Worksheet name.
~|
Message: http://www.houseoffusion.com/lists.cfm?link=i:4:
Here is a good link to get more information about working with excel
http://www.cfcomet.com/excel/
-Original Message-
From: Ben Densmore [mailto:[EMAIL PROTECTED]
Sent: Monday, September 22, 2003 1:54 PM
To: CF-Talk
Subject: RE: Stripping out columns in Excel
Yeah Tony,
I was tryin
Select *
into Newtable
From Oldtable
workings when ran in ACCESS 2000
-Original Message-
From: Ketan Patel [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 07, 2004 1:34 PM
To: CF-Talk
Subject: access table backup question
Hi All,
I want to backup couple of access tables eve
if the below example holds true for all lines you could:
(assuming there are LF and/or CR at then end of each line).
if no LF and/or CR looks like you could use the date to know when each new
line starts.
Grab the first 6 elements of each line(below they are consistent:
date;code;lib;value1;valu
This is only one way of doing it, may not be the most efficient, but should
work,
---Assumes that record number
is with location not person---
do same for next 4 elements--
---sets array to hold
structur
t position 1 in dimension 1 of object "PERSONNEL" cannot
be found. That dimension of the object is empty. Please, modify the index
_expression_"
Should I use Struct functions to display ?
-----Message d'origine-
De : Bruce, Rodney S HQISEC/Veridian IT Services
[mailto:[EM
x
_expression_"
Should I use Struct functions to display ?
-----Message d'origine-
De : Bruce, Rodney S HQISEC/Veridian IT Services
[mailto:[EMAIL PROTECTED]
Envoyé : mercredi 21 janvier 2004 17:15
À : CF-Talk
Objet : RE: txt file which lines don't have the same length
This is
HI all
Can't figue out why I am getting this error:
Parameter 1 of function IsDefined which is now "QGetProjects.PROJ_NAME[2]"
must be a syntactically valid variable name
It is used in this if statement:
(QGetProjects.PROJ_NAME[Records] EQ QGetProjects.PROJ_NAME[Records+1])>
If I t
PROJ_NAME[Records+1])>
Cheers,
barneyb
> -Original Message-
> From: Bruce, Rodney S HQISEC/Veridian IT Services
> [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 03, 2004 3:03 PM
> To: CF-Talk
> Subject: Isdefined Issue
>
> HI all
>
> Can't
Hi all
I need some help with a query that supplies a report.
The issue for me is one of the tables: (simplified)
Table
UID Name Description Parent Project_id
This table contains different information in the same field (name),like the
projects status (Initializing, Engineering, etc
plied and forwarded this to that list in an
effort to get it over to "the SQL people". They're really great at this sort
of stuff, and you might get a faster, better response from it.
Have at it, "SQL people".
- Original Message -
From: "Bruce, Rodney S H
ay to handle status. I always
have a status field - either an int or a small character field and use a
constraint
('open','closed','pending') and always be assured of a proper status.
-Mark
gets me projects that are closed as well as open
-Original Message---
Using MS SQL 2000, and have used subqueries with it before.
But think the best option so far might be the NOT LIKE suggtion by Mark.
Thanks for this option also, need to play with all of them and see what I
get.
This DB is just sooo screwed up, that its turning my brain to mush.
Thanks
Jochem
your suggested query below returns 0 records, becuase the field will never
contain all three at the same time in the same record. the table looks
something like this:
(example only ;o)
UID NameDescription Parent
Proj_ID
1 Status
: Wednesday, March 10, 2004 9:03 AM
To: CF-Talk
Subject: RE: SQL Help
Bruce, Rodney S HQISEC/Veridian IT Services wrote:
>
> your suggested query below returns 0 records, becuase the field will
> never contain all three at the same time in the same record.
That is not the test being done.
&g
I am doing all of this in the Query Analyzer, trying to create a stored
procedure.
Any ideas
Thanks
Rodney
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 10, 2004 9:03 AM
To: CF-Talk
Subject: RE: SQL Help
Bruce, Rodney S HQISEC/Veridian IT
Same here.
at least with CF5, from the Help :
BM_1410542
Attribute
BM_1410544Description
BM_1410546source
BM_1410548Required. The full pathname of the file to move.
BM_1410550destination
BM_1410552Required. The full pathname of the directory or full
pathname of the file to which the file will
Jochem
with minor changes, I got the query to work.
Thanks everyone for the suggections and help
Rodney
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 10, 2004 4:21 PM
To: CF-Talk
Subject: Re: SQL Help
Bruce, Rodney S HQISEC/Veridian
This seems to be similar to something I just did.
With help from this list I ended up creating a Stored Procedure, placing
the information in multiple temp tables then joining the temp tables.
Something like:
SELECT
OPPORTUNITY_ID AS C1,
TEXT_TYPE_ID AS C2,
OPPORTUNITY_TEXT_DATA AS C3
into T
Hi all
Hope someone can help me with this:
How can I tell a SP to query a different dbs inside of a SP?
I need to be able to run some queries on one db and within that same SP run
queries on another db.
IS this possible? Or will I need to do two different SP one in each db and
a temp table to
Yes for MS SQL 2K
its: db1..tbl
Thanks for the help
Rodney
-Original Message-
From: Smith, Matthew P -CONT(CSC) [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 10:40 AM
To: CF-Talk
Subject: RE: SQL SP
Isn't it "..", as in
SELECT tb1.id, tb2.name
FROM db1..table1 tb1, db2
use to read the file into a variable.
Use LEN(trim(yourvar)) to see if the file is empty.
Then use the list functions to break it up into the data elements to be
entered into your database.
use listlen() to determine how many elements then loop thru the list using
listgetat() to pull
Hi all
Was wondering if anyone has tried this or has information.
They want to use the already built Access front end (menus/forms/reports)
application.
But they want to use MS SQL.
I know that tables can be linked from MS SQL to Access, which gets the
information to the front end applicat
Hi all
I know I have seen threads about giving the user a warning that their
session is about to timeout and possibly giving them the option to reset the
timer, but I am not having any luck finding the threads in the archives.
any help would be appreciated.
Thanks
Rodney
[Todays Threads]
[Thi
Hi all
I know I have seen threads about giving the user a warning that their
session is about to timeout and possibly giving them the option to reset the
timer, but I am not having any luck finding the threads in the archives.
any help would be appreciated.
Thanks
Rodney
[Todays Threads]
[Thi
> HI all
>
> I am just starting to use CSS.
>
> I want to replace a table I am using to display information with a CSS.
>
> The biggest issue I am having so far is that I cant get the s with
> the data in them to all change size to match each other.
>
>
> ie:
>
> If all s only have a single
Got curious so ran the loop with a little mod, added a just to
watch.
Lap #x#
currently up to 2,563,324 and still going.
-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED]
Sent: Friday, April 16, 2004 8:58 AM
To: CF-Talk
Subject: Re: cfloop
looks consistent. I
FYI, running CF5 on WIN2K box with 1 Gig RAM
-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED]
Sent: Friday, April 16, 2004 8:58 AM
To: CF-Talk
Subject: Re: cfloop
looks consistent. I ran Ray's loop and it stopped (no error) at 36799.
This was on MX. On CF 5, I do g
up to 12 signed the quess book will try others tomorrow.
Is kind of fun
-Original Message-
From: Marlon Moyer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 21, 2004 3:10 PM
To: CF-Talk
Subject: RE: A lesson in security by obscurity...
Darn it! I'm not getting any work done now! I'
77 matches
Mail list logo