Search results for query: *

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.

thank you both. that helped :-) got it working.

Hi. i am trying to write a script that scheduled to run every week and delete old archive files. the files are in a folder under c:\arch\. i have a vbscript that examines the modify date of the file. but i need to look through all the files in that folder and delete anything that is older...

thanks for posting a solution. unfortunately it's giving an error on line 11 which is xml.Open "HEAD", strURL, False the error is: error '80004005' i found another solution which also gave a different error: url = "www.espn.com" WMI = "winmgmts:{impersonationLevel=impersonate}"...

Hi. i have an intranet page that has several functions. one of them (planning on having) a page that checks a server to see if it's up or down. i've been trying several things to ping or read a text file on the server to see if it's up or down. but, i'm getting errors. is there any way to ping...

thank you so much turkbear. that helped a lot. it was what i was looking for. you deserve a star.