Re: SOT: Any way to get table names and datatypes via a query?
The problem is I would assume the dimore expects you are an sa login? I wouldn't think there is a need to license it as Google will give you this type of script and more. Still a good start for people who don't one of these scripts already. "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -Original Message- From: C. Hatton Humphrey To: CF-Talk Sent: Sun Oct 22 02:49:25 2006 Subject: Re: SOT: Any way to get table names and datatypes via a query? On 10/21/06, Pete Ruckelshaus <[EMAIL PROTECTED]> wrote: > That's awesome Hatton, thanks. I'll look in BOL to see if I can > figure a better way to find the datatypes, since only varchar and int > IDENTITY seem to be set in your script. That was the initial query that I wrote for the dumper... I never did get around to open-sourcing the SQLDumper tool as I had intended too . too little documentation and no license picked out. Might have to change that though. Interested in what I've got so far? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257695 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Noob MSAccess query struggle
Hi Walter, You may need to post a small sample of data to help us understand this issue. how does petID crop up in the data for example. On 10/22/06, Walter Conti <[EMAIL PROTECTED]> wrote: > > > select signerName, signerLocation, signerComment, dateSigned, > MIN([dateSigned]) as startDate, MAX([dateSigned]) as endDate > from signatures > where signatures.petId ='#id#' > group by signerName, signerLocation, signerComment, dateSigned > order by dateSigned desc > > > returns the same (MAX) date for MIN and MAX even though the date range is > ample. > The error is laughing at me but I cannot see it. > Thanks for helping. > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257696 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Noob MSAccess query struggle
Yes, and if the id field is numeric, not sure using the apostrophes around #id# will work correctly... using apostrophes is usually reserved for text fields I believe -Original Message- From: Michael Traher [mailto:[EMAIL PROTECTED] Sent: Sunday, October 22, 2006 3:55 AM To: CF-Talk Subject: Re: Noob MSAccess query struggle Hi Walter, You may need to post a small sample of data to help us understand this issue. how does petID crop up in the data for example. On 10/22/06, Walter Conti <[EMAIL PROTECTED]> wrote: > > > select signerName, signerLocation, signerComment, dateSigned, > MIN([dateSigned]) as startDate, MAX([dateSigned]) as endDate > from signatures > where signatures.petId ='#id#' > group by signerName, signerLocation, signerComment, dateSigned > order by dateSigned desc > > > returns the same (MAX) date for MIN and MAX even though the date range is > ample. > The error is laughing at me but I cannot see it. > Thanks for helping. > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257697 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT: Any way to get table names and datatypes via a query?
On 10/22/06, Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]> wrote: > The problem is I would assume the dimore expects you are an sa login? Actually it's not based on login at the execution of the script, simply at the datasource level. Whatever the DSN can see, the script will dump... tables, SP's, views and table data. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257698 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Can I use replace function on a string to create form drop bo x options?
On 10/21/06, Andrew Tyrone <[EMAIL PROTECTED]> wrote: > > Just put the days in the list, not codes ;-)) > > That will make a field with a max of what? 50 characters may be? Big > > deal! ;-) > > And...? It doesn't matter which types of data you store in those lists. > How would you return a workable query? You can't, and you'd have to jump Well, MySQL has some stuff for working with lists... I don't like it, because it's one of those things that locks you in with a DB, but hell, who are we kidding? At any rate, don't pre-optimize or whatever, neh? Wot Wot (I think that may be brittish for what what, but I'm not certain) I'm not sure it's cut and dry. There are times where it is much easier to use a list than a link table. I guess it's one of those judgement calls. If only we didn't need judgement, neh? *sigh* 'Prolly be boring as hell... G'night folks- strange as it is to say stuff like that in a timeless medium, or whatever. Heh. =] ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257699 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT: Any way to get table names and datatypes via a query?
yeah, so the login will need access to the sys tables. If that is not granted it will not work..? "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -Original Message- From: C. Hatton Humphrey To: CF-Talk Sent: Sun Oct 22 13:36:33 2006 Subject: Re: SOT: Any way to get table names and datatypes via a query? On 10/22/06, Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]> wrote: > The problem is I would assume the dimore expects you are an sa login? Actually it's not based on login at the execution of the script, simply at the datasource level. Whatever the DSN can see, the script will dump... tables, SP's, views and table data. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257700 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
SQL Question
Im a little burnt out need some help. If I query a table that tracks the number of times a book was checked out and returned. I want to get the most recent item in the table to find the current status of the book. So I can find out if it is checked in or out. How do I write the SQL to find just the highest date/time stamp for that book? Thansk! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257701 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Question
select top 1 * from tablename order by datefield desc On 10/22/06, Chad Gray <[EMAIL PROTECTED]> wrote: > Im a little burnt out need some help. > > If I query a table that tracks the number of times a book was checked out and > returned. I want to get the most recent item in the table to find the > current status of the book. So I can find out if it is checked in or out. > > How do I write the SQL to find just the highest date/time stamp for that book? > > Thansk! > > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257702 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: SQL Question
Thanks Kris! That makes sense. > -Original Message- > From: Kris Jones [mailto:[EMAIL PROTECTED] > Sent: Sunday, October 22, 2006 10:12 AM > To: CF-Talk > Subject: Re: SQL Question > > select top 1 * > from tablename > order by datefield desc > > > On 10/22/06, Chad Gray <[EMAIL PROTECTED]> wrote: > > Im a little burnt out need some help. > > > > If I query a table that tracks the number of times a book was checked > out and returned. I want to get the most recent item in the table to find > the current status of the book. So I can find out if it is checked in or > out. > > > > How do I write the SQL to find just the highest date/time stamp for that > book? > > > > Thansk! > > > > > > > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257703 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SOT: Any way to get table names and datatypes via a query?
Pete, I actually have a free tool (DataMgr) that does this (among other things). http://www.bryantwebconsulting.com/presentations.cfm http://www.bryantwebconsulting.com/cfcs/ Call the getDatabaseTables() method to get the non-system tables. Call the getDBTableStruct(tablename) to get information about the columns in a table. As recommended by Microsoft, the methods use the INFORMATION_SCHEMA views instead of the sys tables (the INFORMATION_SCHEMA views will be supported going forward but the sys tables may not). For example, SQL for getDatabaseTables() is: SELECT Table_Name FROMINFORMATION_SCHEMA.TABLES WHERE Table_Type = 'BASE TABLE' AND Table_Name <> 'dtproperties' HTH, Steve Bryant Bryant Web Consulting LLC http://www.BryantWebConsulting.com/ http://steve.coldfusionjournal.com/ PS - DataMgr will work for Access, SQL Server, MySQL, PostGreSQL. I can add support for other databases if only I can get access to test on them. >Slightly Off-Topic SQL question: > >Using SQL Server 2000, is there any way to get (a) a list of >non-system table names for a given database, and (b) any way to get >the datatypes for database columns? This would be via two different >queries. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257704 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Noob MSAccess query struggle
Walter, You are grouping by dateSigned which ensures that the min() and max() will be the same (because you get a new record for each value of dateSigned). Remove dateSigned from your select statement and your group by statement and see if your results make more sense. Steve Bryant. Bryant Web Consulting LLC http://www.BryantWebConsulting.com/ http://steve.coldfusionjournal.com/ > >select signerName, signerLocation, signerComment, dateSigned, >MIN([dateSigned]) as startDate, MAX([dateSigned]) as endDate >from signatures >where signatures.petId ='#id#' >group by signerName, signerLocation, signerComment, dateSigned >order by dateSigned desc > > >returns the same (MAX) date for MIN and MAX even though the date range is >ample. >The error is laughing at me but I cannot see it. >Thanks for helping. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257705 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Noob MSAccess query struggle
Walter Conti wrote: > > select signerName, signerLocation, signerComment, dateSigned, > MIN([dateSigned]) as startDate, MAX([dateSigned]) as endDate > from signatures > where signatures.petId ='#id#' > group by signerName, signerLocation, signerComment, dateSigned > order by dateSigned desc > > > returns the same (MAX) date for MIN and MAX even though the date range is > ample. > The error is laughing at me but I cannot see it. > Thanks for helping. > You are grouping by the dateSigned column. The MIN and MAX will be on a group defined with that column...so in each row dateSigned = MIN(dateSigned) = MAX(dateSigned). If you want to return the individual dateSigned values and the related MIN and MAX for that id in each row, you will probably have to do it with subqueries...something like... SELECT signerName, signerLocation, signerComment, dateSigned, (SELECT MIN([dateSigned]) FROM signatures WHERE petId = '#id#') AS startDate, (SELECT MAX([dateSigned]) FROM signatures WHERE petId = '#id#') AS endDate FROM signatures WHERE signatures.petId ='#id#' ORDER BY dateSigned desc ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257706 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF_GoogleMap
I tried this (with the sample code) and it hung my cfserver, anyone else have this? I didn't have enough time to play with it, but I'm curious if someone else had similar experiences. dov -Original Message- From: John Blayter [mailto:[EMAIL PROTECTED] Sent: Friday, October 20, 2006 3:18 PM To: CF-Talk Subject: CF_GoogleMap http://www.blayter.com/john/cf_googlemap/ I still need to wrap up some of the documentation and examples but I thought I would release what I have so far. HTH John ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257707 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Noob MSAccess query struggle
I don't think he can remove dateSigned from the group by statement, since you must have all non-aggregate or subquery columns in the group by statement. I think he needs to look at his data in the fashion that the query is grouping it. It may be the case that the min() and max() are the same for the signer/petid that is being returned. Cheers, Kris > You are grouping by dateSigned which ensures that the min() and max() will be > the same (because you get a new record for each value of dateSigned). > > Remove dateSigned from your select statement and your group by statement and > see if your results make more sense. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257708 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF_GoogleMap
I don't know why buy I have seen it kill the server on certain implimentations. I ended up changing the CF_ to CFMODULE calls and that seemed to resolve it. On 10/22/06, Katz, Dov B (IT) <[EMAIL PROTECTED]> wrote: > I tried this (with the sample code) and it hung my cfserver, anyone else > have this? I didn't have enough time to play with it, but I'm curious if > someone else had similar experiences. > > dov > > -Original Message- > From: John Blayter [mailto:[EMAIL PROTECTED] > Sent: Friday, October 20, 2006 3:18 PM > To: CF-Talk > Subject: CF_GoogleMap > > http://www.blayter.com/john/cf_googlemap/ > > I still need to wrap up some of the documentation and examples but I > thought I would release what I have so far. > > HTH > > John > > > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257709 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Shop cart structure problem
I've got a simple shopping cart that stores cart selections in a structure.
Works great. It simply checks for the itemID, then either adds the itemID if
not found or updates the quantity key if the itemID exists.
tempvalue =
listtoarray('#attributes.id#,#attributes.name#,#attributes.price#,#attributes.quantity#,#attributes.option1#');
if (not(structKeyExists(session.cart, attributes.id))) {
StructInsert(session.cart,attributes.id,tempvalue);}
else { tempvalue[4]=session.cart[attributes.id][4]+attributes.quantity;
StructUpdate(session.cart,attributes.id,tempvalue);}
Now, the trouble I'm having, is displaying a page with a product that has
options associated with it such as size. For example a shirt. Since the above
structure updates the quanitity relative to the itemID, I'm forced to give each
shirt,size combo it's own itemID. So when a user adds another shirt size large,
the itemid for shirt size large quantity is updated. On the page where the user
sees the items offered, I can't seem be able to display the shirts any way
other than by itemid, so I end up with shirt size large, shirt size medium,
shirt size small...instead of shirt, choose which size select box.
If I add an options table in the database and relate it to the options filed in
the product, it makes it easy to display, but then when the item is added to
the cart, there's just the one id of the item. If a user goes back and adds a
second shirt, with a different size, I've got nowhere to store the size option
in my structure..since the itemid's are the same, all I can do is overwrite the
option key which won't be correct.
This seems like it should be so easy, am I missing someting obvious?
jeff
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257710
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SOT: Any way to get table names and datatypes via a query?
>>Using SQL Server 2000, is there any way to get (a) a list of non-system table names for a given database, and (b) any way to get the datatypes for database columns? This would be via two different queries. Although it is possible to get these information from SQL Server, you may find it simpler using CFX_ODBCInfo. See http://www.contentbox.com/claude/customtags/ODBCInfo/E/TestODBCInfo.cfm This tag works with virtually any ODBC connection and is compatible with CF5 and CFMX. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257711 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Noob MSAccess query struggle
>>I don't think he can remove dateSigned from the group by statement He should remove it from both the select AND the group statements. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257712 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Can I use replace function on a string to create form drop bo x options?
>>What if a manager would like a printout of the days of the week and which employees are available to work on each of those days. If I worked for a company and had a manager liable to ask anything after a project has been designed, then of course, I would take a belt and suspenders and use a cross table. For the time being, I'm my own manager, and I have my customers pay for what the need, not for what they could possibly need in a couple of years. If they need new features later (and sometimes they do), I charge them for whatever it takes for doing it. Look, I never said that using cross tables is an heresy. I just say that saying "always use cross table" is abusive for the least, and I would even qualify it as a proof of lack of experience. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257715 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT: Any way to get table names and datatypes via a query?
I always got this kind of information via the connection object and metaData() function and Claude has always offered that ODBC product. From the DSN use getConnection().getMetaData() I think. On 10/22/06, Pete Ruckelshaus <[EMAIL PROTECTED]> wrote: > > Nice, Steve, thanks! This will save me a lot of time. > > Pete > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257714 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT: Any way to get table names and datatypes via a query?
Nice, Steve, thanks! This will save me a lot of time. Pete ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257713 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cf-talk@houseoffusion.com
Each needs a starting tag" Any thought? Thanks for helping. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257716 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
SMS Gateway
Hi All, I am looking for a CF hosting provider that offers enabling SMS gateway and is not very expensive. The ideal will be where they give their customers the ability to configure it. Any leads will be much appreciated. Thanks Agha Mehdi IDT - eBusiness Program Manager Work: 408.284.8239 Cell : 510.493.0491 Fax : 408.284.2766 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257717 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SMS Gateway
Hello Agha, You came to the right place! AFP Webworks is doing just that. We have global SMS services set up for two clients now and are nearly finished setting up to allow anyone to have SMS services inbound as well as outbound, using the built-in asynchronous gateway, or xml or http post or SOAP or any of a variety of ways of connecting. Our hosting fees are not the cheapest in the world, but we're not the most expensive either, and we dont nickel-and-dime you out of business by charging a dollar extra for this and 2 bucks extra for that. We havent set prices for SMS services yet but they'll be reasonable. We can talk, as they say. And we can bill you in whatever currency you wish. Just becuase our prices are stated on our site in Australian dollars, doesnt mean we cant bill you in your own currency. We'll absorb any fluctuations in the exchange so you know what you're up for each month. Currently, US$ is about 3/4 of AUD$ so whatever price you see, take 3/4 of it for US$ price. Have a look at http://afpwebworks.com and click on 'hosting' - let me know what you think. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 10/23/06, Mehdi, Agha <[EMAIL PROTECTED]> wrote: > Hi All, > > I am looking for a CF hosting provider that offers enabling SMS gateway > and is not very expensive. The ideal will be where they give their > customers the ability to configure it. Any leads will be much > appreciated. > > Thanks > > Agha Mehdi > IDT - eBusiness Program Manager > Work: 408.284.8239 > Cell : 510.493.0491 > Fax : 408.284.2766 > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257718 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re:
Cross post, answered on another list. "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -Original Message- From: Walter Conti To: CF-Talk Sent: Mon Oct 23 04:45:51 2006 Subject: Each needs a starting tag" Any thought? Thanks for helping. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257719 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
