I need to be able to pull the table names and values from each checkbox name (for example, I would need to pull the "table_city" and "20" from the checkbox above).
In short, how do I pull out the table_city and 20 from the first example. Since the table names and values vary in size, I can't just do a regular mid, left, right function.
I'm doing some text manipulation and I'm getting a strange error. My code is: [vbs] modT = trim(left(CommandArray(x), inStr(CommandArray(x), "-") - 1)) [/vbs]
CommandArray is an array created by a split() statement (so it contains strings). It's content at the time if execution (if I response.write it) is "Policies -name:Board -public:yes". What I the line above to do is return "Policies". All the math should work out, but I get this error:
Code: Error Type: Microsoft VBScript runtime (0x800A0005) Invalid procedure call or argument: 'left' buildLinks.inc, line 10 Line 10 is the line pasted above.
i got two tables (sDetail and newTable).i'm using a left join to find the dif from the two tables using the pk tutor on both tables . then i need to display the table dif on my browser but where am i suppose to take the result from?
I want to use the two first numbers of a user-input as a flag, but don't know how to get them in ASP... How can I use a function like 'variable = left(user_input, 2)' in ASP?
I am trying to retrieve data from a dropdown listbox in asp using:
<%Response.Write + Request.Form("cboBox")%>
The problem is that I only retrieve the first value of the option. For example, if my first option was <option value=this that>, I only can retrieve "this". It won't get the second word.
Is it possible with classic ASP to have a list of image files in a database, automatically transfer them onto our server from another server and resize their dimensions? We have many images of products that we have to screen grab at the moment from our suppliers' websites and it would be useful to automate this.I think there are tools for ASP.NET to do this but can't find anything to do it with ASP.
how or has the resource for graabing a users email address without them knowing? Before I hear all the 'Its not ethical' blurb - I know and my use is legitimate. I am build an e-commerce store and as well as grabbing the users IP at point of sale, i think it would be invaluable to grab a users email address (on top of their registration supplied address - but not always) so that in cases of attempted fraud there is an additional avenue by which we can investigate. The intention is by no means for spam (which I loathe) Anyone know how to do this?
The above line is used by several pages on my browser-based app to obtain the Windows login name for the user. Of course, I replaced our domain name with the generic word "DOMAIN" here, but the point is that I am trying to get that name and store it into a variable.
It works fine in Production, but not on my dev box, which is on the network and is very similar to the Production server (Same OS, for example).
On my dev box, it doesn't return anything, but in Production, it will return jsmith, mjones,etc.
<% If Len(TestRS.Fields.Item("Testimonial").value) > 150 Then Response.Write(Left(TestRS.Fields.Item("Testimonial").Value,150)&""... <br><font size=1><a href=""/Testimonials.asp"">Read More</a></font>") Else Response.Write(TestRS.Fields.Item("Testimonial").Value) End If %>
I am getting a null response from TestRS.Fields.Item("Tesimonial").Value after it is processed by the Len function.
I am getting the following result: Quote: "... Read More This tells me that the len function is analysing the string to be greater than 150 charachters yet the string is not being expressed.
I am working with two databases. One is dockets which holds all kinds of information about upcoming legal hearings. The second one is additional parties which holds additional records related to the dockets data table. Not all dockets have additional parties so when I need to display information about a case I may or may not need records from there so I am using a left outer join. It works perfectly EXCEPT for one small matter. The field that I am joining on (petitionCaseNumber) is turning up empty after the join. Below is the join.
varSQL = "SELECT * FROM Dockets LEFT OUTER JOIN additionalParties ON Dockets.petitionCaseNumber = additionalParties.petitionCaseNumber WHERE dockets.petitionCaseNumber = '" & numberIn &"'"
When I say something like response.write rst("petitionCaseNumber") I get nothing if I say response.write rst("dockets.petitionCaseNumber") I get an error. How do I refer to this field or how do I get this field to contain the case number?
I'm trying to pull a value onto my web page from a joining table and all I keep getting is the id instead of the actual value. table_status has has sid and status. for some reason I'm getting the id number instead of the value of the status. this is my error message when I try to join tables. Code:
I have it inserting a table into an iframe. However I want to pull that table information back out to make changes to it. I am just stumped on how I should go about it. I have the inserting of the table executing through a showmodedialog box. Do I do the same to pull out but how?
I have this site to where people can get access to via a username and passwrod. THere is also a download section in here, but i want to limit the amount of downloads, but i also am covering up where the download is located. So when someone hits download on the page, they get sent to an asp page. This asp page has a response.redirect to download the file.
I have stored the peoples username and password in a session. I can "response.write" the infromatino that is in the session, yet i can not assign that information to a variable. Code:
I have seen people's ASP scripts which call an external .txt file and compare it to a form's returned information (i.e. a password and login system), and--with my being new to ASP--I couldn't figure out how. What I want to do is write a form's results to a .txt document and retrieve those results via JavaScript, HTML, ASP, PHP, etc.
I was playing around in FrontPage and I noticed that you could insert an ActiveX control for a calendar. I would like to be able to use this to integrate with a database - for example, I would like to be able to click on a day of the month and have the page display all data associated with that date (sort of a select * from database where date = "date_clicked_on")
I need to download content on a webpage once a day and then parse the data. I know how to parse, so once I get the page, I'm ready to go. Is it possible to use something like the filesystemobject to read a webpage instead of filename? If yes, great! How? If no, what can I use to automatically download a webpage that I can then in turn parse?
I am working on automating a workflow process for my company. Part of the process requires the user to send a snapshot of their benefits from a secure web site to their manager. I am trying to extract the web page using Microsoft.XMLHTTP but am having problems due to user validation which is required to access the benefits web page. There are 2 layers.
First, user is required to login with user name and password, then user is redirected to another page that asks for PIN. Only if both authentications pass, the user is considered validated and is redirected to the benefits page. I am not able to through any of the validation pages. What can I do?
As a trainer in a company, I launched a webform asking people to log in before they can access the needed training. Nothing fancy and just there for monitoring who comes in and when. Problem is that some "nice-guys" enter who knows what - because that's fun. Can I counteract this by having the ASP form sending me also the IP address from the PC ? And where do I have to add these lines ? Code:
I'm doing a website in PHP/MySQL but its an IIS server - THUS no sendmail. I've used CDONTS to send email in ASP before but this time its a little different
I have a MySQL table called 'emails' in a database called 'db'. The table has Key IDs from 1 to about 50 that correspond with different email addresses. I want to use CDONTS to Grab the email addresses from the MySQL database one by one and in 15 second intervals send out the same email to each address.
I know this sounds a bit 'spammy', but it's a band website with a mailing list. Only about 50 or so entries. I'm trying to set up a mailing list manager and the only missing piece is this damn emailing script.
Many a page has ADO Connection objects that were opened but never closed. The Connection object allocates its own resources when it is opened. When the object goes out of scope without being explicitly closed, the resources ASP allocated for it are freed, but the resources it allocated on its own are not. These eventually clutter up the server and slow it down to a crawl.
My question is, is there a way to track down these orphaned resources and forcibly free them from ASP, without restarting IIS or the server? Or does one have to wait for the unused Connections to time out and release themselves? I know that good coding practice is best, but is there a temporary fix to tidy up these connections left open?
am using an XML feature to web crawl on my provider's site to get a response of an sms message sent. Am using code:
ehioze = left(sResult,3) However, i only want the results of ehioze only if its numeric characters. and if there are any alphabets, it shoudl exlude it. How woudl this be done ?
It works fine but when I use this same code to get x characters plus display it using VBCRLF, with the <br> with writing the code :
<%=Replace LEFT (Recordset1.Fields.Item("Detail").Value,VbCrLf,"<br><br>",50)%>
it gives me error so please can you tell me how can i trim the characaters and at the same time use VBCRLF. why does this above code with LEFT + vbCrLF doesn't work.
When a student taking a quiz having a duration of 2 hrs, a timer will start and keep track the time.
So if he logout or close the window, the remaining time should be recorded into the database. And when he take the same quiz again, the timer will not restart but continue from the previous time.
E.g i take a quiz having a duration of 60mins, and when i logout the time duration remain is 30mins. And when i logon and take the quiz again, the timer countdown from there 30mins but not begining of 60mins.
I am currently having a problem with one of my ASP pages; Currently, in the SELECT, I am using JOIN LEFT functions which work fine (see the code below). However, I have now created a new table which I have successfully linked to the other tables. However, I am not sure how I would word the JOIN LEFT statement for the new table.
The new table is located at Report.Report I have tried to have a go, but am I missing something? I always get an error message saying, Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC Microsoft Access Driver] Syntax error in JOIN operation. Code:
I need to be able to execute some code or display a popup when a user leaves the site. Does anyone know if it is possible to detect this? Is there an event that is called before the user leaves where I could put some code?
I need to evaluate a field's maximum value and then do an if conditional:
if rs("havesubP") = true and rs("displaygroup") < MAX then ....
whereas MAX represents the biggest value in the records for the displaygroup field (an integer datatype). I get an "Either BOF or EOF is True, or the current record has been deleted.." error if i put any type of comparison number (of course MAX is not a vbscript keyword) that is larger than my largest displaygroup value in the dbase , as I will loop thru all the records once this condition is met.
My users logon to the Patriot domain, my intranet is on sdsddata01 server. I have a form that people have to click on a dropdown list to pick their name from the list when submitting a form. Is there any way to grab their username via ADSI so I can query it against a database that will get submitted against a form.
I have seen a few arcticles regarding this but I couldn't make sense of them. They are already authenticating when they login, so I don't want them to have to do it again once they hit the intranet. Is this possible using ADSI? Will I have to make some permission changes in IIS as well?
I have a script which grabs headlines from another website. The site I am trying to grab from is in spanish and has those weird characters, but when my script outputs it onto my page, most of those special characters are replaced with question marks. Is there a way to prevent this from happening?
