RE: Witango-Talk: db connection string in Tango
Yup, you took the words right out of my mouth Ted! That's exactly how I do it. Rick Sanders Webenergy Canada: 902-431-7279 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com -Original Message- From: Ted Wolfley [mailto:t...@ogdengroup.com] Sent: May-21-09 1:23 PM To: witango-talk@witango.com Subject: RE: Witango-Talk: db connection string in Tango Hi, Using direct dbms action, here is sample of a call I use that passes a parameter and returns a value. DECLARE @return_value int, @vmatrixido int SELECT @vmatrixido = 0 EXEC @return_value = [dbo].[ps_matrix] @vordernumberlist = N'@@user$vordernumberlist', @vmatrixido = @vmatrixido OUTPUT SELECT @vmatrixido as N'@vmatrixido' SELECT 'Return Value' = @return_value Ted -Original Message- From: George [mailto:gkass...@rogers.com] Sent: Thursday, May 21, 2009 12:03 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: db connection string in Tango Rick, I'm curious to know how you would call store proc's in witango. Do you also pass parameters? Thx George On May 21, 2009, at 9:47 AM, "Rick Sanders" wrote: I also use SQL Server quite alot. If you're in the same boat as me, the SQL that WiTango generates doesn't quite make the app perform as well as it should, and sometimes the SQL doesn't work the way it should either. What I do is write dtored procedures and just call them from WiTango. Simple queries I let WiTango build for me, but the bigger ones I will do in a stored procedure. Rick Sanders Webenergy Canada: 902-431-7279 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com -Original Message- From: Alec Katz [mailto:ak...@moveable.com] Sent: May-21-09 10:12 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: db connection string in Tango Thanks for reply, Rick. We use SQL Server on Windows. Alec -Original Message- From: Rick Sanders [mailto:r...@webenergy-sw.com] Sent: Wednesday, May 20, 2009 1:29 PM To: witango-talk@witango.com Subject: RE: Witango-Talk: db connection string in Tango I believe you can only do this with Oracle on windows, and Filemaker on the Mac. If I'm wrong, I'm sure someone will jump in. Rick Sanders Webenergy Canada: 902-431-7279 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com -Original Message- From: Alec Katz [mailto:ak...@moveable.com] Sent: May-20-09 2:21 PM To: witango-talk@witango.com Subject: Witango-Talk: db connection string in Tango Hello, Is it possible in Tango to use db connection string instead of ODBC? Thanks, Alec TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: db connection string in Tango
Hi, Using direct dbms action, here is sample of a call I use that passes a parameter and returns a value. DECLARE @return_value int, @vmatrixido int SELECT @vmatrixido = 0 EXEC @return_value = [dbo].[ps_matrix] @vordernumberlist = N'@@user$vordernumberlist', @vmatrixido = @vmatrixido OUTPUT SELECT @vmatrixido as N'@vmatrixido' SELECT 'Return Value' = @return_value Ted -Original Message- From: George [mailto:gkass...@rogers.com] Sent: Thursday, May 21, 2009 12:03 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: db connection string in Tango Rick, I'm curious to know how you would call store proc's in witango. Do you also pass parameters? Thx George On May 21, 2009, at 9:47 AM, "Rick Sanders" wrote: I also use SQL Server quite alot. If you're in the same boat as me, the SQL that WiTango generates doesn't quite make the app perform as well as it should, and sometimes the SQL doesn't work the way it should either. What I do is write dtored procedures and just call them from WiTango. Simple queries I let WiTango build for me, but the bigger ones I will do in a stored procedure. Rick Sanders Webenergy Canada: 902-431-7279 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com -Original Message- From: Alec Katz [mailto:ak...@moveable.com] Sent: May-21-09 10:12 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: db connection string in Tango Thanks for reply, Rick. We use SQL Server on Windows. Alec -Original Message- From: Rick Sanders [mailto:r...@webenergy-sw.com] Sent: Wednesday, May 20, 2009 1:29 PM To: witango-talk@witango.com Subject: RE: Witango-Talk: db connection string in Tango I believe you can only do this with Oracle on windows, and Filemaker on the Mac. If I'm wrong, I'm sure someone will jump in. Rick Sanders Webenergy Canada: 902-431-7279 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com -Original Message- From: Alec Katz [mailto:ak...@moveable.com] Sent: May-20-09 2:21 PM To: witango-talk@witango.com Subject: Witango-Talk: db connection string in Tango Hello, Is it possible in Tango to use db connection string instead of ODBC? Thanks, Alec TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Re: Witango-Talk: WAY OT: anyone know anything about PHP and files?
not using apache, but permissions were set such that anyone has read/ write privileges. witango had no problem, it was PHP that was misbehaving. On May 20, 2009, at 8:04 PM, Christian Platt wrote: Hi Roland, what permissions does the folder have? apache normally uses www as owner, witango needs witango did us try chmod 777? Christian Am 20.05.2009 um 07:51 schrieb Roland Dumas: there's a PHP application that I didn't write (or know anything about) that reads and writes to a directory. It's tracking PDF files. In the PHP application, there is a PDF folder that is an alias to the real folder containing the files. I edited the alias to point to a different folder (which contains more/better files). With that, the PHP application can't read or write to the new folder. The folder in the PHP directory was /pdf/ and is still / pdf/ but just points to a different place. I have all the permissions set so that anyone can read/write. Can any of you PHP bilinguals give me a clue how to fix this? TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Re: Witango-Talk: db connection string in Tango
Rick, I'm curious to know how you would call store proc's in witango. Do you also pass parameters? Thx George On May 21, 2009, at 9:47 AM, "Rick Sanders" wrote: I also use SQL Server quite alot. If you're in the same boat as me, the SQL that WiTango generates doesn't quite make the app perform as well as it should, and sometimes the SQL doesn't work the way it should either. What I do is write dtored procedures and just call them from WiTango. Simple queries I let WiTango build for me, but the bigger ones I will do in a stored procedure. Rick Sanders Webenergy Canada: 902-431-7279 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com -Original Message- From: Alec Katz [mailto:ak...@moveable.com] Sent: May-21-09 10:12 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: db connection string in Tango Thanks for reply, Rick. We use SQL Server on Windows. Alec -Original Message- From: Rick Sanders [mailto:r...@webenergy-sw.com] Sent: Wednesday, May 20, 2009 1:29 PM To: witango-talk@witango.com Subject: RE: Witango-Talk: db connection string in Tango I believe you can only do this with Oracle on windows, and Filemaker on the Mac. If I'm wrong, I'm sure someone will jump in. Rick Sanders Webenergy Canada: 902-431-7279 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com -Original Message- From: Alec Katz [mailto:ak...@moveable.com] Sent: May-20-09 2:21 PM To: witango-talk@witango.com Subject: Witango-Talk: db connection string in Tango Hello, Is it possible in Tango to use db connection string instead of ODBC? Thanks, Alec TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Re: Witango-Talk: db connection string in Tango
Sent from my iPhone On May 21, 2009, at 9:47 AM, "Rick Sanders" wrote: I also use SQL Server quite alot. If you're in the same boat as me, the SQL that WiTango generates doesn't quite make the app perform as well as it should, and sometimes the SQL doesn't work the way it should either. What I do is write dtored procedures and just call them from WiTango. Simple queries I let WiTango build for me, but the bigger ones I will do in a stored procedure. Rick Sanders Webenergy Canada: 902-431-7279 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com -Original Message- From: Alec Katz [mailto:ak...@moveable.com] Sent: May-21-09 10:12 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: db connection string in Tango Thanks for reply, Rick. We use SQL Server on Windows. Alec -Original Message- From: Rick Sanders [mailto:r...@webenergy-sw.com] Sent: Wednesday, May 20, 2009 1:29 PM To: witango-talk@witango.com Subject: RE: Witango-Talk: db connection string in Tango I believe you can only do this with Oracle on windows, and Filemaker on the Mac. If I'm wrong, I'm sure someone will jump in. Rick Sanders Webenergy Canada: 902-431-7279 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com -Original Message- From: Alec Katz [mailto:ak...@moveable.com] Sent: May-20-09 2:21 PM To: witango-talk@witango.com Subject: Witango-Talk: db connection string in Tango Hello, Is it possible in Tango to use db connection string instead of ODBC? Thanks, Alec TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: db connection string in Tango
I also use SQL Server quite alot. If you're in the same boat as me, the SQL that WiTango generates doesn't quite make the app perform as well as it should, and sometimes the SQL doesn't work the way it should either. What I do is write dtored procedures and just call them from WiTango. Simple queries I let WiTango build for me, but the bigger ones I will do in a stored procedure. Rick Sanders Webenergy Canada: 902-431-7279 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com -Original Message- From: Alec Katz [mailto:ak...@moveable.com] Sent: May-21-09 10:12 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: db connection string in Tango Thanks for reply, Rick. We use SQL Server on Windows. Alec -Original Message- From: Rick Sanders [mailto:r...@webenergy-sw.com] Sent: Wednesday, May 20, 2009 1:29 PM To: witango-talk@witango.com Subject: RE: Witango-Talk: db connection string in Tango I believe you can only do this with Oracle on windows, and Filemaker on the Mac. If I'm wrong, I'm sure someone will jump in. Rick Sanders Webenergy Canada: 902-431-7279 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com -Original Message- From: Alec Katz [mailto:ak...@moveable.com] Sent: May-20-09 2:21 PM To: witango-talk@witango.com Subject: Witango-Talk: db connection string in Tango Hello, Is it possible in Tango to use db connection string instead of ODBC? Thanks, Alec TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: db connection string in Tango
Thanks for reply, Rick. We use SQL Server on Windows. Alec -Original Message- From: Rick Sanders [mailto:r...@webenergy-sw.com] Sent: Wednesday, May 20, 2009 1:29 PM To: witango-talk@witango.com Subject: RE: Witango-Talk: db connection string in Tango I believe you can only do this with Oracle on windows, and Filemaker on the Mac. If I'm wrong, I'm sure someone will jump in. Rick Sanders Webenergy Canada: 902-431-7279 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com -Original Message- From: Alec Katz [mailto:ak...@moveable.com] Sent: May-20-09 2:21 PM To: witango-talk@witango.com Subject: Witango-Talk: db connection string in Tango Hello, Is it possible in Tango to use db connection string instead of ODBC? Thanks, Alec TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf