Hi guys, I've got the SQL code below. When the CompletionDate is 25/12/2022 the output is Q3/2022-2023, which is what I want.
But when the CompletionDate is 14/02/2023, the output is Q4/2023-2024. How do I make it so that the output is Q4/2022-2023? Thanks for any insight guys.
'Q' + (...
Hi guys, I have this code below that supposed to evaluate if the values of the textfield and the session token are equal. If they are equal they will be redirected to google. The thing is, they are both equal always but it doesn't redirect to google. I don't know what I am doing wrong. Please...
Hi guys, I have seen this AutoBrowse and I was just thinking if maybe this can be achieved using javascript?
http://www.ilovefreesoftware.com/18/windows/internet/autobrowse-automatically-browse-websites.html
Thanks for any help.
hi guys,
i have a form with 3 textboxes, how do i make sure that at least one of the 3 textboxes have been filled in when a user clicks a submit button?
Thanks for any input.
hi guys, can you help me out please.
if i have:
parentradiobutton1
parentradiobutton2
parentradiobutton3
-childrediobutton1
-childrediobutton2
-childrediobutton3
parentradiobutton4
parentradiobutton5
how do i make childrediobuttons mandatory if parentradiobutton3 is selected?
thanks...
hi guys,
can you please help me that should show the contents of this xml using xsl please? also there are the links (colored red). i want to use those also for pagination. i've been searching the net and been trying all sorts but not been successful. i 'd really appreciate your help.
<?xml...
hi guys,
i have been using this Rss2html script: http://bytescout.com/?q=/products/developer/rss2htmlpro/how_to_display_rss_using_asp.html and this is working fine but what i want is to also have a pagination on this .asp page. can you advice of ways to achieve this?
below is the atom sample...
hi guys,
can you give me some ideas please.
i want to output on an asp page the html texts from database using response.write, but this code below gives an error
<% response.write("hello world<br><img src="somepix.jpg">") %>
changing the double quotes to the following gives no error, but...
hi guys, can you give me some ideas as to how i could achieve this using asp/vbscript?
i want to have a dropdown like this when it's october 2014
<select name="select">
<option value="0">oct 2014</option>
<option value="-1">sep 2014</option>
<option value="-2">aug 2014</option>...
hi guys, can you give me some ideas as to how i should deal with this?
i have 3 radio buttons (all with the same name and have values 1,2 and 3) and a textfield.
i want to have a javascript that makes the textfield mandatory when radio button 2 OR 3 is selected.
any ideas guys please?
thanks.
Hi guys,
I have a table that looks like this:
fld1 fld2
111 apple
111 banana
111 grapes
222 melon
333 grapes
333 orange
.
.
.
and I want a recordset that looks like this:
111 apple, banana, grapes
222 melon
333 grapes, orange
.
.
.
Can you please give me...
Hi guys, can you please point me to the right direction? I have a table that's something like this:
id mydescription col1 col2 col3...
1 description1 12% 23% 34%
2 description2 45% 56% 67%
3 description3 78% 89% 90%
.
.
.
How can I write a SQL that...
Hello folks,
I've been trying to achieve a SQL result but without any success.
If I have a table that is like this:
country
-------
Spain
Greece
UK
Spain
Japan
Australia
Japan
Norway
US
France
US
Spain
.
.
.
I want to achieve a result that is something like this;
country
-------
Spain1...
Hi guys,
Can you give me some SQL advice please? I have a small table in Access that looks like this:
ID Item Description 2000 2001 2003 DescriptionB 2000B 2001B 2003B
1 fruits grapes 23 12 35 banana 31 33 14
2 vegies bean 53 14 17...
hi guys, i have below a script that checks if there's a date and if it's in the format i need. and this works. but what i'd like to do is to also check if the entered date is before a certain date (e.g. 01-jan-2010). if the date entered is before that date, then a poup should show. any idea how...
hi guys, can you give me some advice how to write the SQL to delete the duplicates? thanks for any suggestion.
something like this
id----myWords----chkbox1----chkbox2----chkbox3
1------apple----------x
2------orange----------------------------------x
3------apple----------x...
hi guys, can you please give me some suggestions how i could achieve this? thanks for any help.
myTable:
id - txtCol
1 - detailed financial information on Apple Inc. (NASDAQ:AAPL) including real-time
2 - View the latest Apple real-time stock quote information. Get detailed breaking investment...
Hi Guys,
I am struggling with this problem can you give me some suggestions please.
Thanks.
this is the table
Date dataColumn
1/23/2012 - blah blah Word1 blah Word2 blah blah Word4 bla Word4 blah Word3 blah Word5
2/20/2012 - blah blah Word1 blah blah Word4 blah blah...
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.