|
select wef,weeklyoff,empTimePoliciesId from emptimepolicies where wef >= #2\1\2006# and employeeid=928
is there any problem in the above query?
Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....
|
|
|
|
|
Yeah, the #'s don't look right to me. What makes you ask ?
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Thanks
Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....
|
|
|
|
|
i think u should try to compile u'r query in query analizer.. and look the output
Sonia Gupta wrote: wef >= #2\1\2006# and employeeid=928
i dont know what kind datatype u use for wef and employeeid?
Regards,
Tomi
|
|
|
|
|
Thanks Few minutes ago christian pointed out a very silly mistake.
Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....
|
|
|
|
|
Sonia Gupta wrote: #2\1\2006#
That is a date literal used by the MS Access database. If you are using any other database, it's apostrophes around the date instead.
Also, the database might not recognice that exact date format. You should use a parameterised query, so that you don't have to format the date as a string.
---
single minded; short sighted; long gone;
|
|
|
|
|
I have a site and I want to perform a simple check on each page that session exists.
The exact check on each page will be as below:
If session doesn't exist for the user redirect it to login page
Do I need to write the code on each .cs file or is there a better way to perfome this operation.
Please suggest!
Pavas
|
|
|
|
|
mpavas wrote: Do I need to write the code on each .cs
if u want to do that, its fine..but i think u can make a class for the session check..so, if u want to check the session all you need is call the class function for session check
Kind Regard,
Tomi
|
|
|
|
|
|
Anytime Pavas
Regards,
Tomi
|
|
|
|
|
TomiEdy wrote: so, if u want to check the session all you need is call the class function for session check
Session is not in the context of a class ? So you need to get Page object here to access session. Is it a good practice ?
|
|
|
|
|
Im getting this error "SELECT permission denied on object '_______', database 'name of database', owner 'dbo'." while connecting to database in SQL in asp.net
help
-- modified at 3:50 Tuesday 31st July, 2007
|
|
|
|
|
Sounds like your DB is set up so the user you're logging in as doesn't have permission to do a SELECT.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Isn;t it the ASPNET user, not the logged on user? I recall having to grant permissions to the ASPNET user more than once.
|
|
|
|
|
I was thinking of the user within the database, not the ASPNET user on the system, but you're right, that could be an issue also.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Hello
I try to connect to an Access database ,
The following error appear when i try to open the connection:
"The 'Microsoft.Jet.OLEDB.4.0, DataSource=E:\Documents and Settings\Assaf\Desktop\ProjectToBeSubmited\School.mdb' provider is not registered on the local machine."
Thanks in advance
Assaf
|
|
|
|
|
Assaf82 wrote: ...OLEDB.4.0, DataSource...
try it with a semi-colon here, not a comma...
|
|
|
|
|
ok the Error now is change to :
"Could not find installable ISAM."
Tnaks a lot
-- modified at 5:14 Tuesday 31st July, 2007
Assaf
|
|
|
|
|
Check what drivers are installed on your machine
Control Panel --> Admin tools --> Data Sources --> Drivers
Maybe try setting up a DSN for the database and see if you can acces it through that
If still no luck Google:-
"Could not find installable ISAM" Access
and take it from there... good luck!
|
|
|
|
|
I go to the Admin too and i can find the database
What you mean by setting that:
"Maybe try setting up a DSN for the database and see if you can acces it through that"
Thanks
Assaf
|
|
|
|
|
Assaf82 wrote: setting up a DSN
Control Panel --> Admin tools --> Data Sources --> System DSN --> Add...
follow the wizard, then you can use a connection string like
dsn=mydsnname;uid=xxx;pwd=yyy;
|
|
|
|
|
Hello everyone
I stored some chinese text into my database.but when i got this value into my asp dropdownlist it's showing such as ",< /*& ".
so helps me about this particular...
-- modified at 3:48 Tuesday 31st July, 2007
Deepak
Smile a Lots,Its Costs Nothing
|
|
|
|
|
Hi i am using some links in one of my form...,
Those links i want in all my other forms too...,
I dont like to give each and every forms those links...,
So i like to give those links in some javascript....,
To call that javascript those links want to be come there all other forms...,
Its possible?,
This is my code:(That Inside "div" things want to come in script)
How to do that,Plz help me...,
<form id="clock" method="post" runat="server">
<div class="horizontalcssmenu">
<TABLE id="Table1" style="Z-INDEX: 103; LEFT: 8px; POSITION: absolute; TOP: 136px; HEIGHT: 15px"
width="700" bgColor="#cde686" border="0">
<TR>
<TD style="WIDTH: 836px">
<ul id="cssmenu1">
<li style="LEFT: 4px; BORDER-LEFT: #202020 1px solid; WIDTH: 144px; TOP: 0px; HEIGHT: 1%">
<A style="WIDTH: 160px; HEIGHT: 1%" href="default.aspx">Master</A>
<ul style="LEFT: 0px; TOP: 0px">
<li>
<A href="frmCompanyMasterDetails.aspx">Master Company</A>
</li>
<li>
<A href="frmProjectMaster.aspx">Master Project</A>
</li>
<li>
<A href="frmprojectrpt.aspx">Report</A>
</li>
</ul>
</li>
<li>
<A href="Login.aspx">LogOut</A>
</li>
</ul>
<br style="CLEAR: left">
</TD>
</TR>
</TABLE>
</div>
<asp:hyperlink id="hplchequeissued" style="Z-INDEX: 102; LEFT: 992px; POSITION: absolute; TOP: 328px" runat="server" ForeColor="Indigo" Width="96px" Height="24px" NavigateUrl="frmChequeissuedstatement.aspx" Visible="False">Cheque Issued</asp:hyperlink>
</form>
Regards,
Magi
|
|
|
|
|
Magh_M wrote: i am using some links in one of my form...,
Those links i want in all my other forms too...,
Am I missing Something in Your Question?
Why dont u use a master page that contain the link u want..so if u want those link in other form just add your pages into the master page
Regards,
Tomi
|
|
|
|
|
Means?,
I didnt get what ur trying to say?,
Ya,i have shown those links in my default.aspx page...,
If i selct the link it will go to another aspx page...,
There also i need all those links...,
How to do that?,
Regards,
Magi
|
|
|
|