Basically, what I want to do is to group records according to the first letter of "username" (the primary key).
SQL = "SELECT order_date FROM cart_order WHERE username = 'A*' ORDER BY username"
I've tried using a 'wildcard' (*) in the SQL statement and it doesn't work. So, how does one filter out records according to the first letter of the cell's data?
if not request("email") like "%@%" or not request("email2") like "%@%" then
response.write "<span class=""whitebox500""><br>THIS DOES NOT APPEAR TO BE A PROPER EMAIL ADDRESS."
response.write "<br><br><Br><input type=button onClick=""javascript:history.back(-1);"" value=""Back to Signup <<""><br><br>"
response.end
end if
and want to wildcard test the request to see if it is properly formatted email with an @ and a dot.
I want to replace everything after a colon (:) in a string using ASP
Replace.
Here's an example of the procedure I want to perform:
dim hr1, hr1replace
hr1 = "H.R. 1908: Patent Reform Act of 2007 (On Passage)"
hr1replace = REPLACE(hr1,": [WILDCARD GOES HERE]","")
so the remaining text is only: H.R. 1908
I want someone to enter an area code in a field. They would hit search, and it would pull up all records whose phone number starts with that area code entered. Code:
View Replies View RelatedI have a website and I'm having users upload their homemade mp3s to my server. Anyway I want to have random filenames attached.
The user uploads from their computer
C:DocumentsMusicsong.mp3
I want it to be saved on my server as
d:wwwrootmywebsitemywebsite.comwwwuploadsfnm 8uy.mp3
I have tried the MoveFile and the CopyFile method but when I use wildcards in the Source it gives me a Path Not Found error .....
strSQL = "SELECT user_name, password FROM [tblLogin] WHERE user_name = '" & Request.Form("user_name") & "' AND password = '" & Request.Form("password") & "';"
Is using AND the correct way to use 2 comparisons in the WHERE part of the SQL??
I have a database table, that I need to sort by PART of the contents of a field (named rFieldName in the table):sample contents of this field are:Code:
qid_5_question_1
qid_12_question_5_0_1
qid_12_question_5_0_2
qid_12_question_5_1_1
qid_12_question_5_1_2
qid_12_question_5_2_1
qid_12_question_5_2_2
qid_12_question_5_3_1
qid_12_question_5_3_2
qid_6_question_2I need to sort his field by the value that appears AFTER the 3rd underscore, and if applicable BEFORE the 4th underscore
Is this possible - can you help please - I have no idea where to start on this as I've never had to try to do something like this before.
I would like to use the last 10 characters of a Session object. Is this possible in active server pages. I am familiar with the user of Right$ in visual basic but I after trying serveral conatations I have had to give up.
View Replies View Relatedhow do I get a reg exp to remove part of a string? -
I have: '/page/txtonly/index.asp' and I want to remove the '/txtonly' to end up with: '/bobby/index.asp'.
is it possible to reload just one table row with out reloading the entire page? Or reloading just a table? i'm not thinking it's possible but if it is it's worth asking a qustion.
View Replies View RelatedI need to limit how much of a record is printed to screen. I just want text up to the first full stop.
View Replies View RelatedFollowing java script code to get subscriber ID, its value is like 975683678-28_luxap01s.southernlinc.net, I want to leave number there and cut starting _ part, does anybody know how to remove the character starting underscore "_"? the final value is 975683678-28.
<%
subsciberID = Request.ServerVariables("HTTP_X_UP_SUBNO") ;
%>
we have a database with a lot of products in it. and for some reason one fo the feilds is set up like "<img src="images/something/image.jpg" />". they should be set up without the html but because of the way they are set up theres no way i can use them outside of the root directory.
I need a way to just pull the first 10 characters off the string. which would be the <img src=" part, and then pull off the last 4 characters " />. so that i am just left with images/something/image.jpg.
I can sort of get the first part to work by using Mid(string,10)
but how can i remove the last 4 characters?
in php the function would do the ending characters if you made it a negative number. but Mid(Mid(string,10),-4) doesnt seem to work.
I have a login page where i validate my user id and password... this part is done... I need to get the user id to the next page i am showing...
Example like:
-------------------------------
Login Page
userid : abc
pwd : XXXXX
Authentication Successful
---------------------------------
Next Page:
Welcome abc ---> i want it here
----------------------------------
Anyone can show me how shld i do it...
I am coding a login system with login form etc. and when users are denied access to a secure page within the secure area, I want to obviously send them to the login page to check who they are and check they are allowed to view the secure content of the site.
The problem I am having is that currently, if a user is denied access to a secure page, they are sent to the login page. Once they are granted access, they should be sent back to the page they were originally trying to view and not to the main menu.
(The secure area has lots of pages and users would not be happy if they had to trawl through hundreds of pages to try and find what they wanted.
I know I need to use the ServerVariables collection to retrieve the ("URL"), but I dont want to just use this as a querystring parameter when I send a user to the login page.
This would be insecure because someone out there would find my little login script and start using it on their own site by sending users to my login script to login, and then using the querystring parameter to redirect the user back to their own site.
All I want to do is select the part of the URL after the http://www.somedomainname.co.uk/manager/ part. I cannot use a Left select or right select option because my login script will be put onto lots of different websites, and I would have to change the Left select on each different site.
I can come up with a page that displays some information. The information will always be displayed on specific part of the page, with auto refresh. But he doesn't want the whole page to be refreshed so that buttons and images around the information do not get
reloaded each time. Is this really possible?
Other pages on this site don't use frames, so this page can't use frams too. Creating an ActiveX control is also not an option of us ...
Is there a way of extracting only part of an entry retrieved from a SQL database. For instance, if I have an article of 4000 characters can I extract only the first line of the article and them put a link to the full article after the extracted text.
It is something I have been trying to master and will help me display my retrieved recordset data better.
I have link from a page.If you click on 'pedir presupuesto' it goes to a form, when someone clicks submit on the form the next page sends an e-mail, and must print part of the table from the original asp page (0.asp - from the first darker grey header to the second one).
View Replies View RelatedI want to strip email from the text. Some of my users may send me a string:
str = "This is email 1: Join Bytes! and here is email 2: <a
href="mailto:me@me.com">me@me.com</a>"
How do I parse the string to get email address only? mI know I may use instr() to determine if email address exists, but please, give me a hint on how to handle it next.
I have created a drop down box that picks items (active product lines) from my dbase (sql), once the user selects an item from the drop down, I would like asp to relate that choice to the next table and pop up another drop down box (active products from the above product line chosen).
I'm assuming that there needs to be some function to hide the second drop down box until the first choice is made (I could be wrong here??) so I don't know what the code would be for the page to stop showing anymore information until a choice is made. I usually show code here but this is really a question about code that I don't know.
The web page has page1.asp, page2.asp, page3.asp, etc... However, When we type http://www.myserver.com, and go to different pages, the URL will be unchanged. How to do that? Usually, it will be http://www.myserver.com/page1.asp, http://www.myserver.com/page2.asp, etc..., with the actual page.
View Replies View Relatedi have a site that has a header include file, i don't want the header to refresh as i navigate through the site. Is this possible?
View Replies View RelatedI'm just starting out learning a bit of asp with my job so pardon my bad use of any jargon
In 'A:B:C: D:E' I want it to only return 'A:B:C: D'. Dropping off the content after and including the LAST :
Can anyone help?
i did not see from that view point of yours. anyway, i guess everyone reading this thread learned something about sessions & querystrings.
View Replies View RelatedIs there a way in asp to retrieve part of the URL and use it
say the url was
http://localhost/site/craig/default.asp
or
http://localhost/site/craig/test.asp
or
http://localhost/site/craig/roger.asp?dan=1
is there anyway of retrieving the word craig so to use it in the page, I just want the word Craig
This is because i could have other addresses that are for example
http://localhost/site/jon/default.asp
or
http://localhost/site/jon/test.asp
or
http://localhost/site/jon/roger.asp
where i need to retrieve the word jon
at the moment i use the code
strURL = Replace(Request.ServerVariables("URL"), "/default.asp", "")
intStart = instrRev(strURL, "/") + 1
strName = mid(strURL, intStart)
this worked fine until new pages are added ie a page that isnt default.asp
Obviously i cant use strURL = Replace(Request.ServerVariables("URL"), "/default.asp", "") because default.asp will change...
i want to update a specific part of a page every 3 seconds without refreshing the whole page, any ideas?
View Replies View RelatedI am trying to generate a tree view in asp 3,0 using sql server.Whats happening is its not pulling the data from the database i can only see folders and the gifs but not the actual data. Code:
View Replies View RelatedOn one of the sections I have a text field called IMO where the user may input text. Beside the IMO text field I have a button that will submit the value found in the IMO field if any to another asp page namely get_vessel_fields.asp.
I don't get any errors but nothing happens when I click the button.
<FORM><input type="text" name="IMO"> 'THis is the IMO field in question there are other fields in this form
Dim strIMO
strIMO = IMO
<FORM><INPUT TYPE='button' VALUE='Pop' onClick='get_vessel_fields.asp?strIMO;return true;'></FORM>
'get_vessel_fields.asp will then process the value submitted
I've spent ages hunting for this but no joy, another user suggested cookies, but was ideally hoping to use Session Variables so its just stored while a user is on the site.
Basically I need to capture a section of a URL i.e.
www.myurl.com?ref=thisiswhatIneed!
I then need to simply save 'thisiswhatIneed' into a session variable and then enter it into a form box on another page (which I know how to do).
I just don't know how to get/store the part of the URL?
Alright, now I'm trying to combine time and date in one variable as such:
Combined = time & " " & date
But instead of getting 12:42:13 PM 6/12/2006, I just want to get 12:42 6/12. How do I strip off the last characters to just get the parts I want? Also, I'd really like to see the time in 24 hour(military) format, but I'm not sure how to accomplish that either.
I have the following string loaded in var1:
DMN-NebatoFMeussen
How can i make a function that isolates the FMeussen part so anything that is before the backslash is ignored/deleted.
I'm migrating from Dimac Jmail to Microsoft CDOSYS for an ASP
application, and I'm in stuck with a multipart message wich sends an e-
card. Code:
I'm working on an asp page where I need to be able to click on a link and then show or hide a section of the page. Kind of like folding markers. I can do it by simply refreshing the page but I'd prefer for it to just open and close. Is there a way to do this?
View Replies View Related