Search results for query: *

Hi, I have a data flow task that truncates and appends to a table. The thing is that if this table has any results then these need to be investigated so after the data flow task I'd like a task that checks to see if the row count of the table is > 0 and if so sends an email. Also I have a few...

Thanks E, I took what you said, did some looking up and some guessing an came up with the following which works well for me. declare @SDate datetime set @SDate = '2008-04-01T00:00:00' declare @EDate datetime set @EDate = '2008-04-09T00:00:00' declare @SQLString...

Hi, Using SQL Server 2005 I'm trying to run an openquery statement that pulls data from an Oracle DB but with some date parameters and I'm getting a syntax error {Code Below}. I would just use an oracle linked server using a T-sql statement but I'm getting errors with datetimes converting into...

Remou, works perfectly and saved me hours of staring at a screen, love your work. Mike

Hi, Using access 2000 I have 2 list boxes that are supposed to perform the same action so I moved the code out to a module so I didn't have to repeat code, but I'm having trouble with that. Below is my code which works fine when the listbox name is hardcoded into the for each line but I get an...

Hi, Using acess and excel 2002, I have the below access vba that pulls data from local access tables and then adds the items to combo box on the excel sheet. (Connection lines omitted.) This works brillantly a populates the excel combo with all the data, until you save and close the excel file...

Hi, Using acess 2002 I'm sucessfully running an ado recordset and inserting it into a local access table until the recordset fields have null results. The trouble is that the string that I'm building (sqlIns) converts the nulls to empty strings as such and so I'm getting a syntax error with the...

Great! thanks for the help

Hi, This may be a noob question so pls forgive. Using PHP, Apache and MS_SQL2000 I have a page that has a text box, a select box and a submit button, this posts to another php file that then does a search using these parameters, the problem is that the select box's values have gaps and this...

Hey, Thanks for answering, I'm not sure about your first point but your second point was spot on. had an error in the adodb file adodb-lib.inc.php line 426. I then went googling and found that this line is most likely incorrect and can be fixed by replacing $rewritesql with $sql. Thanks Mate

Ah! good point thanks mate, well worth a star.

Hi, Using PHP,Apache and MS-SQL2000 I'm trying to get the required sql output and a counter at the top that says something like '100 out of 15000 records returned' I have the below code thanks to http://phplens.com and a bit of legwork but when I run this I get the result 100 out of 1 records...

Hi, Using PHP, Apache and a ms sql 2000 db I'm trying to recreate the simple scrolling through a recordset process as depicted on http://phplens.com/adodb/tutorial.implementing.scrolling.with.next.and.previous.html I get everything except for the scroll links and I'm wondering if this method...

Santa thats great and I'm sure it would work fine if we were using a current version of Oracle, I think the trouble I'm having is that were using an older version that doesn't support the rank function. You've already been heaps of help but would you have an idea how to do this in older oracle...

Hi, Using an access pass through query to oracle (Native oracle pl sql) I'm trying to return the 2 most recent records (Max PRICE_EFFECTIVE_DATES) for each contract. (SUBCONTRACT is the field in my code.) So the result I'm after is like: SUBCONTRACT P_E_DATE P_P_B 1...

Hi, [Originally posted in Access queries but reposted here in case there's a VBA solution] Using access 97 and connecting to Oracle I have 2 pass through queries that are connecting to the same oracle db but two different schemas in that db. Access to these different schemas is by the login...

Hi, Using access 97 and connecting to Oracle I have 2 pass through queries that are connecting to the same oracle db but two different schemas in that db. Access to these different schemas is by the login so I have different logins in either pt query which works fine when you run the 1st query...

Finally Sucess! Thanks for your help Remou, well worth a star. It worked by using a multi-dimensional array and a DAO recordset. Dim RstArray(1, 2) Dim rs As DAO.Recordset Set acapp = CreateObject("Excel.Application") acapp.displayalerts = False acapp.Workbooks.Open ("G:\Bsprice\BA Team...

Remou, It debug.printed all the table and tab names perfectly so I guess it's some kind of problem with the .copyfromrecordset, I thought maybe it was a timing thing but this error still happens when I step through the code also. Any more ideas? Thanks heaps for your help so far. Mike

Sure Remou, My code is below and the code is running in access 2k but effectively copy and pastes to excel. Sub test() Dim con As New ADODB.Connection Dim rst As New ADODB.Recordset con.ConnectionString = CurrentProject.Connection con.Open Set rst.ActiveConnection = con Set acapp =...