Does anyone know of a component or dll built for cf that would allow one to monitor services on network servers?
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
I know that, I am running that code in a stored procedure. What I want to know is how do I put correct information in the code to accept a domain id and pass.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
there. I put evaluate around
the value and it says there is an error near the @ symbol. This works
fine on my insert but fails on the update.
Please Help
Joshua Tipton
~|
Archives: http://www.houseoffusion.com/cf_lists
http://www.mydatavault.net/
CF in medical field
On Mon, 16 Dec 2002, "Oliver Cookson" wrote:
>
>
> >>Can anyone provide specific links. press releases,
> information
> >>regarding the security plus's / minuses and again -
> the success rate of
> >>Cold Fusions implementation on large scale,
Make sure you have sql authentication turned on on your sql server.
-Original Message-
From: Haggerty, Mike [mailto:MHaggerty@;mbda.gov]
Sent: Monday, November 04, 2002 4:15 PM
To: CF-Talk
Subject: RE: Running ASP on a server used for CF
Here's what Microsoft says about the issue:
http:
OpenButton1 plus the projected. Please help. Below is
the code that I was trying to use without success.
Joshua Tipton
window.opener.document.OpenButton1#projectid#.click();
~|
Archives: http
where emp_nr not like
'00%'))
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 15, 2002 8:53 AM
To: CF-Talk
Subject: Re: SQL HELP
Joshua Tipton wrote:
> For some unknown reason this query does not work correctly even though
the field values - change
to an int and see what hapens
-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: 15 October 2002 13:52
To: CF-Talk
Subject: RE: SQL HELP
Both char(10) I can change them to int is you think it would make a
difference.
-Original Message
Solutions
www.navtrak.net
410.548.2337
-Original Message-----
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 15, 2002 8:40 AM
To: CF-Talk
Subject: SQL HELP
For some unknown reason this query does not work correctly even though I
know that there is data in temptbljobevl that does
WHERE SYS_EMP_ID_NR NOT IN
(SELECT emp_id_nr
FROM tblemployee)
.tony
Tony Weeg
Senior Web Developer
Information System Design
Navtrak, Inc.
Fleet Management Solutions
www.navtrak.net
410.548.2337
-Original Message-
From: Joshua T
For some unknown reason this query does not work correctly even though I
know that there is data in temptbljobevl that does not match tblemployee
data. Can someone please help me do this via a join.
Thanks,
Joshua Tipton
SELECT *
FROM temptblJOBEVL
WHERE (SYS_EMP_ID_NR NOT IN
desc is a reserved word [desc] is okay.
Joshua Tipton
-Original Message-
From: Les Irvin [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 14, 2002 2:35 PM
To: CF-Talk
Subject: sql for creating access memo field?
Can anyone tell me the sql for creating a memo field in a table (Access
I would like to create an id that can only login in to enterprise manager
and run dts pacakges is this possible? SQL 7.0.
Thanks,
Joshua Tipton
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Red hat 8.0 free support = 0
XP Upgrade 160.00 support = Yes within 30 days of purchase
-Original Message-
From: Robertson-Ravo, Neil (REC)
[mailto:[EMAIL PROTECTED]]
Sent: Friday, October 04, 2002 12:05 PM
To: CF-Talk
Subject: RE: RE: Cumulative Patch for SQL Server (Q316333) Crtical for
hash
-Original Message-
From: Casey C Cook [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 30, 2002 12:53 PM
To: CF-Talk
Subject: SQL command - data encryption
Hello -
I was just looking for confirmation that a command in SQL does not exist
that will encrypt data while inserting or
I do not know if this may be the underlying cause of the error but I do know
that if sql is your database you cannot use timestamp as the datatype when
you are passing in a date time field. It has to be CF_SQL_DATE. There was
a disscusion about this on here last week but I think the person havi
run it all in a dts package truncate the table and then use bcp to import
the csv file.
-Original Message-
From: Chad [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 25, 2002 10:37 AM
To: CF-Talk
Subject: Mass Database update
We have a client that wants to drop a database table an
What database platform and what version of cf?
-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 24, 2002 5:55 PM
To: CF-Talk
Subject: OT: Can't use UNION
I am putting together an application and I canot use UNION, here is my query
that I have
There is a cf_postit tag on dev exchange
-Original Message-
From: Matthew Friedman [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 20, 2002 5:43 PM
To: CF-Talk
Subject: RE: Post it like notes.
if you are looking at the dhtml version, check out dynamicdrive.com they
have some great stuf
What are vtm files and what do I do with them?
Josh
__
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www
UP BY s.state, l.lab_name
#qr_states.state#
#qr_states.lab_name#
Good Luck
Paul Giesenhagen
QuillDesign
- Original Message -
From: "Joshua Tipton" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, July 23, 2002 9:10 PM
Subjec
Okay I fell stupid asking this because I have accomplished this many
times I just cant rememeber tonight.
SELECT PK_tblSTATEID, State
FROM dbo.tblSTATE
SELECT FK_tblSTATEID, Lab_Name, Lab_City, Lap_Phone
FROM tblLABS
wherefk_tblSTATEID
I am running cf 5 and when I use the following cf content around my code
all that is returned is a page formatted for excel. Why does it not ask
me to download the file or open the file in excel on my machine?
Josh
__
Search ebay there is so many .coms that are going under it is hard to
build a good server cheaper than what you can get one of the pre built
dell or Compaq servers. I just bought a dell 2500 dual p3 1.4, 1gig
ram, 5 36 gig scsi drives, 2 network cards, triple redundant power
supplies, and a 40/80
On my page layout I would like every other row in the table to be a
blank row. Does anyone have any idea how to do this. I am working with
mod 2 trying to figure it out.
Joshua Tipton
__
Structure your ColdFusion code
Has anyone ever used this and if so please contact me off list. I need
some instructional help.
Thanks,
Josh
__
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkin
Does anyone know how to create a button that looks like the xp start
button with the curves besides using a graphic?
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion H
The first line of your xml page or whatever you are passing has its
designation ie mailto:[EMAIL PROTECTED]]
Sent: Friday, July 05, 2002 6:12 PM
To: CF-Talk
Subject: WDDX related
Anyone know what this is all about:
WDDX packet parse error at line 1, column -1.. Invalid date string
2-11-30T0:0:
Could be long and painful.
I have built and transferred many servers using this and have had zero
problems.
Joshua Tipton
-Original Message-
From: Brian J. LeRoux [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 05, 2002 5:07 PM
To: CF-Talk
Subject: RE: Migrating sqlservers
whoa
the database from that server have that also sent
to you. First try to restore the full backup if the does not work then
use sp_attachdb on the new server.
Joshua Tipton
-Original Message-
From: Brian J. LeRoux [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 05, 2002 3:36 PM
To: CF-Talk
another website connecting to the same server with no problems.
Thanks
Thanh
-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 02, 2002 4:23 PM
To: CF-Talk
Subject: RE: ODBC Error Code = 08001
That error could also be caused by an over worked sql server
Dts should pull it in no prob
-Original Message-
From: Seamus Campbell [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 02, 2002 7:42 PM
To: CF-Talk
Subject: parsing question
Hi
I hope someone can help me.
I have a txt file (copy of a small portion of it below) that I need to
be
able to
That error could also be caused by an over worked sql server and because
that query processor cannot grab the query string then the cf server
thinks that either the sql server is not running or access was denied.
Josh
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
S
If it only happens every now and again sounds like you have some
problems with your SQL Server. You probably need to either, run a trace
on the database for the entire day, then run index wizard using the
trace file that you created to create some good indexes on your
database.
Joshua Tipton
Run a trace on that db saving the trace data to a file while you run your app then run
the index tunning wizard
-Original Message-
To: CF-Talk <[EMAIL PROTECTED]>
From: Jochem van Dieten <[EMAIL PROTECTED]>
Subject: Re: Need to optimise query performance
Date: Wed, 26 Jun 2002 13:44:39
I do not know if someone already said this or not but when you open an
access db it creates an ldb file that might be kinda hard on a cd.
Josh
-Original Message-
From: Digital Internet Limited [mailto:[EMAIL PROTECTED]]
Sent: Sunday, January 02, 2000 8:32 AM
To: CF-Talk
Subject: Re: Acc
Thanks for the clarification. I can see clearly now that the rain is gone.
Josh
-Original Message-
From: Kevin Miller [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 18, 2002 3:28 PM
To: CF-Talk
Subject: RE: Getting to an Access DB on a remote machine
NetBEUI is non-routable. NetBIOS
I may be wrong and have been befoer but I was always told that netbios is a
non-routable protocal
-Original Message-
From: Kevin Miller [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 18, 2002 3:19 PM
To: CF-Talk
Subject: RE: Getting to an Access DB on a remote machine
In order for this
To backup all databases use a database maintenance plan to backup them
up to the local server then have it run a script on completion to copy
the files to the other server then when that job is finished have it run
the restore of the databases.
Joshua Tipton
-Original Message-
From
the outlook question and I have seen you lash out at others. This
is a list to help not slam let's try to keep it that way.
Joshua Tipton
-Original Message-
From: Costas Piliotis [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 10, 2002 4:02 PM
To: CF-Talk
Subject: RE: Pez convention
Having to use unfortunate frames for one small part and it messes
everything up when you resize the screen. Thanks for your help it
worked.
Joshua Tipton
-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 14, 2002 11:04 PM
To: CF-Talk
Subject: Re
reload();
This is a shot in the dark on my part. I would like for the page to reload
if the user resizes the screen in any way. Please help.
Joshua Tipton
__
This list and
on the cf server process the
form and send out the results. I do this all the time on little surveys and
have never had a problem. Your problem is that outlook has no Idea what
is and does not process it.
If you have any questions contact me off list.
Joshua Tipton
-Original Message
I think that the cards have to be the same.
Josh
-Original Message-
From: Jason Miller [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 13, 2002 11:18 PM
To: CF-Talk
Subject: Re: WOT: Dual Display
I have my dual monitors running of my single card.. but when a monitor
went down I was h
If its 2000 I would boot into safe mode so hopefully if something has a hold
on that key it will let go.
Josh
-Original Message-
From: Steven Dworman [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 13, 2002 3:45 PM
To: CF-Talk
Subject: Re: registry error
it's not in the odbc datasource
How long ago did you change this sometimes it will take up to 24 hours to
propogate around the world.
Josh
-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 13, 2002 3:30 PM
To: CF-Talk
Subject: RE: DNS Havoc!!
I'm getting the nw IP from both
data (SOLVED)
Thanks Joshua, that worked like a charm.
-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 13, 2002 1:45 PM
To: CF-Talk
Subject: RE: Access to SQL discrepancy in transfer of data
select fullname, role
from
select fullname, role
fromdbo.tbl_users
where role = (select 'key_' + '' + role as keyrole
from dbo.tbl_users
where username = '#session.username#')
-Original Message-
From: James Taavon [mailt
.
Do I then get the SQL agent, on top of that?
Sorry to put these questions here but this is all a little new to me...
-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 12, 2002 1:22 PM
To: CF-Talk
Subject: RE: Backups II, the Sequel
On a daily basis
or tree
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 12, 2002 4:15 PM
To: CF-Talk
Subject: Re: web directory reporting tool
Not sure of exactly what you need, but you can get a text file listing using
windows built in tools.
Open a dos com
On a daily basis we have what we call an online back where we allow sql to
backup to the local drive then we backup those files. We then on sunday
stop the sql service and backup the entire server. On critical servers we
do the same with the exception of an online backup in which we use the
veri
Either that or you can set the user ID that that datasource uses to a
different default database instead of master.
In ODBC if you leave default database blank than it will default to the
default database that the user id has rights to.
Josh
-Original Message-
From: [EMAIL PROTECTED] [m
I fill like a nimrod I am going home I am tired.
Josh
-Original Message-
From: Patric Stumpe [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 12, 2002 11:42 AM
To: CF-Talk
Subject: Re: iif driving me nuts
Hi Joshua,
you could also use a simple (perhaps faster cfif-statement like this:
pment :: Programming
Eagle Web Development LLC
www.eaglewd.com
[EMAIL PROTECTED]
(304) 622-5676 (Clarksburg Office)
(304) 456-4942 (Home Office)
-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 12, 2002 11:23 AM
To: CF-Talk
Subject: RE: DB Table N
Please help me with this or can you guys and gals tell me a better way to
code this. Of course the phrases will be changed but this will give you the
basic concept.
Josh
#iif((qryquicklinks.recordcount gte 8), DE("onClick='alert("Sorry, you
suck")';"), DE("onClick='alert("You Deleted Me")';"))#
MS says that only system stored procedures should start with sp becasue when
sql recieves a stored proc with sp_ it looks in the master system stored
procedures first then looks in the current database. I doubt the speed
difference is that much but just a tidbit of my two cents.
Josh
Many of
Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 11, 2002 10:39 AM
To: CF-Talk
Subject: RE: Outlook Calendar
Actually I found a tag look for cf_outlook in MM Exchange pulls the data
CLIENT side from OUTLOOK on the CLIENT machine.
Josh
-Original Message-
From
here, or conversely the client has to upload
their calendar somehow, like through an ActiveX control or a Java Applet.
Imagine the damage one could do if a web server could access a client's
outlook mailbox.
-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Monday
I would like a custom tag or some code to import some ones outlook
calendar from his or her machine and show it on the screen for any
particular day.
Josh
__
Structure your ColdFusion code with Fusebox. Get the official
Use cfcontent if you can output it to excel then import into access.
-Original Message-
From: Allen Hudson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 06, 2002 1:16 PM
To: CF-Talk
Subject: DB Compatibility Sybase SQL Anywhere
A colleague has a situation that I am sure has crossed th
Using the FSO I would like to get the last modified date of a file. Can
anyone help me?
Josh
__
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.th
I run sql 7x on my xp pro machine.
Josh
-Original Message-
From: Peter Tilbrook [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 05, 2002 5:20 AM
To: CF-Talk
Subject: SOT: recommendations for AV software (Win2K Advanced Server)
Short of a re-install, my Norton AV software has ceased to
select sum(column) as sumofcolumn
from table
-Original Message-
From: Kris Pilles [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 03, 2002 2:48 PM
To: CF-Talk
Subject: Sum Help
Ok.. I;ve got myself confused here...
I have a table that has some numbers lets say 5 records (50, 45, 33, 23,
dim mydate, mytime, timedate, final
set mydate = date
set mytime = time
set timedate = mydate & mytime
set final = formatdatetime(timedate, 0)
Not sure if this will work pulled it out of my head and pulled the other
from a vbscript help file.
Josh
FormatDateTime Function
Returns an expression
Sorry man you need to put a div in like below. I had to go back and look at
some previous code.
Joshua Tipton
Headers for table
YourStuff
ginal Message-
From: Simon Whittaker [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 31, 2002 7:47 AM
To: CF-Talk
Subject: Re: scrolling tables
like this
style="z-index : auto;"
or have I got completely the wrong idea?
Simon
- Original Message -
From: "Joshua Tipton" &l
This should work.
Joshua Tipton
Headers for table
mailto:[EMAIL PROTECTED]]
Sent: Friday, May 31, 2002 11:04 AM
To: CF-Talk
Subject: Re: OT: scrolling tables
oi Critz!!
ok..using the example with the overflow...any idea how to line up
the
table
completely the wrong idea?
Simon
- Original Message -
From: "Joshua Tipton" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, May 31, 2002 1:05 PM
Subject: RE: scrolling tables
> Set a z-index in the style property on the table, tr,
Set a z-index in the style property on the table, tr, or td and then that
part will scroll.
Joshua Tipton
-Original Message-
From: Parker, Kevin [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 30, 2002 10:59 PM
To: CF-Talk
Subject: RE: scrolling tables
I've seen this done with bu
Put it in your custom tags directory on your server or use cfmodule.
-Original Message-
From: Brian Eckerman [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 30, 2002 11:05 AM
To: CF-Talk
Subject: Quick question on custom tags
Is it possible to call a custom tag that resides in a folder o
Put the image in the background of a table.
-Original Message-
From: LANCASTER, STEVEN M. (JSC-OL) (BAR)
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 23, 2002 12:38 PM
To: CF-Talk
Subject: dynamic image
I want to create an image and make the text on the image dynamic, but I am
not sur
Does anyone know the correct synatx to the option query hint keep plan BOL
God bless it is sometimes sparce in its explanations.
TIA,
Josh
SELECT m_id, y_id, reg_no,
SUM(CASE WHEN SLIC NOT LIKE '88%' THEN cost ELSE 0 END) AS INTCOST,
SUM(CASE WHEN SLIC LIKE '88%' THEN cost ELSE 0 END) AS exT
"1" as column name
-Original Message-
From: Ryan Pieszak [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 20, 2002 11:29 AM
To: CF-Talk
Subject: RE: OT (SQL): Add column to query?
just in the returned query
-Original Message-
From: Jerry Johnson [mailto:[EMAIL PROTECTED]]
Sent: Mon
Eventually as in the current connection or eventually as in sometime this
week?
Temp table straight out of books online
You can create local and global temporary tables. Local temporary tables are
visible only in the current session; global temporary tables are visible to
all sessions.
Prefix l
Might be dangerous
Question Is there any way to disconnect from a database programmatically?
Answer This is possible, but not recommended, especially if it is a
multi-user database. To do so, however, clear the cached connection
information with the following code:
This code flushes all conne
Does anyone know via DTS how to open a zip file so that I can attach to a
dbf file that is in the zip file?
Josh
__
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
That it was I thought but me not ever using verity before I was not sure.
Josh
-Original Message-
From: Paul Hastings [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 15, 2002 10:32 AM
To: CF-Talk
Subject: Re: Verity (was: [admin] List status)
> > Duh Verity I forgot about that. But sti
S 19 N., Ste. C
Clearwater, FL 33761
www.trxi.com
-----Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 15, 2002 10:25 AM
To: CF-Talk
Subject: Studio Problem
In Studio 5 when I try to query the help it always comes up with No matches
Found no matter what I
In Studio 5 when I try to query the help it always comes up with No matches
Found no matter what I put in. I have put in cfquery and nothing comes up.
Is there anything I can do to fix this or is a reinstall coming my way?
Joshua Tipton
Duh Verity I forgot about that. But still wouldnt the back end of sql be
alot faster than cf verity?
-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 15, 2002 10:03 AM
To: CF-Talk
Subject: RE: [admin] List status
Does mysql have full text
Does mysql have full text searching capabilities like MS SQL if not then
they would be almost pointless to use MY SQL to search through the list
archives.
Josh
-Original Message-
From: Michael Ross [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 15, 2002 9:50 AM
To: CF-Talk
Subject: RE:
look up IIF
-Original Message-
From: Ben Covington [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 15, 2002 9:00 AM
To: CF-Talk
Subject: Dropdown Box
Hello All,
When recalling a stored value that was submitted by a dropdown box, is
there a way to have the dropdown box show the chosen v
I use this code all of the time. I have changed some of the documentation
on this code so that you will know what is going on.
There are 3 primary locations DTS packages are generally loaded from:
>From SQL Server, from Storage File, or from repository. There are 3
different primary
methods
Just a thought but check the power management on your machine running sql
make sure that the hdds are not going to sleep
-Original Message-
From: Robert Everland [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 02, 2002 9:08 AM
To: CF-Talk
Subject: RE: Problem with 1st hit to MSSQL 7.0
I
Can anyone else give me any insight on this?
-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 01, 2002 12:08 PM
To: CF-Talk
Subject: RE: sql Stored Proc
I recieve an error incorrect synatx near the keyword "and".
declare @col as varcha
nal Message-
From: Costas Piliotis [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 01, 2002 12:00 PM
To: CF-Talk
Subject: RE: sql Stored Proc
You missed the word "AS" in the declare statement:
DECLARE @col AS nvarchar(30)
-Original Message-
From: Joshua Tipton [mailto:[EMAI
If the colors didnt come across the declare and set all work fine the part
that is giving me a problem is the @col when I try to use it in the query.
Does anyone know how to make this work correctly?
Joshua TIpton
-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent
The red protion works and I can output the variable my problem is the blue
highlighted part. Is it possible to create that part of the query from what
is in a variable?
CREATE PROCEDURE sp_ctmdatacorp
@corp char(4) = null,
@reg_no char(4) =null,
@dis_no char(4) =null,
@date1 varchar(4),
@date
PROTECTED]]
Sent: Wednesday, May 01, 2002 9:20 AM
To: CF-Talk
Subject: Re: sql query
All you need is the Insert() function, something like:
SSN = Insert("-", SSN, 3);
SSN = Insert("-", SSN, 6);
>>> "Joshua Tipton" <[EMAIL PROTECTED]> 05/01/02 09:14AM >&g
I would like to run an update query to take a 9 digit social security number
and place the dashes in the correct spots. IE.. 999-99-. Can anyone
help me with this?
Joshua Tipton
__
Structure your ColdFusion code with
Anyone ever seen this error
unknown exception condition
PCodeDocumentNodeImp::prepareForExecution
The error occurred while processing an element with a general identifier of
(CFINCLUDE), occupying document position (270:2) to (270:47) in the template
file E:\SER\TSG\APPS\OVERDUEDISPO\OVDCORP\CT
sp_helpdb and the db name
-Original Message-
From: Paul Hastings [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 26, 2002 12:55 AM
To: CF-Talk
Subject: Re: Get list of tables from a SQL Server DB
> Is there any way I can get the list of tables in a SQL 2000 DB
> programmatically ? I gues
I need this query to pull the reg_no, dis_no, m_id, and the y_id from
tbl_CTMCORPMONTHYEARRDD where it cannot be found in pagan table. I wrote
this query and cannot get it to work please help.
Josh
SELECT tbl_CTMCORPMONTHYEARRDD.reg_no,
tbl_CTMCORPMONTHYEARRDD.dis_no,
tbl_CTMCORPMONTHY
Can anyone help me with this???
-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 25, 2002 9:28 AM
To: CF-Talk
Subject: SQL Join/ QUERY HEADACHE problem
I have two tables that I am trying to join and it is killing me.
1st Table has the following
4 February 2001 12 15
All the way down through all of the months. I think it has something to do
with the case statement and I am hoping that someone can please help me with
this I am dying on this one. If you need to call me to ask me anyquestions
or would like me to call you I ca
Please help me, I have gotten this far and I am not having any luck.
I need to output the numbers from the sequence into a database.
CREATE SEQUENCE "DeptCodeSeq"
INCREMENT BY 20
START WITH 1000
MAXVALUE 9080
NOCYCLE;
CREATE TABLE "Departments"
("DeptCod
I have one page that is a form that will be included in a java script popup.
I was thinking about setting the page to a variable then outputting the page
into the java script popup. Can anyone help me with this one?
What I want to do:
>
Java Script Pop Up:
window.onload=function(){
new pop
DECLARE
V_DeptCode "DeptCodeSeq".nextval%type;
v_Name varchar2(30);
v_DeptSize number(5);
BEGIN
END
-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Sunday, April 21, 2002 6:59 PM
To: CF-Talk
Subject: Oracle Gurus
I would be at anyone&
DECLARE
V_DeptCode "DeptCodeSeq".nextval%type;
v_Name varchar2(30);
v_DeptSize number(5);
BEGIN
END
-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Sunday, April 21, 2002 6:59 PM
To: CF-Talk
Subject: Oracle Gurus
I would be at anyone&
I would be at anyone's mercy if they could do this for me.
1.Create a sequence DeptCodeSeq to generate dept codes in the range
1000, 1020, 1040, . .., 9080
Create table called Departments that has the following columns in it.
DeptCode
Name
DeptSize
NUMBER(4)
VARCHAR2
1 - 100 of 246 matches
Mail list logo