|
I am working in SQL Server/asp.net Database
How to using val() in sql?
mycode datatype is string
values as "MS12", "MW10", ...
My query is "Select * from FILE1 where val(substring(mycode,3,2))=10"
Sql say error as val is not recognised function name
Kindly tell your suggesions.
Thanking you
abglorie
|
|
|
|
|
Re: Please Dont Cross Post
|
|
|
|
|
How to using val() in sql?
mycode datatype is string
values as "MS12", "MW10", ...
My query is "Select * from FILE1 where val(substring(mycode,3,2))=10"
Sql say error as val is not recognised function name
Kindly tell your suggesions.
Thanking you
abglorie
|
|
|
|
|
which database you are working? Please specify
Abhishek Sur
|
|
|
|
|
sql2000 database is using
|
|
|
|
|
abglorie wrote: Sql say error as val is not recognised function name
Thats because it isn't. Bet you copied this from excel or Access. Just look up substring in sql help.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
write like this
Select * from FILE1 where Cast(substring(mycode,3,2) as int)=10
Abhishek Sur
|
|
|
|
|
Hi All,
I've created a tab container with tab panels. The page in which I created the tab container is a content page.When I run the application I am not able to view the tabs.If I create these tabs in normal pages I have no problem.
code is given below.
]]>
<asp:content contentplaceholderid="SiteContentPlaceHolder" runat="server" xmlns:asp="#unknown">
<asp:scriptmanager id="ScriptManager1" runat="server">
<ajaxtool:tabcontainer id="TabContainer1" runat="server" activetabindex="0" xmlns:ajaxtool="#unknown">
<ajaxtool:tabpanel id="TabUsers" runat="server" headertext="Users" font-underline="False">
<contenttemplate>
<asp:textbox id="TextBox1" runat="server">
<asp:button id="Button1" runat="server" text="Button">
<ajaxtool:tabpanel id="TabQuestionBank" runat="server" headertext="QuestionBank">
Font-Underline="False">
<contenttemplate>
<asp:label id="lblExperience" text="Experiencerfd" runat="server">
<ajaxtool:tabpanel id="TabPanel1" runat="server" headertext="Roles" font-underline="False">
<contenttemplate>
<asp:label id="Label2" text="Exfsdfsdf" runat="server">
|
Thanks for any one who is going to help me
|
|
|
|
|
Why do you have:
<form id="form1" runat="server">
and
<asp:scriptmanager id="ScriptManager1" runat="server">
In my opinion these to should bee on your MasterPage and not on the content page
I had a project where I used tabs on a content page without any problems...... Try to move this two and then run it again.....
Kind regards,
simsen
|
|
|
|
|
Hi,
i have created a new folder and define a class outside the app code folder but it is not visible on webpage.aspx.vb pages. will any one help me
KnightGuy
|
|
|
|
|
I think change your web site to web application. Then it will do.. I think.
You need to see if the file is included or not and in current namespace.
Abhishek Sur
modified on Thursday, September 18, 2008 6:14 AM
|
|
|
|
|
Check if the newly created class has any namespace
if it has namespace then include this namespace in your .vb class
by
using namespaceWholeName;
then try to access
<edited>
Might be yours is website and compiler will not compile you class files until these are not in App_Code folder thats the reason you can't access this class
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
Check My Blog
|
|
|
|
|
Hi,
I want to restrict the user to access the page directly through giving the address in the Address Bar of the browser. For Example, I have a page named:
http: . Now I can access this page directly by giving the address in the adress bar but I want to restrict user to access this page only through a particular link not just by giving the address. How it will be possible. Please help.
|
|
|
|
|
Check the Request.UrlReferer property on Compose.aspx and ensure that they came from where you expect them to have come from.
Not particularly good security, but does what you asked!
|
|
|
|
|
but watch out, the URL referer can be faked rather easy...
<< Nearly all men can stand adversity, but if you want to test a man's character, give him power. >>
|
|
|
|
|
I think you can check your authentication token which you place on login to session. And each page will check if you are authenticated or not.
If you are out of session, generate an error and handle it to go to some errorpage from Global.asx
For Example : Your page Compose.aspx will check Session["Auth_token"]. If true show the page, otherwise dont....
You can also use Application_BeginRequest event of Global.asax to implement this logic, because it will be called on every page call... ![Rose | [Rose]](https://codeproject.freetls.fastly.net/script/Forums/Images/rose.gif)
Abhishek Sur
|
|
|
|
|
i use checkboxlist & fill it by data source.my data item are more n all are load in that checklistbox n page becomes large.
I want a 4 or 5 checkbox at a time and remain in scroll bar so that user can select it choice by moving scroll bar.
AmitGautam
|
|
|
|
|
Dont repost
The answers posted by me are suggestions only and cannot be used in anyway against me.
|
|
|
|
|
ur question is not well understood. Please explain briefly.
And yes plz dont cross post
|
|
|
|
|
Just put your CheckBox list in Div tag give height and width to this div tag and make it scrollable like this
<div style="overflow:scroll;height:50px;width:200px" >
<asp:CheckBoxList ID="CheckBoxList1" runat="server">
<asp:ListItem>One</asp:ListItem>
<asp:ListItem>two</asp:ListItem>
<asp:ListItem>Three</asp:ListItem>
</asp:CheckBoxList>
</div>
Is that you want ?
got resolved ?
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
Check My Blog
|
|
|
|
|
I think using dynamic height will be better so that it will shrink whenever there is no checkbox.
<asp:checkboxlist id="CheckBoxList1" runat="server" xmlns:asp="#unknown">
<asp:listitem>One
<asp:listitem>two
<asp:listitem>Three
Please do change the maxheight you want before the scroll will come.
Abhishek Sur
|
|
|
|
|
its ride correctly ....
thanks for ur great support.
with great regards
amit gautam
|
|
|
|
|
hi...
how can i create a server control...could u please help me with example if possible
advance thanks
|
|
|
|
|
<asp:button id="btn_Update" runat="server" visible="false" text="Save Changes" onclick="btn_Update_Click" xmlns:asp="#unknown">
There you go
The answers posted by me are suggestions only and cannot be used in anyway against me.
|
|
|
|
|
Just write runat="server" on a control, it will be a server control.
Abhishek Sur
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
