Re: Coldfusion Uses Perl for QoQ ?

2004-10-28 Thread Ricardo Russon
Problem seems to be solved. After reading through the docs i can accross http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/using_35.htm Handling null values That did the trick. Just to note, that withoug using the fix AND NOT NULL that is mentioned in the docs, if i changed the LIKE %val%

RE: Double Quotes in Database

2004-10-28 Thread Pascal Peters
DON'T use HTMLEditFormat() to insert in the database! Just store the quotes as is in the database. Use HTMLEditFormat() for display. This way you will not have the double encoding and you can even use the data in non HTML. If you insist on using html code in the db, you could use a UDF to

asp 2 cfm help pleazzzzzzzzzzzz

2004-10-28 Thread dave
working on converting this page here is the asp code, mostly interested in the paging part %@ Language=VBScript % % Response.Buffer=True % % Dim GuestBookName dim GuestbookUrl Dim MailBox Dim Password1 Dim AllowUbbcode Dim ConnectionString Dim PageSize Dim AdminLogFlag IF Session(AdminLogged)1

Variable Session scopes

2004-10-28 Thread Carl V
What is the best way of creating variable session scopes called from a global vars page without CF chucking errors.. global vars page cfscript request.sessionVar = mySite; // This changes across the mini sites request.dbsitePrefix = test; /cfscript Application.cfm Page - and yes

Re: Variable Session scopes

2004-10-28 Thread Stephen Moretti (cfmaster)
Carl V wrote: What is the best way of creating variable session scopes called from a global vars page without CF chucking errors.. global vars page cfscript request.sessionVar = mySite; // This changes across the mini sites request.dbsitePrefix = test; /cfscript Application.cfm Page - and

Web Services problem

2004-10-28 Thread Will Tomlinson
I'm learning about using Web Services and I'm getting an error that doesn't make sense. Maybe someone could shed some light on the problem? I'm using a CFC to simply retrieve some zip codes from a db. cfcomponent cffunction name=myFunction access=remote returntype=query

Re: asp 2 cfm help pleazzzzzzzzzzzz

2004-10-28 Thread dave
anyone see anything diff that needs to be added (its 441am im sure im missing something !--- get message list --- cfquery name=qGetXMLlist datasource=#dsn# username=#un# password=#pw# SELECT * FROM guestbook ORDER BY postdatetime desc /cfquery !--- get message count --- cfparam

Re: Web Services problem

2004-10-28 Thread Stephen Moretti (cfmaster)
Will Tomlinson wrote: I'm learning about using Web Services and I'm getting an error that doesn't make sense. Maybe someone could shed some light on the problem? I'm using a CFC to simply retrieve some zip codes from a db. cfcomponent cffunction name=myFunction access=remote

Dan Switzer

2004-10-28 Thread Tangorre, Michael
Anyone heard from Dan Switzer lately? ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=38 Message:

RE: authorize.net processing

2004-10-28 Thread Mark A Kruger
Tim, Nope - you use the password in the old 3.0 implimentation. The x_tran_key is created by you in the merchant terminal. You answer a secret question and they use your answer to give you a hash or encrypted string. That string is then used as your x_tran_key. This is the version 3.1

Re: Web Services problem

2004-10-28 Thread Joe Rinehart
Will, Change wtomlinson..com to wtomlinson.com :) -joe On Thu, 28 Oct 2004 06:40:00 -0400, Will Tomlinson [EMAIL PROTECTED] wrote: I'm learning about using Web Services and I'm getting an error that doesn't make sense. Maybe someone could shed some light on the problem? I'm using a CFC

RE: Dan Switzer

2004-10-28 Thread Peterson, Andrew S.
Is he Mr. PengoWorks? Man I love those qForms. Macromedia should have bought qForms for embedded Blackstone form validation :-) Sincerely, Andrew -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Thursday, October 28, 2004 6:52 AM To: CF-Talk Subject: Dan

Re: OT: Find out my IP

2004-10-28 Thread Andy Jarrett
WOW, cheers for the response, i never knew all that about NTL's proxies. As for the upgrades, i've got mine here (on the south coast) had it for a while now and i gotta say i like it. Though the upload speed is what really needs looking into. Andy On Wed, 27 Oct 2004 20:18:02 +0100, Paul

