Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
one server to another server upload. best method?
Hello all, Iam trying to write a program to upload multiple files from one server to another server, what is the best way of doing using java technologies...either servlets, applets..etc., please also give me pros and cons... thanx sreeky -
how do i connect to lotus notes database?
hello! how do i connect to lotus notes database. my environment is asp, vbscript/jscript, sqlserver. would really appreciate if some one gives me this info. Thanks, sreeky- sreeky
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
how do i connect to lotus notes database?
hello! how do i connect to lotus notes database. my environment is asp, vbscript/jscript, sqlserver. would really appreciate if some one gives me this info. Thanks, sreeky- sreeky
- Thread
- Replies: 0
- Forum: Microsoft: ASP (Active Server Pages)
-
Need convert date format in sql SELECT statement!
what ever function i give inside the SELECT statement, I get this error => -2147467259,[IBM][CLI Driver][DB2] SQL0440N No Function by the name "CONVERT" having compatible arguments is found in the function path. Sqlstate = 42884 This is when i try using convert function. same with the...- sreeky
- Post #12
- Forum: Visual Basic (Classic)
-
Need convert date format in sql SELECT statement!
no! it is in the format mm/dd/yy. That is the standard right when we declare it as Date in vb program. now the date in db2 database is in YYYY-MM-DD, which it is not liking.- sreeky
- Post #11
- Forum: Visual Basic (Classic)
-
Need convert date format in sql SELECT statement!
even if i declare that variable as date doesn't solve the problem. tell me how should my sql look like if i declare that as date? i did try the below sqls with string and with date, they didn't work. mscSQL = "select DateValue('D_SYS_CLSD') from P.PQNCQIR where I_QLTYISS = 123" AND...- sreeky
- Post #8
- Forum: Visual Basic (Classic)
-
Need convert date format in sql SELECT statement!
i hv this sql mscSQL = "select D_SYS_CLSD from P.PQNCQIR where I_QLTYISS = 123" where actualCloseDateOut is declared as a string whenever i try to return a date using this statement below actualCloseDateOut = mscRs("D_SYS_CLSD"), it errors out. format of D_SYS_CLSD in the...- sreeky
- Post #6
- Forum: Visual Basic (Classic)
-
Need convert date format in sql SELECT statement!
Thanks for the info, but I need the function inside the SQL SELECT statement as the recordset is erring out when i tru to do getTheDate = myRs("myDate") thanks- sreeky
- Post #4
- Forum: Visual Basic (Classic)
-
Need convert date format in sql SELECT statement!
I have a VB pgm and a sql query in that selects a date. need to convert the date from YYYY-MM-DD to mm/dd/yy as the sequel server doesn't recognize the YYYY-MM-DD date format. Any help thanks, sreeky- sreeky
- Thread
- Replies: 12
- Forum: Visual Basic (Classic)
-
Error retrieving DATE(mm-dd-yyyy) from DB2 database
I am getting this error while trying to get the date from DB2 database. I have the below code in VB 6. I don't have problems retrieving all the other data. This error occurs only if I try to get dates. ERROR => Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if...- sreeky
- Thread
- Replies: 0
- Forum: Visual Basic (Classic)
-
printing problem
How do I print say 300 reports(pages)? obviously if I have them all preformatted in HTML would take lot of time......is there any alternative? Is there any java class for printing? which is fast !!!!...... -sreeky -
Can we have a string array in the session.putValue?
since i had some problem using strings ............i am now using vectors.....i have this code which gives me this error...........java.lang.NullPointerException at the line.........Vector vrs = (Vector) session.getAttribute("vrs"); I am basically trying to use this vector which was... -
Can we have a string array in the session.putValue?
since i had some problem using strings ............i am now using vectors.....i have this code which gives me this error...........java.lang.NullPointerException at the line.........Vector vrs = (Vector) session.getAttribute("vrs"); I am basically trying to use this vector which was... -
Can we have a string array in the session.putValue?
thanx as you said the array was out of scope and i also got rid os putValue() Thanks a lot! sreeky -
Can we have a string array in the session.putValue?
I have this code which is not functioning any idea why? String[] rsarray = new String[rssize]; .. .. .. session.putValue("rsarray1", rsarray); .. .. error while compiling => etxrpt_serv.java:249: cannot resolve symbol symbol : variable rsarray location: class xxx.yyy.zzz.test... -
error : ActiveX component can't create object: "word.Application"
<html> <head> <SCRIPT LANGUAGE=vbscript> <!-- 'SpellChecker ' PURPOSE: This function... -
error : ActiveX component can't create object: "word.Application"
how do i enable the script to create the client-side word application obj? i add the trusted site in the browser settings..... any help -sreeky -
is there a temporary Q?
is there a temporary Q in JAVA which I can store my data(text) and retrieve them as and when i want? -sreeky -
error : ActiveX component can't create object: "word.Application"
i am not really familiar with vbscript. can any one please tell me how to convert this code to run on the client side instead of on the server side? i know i have word 97 loaded in my hard disk. thanks, sreeky -
error : ActiveX component can't create object: "word.Application"
what it i have word or MS office97 loded in my hard drive? will it not work then?
