[cfaussie] Re: SMSC SMS providers in Australia

2006-09-26 Thread christophe albrech
Lucas,Here, we're using messagemedia, who are an sms wholesaler. this means that you can actually bill your clients per SMS. they have an java api, which works pretty well.Tof On 9/20/06, Lucas [EMAIL PROTECTED] wrote: Hey Folks,does anyone know of a good SMS provider in Australia that will allow

[cfaussie] Re: Query picking up an odd value from somewhere

2006-09-26 Thread Joel Cass
My own take on it would be that there is an issue with your joins. You could either get rid of all the brackets and join each table sequentially, IE. SELECT FROM A INNER JOIN B ON A.ID = B.A_ID INNER JOIN C ON C.ID = B.C_ID etc OR grab tables and join in the where clause

[cfaussie] Re: SMSC SMS providers in Australia

2006-09-26 Thread Lucas
Hi Tof,thanks for that - we are already working with these guys and their java api but we want to take things to the next level and make use of the free SMSC intergration/gateway that is in CFMX Enterprise.L. On 9/26/06, christophe albrech [EMAIL PROTECTED] wrote: Lucas,Here, we're using

[cfaussie] Re: Query picking up an odd value from somewhere

2006-09-26 Thread Seona Bellamy
On 27/09/06, Joel Cass [EMAIL PROTECTED] wrote: My own take on it would be that there is an issue with your joins. You could either get rid of all the brackets and join each table sequentially, OR grab tables and join in the where clause This might make things easier to see.. Good call.

[cfaussie] Re: Query picking up an odd value from somewhere

2006-09-26 Thread Blair McKenzie
If the fields are the same, just use a QoQ union egcfquery dbtype=query name=qCombinedselect * from qA union select * from qB/cfqueryOn 9/27/06, Seona Bellamy [EMAIL PROTECTED] wrote: On 27/09/06, Joel Cass [EMAIL PROTECTED] wrote: My own take on it would be that there is an issue with

[cfaussie] Re: SMSC SMS providers in Australia

2006-09-26 Thread Steve Onnis
When you say "free" I believe its not actually free as such. Its a gateway that you need to hook into an actual SMS gateway so you still have to pay for messages. You don't actually send messages and receive messages for free. It is supposed to an example of how to create a gateway.

[cfaussie] Query picking up an odd value from somewhere

2006-09-26 Thread Scott Thornton
regarding your vaguley related question: can you UNION yor queries together? (assuming all the fields are in the same order and of the same data type) [EMAIL PROTECTED] 27/09/2006 11:11 am On 26/09/06, Greg Misdom [EMAIL PROTECTED] wrote: I'm not much of a sql person, but I'd say that each

[cfaussie] Re: Help with a Oracle issue

2006-09-26 Thread Mark Mandel
How is this for bizarre - If I remove the binding - i.e. change SELECT sequence_value FROM transfer_sequence WHERE sequence_name = cfqueryparam

[cfaussie] Help with a Oracle issue

2006-09-26 Thread Scott Thornton
does arguments.object.getTable() return something that the cfqueryparam might think is something more complicated than an actual varchar\string? [EMAIL PROTECTED] 27/09/2006 11:53 am How is this for bizarre - If I remove the binding - i.e. change SELECT

[cfaussie] Re: Help with a Oracle issue

2006-09-26 Thread Mark Mandel
Nope... It's because it seems that CF assumes that for cfqueryparam'd data the database is not likely to change.. so it caches the database meta data. You make a change, like add the whole new table, it freaks out. I've gotten around it by checking if the error occurs, and then firing off the

[cfaussie] Re: SMSC SMS providers in Australia

2006-09-26 Thread Duncan
Lucas, I just had a chat with the IT guys here, asa far as they are aware there isnt a provider in Aus that allows you to do this. Java API, HTTP and email are the only ways we know of. Having said that they havent looked into this for a while - if you find someone that allows you to connect

[cfaussie] Re: SMSC SMS providers in Australia

2006-09-26 Thread Mike Kear
Steve's right, you cannot send SMSs without paying a provider somewhere along the line either by paying money per message, or carrying an ad for some other product with your message. If you need to connect directly to the SMS gateway using SMPP, talk to me. I have a solution for you nearly

[cfaussie] Re: SMSC SMS providers in Australia

2006-09-26 Thread Lucas
Hi Steve,that is correct - i am more than happy to pay for the SMSes, just looking to use the gateway...L.On 9/27/06, Steve Onnis [EMAIL PROTECTED] wrote: When you say free I believe its not actually free as such. Its a gateway that you need to hook into an actual SMS gateway so you still

[cfaussie] Re: ColdFusion Hosting Australia

2006-09-26 Thread Ben[dog]
If i may contribute, Don't go Inevative, I've worked with a client who was using them, and w, not happy. Very poor service, don't ask any questions, you probably won't get a reply. I'd recommend Web Central (webcentral.com.au). They're a tad expensive maybe but they provide some really good