Re: sql query for dropdownlist - ASP.NET Discussion Boards

Re: sql query for dropdownlist

Blue_Boy5-Sep-08 4:19

Blue_Boy

5-Sep-08 4:19

try this

select * from table where field1 not in (select field2 from table2 where field3 like '%05/09/2008%' and (select top 1 sum(t1.field3) from table2 as t1 where t1.field3= table2.field3 group by t1.field3)  < 1<br />

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

Re: sql query for dropdownlist

eyeseetee5-Sep-08 4:37

eyeseetee

5-Sep-08 4:37

Hi
OK Im not sure how to write this query but Im going to explain because the code above works but it doesnt do what I want.
Basically I need to do check how many rows in another table contain the number 2 and match a certain date.
so something like

select * from table where field1 not in (select field2 from table2 where field3 like '%05/09/2008%' and sum number of fields containing '2' < 1)

any help on this would be great

thanks

The answers posted by me are suggestions only and cannot be used in anyway against me.

Re: sql query for dropdownlist

Blue_Boy5-Sep-08 4:41

Blue_Boy

5-Sep-08 4:41

Which result you get from my query and which result you want to get?

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

Re: sql query for dropdownlist

eyeseetee5-Sep-08 4:49

eyeseetee

5-Sep-08 4:49

Well to be honest i used the others guys query because I didnt understand what you mean by t1 Sigh | :sigh:

The answers posted by me are suggestions only and cannot be used in anyway against me.

Re: sql query for dropdownlist

Blue_Boy5-Sep-08 4:53

Blue_Boy

5-Sep-08 4:53

Anyway

,if you want post here result which u get from query and post result which you want.

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

Re: sql query for dropdownlist

eyeseetee5-Sep-08 5:11

eyeseetee

5-Sep-08 5:11

It doesnt work, it just shows errors in the sql like incorrect syntax near '1'
thanks anyway!

The answers posted by me are suggestions only and cannot be used in anyway against me.

Re: sql query for dropdownlist

Blue_Boy5-Sep-08 5:13

Blue_Boy

5-Sep-08 5:13

.netman wrote:
thanks anyway!

No problem,it would be my pleasure if I could help you.

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

Re: sql query for dropdownlist

Apr^Ngp5-Sep-08 7:13

Apr^Ngp

5-Sep-08 7:13

@ Blue_Boy

i think in the query u provided, something like,
SELECT * FROM table AS t1
is missing ....

Apurv

Re: sql query for dropdownlist

Blue_Boy5-Sep-08 7:22

Blue_Boy

5-Sep-08 7:22

I have already specify table2 as t1 on my first post for this question.

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

window popup on textbox textchanged

kishorg15-Sep-08 2:48

kishorg1

5-Sep-08 2:48

<C1WebGrid:C1TemplateColumn HeaderText="StartDate">
<ItemStyle HorizontalAlign="Center"></ItemStyle>
<HeaderStyle HorizontalAlign="Center"></HeaderStyle>
<ItemTemplate>
<asp:TextBox ID="txtbxStartDate" runat="server" Style="width: 70px" ReadOnly="true" AutoPostBack="true" EnableViewState="true"></asp:TextBox>
<asp:ImageButton ID="imgStrtDt" runat="server" TabIndex="9" Height="21px" ImageUrl="../Images/calecder.jpg"
AlternateText="SelectDate" OnClientClick="return false;" />
<ajaxToolkit:CalendarExtender ID="clndrStrtDt" runat="server" Format="MM/dd/yyyy"
TargetControlID="txtbxStartDate" PopupButtonID="imgStrtDt">
</ajaxToolkit:CalendarExtender>
</ItemTemplate>
</C1WebGrid:C1TemplateColumn>

i have textbox and hidden button.......... <input id="hiddentxtDate" runat="server" type="hidden" />
when date get enter into textbox .....i want window popup
i want to call tht window popup in code behind.
how i will call?

getting image from scripts

rohit tiwary5-Sep-08 2:22

rohit tiwary

5-Sep-08 2:22

1.
2.
3.

i have scripts like above and many more, whether it is possible to get image from these scripts.if possible then how?

thanks for any reply in advance.

calling ASP function

The Web Developer5-Sep-08 1:42

The Web Developer

5-Sep-08 1:42

I need to call an ASP fuction when closing the form. i have a HTML button that close the page is their any way i can call a function in the aspx.vb page?

Thanks

The Web Developer. Beirout-Lebanon

Re: calling ASP function

ToddHileHoffer5-Sep-08 2:21

ToddHileHoffer

5-Sep-08 2:21

Use an asp.net button. After you run your code on the server use registerClientScriptBlock or whatever it to send the javascript to the client to close the window.

If you want to run a server side function from javasript you can use ajax to do that. The best method for that would depend on what version of asp.net you are working with.

I didn't get any requirements for the signature

Re: calling ASP function

The Web Developer5-Sep-08 2:31

The Web Developer

5-Sep-08 2:31

I'm using ASP.NET 1.1 can it be done on 1.1 ?

The Web Developer. Beirout-Lebanon

Re: calling ASP function

ToddHileHoffer5-Sep-08 2:47

ToddHileHoffer

5-Sep-08 2:47

Yes, you can still use AJAX in 1.1 but you have to use your own javascript.http://www.15seconds.com/issue/050526.htm[^]

I didn't get any requirements for the signature

restricting multiple logon to an application with single user account

surender9395-Sep-08 1:11

surender939

5-Sep-08 1:11

pls help restricting multiple logon to an application with single user account.

Here wht m doing is ,
m checking login details against a database.
if is a valid user then allowing to browse throuth the application.

my requirement is if one user is loged in and if someother user tries to login with same user account i need to restrict the second user saying "this login is already in use".

I can maintain a temp table for this , whenever a login is success i can update "isloged" field as true and we can set it false when user logs out. but how can we handle situations like
if a user logs in and closes bowser close button instead of log out.
if a user logs in and leaves doing nothing.

pls help in resolving this, if possible write a sample code for me.

thanks in advance.

need help with Bind in Gridview

pratik malviya5-Sep-08 0:27

pratik malviya

5-Sep-08 0:27

i am using gridview in My application.
for showing date i use '<%# Bind("date","{0:dd-MM-yyyy}")%>'

i have a sesson variable "date_format".
i need the date format "{0:dd-MM-yyyy}" should come from sesson variable

can this be done...........

how...................??????????????

Re: need help with Bind in Gridview

ToddHileHoffer5-Sep-08 2:18

ToddHileHoffer

5-Sep-08 2:18

Create a template column in the gridview. Add a label to that column lblSessionDate.
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
Label lblSessionDate = (Label)e.Row.FidnControl("lblSessionDate");
lblSessionDate = currentDate.toString(SessionItemClass.DateFormat)
//It is always a good idea to create a class to access session items.
}
}

