Hi
I am trying to use cfexecute to call SQL server from the command line.
The following command works on the command line it executes the query script
and
displays the results of the query however when i call it using cfexecute it
returns a list of parameters as if the parameters being sent are
can any body guide me how to differentiate between two images which have
same name
__
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community.
Bill Henderson wrote:
The other way to do it is to enclose all in brackets like this:
cfquery name=AddRecord datasource=andes dbtype=ODBC
INSERT INTO tunetips (title, blurb, [all])
VALUES ('#Form.title#', '#Form.blurb#', '#Form.all#');
/cfquery
That way, you don't have to rename your
Here's what ya need to do:
1) Give a direct path to your file
D:\Program Files\Microsoft SQL Server\80\Tools\Binn\cust.sql
2) Wrap your infile with quotes:
D:\Program Files\Microsoft SQL Server\80\Tools\Binn\cust.sql
3) Be sure to specify what database you are
Hi,
I am trying to create a login/logout protected area for a section of my website.
Tried the tutorial in webmonkey.com.
However, I still not too sure about the entire mechanism.
Anyone can point me to custom tags, articles, etc ?
Thanks
Nyon
Hi all. I just got done building a chat program out of Flash. It
basically works like the cheapo HTML refresh chat apps, except it
doesn't annoy you by actually refreshing the whole page. I'd like to
test it with a few users if anyone is spending Saturday just playing
and doesn't actually
Thanks everyone for stopping by. As I figured, it needs some work,
but for a first test run, not so bad.
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
Bud wrote:
Thanks everyone for stopping by. As I figured, it needs some work,
but for a first test run, not so bad.
Is this going to be a (free?) product someday? I would be interested.
Jochem
__
This list and all House of
Javascript gurus,
I thought I'd solved the textarea problem, but when I test my 'solution' in Netscape
6.1 and Netscape 4, the Javascript is completely ignored!! I don't get it.
Here's what works well in IE 5.5:
script language=JavaScript type=text/javascript!--
function replaceTA() {
Dina Hess wrote:
Javascript gurus,
I thought I'd solved the textarea problem, but when I test my 'solution' in Netscape
6.1 and Netscape 4, the Javascript is completely ignored!! I don't get it.
Here's what works well in IE 5.5:
script language=JavaScript type=text/javascript!--
Jochem,
That worked! Thanks! Here's something strange though:
This works in Netscape 6.1:
document.myform.ta.value = document.myform.ta.value.replace(/[\r\n]/g, br);
And this works in IE 5.5 and Netscape 4:
document.myform.ta.value = document.myform.ta.value.replace(/[\r\n][\r\n]/g, br);
So
BudJust a thought if you use xml, you can keep your connection open for clients
using flash 5 and XMLSocket. The down fall to doing so would be cpu usage and memory.
IE:
// Create a new XMLSocket object
sock = new XMLSocket();
// Call its connect method to establish a connection with port
File size, maybe?
-- jon
-
jon roig
senior manager, online production
epilepsy foundation
tel: 215.850.0710
site: http://www.epilepsyfoundation.org
email: [EMAIL PROTECTED]
-Original Message-
From: Abraham Lincoln [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March
Sorry, meant to say flash MX
Success is a journey, not a destination!!
Doug Brown
- Original Message -
From: Douglas Brown [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, March 23, 2002 7:51 AM
Subject: Re: Help me test Flash Chat app?
BudJust a thought if
Hi All.
Is there a software that will the given list of procs
on a database on a given server?
right now, I have to install each proc at a time on
the database. It would be much nice if all the procs
would be installed automatically if the list of the
procs would be provided.
Also, is there
On 3/23/02, Jochem van Dieten penned:
Is this going to be a (free?) product someday? I would be interested.
Close to free. :) Probably 10 bucks. Almost everyone will spend 10
bucks. :) May may a free version which limits the number of users to
10 or something.
--
Bud Schneehagen - Tropical
http://www.moock.org/unity
Colin Moock is the god father of Flash, and has already created a socket
server and client objects (.as files) for building chat applications.
Pretty insane.
I also build a chat application based on Flash Services from NEO, but I
don't think I can let you guys see it
CF_AccessMonger is one I wrote, and recently upgraded to use user names
instead of ID numbers.
You'll find boatloads of this sort of app in the Developers Exchange.
Search for password protection.
--Matt Robertson--
MSB Designs, Inc.
http://mysecretbase.com
-Original Message-
From:
Hi
i tried your suggestions:
I still get the same ouotput. THe outout I get is the same output I get if I
run it at the command line with no arguements. I added the USE database to
the file but still get the same problem.
Thanks
-Original Message-
From: Scott Van Vliet
I am not aware of the MM strategy for Flash. However,
I found Flash to be more limited, specialized, and
harder to learn than CF. If MM plan to make CF scripting
available on the desktop, I applaud them, whatever
vehicle they choose!
This paper may be of great interest:
CF Talk List
I am writing my first cold fusion stored procedure call. I
am getting an error I do not understand and do not know how
to correct. I am unable to find any information on the
error, and I am hoping somebody out there can give me a
lead. Here is the cold fusion code I am using to
CF Talk List
I am writing my first cold fusion stored procedure call. I
am getting an error I do not understand and do not know how
to correct. I am unable to find any information on the
error, and I am hoping somebody out there can give me a
lead. Here is the cold fusion code I am using to
Errr...actually my regular expression pattern was off. This works for IE 5.5, Netscape
4 and Netscape 6:
var re = /\n/g;
document.myform.ta.value = document.myform.ta.value.replace(re, br);
Of course, if you hit the back button you see all the brs so there's probabaly a
better solution out
Hi, I'm having a problem using session variables. They are set to time out
at 120 (2 hours).
However if someone does NOT close his browser and then they try to come back
to the site after a couple of hours, they get an error message.
Is there a way to flush and totally expire session variables
PROVIDER=OLEDB
if i recall, sp called via OLEDB might need to be wrapped within
a SET NOCOUNT ON/OFF block.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.325 / Virus Database: 182 - Release Date: 2/19/2002
Hi everyone.
Can anyone provide me a little direction here.
I have a query that queries the SQL DB for the main categories..
I then do a cfoutput with a query attribute set to maincats.
I get the following:
Hardware
Software
Books
Networking
Now, this is the desired results, but what I am
Problem solved..
I forgot to trim the variable... :-)
Mike
- Original Message -
From: Michael Tangorre [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, March 23, 2002 4:48 PM
Subject: CF menu and output
Hi everyone.
Can anyone provide me a little direction here.
I
I have a Database it has a date in one of the columns. I take that date and
another column in the table which is just an integer an use the DateAdd
function to come up with a second date.
I have:
date1, duedate(created from the DateAdd function), days_until_it_is_due
Now I need to give these
Pardeep,
One way you could accomplish this task is to add code like this to your
Application.cfm file.
cfif not isdefined('session.info')
cflocation url=setSessionVarsTemplate.cfm
/cfif
Any time the session information isn't available, it will send the user to a
template that you set the
For the past week or so I've been experiencing a very strange error that I've never
seen before.
Error,TID=1376,03/20/02,15:31:40,Web server provided content data when none
was expected. Data ignored.
My first inclination is that someone has somehow spoofed my page and are trying to
access
Hmmm, what if that session setting code is also in application.cfm?
So far my code looks like this in application.cfm after some thought over
the last hour.
cfif NOT isdefined('session.cid')
cfapplication name=protect
sessionmanagement=yes
sessiontimeout=#createtimespan(0,0,0,0)#
/cfif
So far my code looks like this in application.cfm after some
thought over the last hour.
cfif NOT isdefined('session.cid')
cfapplication name=protect
sessionmanagement=yes
sessiontimeout=#createtimespan(0,0,0,0)#
/cfif
cfapplication name=protect
clientmanagement=yes
I am having trouble getting it to work with my query. With my query second select
never populates. I fail to see why!
Thanks!
Here is a portion of the given sample query output:
MASTER_CAT MCODE CODE CAT FEATURED_POSTING
General Merchandise GEN GENALL All General Mdse.
I can't get the supposedly dirt-simple query below to work. Can anyone
see anything wrong with my SQL? No matter what I do I get this error:
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE
statement.
The field
Try this:
ALTER table_name
ADD COLUMN column_name column_definitions
Seamus
At 01:56 pm 24/03/02 , you wrote:
I can't get the supposedly dirt-simple query below to work. Can anyone
see anything wrong with my SQL? No matter what I do I get this error:
ODBC Error Code = 37000 (Syntax error
Nope. Same error. However I did namage to find the solution by
guesswork
ALTER TABLE settings ADD BLAH text(10) NULL;
works, and
ALTER TABLE (settings ADD BLAH text(10) NULL);
Does not. It's the surrounding parentheses. @#$%!!
Thanks for helping out,
--Matt Robertson--
MSB Designs,
In exporting data to Excel by using HTML, is there any way to force Excel
to diplay gridlines by default? I can set a border on the HTML table
created, but it only applies to the data area, not the whole worksheet.
Thanks,
Jim
Steven:
Given that business days are generally monday thru friday, you can use the
code below (where date, daysUntilDue dueDate would be values from your
database).
cfset date = now()
cfset daysUntilDue = 5
cfset dueDate = dateAdd(d, daysUntilDue, date)
cfset businessDays = 2,3,4,5,6
cfset
hmm.. think i cant do that... coz.. thats will oso return 6 yrs 7 yrs..
blah
hmm.. anyway... i think i got it... thats a datepart in sqlsever oso...
i can use datepart to chk the yr in orderdate = (current yr -5)
hope that can work.. havnt try that out...
thanx anyway pal!!: )
cheers
han
hihi.. i'm thinking of putting up a forum for a non-profitable drama organisation in
singapore for their members to interact with each other...
so anyone hav any idea i can sign up a free forum for them.?? or anyone here hosting a
free one..??
hmm.. or have any simple codes to spare..? sigh..
Every NULL Interface PTR error I've seen means you don't have an OLEDB
datasource configured correctly.
Make sure the datasource PARAGON is confingured correctly and is, indeed, an
OLEDB datasource.
-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March
41 matches
Mail list logo