I have a bit of a problem with UK Post code strings, as you guys in the UK will know, our postcodes are alpha numeric.
LL12 4RS, C4 4GF, DG1 7HD etc etc...
What I need to do is grab the first letter(s) of the post code, ignoring the rest of it. Now, 'cos it can be either 1 or 2 (and in some weird cases 3) letters, I can't do a simple left() on it.I'm guessing something like a regexp will be the way to go? (but I'm a bit hazy on the reg exp thing)
I am requesting a form field which has a UK postcode value eg yo17 9hs, or NE15 7YY. What I need to do is pull out just the first part of the postcode, in this case it will be yo17 and ne15. Anyone help me do this in asp?
strURL = "url that is required" strFileName = sXML
Set oOriginalPO = CreateObject("MSXML2.DOMDocument") Set oXMLHTTP = CreateObject("MSXML2.XMLHTTP")
oOriginalPO.async = False oOriginalPO.load strFileName 'name of file containing cXML data
oXMLHTTP.open "POST", strURL, False 'strURL is our URL you post to oXMLHTTP.send oOriginalPO
So on the assumption that the sXML variable has correct information inside it to send out, can anybody see why perhaps this code isn't working properly?
I'm trying to work out how to do a post code search with longitiude and latitude, the idea is to be able to input yuor postcode and the search will return all company stores in that area.
Is there a way to 'force' a submit on a form with out actually allowing the user to press a button ? For example...
step1: A from is filled out by a user, then they click the submit button.
step2: The form is 'post'ed to an ASP page which writes the values to a database. So far No problems. But..
step3: Now I want to 'post' these values again to another page without any user interaction.
My ideas were:
1) I know you can get the form values from Request.Form("myVar"), so I thought of making a 'dummy' form and setting the 'values' of the form variables to these Request.Form("myVar") valiables, but I don't know how to 'submit' them to another page again.
i have a series of .asp pages that i am dividing into model, view, control logic. my view collects a whole bunch of data and posts it to the controller. im wondering if there is a way to somehow "re-post" this same data to my model page.
in short, is .asp capable of taking data posted to a page and re-post that same data to another page?
i am retrieving a record from the database, I am trying to place the value of the FULLNAME field in a textbox on a Form, the Problem is that it only displays half of the name leaving out the stuff that comes after a SPACE.
Example:
adors("fullname").value <--- Actual Value is John Smith but it only displays John Code:
SELECT * FROM NK_editie " & MM_whereConst & " " & whereClause & " ORDER BY editie desc
And
SELECT * FROM NK_editie INNER JOIN NK_edities ON NK_editie.editieid = NK_edities.ID ORDER BY editie desc
Now I want to combine those 2 to one string.
I have problems to set it up in working order. My tryout: SELECT * FROM NK_editie INNER JOIN NK_edities ON NK_editie.editieid = NK_edities.ID & " & MM_whereConst & " " & whereClause & " ORDER BY editie desc
It shows al the records which are joined, only the second string " & MM_whereConst & " " & whereClause & " is not working.
I found out a really nice way to keep things on the same page is for any processing page to add on a "?<something>=<something>"
and then just check to see what the something is equal to, and the number represents what you want the front page to show.
However, this <something> shows up on the url listing in a browser. Is there anyway to .. encode it so no one can see it? Like a encode/decode function?
I'm building a forum, and right now i'm creating the ability to edit posts. As part of this i want to add the usual "Edited by UserName on Date" line at the bottom, but am having problems doing so.
The problems seems to do with formatting the text in the variable with <span>s using stylesheets, or if there are " and ' markes in the post proper (which I can't seemt to remove with Replace). Here's my code:
I am developing a website and it's going fine, but i've heard that you shouldn't have your database in the wwwroot, it should be outside/above that.
I've done this (i'm using Dreamweaver MX) so I moved the db, fixed my odbc/dsn, connection string etc, but when I upload now I get this error.
Microsoft JET Database Engineerror '80004005'
'C:Program FilesEnsimSiteDatawebpplianceconfdomainsInet pubwwwrootTesting_SiteDatabasesTesting_Website _DataSource.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. /Testing_Site/default.asp, line 8
This is line 8: Recordset1.ActiveConnection = MM_TestingConnection_STRING
Is there something that I have missed. It was ok when it was in the wwwroot.
i am having a problem with comparing two strings. I am taking in the parameter rs("Company") and if this is empty i want to put some text in there. I am testing it with an empty Company field and comparing it like so:
temp1=rs("Company") temp2=StrComp(temp1,NULL)
I have also tried it with temp2=StrComp(temp1,"")
but each time i get nothing returned. Is there some rule about comparing a string with an empty string?
I am using ASP to connect to a simple database to retreive information and also to imput information.What I need is a simple dns connection string syntax to connect and query data.
I have a search function on my site, and what happens at them moment is the user fills in a text box with their search string, and clicks submit. The search page takes their string, and splits it up where it sees " ".
All fairly simple, what I'd like is to allow the user to enter text in speechmarks, so the script would search for a couple of words together, as well as being able to search for every individual word...
Everyone confused yet?!
e.g If the user enters Dev Shed Forums , then the search would look for every occurance of the strings "Dev", "Shed" and "Forums"
What I want is for the user to be able to enter "Dev Shed" Forums, and the search will look for "Dev Shed" and "Forums"...
How do I "escape" any quotes, accidental carriage returns etc that are contained within strPageTitle? Do I have to use a series of replace() functions, or is there a cunning way that makes it OK?
(Using escape(strPageTitle) fills the box with % signs...)
I am storing some strings via asp.net in my dbase. The string looks like this:
Well, that`s just a simple level 100 quiz aiming to imprint ""standard random number generators are not really random"" program to those who still lack it. What will produce the following C# snippet? ‘ ....
Now I am reading these values via ASP and need to print them out.
Unfortunaly it does not UnCode the string back so that I can show it to the user. I know I could use the replace function but I wont replace all chars, there are many from this type. What can I do?
I'm trying to see if a certain string matches a predefined string so I've tried:
-------------- If txtCondition3 = "NO THEFT COVER unless client claim free and occupied prems for 3 yrs" Then response.write "1st condition" Else response.write "2nd condition" End If --------------
I have a form with multiple text fields, when i submit the form i want it to edit a table in my database using UPDATE. I know i have the syntax correct. The problem I have is 2 fields are Currency and 2 are Date. The request.form command always returns a string and i keep getting the 'Data type mismatch in criteria expression' error. How do i convert the strings to dates, and strings to Currencies.
I am currently developing a registration application for the Boy Scouts. We have paper forms for those who choose not to use a computer to register. The paper forms have a box for each letter so that it is legible. how can i re-create the paper forms with ASP. For those who go online and register they need to print out the youths registration forms and I want them to look like the paper forms.
Now there are a few fields that are mutliple words so it would have to support spaces as well. Is there even a way to do this. I know it is going to be a pain for the good look it is going to be critical. I was thinking of using strings to simply seperate each letter and tell the script to simply repeat until. Is the right way?
i have 2 strings: a value in an array and a variable from some xml. I need to numeriaclly add them together, as they are both strings, using + doesn't work. I have tried cStr but it errors what do I do?
I've got a couple of strings I use to validate emails.
I have no idea what either of them do or what they mean! I found them, they work, so I use them!
Could somebody let me know what these mean? My guess is that the longer string is better, simply because it tests more thoroughly, but I could be mistaken.