Recent content by wvdba

if EmpID in tblAssoc has even one null value, then your query will return nothing. better us "not exists". it's also more efficient.

sql server 2008 R2 i think i already mentioned in my post that I DID use split() which gives me five rows. i want five columns. thanks.

Hi, i have a database table column whose content looks like 'abc-1-a-2-01'. i know i can use split(column_name, '-'). this gives you 5 rows of data like abc 1 a 2 01 however, i like to split this into 5 separate columns like abc 1 a 2 01 any help would be greatly appreciated. thanks.

Hi, i have an access 2003 database with some tables. i'm trying to get a list of tables in the database. the code i'm using is: Set objConnection = CreateObject("ADODB.Connection") Set objRecordSet = CreateObject("ADODB.Recordset") dbfile = "c:\a\fleet\fleet\fleet2.mdb"...

hi. i have a page that submits the data and goes to a 2nd page (asp) using a submit button. i would like to print the screen AND submit the form. there's a javascript snippet that checks the data before submit. is there any code that can be placed in java script snippet to print the screen...

SOLVED: here's the code that i used in vbscript that actually workd. strCon = 'connection string for database goes here Set objConn = WScript.CreateObject("ADODB.Connection") Set objRs = WScript.CreateObject("ADODB.Recordset") objConn.Open strCon sql = "SELECT image_data from...

thanks chris. the code on the link does not write the binary data (image) toto file. it just displays it on the browser. i'm able to do that. i just need the binary data to be written to a .jpg file. thanks.

ok. let's say i don't display the page and the image and just want to write the binary data to a file. 1 - i retrieve the binary data (image) from the database. 2 - how do i write this binary data to a file to be used as an image file? in asp classic? or vb script?

that's a great suggestion for a save dialog box. but i'm trying to do this for 1000's of images automatically.

the asp page is on the intranet. the page displays an image. i want to save the image to my local machine. just as if i right-clicked. i'm not sure where to use/set authentication. thanks.

there are hundreds of images based on a page that gets the BLOB (binary large object) from an oracle DB and displays it on a page. here's the code: surl="http://10.xxx.xxx.xxx/offimage/imagedisplay_int.asp?bookid=77863" slocal="c:\a\fleet\" & first_name & "_" & middle_name & "_" & last_name &...

Hi. I have this page that is supposed to display a jpg image from a db on an intranet page (which works fine). I have been asked to let a user to save this jpg image save on his/her local machine when the image is displayed on the page. I used a piece of code that tsuji had posted a while back...

Thanks for the response. table b may have duplicate ID's - which does. and table b has dept_nbr also: 1 john shipping 1 john orders 1 john service 2 jane logistics 2 jane communication 3 .... 4 .... 5 .... 6 .... 7 .... in that case i want to select...

Hi. i have two tables a and b. table a: id name 1 john 2 jane 3 jack table a: id name 1 john 2 jane 3 jack 5 jim 6 mike 7 tom i want to see only 1, 2 and 3 to show up on the resut. i'm using join. but it lists all 7 rows no matter what i use. thanks.

what you need to do is "tattoo" the hard drive using a utility from HP called HDD-DMI. this is done for motherboards and hard drives.