RE: [U2] UD to SMS
We did something similar a few years back and was managed by using URL manipulation - pretty much as you seem to be doing using CallHTTP. Unfortunately the company we were working with is no more and I can't pass on our code - but it was pretty straightforward - biggest challenge was finding someone who would provide the service at the right sort of cost. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Lunt Sent: 26 July 2005 23:47 To: u2-users@listserver.u2ug.org Subject: [U2] UD to SMS Hi All, A couple of months ago you all helped me with CALLHTTP and now I am back to ask for help with SMS. The CALLHTTP is working great, btw. We have a division in Malaysia that wants to be able to have their outside sales reps check on their monthly sales goals using cell-phones and/or pda's. The question I have for the U2 world is if this has been done already and if you can give me some guidelines on what to do and what not to do? We see this as either: 1. exporting the sales goals data to an external server that is accessible from the web 2. have the phone send a query to the Unidata system and then receive a reply with the individual's data, on demand. 3. any other ways to approach a solution to this problem, of course. :) The problem that I see with option 1 is that even though we may have some sales reps in the field that want to use the new remote query ability there could be many more that are just as happy without doing anything different from what they already have. If we off-load the data to a web-service then we either have to update everybody's data (possible security concerns) or mark the records of the sales reps that want to participate (still some security concerns) and off-load only the marked ones. Option 2 is more granular but do I have to worry about different protocols or standards used by the different phone services? I hope I have explained myself well enough. Oh yeah, can anyone recommend a good resource for the programming of SMS? Thanks for any and all assistance. Regards, Bruce Lunt --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UVODBC procedure call from VBScript
Hi, Mr. Jordan. I've been considering using ODBC instead of UniObjects for our web project, too, but am unfamiliar with . Could you please include a small, very generic, code snippet to show what you mean here. It would be much appreciated! Thanks, Dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of OZEMAIL Sent: Tuesday, July 26, 2005 6:21 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UVODBC procedure call from VBScript To return a recordset from a UniBasic subroutine to an ODBC call you need to load data into the @HSTMT variable in the UniVerse Basic Subroutine. Regards David Jordan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, 27 July 2005 6:31 AM To: u2-users@listserver.u2ug.org Subject: [U2] UVODBC procedure call from VBScript Hi all, I'm trying to convert a web app from Sybase to UV. I've been attempting to get a vbscript app to call a subroutine as a stored procedure. I am able to connect to the database using the OLE provider and retrieve recordsets. I'd like to be able to execute stored procs as well. IBM provided me with a VB sample to call a subroutine but I can't seem to implement it in VBScript. I've gone over the docs a million and one times and still can't seem to see what I'm missing. Does anyone have any samples, calling a subroutine through ODBC that would return a rescordset to the script that they would be able to share ? Thanks for any help, Vance Forste --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Connecting SQL server from Universe
We're using Easysoft ODBC-ODBC-Bridge, on our AIX using UniData connecting to MSSQL 2K, for database inquiries. I don't see why it wouldn't work for uniVerse also, you would just need write UVBASIC code to use GCI/BCI? to interface with the ODBC driver. The code is pretty simple, with BCI at least. This might be easier than trying to learn XML, if you don't already know/use it. -Arthur - - - - - - - - - - - - Arthur E. Metherall Sr. Programmer Analyst Courier Corporation - - - - - - - - - - - - -Original Message- Date: Mon, 25 Jul 2005 11:03:44 -0500 From: Yang, Songying, JIMS [EMAIL PROTECTED] Subject: [U2] Connecting SQL server from Universe Hello all, We are trying to connect to MSSQL server from Universe Database Server (currently we are using Universe 10.1.7 on Aix 5.2). Doesn't anybody have experiences in that? Thanks, Songying Yang Johnson County Court, KS --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Win2003 Serial Printers
All, One of my UniVerse clients is changing over from UNIX to Windows. They currently have a number of serial printers attached to their UNIX box using Xylogic Annex terminal servers. Since these are as old as the hills and not supported on Win2003, can anyone recommend a suitable replacement? Thanks, Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UVODBC procedure call from VBScript
I don't have a problem retreiving record sets. Actually calling the
procedure is what I'm having a problem with. The procedure calls fail with
an error of not a valid SQL command when I use a statement like
sql = {CALL LIST VOC}
or in my case I'd like it to be a subroutine but this is something like
one of the sample from the docs.
Well if I get an answer I'll pass it along
Vance
Hi, Mr. Jordan.
I've been considering using ODBC instead of UniObjects for our web
project, too, but am unfamiliar with . Could you please include a small,
very generic, code snippet to show what you mean here. It would be much
appreciated!
Thanks,
Dave
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of OZEMAIL
Sent: Tuesday, July 26, 2005 6:21 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UVODBC procedure call from VBScript
To return a recordset from a UniBasic subroutine to an ODBC call you need
to
load data into the @HSTMT variable in the UniVerse Basic Subroutine.
Regards
David Jordan
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Wednesday, 27 July 2005 6:31 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] UVODBC procedure call from VBScript
Hi all,
I'm trying to convert a web app from Sybase to UV. I've been attempting to
get a vbscript app to call a subroutine as a stored procedure. I am able
to connect to the database using the OLE provider and retrieve recordsets.
I'd like to be able to execute stored procs as well. IBM provided me with
a VB sample to call a subroutine but I can't seem to implement it in
VBScript. I've gone over the docs a million and one times and still can't
seem to see what I'm missing. Does anyone have any samples, calling a
subroutine through ODBC that would return a rescordset to the script that
they would be able to share ?
Thanks for any help,
Vance Forste
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UVODBC procedure call from VBScript
Dave:
AFAIR this is documented in the less-than-obvious location of the UCI Guide.
Here is a quick example using local UniVerse SQL in a subroutine as a stored
procedure.
I've used this with OleDB though not with ODBC, using the SQL CALL
statement.
NOTE that if you are using ODBC, I've found that {NATIVE} queries are very
much quicker that regular ODBC queries. Check out the syntax for the NATIVE
statement in the uvodbc guide.
GetOrdersForCustomer
0001 SUBROUTINE( CustNo )
0002 $Include UNIVERSE.INCLUDE ODBC.H
0003
0004 TCL = SELECT * FROM ORDERS WHERE CUSTNO = : CustNo
0005 T = SQLExecDirect(@HSTMT, TCL)
0006 RETURN
Brian
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dave Tabor
Sent: 27 July 2005 13:14
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UVODBC procedure call from VBScript
Hi, Mr. Jordan.
I've been considering using ODBC instead of UniObjects for
our web project, too, but am unfamiliar with . Could you
please include a small, very generic, code snippet to show
what you mean here. It would be much appreciated!
Thanks,
Dave
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of OZEMAIL
Sent: Tuesday, July 26, 2005 6:21 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UVODBC procedure call from VBScript
To return a recordset from a UniBasic subroutine to an ODBC
call you need to load data into the @HSTMT variable in the
UniVerse Basic Subroutine.
Regards
David Jordan
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Wednesday, 27 July 2005 6:31 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] UVODBC procedure call from VBScript
Hi all,
I'm trying to convert a web app from Sybase to UV. I've been
attempting to get a vbscript app to call a subroutine as a
stored procedure. I am able to connect to the database using
the OLE provider and retrieve recordsets.
I'd like to be able to execute stored procs as well. IBM
provided me with a VB sample to call a subroutine but I can't
seem to implement it in VBScript. I've gone over the docs a
million and one times and still can't seem to see what I'm
missing. Does anyone have any samples, calling a subroutine
through ODBC that would return a rescordset to the script
that they would be able to share ?
Thanks for any help,
Vance Forste
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Win2003 Serial Printers
yes. Whatabout hooking up a USB hub, then hook each printer to a USB - Serial adapter. If there a number of printers, then put in a PCI/USB card just for the printers, so it won't slow down any other USB traffic. George This should be a fairly inexpensive option. The Hub should be about $40-$50 maximum, and each USB-Serial (9 pin) can be had for $10-$20 each. I don't know the maximum number of USB serial ports Windows supports however. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Brian Leach Sent: Wednesday, July 27, 2005 9:21 AM To: u2-users@listserver.u2ug.org Subject: [U2] Win2003 Serial Printers All, One of my UniVerse clients is changing over from UNIX to Windows. They currently have a number of serial printers attached to their UNIX box using Xylogic Annex terminal servers. Since these are as old as the hills and not supported on Win2003, can anyone recommend a suitable replacement? Thanks, Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Win2003 Serial Printers
[EMAIL PROTECTED] wrote: All, One of my UniVerse clients is changing over from UNIX to Windows. They currently have a number of serial printers attached to their UNIX box using Xylogic Annex terminal servers. Since these are as old as the hills and not supported on Win2003, can anyone recommend a suitable replacement? What's as old as the hills? The printers, or the terminal server? Either way, taking your email at face value, Windows ought to be able to support them (I can't say for sure, not having used W2K3). The printers, you just want to select generic/text as the driver - UV will ignore the drivers anyway. The terminal servers - it was well hidden in NT4 and must surely still be there, but is probably just as well hidden :-) you must be able to configure a printer using reverse telnet ... I'm sure we did it though I can't remember how. Just configure it with the IP address and port number. Cheers, Wol --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Win2003 Serial Printers
0. Consider new printers altogether. 1. Consider contacting the original printer manufacturer. The printers probably have (EPT ?) parallel ports. 2. Together with an HP JetDirect print server, Digi has perhaps the most robust serial-to-ethernet converters for ~$200 each. 3. Printronix (free) tech support helped me with some special settings on the JetDirect to make our legacy Printronix P300 work. --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Brian Leach Sent: Wednesday, July 27, 2005 9:21 AM To: u2-users@listserver.u2ug.org Subject: [U2] Win2003 Serial Printers All, One of my UniVerse clients is changing over from UNIX to Windows. They currently have a number of serial printers attached to their UNIX box using Xylogic Annex terminal servers. Since these are as old as the hills and not supported on Win2003, can anyone recommend a suitable replacement? Thanks, Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UVODBC procedure call from VBScript
Brian,
This is exactly what I wantto do. However the VBScript syntax is where I'm
getting stuck. How do I set the arguments... I know with uvobj sub calls
you need to set the parameter values for the routine. I'm assuming the
same is true here. But this is what I have :
dim cnn
set cnn = Server.CreateObject(ADODB.Connection)
cnn.Provider = IBM.UniOLEDB.1
dim dns
dsn = DATA SOURCE=localuv;LOCATION=test;USER ID=test;PASSWORD=test;
cnn.Open(dsn)
dim rs, sql
set rs = server.createobject(adodb.recordset)
txtSubroutine = MYSUB
SQL = {CALL txtSubroutine }
rc = cnn.Execute (SQL)
but my sub has arguments that need to be passed. I'm sure I'm looking
right at the answer and looking right over it.
Vance
Dave:
AFAIR this is documented in the less-than-obvious location of the UCI
Guide.
Here is a quick example using local UniVerse SQL in a subroutine as a
stored
procedure.
I've used this with OleDB though not with ODBC, using the SQL CALL
statement.
NOTE that if you are using ODBC, I've found that {NATIVE} queries are very
much quicker that regular ODBC queries. Check out the syntax for the
NATIVE
statement in the uvodbc guide.
GetOrdersForCustomer
0001 SUBROUTINE( CustNo )
0002 $Include UNIVERSE.INCLUDE ODBC.H
0003
0004 TCL = SELECT * FROM ORDERS WHERE CUSTNO = : CustNo
0005 T = SQLExecDirect(@HSTMT, TCL)
0006 RETURN
Brian
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dave Tabor
Sent: 27 July 2005 13:14
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UVODBC procedure call from VBScript
Hi, Mr. Jordan.
I've been considering using ODBC instead of UniObjects for
our web project, too, but am unfamiliar with . Could you
please include a small, very generic, code snippet to show
what you mean here. It would be much appreciated!
Thanks,
Dave
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of OZEMAIL
Sent: Tuesday, July 26, 2005 6:21 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UVODBC procedure call from VBScript
To return a recordset from a UniBasic subroutine to an ODBC
call you need to load data into the @HSTMT variable in the
UniVerse Basic Subroutine.
Regards
David Jordan
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Wednesday, 27 July 2005 6:31 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] UVODBC procedure call from VBScript
Hi all,
I'm trying to convert a web app from Sybase to UV. I've been
attempting to get a vbscript app to call a subroutine as a
stored procedure. I am able to connect to the database using
the OLE provider and retrieve recordsets.
I'd like to be able to execute stored procs as well. IBM
provided me with a VB sample to call a subroutine but I can't
seem to implement it in VBScript. I've gone over the docs a
million and one times and still can't seem to see what I'm
missing. Does anyone have any samples, calling a subroutine
through ODBC that would return a rescordset to the script
that they would be able to share ?
Thanks for any help,
Vance Forste
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
[U2] UV 10.1.3 and Windows 2003 service pack 1
Has anybody installed service pack 1 for server 2003 on a box running 10.1.3 and if so did you have any issues. Thanks Tony Caufield IS Manager Harbor Wholesale Grocery Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] Select Question
In a message dated 7/25/2005 11:38:53 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: The distinction with using an EOF variable is that it is not referenced, until the next READNEXT. Each new variable that is read into memory will push the EOF variable further to the back. This definitely caused frame faults (I think that's what they were called) on Advanced Pick. On either U2 systems or on properly built systems, I doubt it makes a bit of difference, it might even slow things down. Charlie this is not correct. The map location of the variables is determined at compile time and not moved after that point. You can confirm this for yourself by looking at the variable map table. So if the location mapped for your EOF variable is 0080 that will not change no matter what the program RUN-time engine does. Will Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Win2003 Serial Printers
Brian - We have very successfully used Equinox ESP-8 port terminal devices to connect our serial printers over a WAN and LAN. These are inexpensive and easy to administer devices (admin through a web interface). I highly recommend them for connecting all serial devices to U2 systems. Ken At 06:21 AM 7/27/2005, you wrote: All, One of my UniVerse clients is changing over from UNIX to Windows. They currently have a number of serial printers attached to their UNIX box using Xylogic Annex terminal servers. Since these are as old as the hills and not supported on Win2003, can anyone recommend a suitable replacement? Thanks, Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ Ken R. Hall Information Technology Manager Western States Electric, Inc. a Hughes Supply Company www.wselectric.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Win2003 Serial Printers
Brian, Several of our customers have used the D-Link serial/parallel print server with excellent success. Also, if you connect a printer to another PC on the network acting as a print server (rather than directly to a print server), you must install that printer on your Universe server using an lpr port. As mentioned in another post, be sure to install the Generic/Text driver from the Generic printer manufacturer in Windows on your logical printer on the Universe server. In addition to connectivity differences, your customer also faces the fact that Universe on .nix is not exactly the same as Universe on Windows. One specific difference is that Universe on Windows has * no* print spooler (none). All print jobs go directly to either the Windows spooler or the Windows printer, depending on how the Windows printer has been installed on Windows. To resolve this problem, and to provide a print environment in Universe on Windows similar to the print environment in a generic multivalue database, we have developed a multivalue print spooler utility, SpoolerPlus (tm), that provides the functionality of a generic multivalue spooler in Universe on Windows. This can save hundreds of hours and thousands of dollars in conversion costs associated with rewriting each program and proc that generates a print job, and in retraining all users who generate print jobs from TCL in the use of an entirely new set of verbs and procedures for printing on Universe on Windows. Please contact me offlist of you would like to explore the possibility of using SpoolerPlus for your customer. Rgds, Dave Dave Taylor President Sysmark Information Systems, Inc. 49 Aspen Way Rolling Hills Estates, CA 90274 800-SYSMARK (800-797-6275) (O) 310-544-1974 (P) 800-339-1497 (F) 310-377-3550 Your Source for Integrated EDI Translation and DataSync Integration www.sysmarkinfo.com - Original Message - From: Brian Leach [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, July 27, 2005 6:21 AM Subject: [U2] Win2003 Serial Printers All, One of my UniVerse clients is changing over from UNIX to Windows. They currently have a number of serial printers attached to their UNIX box using Xylogic Annex terminal servers. Since these are as old as the hills and not supported on Win2003, can anyone recommend a suitable replacement? Thanks, Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] Select Question
If you really want to debate the issue, contact either Ian Sandler or Harvey Rodstein. The syntax came from one of their books. Personally, I'm looking into the future and seeing a THREAD CLOSED message from the moderator. Charlie Rubeor Unix/Database Admin The Wiremold Company 800.338.1315 x3498 860.523.3690 fax [EMAIL PROTECTED] wrote on 07/27/2005 11:48:14 AM: In a message dated 7/25/2005 11:38:53 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: The distinction with using an EOF variable is that it is not referenced, until the next READNEXT. Each new variable that is read into memory will push the EOF variable further to the back. This definitely caused frame faults (I think that's what they were called) on Advanced Pick. On either U2 systems or on properly built systems, I doubt it makes a bit of difference, it might even slow things down. Charlie this is not correct. The map location of the variables is determined at compile time and not moved after that point. You can confirm this for yourself by looking at the variable map table. So if the location mapped for your EOF variable is 0080 that will not change no matter what the program RUN-time engine does. Will Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UVODBC procedure call from VBScript
Ok,
Try the following. This works for me, all other routes seem to fall over :-(
- Use a ? to substitute for each subroutine argument
- Create an ADODB parameter for each argument
- Set the value of the ADODB parameter
- Append that parameter to the command Parameters collection
NOTE: Using the ADODB.Command.CreateParameter does NOT seem to work with
UniOleDB.
Assuming that dbConn is an open UniOleDB connection, this calls a subroutine
SelectTitle (similar to the one I posted before) in VB - and should work the
same in VBScript:
Dim dbParam As ADODB.Parameter
Dim dbCmd As ADODB.Command
' Set the command to point to the SelectTitle subroutine
Set dbCmd = CreateObject(ADODB.Command)
dbCmd.ActiveConnection = dbConn
dbCmd.CommandText = CALL SelectTitle(?)
' Create an unnamed parameter to substitute.
Set dbParam = CreateObject(ADODB.Parameter)
dbParam.Type = adBSTR
dbParam.Value = Text1.Text
dbCmd.Parameters.Append dbParam
' Execute and display results. RecordCount is -1 if data is found.
Set dbRS = dbCmd.Execute
If dbRS.RecordCount 0 Then
dbRS.MoveFirst
Do
List1.AddItem dbRS.Fields(TITLE)
dbRS.MoveNext
Loop Until dbRS.EOF
End If
Hope this helps,
Brian
This is exactly what I wantto do. However the VBScript syntax
is where I'm getting stuck. How do I set the arguments... I
know with uvobj sub calls you need to set the parameter
values for the routine. I'm assuming the same is true here.
But this is what I have :
dim cnn
set cnn = Server.CreateObject(ADODB.Connection)
cnn.Provider = IBM.UniOLEDB.1
dim dns
dsn = DATA SOURCE=localuv;LOCATION=test;USER
ID=test;PASSWORD=test;
cnn.Open(dsn)
dim rs, sql
set rs = server.createobject(adodb.recordset)
txtSubroutine = MYSUB
SQL = {CALL txtSubroutine }
rc = cnn.Execute (SQL)
but my sub has arguments that need to be passed. I'm sure I'm
looking right at the answer and looking right over it.
Vance
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Win2003 Serial Printers
Thanks for all the responses, I'll pass these on to the client. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: 27 July 2005 14:21 To: u2-users@listserver.u2ug.org Subject: [U2] Win2003 Serial Printers All, One of my UniVerse clients is changing over from UNIX to Windows. They currently have a number of serial printers attached to their UNIX box using Xylogic Annex terminal servers. Since these are as old as the hills and not supported on Win2003, can anyone recommend a suitable replacement? Thanks, Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UVODBC procedure call from VBScript
Hi,
I don't see that you're passing any arguments. Assuming that you are in fact
connecting, try:
SQL = CALL MYSUB ('ARG1','ARG2');
IMHO, the UV docs really should contain an example for every definition.
Brian Grayson
[EMAIL PROTECTED] wrote:
Brian,
This is exactly what I wantto do. However the VBScript syntax is where I'm
getting stuck. How do I set the arguments... I know with uvobj sub calls
you need to set the parameter values for the routine. I'm assuming the
same is true here. But this is what I have :
dim cnn
set cnn = Server.CreateObject(ADODB.Connection)
cnn.Provider = IBM.UniOLEDB.1
dim dns
dsn = DATA SOURCE=localuv;LOCATION=test;USER ID=test;PASSWORD=test;
cnn.Open(dsn)
dim rs, sql
set rs = server.createobject(adodb.recordset)
txtSubroutine = MYSUB
SQL = {CALL txtSubroutine }
rc = cnn.Execute (SQL)
but my sub has arguments that need to be passed. I'm sure I'm looking
right at the answer and looking right over it.
Vance
Dave:
AFAIR this is documented in the less-than-obvious location of the UCI
Guide.
Here is a quick example using local UniVerse SQL in a subroutine as a
stored
procedure.
I've used this with OleDB though not with ODBC, using the SQL CALL
statement.
NOTE that if you are using ODBC, I've found that {NATIVE} queries are very
much quicker that regular ODBC queries. Check out the syntax for the
NATIVE
statement in the uvodbc guide.
GetOrdersForCustomer
0001 SUBROUTINE( CustNo )
0002 $Include UNIVERSE.INCLUDE ODBC.H
0003
0004 TCL = SELECT * FROM ORDERS WHERE CUSTNO = : CustNo
0005 T = SQLExecDirect(@HSTMT, TCL)
0006 RETURN
Brian
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dave Tabor
Sent: 27 July 2005 13:14
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UVODBC procedure call from VBScript
Hi, Mr. Jordan.
I've been considering using ODBC instead of UniObjects for
our web project, too, but am unfamiliar with . Could you
please include a small, very generic, code snippet to show
what you mean here. It would be much appreciated!
Thanks,
Dave
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of OZEMAIL
Sent: Tuesday, July 26, 2005 6:21 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UVODBC procedure call from VBScript
To return a recordset from a UniBasic subroutine to an ODBC
call you need to load data into the @HSTMT variable in the
UniVerse Basic Subroutine.
Regards
David Jordan
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Wednesday, 27 July 2005 6:31 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] UVODBC procedure call from VBScript
Hi all,
I'm trying to convert a web app from Sybase to UV. I've been
attempting to get a vbscript app to call a subroutine as a
stored procedure. I am able to connect to the database using
the OLE provider and retrieve recordsets.
I'd like to be able to execute stored procs as well. IBM
provided me with a VB sample to call a subroutine but I can't
seem to implement it in VBScript. I've gone over the docs a
million and one times and still can't seem to see what I'm
missing. Does anyone have any samples, calling a subroutine
through ODBC that would return a rescordset to the script
that they would be able to share ?
Thanks for any help,
Vance Forste
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
[Fwd: Re: [U2] [UV] Select Question]
Original Message Subject:Re: [U2] [UV] Select Question Date: Mon, 25 Jul 2005 21:23:44 -0400 From: Moderator [EMAIL PROTECTED] Reply-To: u2-users@listserver.u2ug.org To: u2-users@listserver.u2ug.org THREAD CLOSED. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Unidata Data Replication - RECONFIG command
Hello all! Unidata 6.1.10 on Unix - I am doing a preliminary investigation of Data Replication and will be setting up a test environment. The guide says that I can install it manually (creating files, updating a table, setting the REP_FLAG in udtconfig), but, it also says that the system is dynamically configurable by executing the RECONFIG command. I cannot find this command anywhere. Anyone know if this is only installed by the Udt installation process if you say Y to Turn on the Replication SubSystem prompt? (Of course we originally said N) I'm on digest so TIA for any responses. Thanks! Shaun --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Unidata Data Replication - RECONFIG command
the doc can be a little confusing on this. I would call 'reconfig' an argument of the 'ud_repadmin' command. syntax: ud_repadmin reconfig The administration interface for Replication from UniAdmin client is excellent, also. Note: ud_repadmin was originally named 'repadmin' - but there appeared to be a conflict with a MS command - so we renamed it (farily early on). Wally Terhune Manager - U2 Advanced Technical Services IBM Information Management Solutions Tel: 303.294.4866 Fax: 303.294.4832 [EMAIL PROTECTED] Check out the details of the special 3 day SMB offer available for U2 customers and Partners to attend the IBM DB2 Information Management Technical Conference on September 11-16, 2005 in Orlando, Florida. See the complete listing of exciting U2 technical sessions that will be offered. Attend several of the no-charge U2 pre-conference tutorials on Sunday the 11th. Sign up for no-charge U2 certification exams that are taking place throughout the conference. Attend one of our brand new Usability Lab sessions on External Database Access (EDA) or U2 Web Builder and offer your valuable feedback on product design and functionality. http://www.ibm.com/software/data/u2/offers [EMAIL PROTECTED] erguson.com Sent by: To [EMAIL PROTECTED] u2-users@listserver.u2ug.org stserver.u2ug.org cc Subject 07/27/2005 02:29 [U2] Unidata Data Replication - PMRECONFIG command Please respond to u2-users Hello all! Unidata 6.1.10 on Unix - I am doing a preliminary investigation of Data Replication and will be setting up a test environment. The guide says that I can install it manually (creating files, updating a table, setting the REP_FLAG in udtconfig), but, it also says that the system is dynamically configurable by executing the RECONFIG command. I cannot find this command anywhere. Anyone know if this is only installed by the Udt installation process if you say Y to Turn on the Replication SubSystem prompt? (Of course we originally said N) I'm on digest so TIA for any responses. Thanks! Shaun --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type image/gif which had a name of graycol.gif] [demime 1.01d removed an attachment of type image/gif which had a name of pic32729.gif] [demime 1.01d removed an attachment of type image/gif which had a name of ecblank.gif] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UVODBC procedure call from VBScript
Hi, Mr. Jordan. I've been considering using ODBC instead of UniObjects for our web project, too, but am unfamiliar with . Could you please include a small, very generic, code snippet to show what you mean here. It would be much appreciated! Thanks, Dave Hi Dave Brian has provided examples, but it is worth considering what you are trying to do when selecting uniObjects and OLEDB. Uniobjects tends to be more stable, quicker than oledb. uniobjects is more tolerant of poor data and a lot easier to set up. However if your VB programmers don't understand PICK, then they might be more comfortable with OLEDB Regards David Jordan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Open Excel and Import a file or execute a command from a local PC
Are there any utilities to pass as comma delimited file from Unidata/Universe and have it open/imported into Excel? Any way to execute a command from a local PC workstation? Thanks, Ralph - Start your day with Yahoo! - make it your home page --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Index and Print servers
A friend asked me recently about the need or Print and Index servers on Unidata. As I don't work with Unidata that much, or at least not to the infrastructure level, I thought I would pass this on to the knowledge trust here. They are running 'current' unidata on Sun OS box. They have around 600 users with fairly active entry and reporting going on. They have noticed a lot of different bog downs and we have been able to find some. SO .. their question is .. should they be using Index/Print servers. If so using Unix for these processes they shouldn't need 'state of the art' boxes .. Yes thanks -- DSig David Tod Sigafoos --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Open Excel and Import a file or execute a command from a localPC
Ralph, I am not familiar with a utility that will send a file to windows, but, Accuterm will do this for you. Lee [EMAIL PROTECTED] 07/27/05 04:06PM Are there any utilities to pass as comma delimited file from Unidata/Universe and have it open/imported into Excel? Any way to execute a command from a local PC workstation? Thanks, Ralph - Start your day with Yahoo! - make it your home page --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Open Excel and Import a file or execute a command from a local PC
Goo'day, At 16:06 27/07/05 -0700, you wrote: Are there any utilities to pass as comma delimited file from Unidata/Universe and have it open/imported into Excel? If you're using the normal terminal emulators, eg AccuTerm, wIntegrate and whatever HostAccess is called these days, there are the built-in communication MV to desktop Import/Export utilities with them - menu-driven, and all.. If you're not using *them* then you can always write a program to build a .csv file and WRITESEQ it away. Does your implementation support a Query DELIMITER statement?If so, you can put together a RetrieVe sentence and print it to file, by preceeding your sentence activation with a SETPTR ie, SETPTR 0,3,.. (note that's 5 commas, 3) with DELIMITER set to comma, tab, whatever. Or you can get DOWNLOAD from, IIRC, cedarville . and use that.. I dare say, others will come up with even more options Any way to execute a command from a local PC workstation? Thanks, Ralph - Start your day with Yahoo! - make it your home page --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.9.6/59 - Release Date: 27/07/05 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.9.6/59 - Release Date: 27/07/05 Regards, Bruce Nichol Talon Computer Services ALBURYNSW 2640 Australia http://www.taloncs.com.au Tel: +61 (0)411149636 Fax: +61 (0)260232119 If it ain't broke, fix it till it is! -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.9.6/59 - Release Date: 27/07/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Open Excel and Import a file or execute a command from a local PC
Ralph, You may be looking for something a little more elegant, but if you generate a comma delimited file and give it a .csv suffix, Excel will just open it. From there you can save as any of the various file types that Excel supports. As for executing a command - I presume you mean *on* the local PC - I believe both Accuterm or Wintegrate have this functionality. If you prefer a DIY approach, map a common drive between host PC, write a batch file that executes your commands to a known location, and then execute it using psexec (http://www.sysinternals.com/Utilities/PsExec.html). In fact, get the whole pstools toolkit while you're there - good stuff. -Original Message- From: Ralph Burton [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 27, 2005 4:06 PM To: u2-users@listserver.u2ug.org Subject: [U2] Open Excel and Import a file or execute a command from a local PC Are there any utilities to pass as comma delimited file from Unidata/Universe and have it open/imported into Excel? Any way to execute a command from a local PC workstation? Thanks, Ralph --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Open Excel and Import a file or execute a command from a local PC
In Unidata you can do it with the LIST command using the TO and DELIM clause hth, Allen LIST Syntax LIST [DICT] filename [record_IDs] [selection_criteria] [sorting_criteria] [attributes | ALL] [format_options] [report_options] [TO [DELIM char]text_file [ELEMENTS] [WITHDTD] [XMLMAPPING mapping_file]] Description -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ralph Burton Sent: Wednesday, July 27, 2005 16:06 To: u2-users@listserver.u2ug.org Subject: [U2] Open Excel and Import a file or execute a command from a local PC Are there any utilities to pass as comma delimited file from Unidata/Universe and have it open/imported into Excel? Any way to execute a command from a local PC workstation? Thanks, Ralph - Start your day with Yahoo! - make it your home page --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Index and Print servers
David Tod Sigafoos wrote: A friend asked me recently about the need or Print and Index servers on Unidata. As I don't work with Unidata that much, or at least not to the infrastructure level, I thought I would pass this on to the knowledge trust here. They are running 'current' unidata on Sun OS box. They have around 600 users with fairly active entry and reporting going on. They have noticed a lot of different bog downs and we have been able to find some. SO .. their question is .. should they be using Index/Print servers. If so using Unix for these processes they shouldn't need 'state of the art' boxes .. Yes 1) I have little idea what you mean by Index/Print Servers. A print server to me is a machine dedicated to despooling print requests. The benefits your friend might get from having dedicated print servers will depend on their network infrastructure, the type of printers they use, and how much printing happens in their application. UniData itself is not going to spend any time worrying about printing. All it does is hand print jobs off to UNIX and let the OS handle them. If the UNIX spooler is spending considerable time waiting for printers to come on line and is continually retrying jobs then the OS will have less CPU cycles to devote to your friend's 600 users, so offloading that overhead to a dedicated print server could be beneficial. As for Index servers, I have no idea. UniData does a pretty good job of indexing if you let it, but you may mean something completely different so I'll wait for a clarification before venturing any detailed comment. 2) 'current' UniData on Sun OS: Give us a clue - Bleeding edge UniData is 7.1 (just released), reasonably current is 6.x, 5.2 is getting a bit long in the tooth, and anything earlier is way out of date. As for Sun, their OS hasn't been called SunOS for a damn long time - its Solaris. The current release is 10, 9 is modern, 8 might still count as current. Solaris 2.5, 6, and 7 are probably end-of-lifed already. SunOS was prior to that and no release of UniData above 4.1 would run on it I'd expect. 600 users on a relatively old Sun box is a decent user population, you'd expect that a number of years operating a decent sized application in that environment without input from someone who knows UniData could end up with a system that doesn't run as smoothly as it could. So to come back to your question, I'd have to say I'd need a lot more info to provide an opinion. Your friend might do well to engage someone who knows what they are doing to have a look round their system for a couple of days and do a performance analysis rather than focussing on one particular idea. Cheers, Ken --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re[2]: [U2] Index and Print servers
Ken, thanks for the info .. your 'little idea what you mean by .. ' tells me a lot. I believe it is 6.x but they are looking to make sure. My friend just got there and found a company with no 'support' for these system, no knowledge of what is or was there. So she is digging through everything to find out what is what. '.. application in that environment without input from someone who knows UniData could end up with a system that doesn't run as smoothly as it could' which is right where we are. There are a lot if file size issues we know we have to work through. I had not heard of index servers on unidata (or universe for that matter which is where i am from) but it was asked at the company and thought I would pass it along .. Thanks again DSig --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Where's the FAQ for UV/PE on Linux
I downloaded the 163Mb tar I extracted I can see a stack of what appear to be executables Figured STARTUP would be a good place to start (as DOCS did nothing) Maybe something I'm missing ? On RH9 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UV PE/Linux FAQ
I downloaded the 163Mb TAR ball I extracted see what appear to be executables DOC doesn't work, but STARTUP sort of does (well, actually it fails to - but at least it did SOMETHING that looked like an install program running) Does UV work over RH9 ? If someone can point me to some kind of installation doc I should be right (gimme a windows EXE any day !) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Where's the FAQ for UV/PE on Linux
You need the installation guide. http://www-306.ibm.com/software/data/u2/pubs/library/100univ/univ_101.html -Original Message- From: Ross Ferris [mailto:[EMAIL PROTECTED] Sent: Thu Jul 28 00:03:47 2005 To: u2-users@listserver.u2ug.org Subject:[U2] Where's the FAQ for UV/PE on Linux I downloaded the 163Mb tar I extracted I can see a stack of what appear to be executables Figured STARTUP would be a good place to start (as DOCS did nothing) Maybe something I'm missing ? On RH9 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Text extraction.
Is there any downside to having a very large number that exceeds the actual length of a string to indicate the balance of the string in the [] function. I see: NEW=ABC:REC[15,LEN(REC)-15] versus NEW=ABC:REC[15,100] Just curious. Thanks. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Where's the FAQ for UV/PE on Linux
Thanks Perry ! I Know, I Know - RTFM Wha I hadn't twigged to was the fact that I needed to set my 'tape names' to the directory where I'd unloaded everything Thanks once more -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Perry Taylor Sent: Thursday, 28 July 2005 2:14 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Where's the FAQ for UV/PE on Linux You need the installation guide. http://www-306.ibm.com/software/data/u2/pubs/library/100univ/un iv_101.html -Original Message- From: Ross Ferris [mailto:[EMAIL PROTECTED] Sent: Thu Jul 28 00:03:47 2005 To:u2-users@listserver.u2ug.org Subject: [U2] Where's the FAQ for UV/PE on Linux I downloaded the 163Mb tar I extracted I can see a stack of what appear to be executables Figured STARTUP would be a good place to start (as DOCS did nothing) Maybe something I'm missing ? On RH9 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Text extraction.
Mark Johnson wrote: Is there any downside to having a very large number that exceeds the actual length of a string to indicate the balance of the string in the [] function. I see: NEW=ABC:REC[15,LEN(REC)-15] versus NEW=ABC:REC[15,100] Not that I know of, but anybody who's had to fix a bug caused by a prior programmer using this technique and underestimating what 'a very large number' should be, will prefer to see the former to the latter. Personally, I prefer NEW=ABC:REC[15,LEN(REC)] Since it guarantees that you get the right hand end of the text without an unnecessary calculation, and LEN(REC) is implicitly known by the run machine without needing to count bytes. Cheers, Ken --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD to SMS
Thanks! This is a great start. I will have to spend some time with this whole thing before I know what we'll do but the cdp thread help a lot. Thanks again. From: Tony Gravagno [EMAIL PROTECTED] Reply-To: u2-users@listserver.u2ug.org To: u2-users@listserver.u2ug.org Subject: RE: [U2] UD to SMS Date: Tue, 26 Jul 2005 19:17:45 -0700 Bruce Lunt wrote: We have a division in Malaysia that wants to be able to have their outside sales reps check on their monthly sales goals using cell-phones and/or pda's. We had a discussion about this a couple months ago in CDP. Here's a link: http://tinyurl.com/7q3zc (scroll to top before reading) If you'd rather let someone else do the RD on this after you've seen some of the DIY solutions, feel free to drop me a note. We're planning to do this sort of integration with MITS in the near future, providing mobile information for management and field people with cell phones, PDAs, Blackberry, etc. Tony Gravagno Nebula Research and Development TG@ removethisNebula-RnD .com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
