skip, thanks for the quick response, but the problem is the file am uploading is hughe and runs in to thousands for records and if for every record i do this , it will be very time consuming
any thing else, better than this ... thanks
__________
[cheers]
Niraj...
"The unexpected success...
hi experts,
am passing a date in "dd/mm/yyyy" fromat (reading from a file) to a table in SQL database. but when i see the table the date is converted.
ex - i enter 08/04/2004 (8th April 2004)
the table shows 04/08/2004 (4th August 2004)
the data type of the field is date
am using SQL 2000 and...
will list down very specific steps am trying ti achieve.
1.Open the Word document
2. Goto the First line
3. From there go to the first Table
4. start inserting data in the Table Cell one after another
5. Save and close the file
6. give the user a link of file on the server.
but now the...
tsuji,
thanks for the response,
but i guess the wdLine is some parameter defined for the GoTo function in MS Word. creating constants will not help... nevertheless i tried the same
now for some odd reason it gives and error
ASP 1077
Server.CreateObject Failed
Invalid ProgID. For...
Dear all,
i have word templates i.e word do with empty tables etc ....
1. want to use ASP to populate them
2. and then save the file on the server
3. give a link to the user for that file
am using the following in the ASP page but it gives an error "Expected Statement" pls help ...
thanks, i also tried the ADODB Begin / Commit / Rollback Trans it worked... but now another issue with this
say i have a hughe file for upload, and error occures at line number 1000, the program will still continue to read and attempt to write, then at the end it will give anr error and...
try directly uisng the following stmt
Left(Request.ServerVariables("PATH_TRANSLATED"), inStrRev(Request.ServerVariables("PATH_TRANSLATED"), "\")) & <<actual file name>>
__________
[cheers]
Niraj...
"The unexpected success is not just an opportunity for innovation. It demands...
dear all,
i have understood that we can redirect all errors to a custom page and display a whole lot of information to the user etc etc ... but still got a very basic doubt.
Example :
I have a page which uploads a file to the database. There could be errors on this page. how do i do a rollback...
thanks but that's a typo on the forum on the page that is perfectly ok i even tried the following code
dim i
dim j
j=Session.Contents.Count
Response.Write("Session variables: " & j)
For i=1 to j
Response.Write(Session.Contents(i))
Next
it shows 0 variables. pls note the next page is a framed...
the following is the code
Page 1:
Session("SCName")= Request("txtusrname")
'// This writes to the database table
Call WriteToLogFile(Session("SCName"),"INFO",Now,"LOGIN SUCCESSFUL")
Response.Redirect "ican.htm"
Page 2:
Reponse.Write(Session("SCNam"))
this does not show the value. what could...
after some goo amount of research i figured out that there is no other way but to write a recursive function for this.... some problem still .......
<%
'Sample to get the menu hierarchy
set rsMnuTop = Server.CreateObject("Adodb.recordset")
set rsMnuLvl = Server.CreateObject("Adodb.recordset")...
would not really help, because in the current example under the menu CPC there is only one item which is Os Det , what if under Os Det there is another one ....
CPC
|__Os Det
|__Level 2
would not be able to go on creating tables. gues this should be possible ! .. don't know how...
actually am jus trying, and hence using *...
but the problem is : am trying to biuld a generic menu heirarchy into the table and then retrieve it using the code so some menu in DHTML can be made
the current table represents the MENU
UPLOAD
|__CPC
|__Os Det
|__IBBS
|__Vendor
Reports...
onpnt, thx
this is my table
cod_mnuId txt_mnuname mnu_Pindex mnu_Nindex txt_page typ_top
1 Upload 0 0 upl.asp Y
2 CPC 1 3 cpc.asp Y
3 IBBS 1 4 ibbs.asp N
4 Vendor 1 5 vend.asp N
5 Os Det 2 0 os.asp N
6 Reports...
Thank u all, actuall me jus getting back to some coding...
Thx once again
__________
[cheers]
Niraj...
"The unexpected success is not just an opportunity for innovation. It demands innovation."
[noevil]
am using SQL 2000 and ASP the below code gives an error
set rsMnuTop = Server.CreateObject("Adodb.recordset")
set rsMnuLvl = Server.CreateObject("Adodb.recordset")
rsMnuTop.open "select * from menumaster where typ_top='Y' and mnu_Pindex=0 and mnu_Nindex=0",con,adOpenDynamic
do until...
hi,
ummm try using RND function to generate Randon numbers to avoid duplicates.
as regards to already exisitng duplicate values u can write a select stmt to get the duplicate values and then update accordingly
hope this helps else write back
__________
[cheers]
Niraj...
"The unexpected...
hi all,
need to construct a regular expression for the following file
-------------------------------------
01.05.2001 BALANCE BROUGHT FORWARD CREDIT INR 969,228.00
02.05.2001 CASH MGMT NO HOLD 30.04.2001 50.00-
0112021293002 CCLRUIIC...
hi all,
me new to regular expresion. below is the file
'//// File Start
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAa
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAa
^D
Funds Transfer USD 10.00
Cust Ref : EEE
Bene Name : Niraj
Some More : 1
ONE MORE FIELD ...
hi,
if am not wrong u can look at using "format" function which allows u to format date in many different ways.
also i don't think any kind of a control should matter. finally if u store it in a variable u can deal with it the way u wish to.
hope this help u
__________
[cheers]...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.