in your aspx markup add the property to the gridview OnRowDataBound="GridView1_RowDataBound"

I didn't get any requirements for the signature

Re: need help with Bind in Gridview

AlexeiXX35-Sep-08 13:19

AlexeiXX3

5-Sep-08 13:19

try this

<%# Bind("date",session("date_format"))%>

if you are using c#, chage session("date_format") to session["date_format"]
Let me know if it works

Alexei Rodriguez

Chat control

Ha_804-Sep-08 23:46

Ha_80

4-Sep-08 23:46

hi,
In my web site i want include a chat control ..like customer support..
How can i do this..
I done simple chat control...but now i want to create chat support ..like customer support..

Plz give me the ideas and codes..
Thanx in advance

Re: Chat control

eyeseetee5-Sep-08 0:11

eyeseetee

5-Sep-08 0:11

Do you mean like an MSN attached to your website?I dont think this is something that is easy to create from scratch

The answers posted by me are suggestions only and cannot be used in anyway against me.

regular expression validator for telephone number

eyeseetee4-Sep-08 23:23

eyeseetee

4-Sep-08 23:23

Hi
I need a validator expression for a telephone number.
The thing is I need it to also validate the following:

XXXXX XXXXX i.e. to lots of 5 numbers which most dont validate they only validate 6 numbers on the end which is annoying as I myself have a 10 number telephone number.

thanks

The answers posted by me are suggestions only and cannot be used in anyway against me.

Re: regular expression validator for telephone number

J4amieC4-Sep-08 23:37

J4amieC

4-Sep-08 23:37

does $[0-9]{5} [0-9]{5}^ do it for you?

Re: regular expression validator for telephone number

eyeseetee4-Sep-08 23:43

eyeseetee

4-Sep-08 23:43

I used this one in the end:
(^0[1-9]\d{1}\s\d{4}\s?\d{4}$)|(^0[1-9]\d{2}\s\d{3}\s?\d{4}$)|(^0[1-9]\d{2}\s\d{4}\s?\d{3}$)|(^0[1-9]\d{3}\s\d{3}\s?\d{2}$)|(^0[1-9]\d{3}\s\d{3}\s?\d{3}$)|(^0[1-9]\d{4}\s\d{3}\s?\d{2}$)|(^0[1-9]\d{4}\s\d{2}\s?\d{3}$)|(^0[1-9]\d{4}\s\d{2}\s?\d{2}$)|^07([\d]{3})[(\D\s)]?[\d]{3}[(\D\s)]?[\d]{3}$

thanks for the post anyway.

Ive got another quick question though instead of starting anew post.
I have a dropdown which is populated from the database. however when I try and set the default value of the textbox as Select it just inserst that into the database when I use selectedvalue.
How can I set the default value of the dd to Select without entering it into the database?

thanks

The answers posted by me are suggestions only and cannot be used in anyway against me.

Re: regular expression validator for telephone number

The Web Developer5-Sep-08 1:48

The Web Developer

5-Sep-08 1:48

.netman wrote:
How can I set the default value of the dd to Select without entering it into the database?

add the new item by code after binding the data in the DD.

Does this help you

The Web Developer. Beirout-Lebanon

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.