Re: Web Services problem

2004-10-28 Thread Scott Stroz
I just tried it and it worked finemaybe a little slow, but it worked. Here is the dump of the returned query: query ZIPCODE 1 00501 2 00544 3 00601 4 00602 5 00603 6 00604 7 00605 8 00606 9 00610 10 00611 11 00612 12

Re: authorize.net processing

2004-10-28 Thread Tim Laureska
thanks Mark -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Thursday, October 28, 2004 12:32 PM To: 'CF-Talk' Subject: RE: authorize.net processing Tim, Nope - you use the password in the old 3.0 implimentation. The x_tran_key is created by you in the merchant

RE: asp 2 cfm help pleazzzzzzzzzzzz

2004-10-28 Thread Gavin Brook
Have you got any sample data? The lt makes me think less than symbol, maybe there is something in your data that is causing invalid XML?? Gav -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: 28 October 2004 10:11 To: CF-Talk Subject: asp 2 cfm help plea

Re: OT: Find out my IP

2004-10-28 Thread Thomas Chiverton
On Thursday 28 Oct 2004 13:08 pm, Andy Jarrett wrote: WOW, cheers for the response, i never knew all that about NTL's proxies. When I was on NTL, my box just got a public IP. How are you connected to them ? Set top box ? Stand alone box ? xDSL ? Intergrated wireless gatway nonsense ? Linux

cfchart / cfgraph help please

2004-10-28 Thread Guy Bambury
Hello, I am currently trying to generate some bar charts. The server we are running is Version 6,0,0,48097 Professional On using cfchart or cfgraph the page that loads just shows the little place holder as if you were missing a picture (the white square with a red cross) After looking in

XML faster?

2004-10-28 Thread Johnny Le
Is it faster to connect to an XML file than to a database? Assuming both store the same amount of data. I know that getting the data in and out is easier with a database, but I wonder if it is faster with XML. XML vs. Access? XML vs. SQL Server? XML vs. MySQL? XML vs. Oracle? Johnny

Re: OT: Find out my IP

2004-10-28 Thread Andy Jarrett
N nothing that complicated. Just the usual direct wire from the NIC to the NTL box. On Thu, 28 Oct 2004 15:21:48 +0100, Thomas Chiverton [EMAIL PROTECTED] wrote: On Thursday 28 Oct 2004 13:08 pm, Andy Jarrett wrote: WOW, cheers for the response, i never knew all that about NTL's

Re: XML faster?

2004-10-28 Thread G
I can't imagine a scenario where file read/writes would be faster than database queries, everything else being equal. - Original Message - From: Johnny Le [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, October 28, 2004 9:45 AM Subject: XML faster? Is it faster to

Re: XML faster?

2004-10-28 Thread Damien McKenna
Johnny Le wrote: Is it faster to connect to an XML file than to a database? Assuming both store the same amount of data. I know that getting the data in and out is easier with a database, but I wonder if it is faster with XML. It would depend on drivers, whether ODBC was used, etc. One

Re: Variable Session scopes

2004-10-28 Thread Carl V
Do you put this in the application.cfm or somewhere else? Carl Carl V wrote: Its probably worth copying your session variable to a local variable, so that you don't keep hitting the session and to make it easier to access your variables. request.thisSession =

RE: cfchart / cfgraph help please

2004-10-28 Thread Ryan Duckworth
-Login to your CF Administrator -Click the charting Link. Try these settings: Disk Cache 50 4 C:\CFusionMX\charting\cache This should solve your problem. Ryan Duckworth Macromedia ColdFusion Certified Professional Uhlig Communications 10983 Granada Lane Overland Park, KS 66211 (913)

CFMail Problem

2004-10-28 Thread Mark Leder
Hi all, I have a couple of clients who manage their own mail servers. I host their websites. In a simple contact form using CFMail, the message being sent to the client works fine. But as best practice, I always generate a confirmation email back to the sender, so they can have a record of what

Html Area 3 issue?

