Search Again: Re: SQL hook From: mbailey@journey.net Date: Monday, June 4, 2001 Time: 6:25:03 pm If you use the SQL hooks you need the JSQL plugin to use them. The JSQL is the link to the JDBC environment in Opti.. Also Shawn notice the data format.. The same as mine all in one field. Maybe an option for the SQL Hooks to parse a single date/time field instead of needing two :) --Matt On Mon, 4 Jun 2001, Flash wrote: > Why would we need the JSQL plug-in? We are using accounting information from > VOP Radius that stores logdate as 'YYYY-MM-DD HH:MM' in Oracle. > > Regards, > Flash > > ----- Original Message ----- > From: "Shawn Hogan" <shawn@digitalpoint.com> > To: "Optigold ISP List" <isp-list@optigold.com> > Sent: Sunday, June 03, 2001 4:55 PM > Subject: Re: [Optigold ISP] SQL hook > > > > Flash wrote: > > > > > Selecting 'Import Usage' the prompts "Import Complete" and "Does the > time > > > usage import data look good? appear. No data is in the display, I > select > > > "No". > > > or > > > Selecting "History", Usage Detail returns "Err:Unknown". > > > > > > OK, yesterday, after several attempts, I did NOT receive SQL Action > Failure > > > mail. Today, I did. Both had complaints "ERR: This plugin is > unlicensed > > > ......". This message is related to CCAuthorize right? > > > > Nope... both JSQL and CCAuthorize are 3rd party plug-ins that have a > > built-in demo period until you would have to license them. > > > > > > > However, I noticed that <M1> and <M2> resolved to '5' and the database > > > expects '05'. ie YY-MM-DD = '01-05-01'. > > > > What database are you using that requires a leading zero and a 2 digit > year > > for a date field? > > > > - Shawn > > > > ------------------------------- > > Shawn D. Hogan > > President, Digital Point Solutions > > http://www.digitalpoint.com > > (858) 452-3696 > > > > > > --------------------------------------------------- > > To subscribe, unsubscribe or to search list archive > > please visit http://www.optigold.com/lists/isp.html > > --------------------------------------------------- > > > > > --------------------------------------------------- > To subscribe, unsubscribe or to search list archive > please visit http://www.optigold.com/lists/isp.html > --------------------------------------------------- > --------------------------------------------------- To subscribe, unsubscribe or to search list archive please visit http://www.optigold.com/lists/isp.html ---------------------------------------------------

Messages In This Thread: SQL hook by Sheron Lowe on Jun 2, 2001 at 5:52:32 pm Re: SQL hook by Shawn Hogan on Jun 3, 2001 at 11:25:44 am Re: SQL hook by Sheron Lowe on Jun 3, 2001 at 12:24:06 pm Re: SQL hook by Shawn Hogan on Jun 3, 2001 at 1:55:21 pm Re: SQL hook by Shawn Hogan on Jun 3, 2001 at 8:50:52 pm Re: SQL hook by Sheron Lowe on Jun 4, 2001 at 5:57:43 pm Re: SQL hook by Sheron Lowe on Jun 4, 2001 at 6:00:01 pm Re: SQL hook by mbailey@journey.net on Jun 4, 2001 at 6:25:03 pm Re: SQL hook by Shawn Hogan on Jun 4, 2001 at 8:21:11 pm Re: SQL hook by Shawn Hogan on Jun 4, 2001 at 9:06:07 pm Re: SQL hook by mbailey@journey.net on Jun 4, 2001 at 10:21:22 pm Re: SQL hook by Sheron Lowe on Jun 4, 2001 at 10:27:54 pm Re: SQL hook by Luke Skidmore on Jun 5, 2001 at 6:00:00 am Re: SQL hook by Shawn Hogan on Jun 5, 2001 at 11:09:48 am Re: SQL hook by Luke Skidmore on Jun 7, 2001 at 11:00:51 am Re: SQL hook by Luke Skidmore on Jun 7, 2001 at 11:38:46 am Re: SQL hook by mbailey@journey.net on Jun 7, 2001 at 12:14:02 pm Re: SQL hook by mbailey@journey.net on Jun 7, 2001 at 12:27:49 pm Re: SQL hook by Shawn Hogan on Jun 7, 2001 at 12:50:57 pm Re: SQL hook by mbailey@journey.net on Jun 7, 2001 at 1:04:08 pm Re: SQL hook by Luke Skidmore on Jun 7, 2001 at 1:23:01 pm Re: SQL hook by Shawn Hogan on Jun 7, 2001 at 2:01:41 pm Re: SQL hook by mbailey@journey.net on Jun 7, 2001 at 2:05:41 pm Re: SQL hook by Shawn Hogan on Jun 7, 2001 at 2:12:41 pm