Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
access database query
#1
i have a query that i need to have qm hit an access query and pull the data out so i can send emails via blat (blat.net).

how can i do this?

Thanks.
#2
I cannot help much. It is possible to use COM. Begin from this:

Code:
Copy      Help
typelib Access {4AFFC9A0-5F99-101B-AF4E-00AA003F0F07} 9.0
Access.Application a._create
a.OpenCurrentDatabase(_s.expandpath("$personal$\db1.mdb") 0 "")
a.Visible=-1
3
#3
this really works well. i was wondering if there is a way to have the output not put in all the "-" and "|". any ideas?

-------------------------------------------------------
| File Name |
-------------------------------------------------------
| 175.txt |
-------------------------------------------------------
| 503.htm |
-------------------------------------------------------


thanks.
An old blog on QM coding and automation.

The Macro Hook
#4
nvmd!

wow the database type is really nice!!!!!!

fyi here's how to pull a query

Code:
Copy      Help
db.QueryArr("SELECT * FROM [Query Name Here]" a)


Nice work G.!


use this now
Database /odbc
An old blog on QM coding and automation.

The Macro Hook


Forum Jump:


Users browsing this thread: 1 Guest(s)