2004-10-28 Thread DRE
Hi, Any of you guys using the HTML Area 3 wysiwig? I've been using it and have found a really annoying problem that I dont know how to solve. I can duplicate this on 2000 and xp ie 6. To duplicate, open a page with the wysiwig and then keep reloading it with f5. If I do this between 5 and 20

Dates in Queries - Again

2004-10-28 Thread Les Mizzell
I don't know why I have so much trouble with this.. OK, I need to get all records with a depart date starting today and for the next 15 days... So, first set the variables... cfset TodayDate = #CREATEODBCDATE(now())# cfset FutureDate = #CREATEODBCDATE(now() + form.departdate)# !---

SQL Mask not using CF

2004-10-28 Thread Mickael
Hi All I was wondering if someone could help me out with the following SQL function. I would like to select Today(*) from my database but have it display as Thursday, October 28, 2004 This is easily done with a mask in CF but is there a way to do it right in my select statement? Something

OT: JavaScript Form Behaviour

2004-10-28 Thread Jillian Koskie
I have a form that has a series of radio buttons, so that users can choose a timeperiod. If the user picks 'Range', they can then also choose 'one week, two weeks, one month, etc.' to specify the range. What I'm wondering... is whether there is a way I can write something in JavaScript that

Re: Html Area 3 issue?

2004-10-28 Thread Damien McKenna
DRE wrote: Any of you guys using the HTML Area 3 wysiwig? I've been using it and have found a really annoying problem that I dont know how to solve. I stopped using HTMLArea when I noticed conflicts between it and some other JS code I use, specifically fValidate. I've since started using

Re: Dates in Queries - Again

2004-10-28 Thread Douglas Knudsen
what RDBMS are you using? Look at the BETWEEN op WHERE DEPART_DATE BETWEEN #TodayDate# AND #FutureDate# Also, I'd use cfqueryparam on this WHERE DEPART_DATE BETWEEN cfqueryparam cfsqltype=cf_sql_date value=#TodayDate# / AND cfqueryparam cfsqltype=cf_sql_date value=#FutureDate# / Actually,

Re: Web Services problem

2004-10-28 Thread Scott Stroz
The 'wtomlinson..com' is showing up in the error message, not from his code (or at least the code he posted here) I copied his code right from his post into a page and it worked. On Thu, 28 Oct 2004 07:07:49 -0400, Joe Rinehart [EMAIL PROTECTED] wrote: Will, Change wtomlinson..com to

RE: JavaScript Form Behaviour

2004-10-28 Thread Tangorre, Michael
I have a form that has a series of radio buttons, so that users can choose a timeperiod. If the user picks 'Range', they can then also choose 'one week, two weeks, one month, etc.' to specify the range. What I'm wondering... is whether there is a way I can write something in

Re: Html Area 3 issue?

2004-10-28 Thread DRE
Thanks Damien, It is cute but amazingly enough it seems to have the same issue for me I'm amazed! But both my computers seem to do it for me on and off site!!! DRE On Thu, 28 Oct 2004 11:28:51 -0400, Damien McKenna [EMAIL PROTECTED] wrote: DRE wrote: Any of you guys using the HTML

Re: OT: JavaScript Form Behaviour

