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...
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 ...
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...
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...
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 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 all,
is there a simple & efficient way of calculating a Check Sum ... i mean i do no want to use loop and stuff .. coz if the files are large performance issues arise.
could any API be a solution ?
__________
[cheers]
Niraj...
"The unexpected success is not just an opportunity for...
hi all,
i have an activeX exe (SQL Editor) .. there could be any application using this exe. Every application will have its own database and stuff.
these parameters needs to be passed to the exe by the calling application.
how can this be done. how will the application call the exe...
hi,
am developing a DLL. the following is the function
-------------------------------------------
Function FillValues(ByRef objControl As Object, _
ByVal objRecordset As Object, ByVal FieldNumber As Integer, _
ByVal Append As Boolean)...
hi all,
i have a usercontrol which has DbGrid, ComboBox, ListBox. the
usercontrol is supposed to perform some database query.
need to set a single DataSource property for all the controls i.e when
my usercontrol is dropped on the form, the properties window should
should show a DataSource...
hi all,
need to know how to use Left Shift "<<" and RighShift "<<" operators with the "XOR" operator in Visual Basic 6.0 ....
pls pls help this is really really urgent....
__________
[cheers]
Niraj...
"The unexpected success is not just an opportunity for...
hi all,
take an example of the Data Control available with VB .. i.e the DAO
DataControl ... it has the "DatabaseName" property which shows a commondialog box to select a file from ....
am developing an ActiveX control ......
can this be done in my control too ... how ?
Pls help...
hi all,
got an ActiveX Control, this has DBGrid Combo Box and few more controls
it has a property DbNam - used to get the path and name of the database. have created a property page to set this, but the property does not update.... the code -
- in the UseControl...
hi all,
need some help on creating property pages. have designed a control which has 2-3 comboboxes and a grid.
for the comboboxes i want the user to be able to set font and color properties.
how do i do it using property pages. also if someone has a good document or a pdf on property pages...
hi all,
need to develope some kinda generic module for loggin into any Visual Basic Application. this application wud be responsible for -
1 - Granting access to the main application
2 - Force change pwd after 30 days
3 - Disable User id after 3 bad logins etc etc ...
The Poblem.
currently we...
hi below is the code
====================
Dim objRs As ADODB.Recordset
Dim objConn As ADODB.Connection
Set objConn = New ADODB.Connection
objConn.ConnectionString = "driver={SQL Server};" & _
"server=ufobaby99;uid=niraj;pwd=abc123;database=test_niraj"
objConn.Open
Set objRs...
hi all,
am trying to install a s/w from a CD but gives the above error.
what could be the reson ? how to solve this.
am using Windows 2000 and log in as administrator
[cheers]
Niraj
[noevil]
Dear all,
This FAQ explains how to Read and Write an INI files. To give a backgruond for newbies; INI files are Information files and are used to store some information required frequently... The same is accessed by some API's
in a new class module write the following code
Option Explicit...
all,
need to know how to use the existing ASP pages on and Apache web server. upgrading the server is not a problem but need a solution where i donot have to change my code...
this is a little urgent thanks !
[cheers]
Niraj [noevil]
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.