How to insert current date and time into query result in vb

[kdjonesmtb2]

Hello,

How could I insert a vbscript date and time into the following query results set?

dim qdate
dim qtime

qdate = Date
qtime = Time

set rs602 = connB.execute(replace(" select test_case='$TESTCASE$', * from #cpt_variance ","$TESTCASE$",trim(datatable("Test_Case_Number", dtGlobalSheet))))

Thanks

 

[Geates]

The same way you add a lump of coal into the tree in my front yard...

Can you provide more detail? What do the results look like? Where is the date/time supposed to go?

-Geates

http://raqxtr.sstar.com/caspdoc/html/chapter_5__developer_s_reference.htm

 

[kdjonesmtb2]

Hello

I would like to have it after the *

I was not sure of the correct syntax on the replace statement

set rs602 = connB.execute(replace(" select test_case='$TESTCASE$', *[highlight #FCE94F]qdate, qtime[/highlight] from #cpt_variance ","$TESTCASE$",trim(datatable("Test_Case_Number", dtGlobalSheet))))

 

[Geates]

I still don't understand. You can select a value or a condition. Plus, you are select all (*) so why would you need to select anything else. What is it that you want this code to accomplish?

-Geates

http://raqxtr.sstar.com/caspdoc/html/chapter_5__developer_s_reference.htm

 

[guitarzan]

Is this what you want?

set rs602 = connB.execute(replace(" select test_case='$TESTCASE$', *[highlight #FCE94F], Date(), Time()[/highlight] from #cpt_variance ","$TESTCASE$",trim(datatable("Test_Case_Number", dtGlobalSheet))))

 

[kdjonesmtb2]

Yes that is what I was looking for

This query is populating a spreadsheet on shared drive


Thanks!

 

[Geates]

Oh, I get it now. Even quitarzan's answer seemed wrong but I now understand. You want the results from the query AND certain values that are not in the results. Sorry I wasn't much help.

-Geates

http://raqxtr.sstar.com/caspdoc/html/chapter_5__developer_s_reference.htm