2004-10-28 Thread Greg Stewart
Jillian, The answer is yes. In your drop down have an onChange event, that calls a function that checks the value selected and then does a document.formName.formFieldFame.selected = true based on that value. This should work. HTH G On Thu, 28 Oct 2004 09:28:29 -0600, Jillian Koskie [EMAIL

Re: SQL Mask not using CF

2004-10-28 Thread Charlie Griefer
http://www.rocket99.com/sybase/sybase22.html see: Transact SQL: date/time formats Use the convert function to format the date into the style of your choice. On Thu, 28 Oct 2004 11:27:36 -0400, Mickael [EMAIL PROTECTED] wrote: Hi All I was wondering if someone could help me out with the

Re: JavaScript Form Behaviour

2004-10-28 Thread Charlie Griefer
form select name=foo onchange=this.form.r[2].checked=true; option value=11/option option value=22/option option value=33/option /select input type=radio name=r value=a /a input type=radio name=r value=b /b input type=radio name=r value=c /c /form On Thu, 28 Oct 2004

Re: Dates in Queries - Again

2004-10-28 Thread Les Mizzell
WHERE DEPART_DATE BETWEEN #TodayDate# AND #FutureDate# At least the dates are correct. Hmmm... Database is mySQL 76 : WHERE DEPART_DATE BETWEEN #TodayDate# AND #FutureDate# Syntax error or access violation: You have an error in your SQL syntax near 'WHERE DEPART_DATE BETWEEN '2004-10-28' AND

Re: Web Services problem

2004-10-28 Thread Stephen Moretti (cfmaster)
Scott Stroz wrote: The 'wtomlinson..com' is showing up in the error message, not from his code (or at least the code he posted here) I copied his code right from his post into a page and it worked. Yep - so he's got a typo in his code on that remote server that has been introduced after he

OT - hosting?

2004-10-28 Thread DRE
I know, its a dead horse but I've been out of the loop for a while. I did do a search but didnt find much. Does cfdynamics still have the favorable reputation that it used to? If not, any suggestions. MX sql2000 medium traffic site. Thanks. DRE -- DRE www.webmachineinc.com

Re: OT - hosting?

2004-10-28 Thread simon
I've had nothing but good experiences with them, for what it counts. ~Simon I know, its a dead horse but I've been out of the loop for a while. I did do a search but didnt find much. Does cfdynamics still have the favorable reputation that it used to? If not, any suggestions. MX

Re: OT - hosting?

2004-10-28 Thread Charlie Griefer
crystaltech generally seems to be one of the more recommended as having a favorable reputation these days. http://www.crystaltech.com On Thu, 28 Oct 2004 08:57:57 -0700, DRE [EMAIL PROTECTED] wrote: I know, its a dead horse but I've been out of the loop for a while. I did do a search but

Re: OT - hosting?

2004-10-28 Thread Donna French
www.CrystalTech.com HTH, Donna On Thu, 28 Oct 2004 08:57:57 -0700, DRE [EMAIL PROTECTED] wrote: I know, its a dead horse but I've been out of the loop for a while. I did do a search but didnt find much. Does cfdynamics still have the favorable reputation that it used to? If not, any

Re: OT - hosting?

2004-10-28 Thread Paul Hastings
[EMAIL PROTECTED] wrote: I've had nothing but good experiences with them, for what it counts. me too. i can't remember the last time i had a technical problem with cfdynamics. ~| The annual ColdFusion User Conference is being

RE: cfchart / cfgraph help please

2004-10-28 Thread Dave Watts
I am currently trying to generate some bar charts. The server we are running is Version 6,0,0,48097 Professional In addition to Ryan's suggestions, you might want to consider upgrading to CFMX 6.1. That's a free upgrade. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone:

RE: JavaScript Form Behaviour

2004-10-28 Thread Jillian Koskie
Worked like a charm --thanks everybody!! -- Jillian -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: October 28, 2004 9:52 AM To: CF-Talk Subject: Re: JavaScript Form Behaviour form select name=foo onchange=this.form.r[2].checked=true; option

RE: XML faster?

2004-10-28 Thread Hassan Arteaga Rodriguez
Imagine do u have application where the user can built his own report visually (ie: one form with differents fields of the table in database and u want to built the report output, Employees from the sales department where the amount of their sales is greather than 30 000 dls )...the imagine u can

Re: OT - hosting?

2004-10-28 Thread DRE
Excellent! Thanks for the feedback! DRE On Thu, 28 Oct 2004 23:13:53 +0700, Paul Hastings [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: I've had nothing but good experiences with them, for what it counts. me too. i can't remember the last time i had a technical problem with

RE: OT - hosting?

2004-10-28 Thread Ian Skinner
+1 for me as well. With one small caveat; just make sure one knows that database back-ups by CFdynamics are only available for 3-7 days. Found this out when we learned that a programming snafu on my part cleared an important table, seven days after it happened. We lost the data. On that

spell checker

2004-10-28 Thread Tim Do
Can anybody point me to a client side spell checker that uses the microsoft data file or whatever it is that MS Word uses? Thanks, Tim ~| Protect your mail server with built in anti-virus protection. It's not only good

RE: Dates in Queries - Again

2004-10-28 Thread Figy, Kam
cfset FutureDate = #CREATEODBCDATE(now() + form.departdate)# I'm not sure exactly what that code would do, but it's cleaner (and probably works better) to use DateAdd() to add days to an existing date. Since your date field is a varText you can't directly compare it to a ODBC date (I assume

Re: Dates in Queries - Again

2004-10-28 Thread Greg Morphis
Does mySQL allow casting? in Oracle I've had to use the to_date() function to cast a char field to date. On Thu, 28 Oct 2004 11:42:56 -0400, Les Mizzell [EMAIL PROTECTED] wrote: WHERE DEPART_DATE BETWEEN #TodayDate# AND #FutureDate# At least the dates are correct. Hmmm... Database is

OT: dummy frame?

2004-10-28 Thread Damien McKenna
One of our outside consultants has created a site for us that they're using frames to hide the real location of. Besides the fact that this won't work well for our purposes, their frameset included the link to the actual site and one for a dummy page, e.g.: HTML TITLEOur Company's Site/TITLE

RE: XML faster?

2004-10-28 Thread Figy, Kam
XML will always be slower than a good database, particularly for large volumes of data. Consider a scenario where you have 1000 records that are about 500 bytes each. If it's in a database, it's already in a read-optimized format that can be quickly queried and send back only the needed results.

RE: OT: Find out my IP

2004-10-28 Thread Paul Vernon
I know this is getting way OT from CF so this is my last post on this but it does illustrate the point... When I was on NTL, my box just got a public IP. It's unlikely that you ever got a truly public IP using NTL cable however I would have to say depending on the region you lived in it would

OT: editors, back to HomeSite+ for me

2004-10-28 Thread Damien McKenna
Well, after spending ages between last night and this morning doing my bi-annual editor search, I went back to Homesite+ and am going to stick with it. The 5.5 version seems to do what I need in terms of code insight and syntax highlighting, and its less resource intensive than Dreamweaver by

Re: OT - hosting?

2004-10-28 Thread DRE
Thanks Ian, I would be interested in this as well. DRE On Thu, 28 Oct 2004 09:29:44 -0700, Ian Skinner [EMAIL PROTECTED] wrote: +1 for me as well. With one small caveat; just make sure one knows that database back-ups by CFdynamics are only available for 3-7 days. Found this out when we

request scope question

2004-10-28 Thread G
Been away too long... What does the following block of code assign to the request.queryName variable?? cfquery name=queryName SELECT column1, column2 FROM table /cfquery cfset request.queryName = queryName Can i now access request.queryName.column1 ? TIA, Brian

Re: request scope question

2004-10-28 Thread Barney Boisvert
It assigns the recordset as a whole. request.queryName.column1 should return the value of column1 in the first row of the recordset. cheers, barneyb On Thu, 28 Oct 2004 12:02:04 -0500, G [EMAIL PROTECTED] wrote: Been away too long... What does the following block of code assign to the

Re: Dates in Queries - Again

2004-10-28 Thread Scott Stroz
Lee, IF you are using Version 4.1.1 or higher, you can use the STR_TO_DATE() function. WHERE STR_TO_DATE(DEPART_DATE, '%c/%e/%Y') You will need to consult the MySQL documentation for more info on the date formatting options. http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html

RE: dummy frame?

2004-10-28 Thread Dave Watts
Why would they bother with the dummy frame, why would it be needed? It's a handy way to keep JavaScript persistent. I don't know if that's why they're doing it, though. And is it a common practice in the JSP world to put spaces as the first character of every attribute value (see above)?

Re: Dates in Queries - Again

2004-10-28 Thread Douglas Knudsen
ooopsies! I missed the part about ur field being varText. Yeah, that's going to be fun. ;) Looks like you can use the STING_TO_DATE() function maybe? Doug On Thu, 28 Oct 2004 11:40:29 -0400, Douglas Knudsen [EMAIL PROTECTED] wrote: what RDBMS are you using? Look at the BETWEEN op WHERE

Re: OT: editors, back to HomeSite+ for me

2004-10-28 Thread Spike
Did you look at cfeclipse? Spike Damien McKenna wrote: Well, after spending ages between last night and this morning doing my bi-annual editor search, I went back to Homesite+ and am going to stick with it. The 5.5 version seems to do what I need in terms of code insight and syntax

Re: CFMail Problem

2004-10-28 Thread Ryan Emerle
Yeah, that most definitely sounds like a relaying issue. Have your client add your server address(es) to their relay-allow list(s). Most (though it should be all) mail servers will not allow a foreign IP to send email to domains that the server does not host. -Ryan On Thu, 28 Oct 2004

cfqueryparam strangeness

2004-10-28 Thread Tony Weeg
223073026 that value should validate in this right... (CMFX 6.1 WIN2KSERVER) cfqueryparam value=#ipAddressNumber# cfsqltype=CF_SQL_INTEGER thanks. -- tony Tony Weeg macromedia certified coldfusion mx developer email: tonyweeg [at] gmail [dot] com blog:

SP to find all triggers in a database?

2004-10-28 Thread powell
Howdy - I've inherited the database (SQL Server 2000) from ^*^*, and it has about a zillion tables in it. I need to make some changes to the app that goes with it, but want to find out if there are any triggers out there that are going to do things behind my back. Is there an easy way to do

RE: cfqueryparam strangeness

2004-10-28 Thread Tangorre, Michael
223073026 that value should validate in this right... (CMFX 6.1 WIN2KSERVER) cfqueryparam value=#ipAddressNumber# cfsqltype=CF_SQL_INTEGER Trim(ipAddressNumber) ~| This list and all House of Fusion resources hosted by

Re: SP to find all triggers in a database?

2004-10-28 Thread Scott Stroz
This will get you all of the Triggers in teh DB: select * from sysobjects where xtype = 'TR' You may want to expand the query to get more descriptive information for the 'parent' On Thu, 28 Oct 2004 13:42:41 -0400, powell @ nauticom. net powell @ nauticom. net [EMAIL PROTECTED] wrote: Howdy -

Re: SP to find all triggers in a database?

2004-10-28 Thread Rey Bango
This should tell you if you have any: SELECT * FROM sysobjects WHERE (xtype = 'tr') Rey - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, October 28, 2004 1:42 PM Subject: SP to find all triggers in a database? Howdy -

Re: cfqueryparam strangeness

2004-10-28 Thread Tony Weeg
nope. On Thu, 28 Oct 2004 13:49:14 -0400, Tangorre, Michael [EMAIL PROTECTED] wrote: 223073026 that value should validate in this right... (CMFX 6.1 WIN2KSERVER) cfqueryparam value=#ipAddressNumber# cfsqltype=CF_SQL_INTEGER Trim(ipAddressNumber)

RE: cfqueryparam strangeness

2004-10-28 Thread Tangorre, Michael
223073026 that value should validate in this right... (CMFX 6.1 WIN2KSERVER) cfqueryparam value=#ipAddressNumber# cfsqltype=CF_SQL_INTEGER Also, make sure you that your DB Column is INT and not BIGINT or TINYINT. Or, if it is.. Use the corresponding CF SQL type Mike

Re: Survey Creation Application

2004-10-28 Thread Marco Antonio C. Santos
Do you can show that survey tool? Maybe a link? Cheers Marco On Wed, 27 Oct 2004 18:37:51 -0400, Nick Cabell [EMAIL PROTECTED] wrote: I built a survey creation system for a non-profit using CF. It is fairly customized and has been very difficult. It allows a variety of clients to create

Re: XML faster?

2004-10-28 Thread Kwang Suh
Consider a scenario where you have 1000 records that are about 500 bytes each. If it's in a database, it's already in a read-optimized format that can be quickly queried and send back only the needed results. With XML, you'd first need to read the WHOLE file (500k+, with tags) from disk, run the

Re: cfqueryparam strangeness

2004-10-28 Thread Tony Weeg
the datatype in the MSSQL DB is BIGINT here is my code... cfset request.ipAddressNumber = 223073026 cfquery name=GetVehicleName datasource=myDataSource select * from thisTable v inner join thatTable c on c.companyIdNumber = v.companyIdNumber where

OT- SQL copy over

2004-10-28 Thread Asim Manzur
I have two SQL servers (DEV and LIVE) Whenever I need to change something in SQL I do first on DEV then I got the approval from client and then I copy over all the tables from one to another. Is there any easiest way that I can run the query which radomaly take all the table from DEV and COPY

Re: OT- SQL copy over

2004-10-28 Thread Tony Weeg
EXACTLY and RANDOMLY? hmmm.. i would say you could do a backup and restore DTS package, maybe? tw On Thu, 28 Oct 2004 14:32:14 -0400, Asim Manzur [EMAIL PROTECTED] wrote: I have two SQL servers (DEV and LIVE) Whenever I need to change something in SQL I do first on DEV then I got the

Re: XML faster?

2004-10-28 Thread Massimo, Tiziana e Federica
Use SAX then. Extremely quick. I've used SAX on 20 meg XML files with awesome results. Yes, SAX is fast, but it requires more work than simply using CF's native capabilities (that use DOM in the background) Too bad CF doesn't directly support SAX (yet). You can leverage Java for that, I

Re: OT: editors, back to HomeSite+ for me

2004-10-28 Thread Rick Root
FWIW, I recently tried He3, and disliked it immensely. I'm still using Homesite 5.5+ =) - Rick ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community.

RE: OT- SQL copy over

2004-10-28 Thread Gaulin, Mark
Look at DTS (in SQL Server Enterprise Manager) for server-to-server object copying. This can move tables (w/ indexes) and data (if you want it to). The simplest way to invoke it is to right-click on a database and select the All Tasks/Export option. Mark -Original Message-

Re: OT- SQL copy over

2004-10-28 Thread Asim Manzur
well I mean to say that. When I do changes on DEV and get approved by the client. Then I have to move back all the table to the LIVE. So its pain everytime to login on the server, launch the enterprise manager and then remove the old tables and wait for import/export and copy over all the data.

synching local database with web

2004-10-28 Thread Tim Laureska
I've been asked if its possible to have this scenario: Sales people entering information into their laptop computer database (ms access file) right after meeting a client - the sales person would not be online at that time. That evening or the next time they're online, is there someway to sync

Re: OT- SQL copy over

2004-10-28 Thread Asim Manzur
Oh I actually used the first option all the time which is Copy tables and views from the source database. I will try this option next time and see how it goes. Look at DTS (in SQL Server Enterprise Manager) for server-to-server object copying. This can move tables (w/ indexes) and data

Re: OT- SQL copy over

2004-10-28 Thread Tony Weeg
you could setup a dts package, that does this, and then it would be as easy as a doubleclick to execute the package. tw On Thu, 28 Oct 2004 14:54:05 -0400, Asim Manzur [EMAIL PROTECTED] wrote: well I mean to say that. When I do changes on DEV and get approved by the client. Then I have to

Re: SP to find all triggers in a database?

2004-10-28 Thread powell
Thanks for the postings, taht works great - narrows things down to about a dozen tables that I need to look at. Is there a way to programatically get the actual trigger code for a given trigter? I've followed the various links from sysobjects for the triggers, but none lead to the actual

Re: Dates in Queries - Again

2004-10-28 Thread Les Mizzell
Looks like you can use the STING_TO_DATE() function maybe? That didn't seem to work either. I'm not 100% sure what version the host is running. So, I added additional fields to the database, created a new query to properly convert the varCHAR dates to real dates, and all seems fine now.

Re: OT: editors, back to HomeSite+ for me

2004-10-28 Thread Spike
What did you dislike about He3? cfeclipse != He3 Spike Rick Root wrote: FWIW, I recently tried He3, and disliked it immensely. I'm still using Homesite 5.5+ =) - Rick ~| Purchase from House of Fusion, a

Re: Web Services problem

2004-10-28 Thread Will Tomlinson
I just tried it and it worked finemaybe a little slow, but it worked. Here is the dump of the returned query: query ZIPCODE 1 00501 2 00544 3 00601 4 00602 5 00603 6 00604 7 00605 8 00606 9 00610 10 00611 11 00612 12 00613 13

RE: synching local database with web

2004-10-28 Thread Dave Watts
I've been asked if its possible to have this scenario: Sales people entering information into their laptop computer database (ms access file) right after meeting a client - the sales person would not be online at that time. That evening or the next time they're online, is there

Re: SP to find all triggers in a database?

2004-10-28 Thread Scott Stroz
If you right-click on a table name, then 'All Tasks', you can 'Manage Triggers' On Thu, 28 Oct 2004 15:09:27 -0400, powell @ nauticom. net powell @ nauticom. net [EMAIL PROTECTED] wrote: Thanks for the postings, taht works great - narrows things down to about a dozen tables that I need to

RE: OT: editors, back to HomeSite+ for me

2004-10-28 Thread Guy Rish
Spike, Some of his dislikes were features lacking in the current public beta of He3 (missing browser, non-Windows standard key mappings) and some of them were Eclipse specific things (updater problems and unfamiliar interface). I think that both He3 and cfeclipse could better target the

Re: OT: editors, back to HomeSite+ for me

2004-10-28 Thread Rick Root
Spike wrote: What did you dislike about He3? cfeclipse != He3 I know. To answer your question... #1 - I downloaded the beta, then had to restart He3 something like 5-6 times while it downloaded one new update at a time. That was annoying. #2 - It doesn't have browse capability for HTML

Re: synching local database with web

2004-10-28 Thread Joe Rinehart
One thing you may want to look at doing is developing the salesperson app in Macromedia Central. It's made to do occaisionally connected apps like this. Cheers, Joe ~| Purchase from House of Fusion, a Macromedia Authorized

cfhttp error

2004-10-28 Thread Carol Chandler
My code: cfhttp method=get name=stuff url=http://www.usaepay.com; /cfhttp The result: The column name html is invalid. Any ideas? My ultimate goal with this is to write wrappers for custom reports on the usaepay site, so that different departments in my client's company can see only their

RE: cfhttp error

2004-10-28 Thread Dave Watts
My code: cfhttp method=get name=stuff url=http://www.usaepay.com; /cfhttp The result: The column name html is invalid. Any ideas? My ultimate goal with this is to write wrappers for custom reports on the usaepay site, so that different departments in my client's company can see

Re: synching local database with web

2004-10-28 Thread Al Musella, DPM
You could add a flag for transactions that are not uploaded to the server yet. When they add a new transaction, the flag is set. When they connect to the server, run a script that finds the ones with the flag set and upload them, and reset the flag At 03:00 PM 10/28/2004, you wrote: I've

Re: OT: editors, back to HomeSite+ for me

2004-10-28 Thread Spike
Thanks Guy, I'm inclined to agree with you. It would probably be good to have a simple way of configuring either He3 or cfelclipse to match the Homesite or DreamWeaver layout and configuration. I shall put it on my (very long) todo list :) Spike Guy Rish wrote: Spike, Some of his

Re: OT: editors, back to HomeSite+ for me

2004-10-28 Thread Spike
Rick Root wrote: Spike wrote: What did you dislike about He3? cfeclipse != He3 I know. To answer your question... #1 - I downloaded the beta, then had to restart He3 something like 5-6 times while it downloaded one new update at a time. That was annoying. #2 - It doesn't have

OT: Homesite - disabling Browse feature and Edit/Browse tabs?

2004-10-28 Thread Damien McKenna
Is there any way, in HomeSite+ 5.5, to disable the Browse tab entirely and hide the tabs, just leaving the Edit pane? Given that I never use it its a bit useless for me. Thanks. -- *Damien McKenna* - Web Developer - [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The Limu Company -

OT: Sql insert from one db to another

2004-10-28 Thread Rodger
I can use an INSERT to copy the data from one table to another like: INSERT empinfoEmployeesTemp (EmployeeNum, FirstName, LastName) (SELECT EmployeeNum, FirstName, LastName FROM empinfoEmployees) But I need to copy the data from different databases (production to dev). How can I specify

Re: cfhttp error

2004-10-28 Thread Carol Chandler
Thanks, Dave, that was it. Man, do I feel dumb. Now I have a new problem. *g* Now I'm trying to get one of the pages that requires login, and I'm sending the username and password in the request, but I'm getting the login page instead. Am I missing some other important parameter, or does it

  1   2   >