Hi Toby,
is this a one-time task? If yes, I'd suggest a native mysql import, or
simply use sqlyog for that.
greetings,
marcus
Toby King schrieb:
Hi there
I have a MySQL database setup with a table called members.
Basically the structure of the table is
Memberidvarchar 25
Firstname
schrieb:
Hi there
I have a MySQL database setup with a table called members.
Basically the structure of the table is
Memberidvarchar 25
--
Mit freundlichen Grüßen,
Marcus Raphelt
at.net websolutions
Mühlenbeck Raphelt GbR
Klever Str. 60
47839 Krefeld
Tel.: 02151 / 3699732
Fax
* weak at (sadly).
as far as the cf part is concerned: you can use two loops for that. one
to loop over the list of elements divided by line breaks (13/10), one
inner loop that uses chr#9 as delimiter.
bye,
marcus
Rick Faircloth schrieb:
Hi, all...
I've got a text file that I'm trying
Hi Jim,
the filename attribute requires an absolute system path, you might try
expandpath().
bye,
marcus
Jim Gabler schrieb:
cfreport
filename=http://dtsc-dev/temp/SBA_Temp.pdf;
format = PDF
template =
c:\\inetpub\wwwroot\Database\Military_Billings\CFR_Templates\SBA.cfr
Hi Brad,
good idea - I'll give SeeFusion a try.
Nevertheless, I wonder if that will solve the font size problem...
bye,
marcus
Brad Wood schrieb:
It looks like you need to find out what your server is doing during those 10
minutes. I would recommend installing SeeFusion or Fusion-Reactor
the report in HTML format and convert it
to SWF via cfdocument. The resulting HTML file is extremely large, I
stopped the request as it reached 5GB (yes, gigabytes again).
Any ideas, anyone? ;-)
bye,
marcus
Brad Wood schrieb:
I hate to be pessimistic, but your font problem has a good chance
internally that way - generating HTML and
converting it to SWF afterwards? That'd be weird. ;-)
bye,
marcus
Brad Wood schrieb:
Wow, that's a lot of data. I'm curious if you look in the temp file while
creating the HTML version what you would see.
It sounds like and endless loop or something
issues yet?
System: SLES10, 32bit, Apache2, CF7 / CF8
--
Mit freundlichen Grüßen,
Marcus Raphelt
at.net websolutions
Mühlenbeck Raphelt GbR
Klever Str. 60
47839 Krefeld
Tel.: 02151 / 3699732
Fax : 02151 / 3699734
Mob.: 0151 / 58113803
mailto: [EMAIL PROTECTED]
http://www.atnet-websolutions.de
Hi,
as far as I can remember, we solved this in a CF7 project by pointing to
images using file:///-Links.
Not very elegant, but it worked.
bye,
marcus
Robert Rawlins schrieb:
Does anyone know a work around for this? I'm sure it's something some of you
have come across in the past
- mysql behaves like that by intention.
bye,
marcus
Rick Faircloth schrieb:
Hi, all...
I've just moved a website from a server running MySQL 4.1 to
a server running MySQL 5 and now this query is giving me problems.
The program was built years ago and has been running without problem
until I
to reconfigure the server...
bye,
marcus
Chad Gray schrieb:
Hello, I am using CFMail to send an email and if one of the email addresses
in the TO attribute does not exists then no one in the TO attribute gets the
email. It sits in the undelivered folder.
Error,scheduler-5,09/08/08,10:17:32
trial (downloaded a few days ago)
Ideas, anyone? ;)
bye,
marcus
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive
Try:
cfexecute name=c:\windows\system32\cmd.exe
arguments=c:\test.bat
outputfile=c:\output.txt /
Jochem
Thanks for the reply. I tried it and it doesn't work. It doesn't output
anything in the file either.
Marcus
Is CF logged in as a service or a user?
Thanks for the reply. I tried it and it doesn't work. It doesn't output
anything in the file either.
Marcus
A service.
~|
Adobe® ColdFusion® 8 software 8 is the most important
I have a very simple batch file
Don't forget that the default directory used by the bat file is not the
one the bat file resides,
but the on from which it is run. In this occurrence, it is the CF directory.
Then you may have to set the working directory from inside the bat file
itself.
--
Did you try it logged in as Admin?
A service.
Yes, i am the admin.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
One thing i have noticed is that the output file has a line break before and
after the actual command output. I don't think this would make a difference,
but I guess you never know.
~|
Adobe® ColdFusion® 8 software 8 is the
I have a very simple batch file that i can run fine on its own, but can't seem
to get it to work using cfexecute. I used cfexecute a couple years ago and had
no problems, but i can't seem to get it to work with this particular batch
file. The cfexecute code is very simple...cfexecute
I'm working with some java classes provided by a third party. The class
requires an HTTP servlet request object be sent. Within that request, the
class looks for url parameters via the HTTP Servlet Request. The following
code is what I'm using currently...
cfscript
SearchLogic =
that will allow
it to be installed.
thanks,
Marcus.
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240489
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com
it to display like that on
page load by default.
I thought i'd set all the meta tags and encoding correctly, but I have to be
missing something.
Thanks in advance,
Marcus.
~|
Message: http://www.houseoffusion.com/lists.cfm/link
.
Is this a known issue? Is there a workaround for it?
thanks,
Marcus.
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231223
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com
on the same ACTD.
Any ideas?
The PCS Center, LLC
State Communications
Bill Marcus
VP of Technology
tel: 864-881-4636 x201
fax: 864-688-1035
Click here to add me to your address book...
https://www.plaxo.com/add_me?u=34360659627v0=1837430k0=1294341585
http://www.plaxo.com/signature
This is what I added in the Application.cfm
!-- Control of the user's lastVisit ---
cfif session.intLoggedIn EQ 1
cfif NOT isdefined('session.myLastVisit')
cfquery datasource=#dsn# name=qGetUserInfo
SELECT dtLastAccessed FROM tblForumUsers WHERE
Thanks for all help.
I solved it now with this code:
cfif session.intLoggedIn EQ 1
cfif NOT isdefined('session.myLastVisit')
cfquery datasource=#dsn# name=qGetUserInfo
SELECT dtLastAccessed FROM tblForumUsers WHERE intId =
#SESSION.intId#
Well... there must be a way, because CFForums and PHP-forums have this feature.
I tried with a JavaScript, but that one updated the cookie everytime I went to
a new page on the webpage.
~|
Logware (www.logware.us): a new and
I don't care about the lastVisit anymore. It does what it's supposed to do. I
just want to know if there is a way to do almost the same as lastVisit does,
but only updates the parameter when the user has left the webpage.
Since the function I'm looking for is used in CFForum and other forums,
Found this when googling:
Forcing session expiration on browser close.
use the following cookies to force sessions to expire a session @ browser
close, instead of letting the cookies persist for the length of the session
timeout.
cfcookie name=CFID value=#Session.CFID#
cfcookie name=CFTOKEN
That doesn't force the session to expire when the browser closes. It simply
causes the cookies used by the browser to associate itself with that session
to be discarded when the browser is closed.
True. I was thinking of using cookies though.
But now I think I will try to put this in the
I think I need some help creating that Client.dtLastAccessed.
Should I create it in the Application.cfm? Wouldn't that cause it to be created
at every page that the user loads?
Sorry, but I'm a newbie at ColdFusion.
~|
Find out
The first time the user loads a page on my page (when the session has started),
I want the old dtLastAccessed value to be stored in a temporary parameter. I
then want to use that parameter during the whole session. So I only want to
read the dtLastAccessed from the database once. Because when
The first time the user loads a page on my page (when the session has started),
I want the old dtLastAccess value to be stored in a temporary parameter. I then
want to use that parameter during the whole session. So I only want to read the
dtLastAccessed from the database once. Because when the
The first time the user loads a page on my page (when the session has started),
I want the old dtLastAccessed value to be stored in a temporary parameter. I
then want to use that parameter during the whole session. So I only want to
read the dtLastAccessed from the database once. Because when
The first time the user loads a page on my page (when the session has started),
I want the old dtLastAccessed value to be stored in a temporary parameter. I
then want to use that parameter during the whole session. So I only want to
read the dtLastAccessed from the database once. Because when
The first time the user loads a page on my page (when the session has started),
I want the old dtLastAccessed value to be stored in a temporary parameter. I
then want to use that parameter during the whole session. So I only want to
read the dtLastAccessed from the database once. Because when
Sorry for my multi post before.
I now try with this:
cfparam name=session.myLastVisit default=#qGetUserInfo.dtLastAccessed#
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking
I'm trying to use Client.LastVisit. It works pretty good, though I don't
want the lastVisit to be updated every time a user clicks on a new link on
my homepage. Is there a way to make it update the lastVisit when the user
leave the homepage, or close the browser?
___
Marcus
purpose?
I want to create a cookie for the current user, save the time of the visit.
Then read the cookie next time the user visits the page. When the user leaves
the page or closes the browser, the cookie should be updated with the new visit
time.
___
Marcus Svensson
Telecommunication
Try updating to the latest version of Navicat - it should then work fine.
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
As far as I know, you can maintain your session across multiple domains, but
the sites must be hosted on the same CF server, and you will need to append the
#session.urltoken# to the url when transferring between domains.
eg. If a session is created on http://www.mysite.com, if you append
Anyone?? Help!
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day
1. extend the timeout in the ColdFusion admin.
From my understanding, the SetTimeout attribute of the CFSetting tag should
override the standard timeout limit set in the CF Admin. Is this correct? I
would have thought that a timeout value of 500 seconds is enough allowance...
2. break up your
Hi,
I am trying sending a client newsletter out to about 25000 subscribers using
the code below. We are running CFMX 6.1 Enterprise on JRun 4 on Windows 2003.
The problem is that every time we try to send the newsletter out, the page
times out and an error is thrown. Some perhaps relevant
setting the From attribute to a bunch of different
addresses, including ones where the domain is delegated to the originating
server.
Thanks in advance.
Marcus
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Flip the text/html parts round so text is first and try again, you might
be pleasantly suprised.
Brilliant! Works like a charm. Perhaps something that should be added to
LiveDocs... Thanks for your help.
Marcus.
~|
Discover
The only problem I see is that it is nota valid HTML document.
I just put that text in there for simplicity. When using the exact CF code as
below (with addresses changed), the result is the same - displays as html in
Outlook, text in all others. The resulting message source is displayed below
Ok, not sure why that didn't display in the forum... I'll try again.
cfmail from=[EMAIL PROTECTED] to=[EMAIL PROTECTED] subject=Test Mail
cfmailpart charset=utf-8 type=html
!DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0
Hi,
I''m having issues with multipart emails using cfmailpart...
cfmail from=#sender# to=#email# subject=#subject#
cfmailpart type=html#html_content#/cfmailpart
cfmailpart type=text#text_content#/cfmailpart
/cfmail
This displays the html version fine with Outlook, but can
only display the text
It could be a setting in the mail client. Most clients have a setting
to display the preferred part of a multipart email - you could decide
to display the text portion only in Outlook Express, for example.
No, I'm pretty sure thats not it. I am testing at the moment in Thunderbird,
and
a regex, due to cfmail's habit of throwing an
error if it finds an incorrectly formatted address. I can do this using cfloop
cfmail, but don't want to if it really slows down or puts too much load on
the system.
Any thoughts?
thanks,
Marcus
regardless of the nda...
any idea whats up with this query param shite?
I had was having much the same problem intermittently for a while when using a SQL
server db. Usually when I restarted CF, the problem disappeared - for a while.
As a last resort, I started using the Microsoft SQL Server
Hi,
I have several CFMX instances running on JRun, and would like to set the Client Variable storage to be a SQL Server datasource. Can all instances use the same database for client variable storage, or will I need to create a separate database for each instance?
Thanks in advance,
Marcus
, and index where necessary, then it should keep working ok with a million tables - so long as your hardware is configured properly.
Just my opinion though...
Marcus.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
. Should I be doing this though? Has anyone
else had issues with this?
thanks,
Marcus.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
about the Enterprise edition, but I haven't been able to find any solid figures on the Professional edition.
I have a number of clients with mailing lists of about 1, so I need to know if Professional edition is going to handle things if I decide to go with that.
Thanks,
Marcus.
[Todays Threads
) solution then feel free to offer suggestions...
thanks,
Marcus
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
I'm trying to get a dts to run on my sql server 7 box. I use the example
from cfcomet, however since I actually have my sql server on a seperate
machine, how can I access the com object? I'm just lost...
Marcus
__
Get Your Own
Perhaps a silly question, but does your second document, the one that your
trying to load in the named window, have the onload=window.focus()
statement in it?
Since your reloading the page, the window will process again, and needs it.
Marcus
-Original Message-
From: Gonzo Rock
I am going brain dead.
I need to see if it's possible to either,
Store changed fields in a database without doing a standard submit with a
reload.
Or, if I can modify the form action to point to two different actions
depending on which submit is pressed.
Marcus
on the
original form, and view his changes. Over and over until he is happy with
the results.
Marcus
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk
(this.form, 'http://mach1/submit.cfm') /
Thanks for all the help...
Marcus
TARGET=_newpage in the FORM tag will also open a new window for you each
time the form is submitted (_newpage should be understood to be
any name you
want for the new window), which will also let you accomplish what
I have to use a Pervasive system every day and have a small piece of advice
for anyone that is going to attempt this...
Run Away!
Pervasive has no support for NULL states. It can't handle large SQL
statements. It is very case aware. And it's just kludgy to have around!
Marcus
person on the contact list,
and they gave you permission to modify the code and the database, then thats
a compleatly different circumstance then what was stated.
Marcus
Ok Ok!! I need to defend my Company...Mr.Houser is correct, if
your name is
not on our contact list we need to contact the owner
of course on the
same server?
Thanks
Stephen Marcus
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Wait...
You modified the DB of a site you 'hosted', modified the code (that you
didn't own or write) and contacted the owner and not the developer?
Scratch one hosting service I'll never use.
Marcus
I did NOT shut the site down as the extra 10 MB gave approx 24 hours
breathing room. I
Does the cruise to Mexico the Boss paid for me and my wife to go on last
month count?
Marcus
-Original Message-
From: Mark Smyth [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 27, 2001 2:47 AM
To: CF-Talk
Subject: RE: Geek Cruises
If anyone manages to get their boss to let them
of the block. Is there a wild card I can use? or some other
way to not specify the last number?
Marcus
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail
I tried refind, and it didn't want to work at all. Contains works great!
Marcus
cfif #cgi.remote_addr# contains '192.168.5'
Will do the trick, but you really need to use REfind and anchor the string
to the start.
~~
Structure your ColdFusion
I made that migration just a few weeks ago.
The zone files from metaIP should transfer almost perfectly with just a few
minor modifications.
Marcus
i'm planning on migrating from MetaIP to Win2K DNS. has anyone made this
particular migration? any recommendations? has anyone had any trouble
This one is driving me crazy...
The problem is that the variable #select_dnis_count.dnis# only changes in
one of the queries in the loop. Any help is appreciated.
Marcus
CFQUERY NAME="select_dnis_count" DATASOURCE="#mainDSN#"
select dnis
from dbo.dnis_list
where a
What about those of us that are not members of the beta, hence no NDA?
A great deal of information has been diseminated through other channels.
Marcus
Guys, just a friendly reminderCF5 is still in Beta, and all Beta
participants are still in the Non-Disclosure Period outlined in the Beta
I just tried to run this test DTS on my SQL7 server using code from
CFcomet...
The problem is, I get the error
COM error 0x800401F3. Invalid class string
I'm pretty new to using COM objects and was wondering if this was just
something stupid I needed to add, or what... ?
Marcus
CFTRY
No... Sql7 lives on a seperate machine called SQL_Server. I take it this is
a problem?
Marcus
Are SQL Server or the SQL Server Enterprise Manager installed on the same
machine as the CF Server?
~Simon
~~
Structure your ColdFusion code
You did?
Is it available? Can I get a copy? Do I sound rabid?
Marcus
-Original Message-
From: Jon Hall [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 22, 2001 3:07 PM
To: CF-Talk
Subject: Re: CF DNS
It's not really that hard to figure out the sturcture of the dns record
Your UNC path shouldn't contain the aliased drive designation of d:\.
ok, i am having a monday!
i am trying to use cffile to write a file to a mapped drive, i have even
tried it using the unc path and have hit the wall...is this a
limitation of
cffile or am i missing something?
the easiest way I have found to see if the drive can be accessed is to go to
the actual web server (either console or PCAnywhere type connection) and hit
run, and type in the unc drive path. If you get through, so can the web
server.
Marcus
ah for sure it is a monday, i goofed on typing
flawlessly (except for my code,
but I can't blame allaire for that).
Marcus
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com
Yeah... I'd like a copy as well :)
Marcus
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http
And in Canada it takes only 4 hours to count 15 million votes. So what
do they have that Florida doesn't.
Triple digit IQ's?
Marcus
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com
. Marcus!
~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free
Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support
Visit SoloServer, https://secure.irides.com/clientsetup.cfm.
Archives
register everything in .com, .net. .org, and even all the other domain
suffix's? NO!
Why? Because as I make my site more and more idiot proof, the universe keeps
creating better and better idiots!
Eventually I have to work to make my sites more effective, rather then
making it easier to find.
Marcus
here, and somehow make it stick, I
would be very much in your debt!
Dr. Marcus Kiel
Director of Development, but not VP!
~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup
from SoloServer PIII600 / 128 MB RAM / 20 GB HD
i guess you find nothing humorous about watching a highly paid,
professional , who is too arrogant of his own abilities to keep
up on his knowledge, get his ass handed to him by a 12 year old. :)
Nope... I see nothing humorous at all about watching a highly paid
professional, WHO DOES keep up
Got an odd error all of a sudden on the server and I've never seen it
before...
***
Error attempting to get the client (Client ID = '11638').
A problem was encountered trying to access the system registry. Error number
1450 occurred.
***
Anyone know what this is about?
Marcus
Thanks for all the help...
Stripped the registry, and moved the session variables to it's own
datasource. An almost painless lesson in in one of the rules of how to set
up a commercial site. Thanks for the info, it worked great!
Marcus
misinterpret this. I'm sure what Marcus meant to say was that he
moved his
client variables to a datasource. Session variables are stored in server
memory and not written to disk or database.
-Cameron
Ooops... Yes, What he said...
Sorry everyone, this has been a MONDAY all around!
Marcus
-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 04, 2000 5:34 PM
To: CF-Talk
Subject: RE: A great Shockwave flash movie
Uh where is it??
Rich
It's the latest worm making the rounds... Luckily this newsgroup filters it
out!
Marcus
try wrapping a urlencode around the variable. This should place a %20 in the
space and fix your difficulty.
Marcus
Hi Everyone,
Try this:
htmlhead/headbodycfoutput
cfset date= "27-FEB-02:28:07:18"
cfset key = "aabbcc"
Before encryption, date is #date#br
cfset date
Thanks Dave... I couldn't have said it any better...
Marcus
A net admin
With all due respect, I suspect you're not a network admin!
Any time you open a port, it's a risk - it's another thing that has to be
watched. There are typically limited resources for what a network
administrator can
I have an odd problem, or at least I hope so.
I need to post a wddx packet automagically to another website/page. How do I
do this without user intervention?
Marcus
Archives: http://www.mail
That is if they even accept the check in the first place.
--K
They do... I print all my company checks from a regular HP inkjet printer
and my bank has never even blinked twice about it.
Marcus
I'm using 2000, and I love it. Much more stable then anything else I've
used. Studio still blows up, by Win2K just staggers a bit, then continues
on. So far, it's been 2 months without a reboot :)
Marcus
How many of you are using Windows 2000 on your pc? I am getting really
tired of win98
development tables) all the time.
Marcus
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message
in the pervasive table for the updated change, and then process the
file. This has to be done constantly so the VP wants it done every minute on
a timer, 24/7. This is putting a heavy load on the machine.
Can anyone think of another way of doing this?
Marcus
and view the file, I again set the key,
cfset key='1234567'
And retrieve the field from a query I ran
cfset txtoutput = #get_report.report#
then I attempt to decrypt the file
cfset decrypted = decrypt(txtoutput, key)
And I get the error...
The value to be decrypted
need 128bit at this point, but I do
need some form of encrypt.
Marcus
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists
person trying to fix the problem. It was instead a salesman
trying to sell me a $28,000 support package from Allaire. And when I
commented that I didn't appreciate someone trying to sell me support when I
was still trying to resolve an issue, I was told that Allaire needed to make
money.
Marcus
the salesmen call and try and sell me a support package!
Marcus
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
Hey all,
I need a jump start with a WDDX solution I have to come up with.
I need to query a table, take the results and change a few of the variable
names, serialize it using wddx, and then send that packet in an email.
Problem is, I have never done WDDX before... any pointers?
Marcus
serialize it using wddx, and then send that packet in an email.
cfwddx action="WDDX2CFML" input="#q#" output="MyWddx"
cfmail
#MyWddx#
/cfmail
Thanks more then you can imagine...
Marcus
1 - 100 of 128 matches
Mail list logo