String Included Or Not
I had a variable called "customer_id_list" and the value is "1, 2, 4, 5, 8". I would like to check that if "4" is in the variable. It return "T".
View RepliesI had a variable called "customer_id_list" and the value is "1, 2, 4, 5, 8". I would like to check that if "4" is in the variable. It return "T".
View Repliesgot this code , among others (attached below) for shopping cart from a friend and it suppose to work, however it requires a connection string to make this database driven website works, so my question is how do I insert a connection string code in the string so that it will make a connection to the Access database. Code:
View Replies View Relatedi want to backup my database included id number..
there are alot table in my database..
but they are not connected with each other..
for example..
table name : products
id | product_name
------------------------
75 ASUS notebook
another table name : type
id | product_id | product_type
----------------------------------
1 75 PIV 3GHZ
2 75 PIV 3.2GHZ
this database is mssql..
how to protect(save) id number while backup database ?
I'm wondering for a way to reload my included page (with a few recordsets) from time to time and display and alert for a trigger limit (based on recordset results)..
I tried to reload it using js, but in that case it reloads the whole page and not only the included file...
<script type="text/javascript">
function page_reload(){
window.location.reload()
}
function page_reload()
{
var t=setTimeout("page_reload(),30000)
}
</script>
Any clue??
I want to save space and time by creating a simple .asp or .txt file that is called into a page. That is a simple include code but how do i make it so the same page opens but the included file changes dipending on the linking page.
something like a dinamic included code.
<!--#include virtual=" dynamic field that changes according to link"-->
Do you think you can help me guys?
I have a function on an "included" page.
For reasons unknown to me I frequently will get an error - to the effect
that the function can't be found.
If I hit refresh/F5 it loads the page just fine.
It doesn't happen often .. maybe once every 50 pages. It also doesn't
happen on any specific page.
I'd show code, but it's not really related to either the function or any
specific page.
Is there any sort of a delay between Asp loading the "includes" and
processing the rest of the page? I'm wondering if the function is getting
called before the include is pulled in.
I have a pretty complicated site written in ASP (it's not live yet, so I really do not want to post a url). On one of my pages, I have a header, the top area, and then the middle area which changes when I click on different links, but the url remains the same.
I need to figure out how to print the middle area. When I just do a print page, it doesn't come out formatted correctly at all. I've been playing around with printing/converting to PDF, which works well, except that most pdf components expect a URL to print, and in this case my url is generic..it doesn't point to a specific page.
Is it possible to get the filename, and more importantly the path, from inside an ASP file, when that file is included? I know it can be done for the base file using Server variables, but I can't figure out how to do that for an included file.
I need to write an application that uses include files, and that may be moved to another folder on the server...
I've got a file in an application that is included in many, many files of an
application, like this:
<!--#INCLUDE FILE="inc_file.asp" -->
I need an instruction I can included at the beginning of inc_file.asp so
that it will not process if I decide to turn it off. I know I can just
replace it with a blank file, but I'd like something more flexible.
I'm assuming that Response.End will end the entire script, and not just the
included file.
I'm attempting to include a file within another file using Server.Execute. This works fine... however, I need to pass the value of a variable defined within the parent file to the one included via Server.Execute.
From what I've read, the included files are processed before the parent files, so it seems as though the variable is getting lost. Is there any way to internally (not relying on query string) to pass a variable to an included file?
I been trying to send a Html email with a form included. I tryed by including <form> and <input> as usual in Html code. What happen is that the email is send and the form are seen but the input button doesnt work right, in hotmail , msn, I mean its not active
Any idea?
I have a standard Header.asp that I want to include in every other page in
my site. Header.asp is located in the root folder, but the calling pages are
in various folders/levels. Since the relative paths specified in header are
subject to change and are based on the relative path of the calling page,
problems arise. (Strangley, using the IFRAME method of including a header
doesn't react the same way.)
The solution I believe lies in using absolute paths in the Header.asp file
using the "virtual" include qualifier. But this assumes your development
directory structure is the same as your production environment. So I guess
that is the answer. Use absolute paths and set up your development directory
structure to be identical to your production.
At my site I have designed a framework with tabs as below:
(tabs_1.asp)
+----+ +------+ +-------+
| MC | | Cars | | Boats |
+ +-------------------------
then, into tabs_1.asp I include another page
(tabs_1_2.asp)
--------+ +--------------
| New | | Used | | Crasched |
+-----+ +------+ +----------+
Works fine so far... Here comes the problem...
The file tabs_1_2.asp has an included page (data.asp) witch doesnt appear...
When I look at the sourcecode from the webbrowser it seems to have been included but nothing is visible.
Is it inpossible to make several includes in the way I described?
I'm developing an Asp.NET system to take a CSV file uploaded via the web, parse it, and insert the values into an SQL database. My sticking point comes when I try to split() the string returned by readline() on the file.
The following code snippet works for me:
tokens = "one,two,three,four".Split(",")
for each token in tokens
response.write("<td>"+token+"</td>")
next
However, if I take the next line in the CSV, read using StreamReader.ReadLine on the PostedFile.InputStream, I receive "Object reference not set to an instance of an object." which I have narrowed down to be my string holding the line. Further investigation reveals that no other string member functions work on my line (.ToCharArray, .ToString, etc).
I suspect that StreamReader.ReadLine is not correctly returning a string, even though Response.Write(line) displays what I would expect .....
I have a form in which several elements are expected to be all digits. Some of those elements can be left empty, but if specified they must be all digits. I have this Sub to edit them: ....
View Replies View RelatedI am pulling info from a sql server By default the query pulls back the inforamtion as text.Therefore when I go to calculate some figures its giving me a type mismatch error.
Is there a function in can call to convert a text string to an integer string using
rstSearch.Fields("name").Value .To pull back the info in a for loop
Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch
If a visitor doesn't put anything in the "Search" text box I'd like them to
be redirected to where they came from before the search form forwarded them
to the search.asp page. Therefore I've put the following at the top of
search.asp to do this.
I am trying to search my access database for a string using LIKE and a wildcard.
Example:
Code:
Dim con
con = "SELECT names.* WHERE name LIKE 'sam*'"
For some reason this gives me no results even though I verified there is entries with the word sam in them.
Also tried using % instead of *. Also took out wildcard. I can search for an integer without a problem though, when I try a string, regardless if there's relevant entries I get nothing back at all.
I am using an SQL statment with a LIKE clause. I am trying to print the actual SQL statement on the screen. However I cannot print a '%' character on the screen. I tried using Chr code and just % outright.
Random variables:
name, rank
Code:
sSQL = "SELECT * from myTable WHERE myField LIKE '" & name & "%'"
It just prints on the screen: (assume name=joe)
"SELECT * FROM myTable WHERE myField LIKE 'joe'"
i have an object which is a string, (objrs4("points")) how do i convert it into int numbers.
View Replies View Relatedi need requirement for the current assignment Im working on.Part of my assignment I have to saved updated data from a datagrid and put into database. I had everything working, but without option strict and explicit. When I put it on i'm having trouble getting the value out of it.
What I need is to get the value out of the textbox control of a datagrid in edit mode. The value is supposed to be in Item.cells(2).Controls(0) but I have no clue on how to get it out correctly. Ive tried everything but keep getting errors that it cannot be converted to a string.
the subject that i need to filter the URL from a memo field that having lots of URL in it, like when we post a message with URL www.websourceinfo.com it will become a base url link with click
View Replies View RelatedI searched google for this (probably easy to solve) problem, but all answerd there did not work hop someone can help me out.In an asp I want to check whether a string contains a " if so the response should be that the "-sign is not allowed.
Elseif InStr(1, username, """) > 0 then Response.Write "-sign is not allowed in the username."
Tried char(34) and /" and """ but none of these options seem to work.
I guess this is easy, but I ask anyway.How can I cut 'www.' and '.no' or '.com' from a string?
example input:
www.norway.no
www.somewhere.com
I want this output:
norway
somewhere
How can I do this?
splitted from this thread, I need to dosomething similar i need comare 2 variables. one of them conaints the other variable but have more information
i need compare
a= "red car"
b= "red"
and then i need ask if is b in A then c=b but i dont know how.
converting string to hex like so:
for x = 1 to len(source)
target = target & hex(ascw(mid(source,x,1)))
next
How to convert it back to a string?
I got as far as:
for x = 1 to len(source) step 2
target = target & chr("&H" & mid(source,x,2))
next
but this fails with the pound sign (£ - £)
This seems like it should be so simple. I would like to create a conditional statement based on the length of a string. The string is a memo field from an Access database. I would like to handle long memos differently from short ones. I'm starting out just by trying to write out the length of the string:
memo = RS("Idea_Note")
Response.Write Len(memo)
I can response.write the memo without trouble, but I get nothing for the length of the memo.
I have a drop down list of ssn and text box to input ssn to view the info in the next page. I am having a problem with displaying and when I debugged the code, I am getting a comma next to the ssn. Here is my code the dropdown and input type:ssn is text field. Code:
<table>
<tr>
<td>
<Select name=ssn >
<%response.write("<option value=""" & RS("ssn") & """>" & RS("ssn") & "</option>" & vbcrlf)%></td>
<td><input type=text name=ssn value="">
</tr>
</table>
In next page when I response.write ssn, I am getting the ssn as: 123456789, why am I getting a comma next to the ssn?
I got this huge query string that works well if I put something like this:
"select * from table"
in the table, there is a field called result wich is a varchar
so if I write "select * from table where result=" & result it says:
Microsoft OLE DB Provider for SQL Server error '80040e07'
Conversion failed when converting the varchar value 'E' to data type int.
/backoffice/ac_medica/operadores.asp, line 82
I'm gonna need the same for dates later... Can anyone tell me how?
I am wondering if any body can guide me on how to break up a string so that i can use the first letter as a querystring.
View Replies View RelatedI need to create some .asp pages to publish data from our manufacturing lines...but I can't figure out how to establish the connection string and print the data. I've been stuck on this all day and about to start pulling my hair out!!!
As an example, can someone create the most basic code necessary to build a web page that does the following:
a) connect to a SQL version of the Northwind db (assume I have a functioning ODBC connection called 'Northwind_ODBC' on a server called 'ProductionServer')
b) Loop through the records in the [Shippers] table and paste the values in a HTML table (using SELECT * FROM SHIPPERS)
I know it sounds simple but I'm looking through some books and can't find a solution that works on my server.
NOTE: I'm running Server 2003 (with IIS), SQL Server 2000, and I have proven ASP does work on this machine...unfortunately, just not with the code I'm trying to build!!!
Im trying to create a string from checkboxes that have been checked, but for some reason its not working
strNumbers = ""
for each key in request.form("chkFacility")
strNumbers = strNumbers + "" & key & ","
intCount = intcount + 1
next
So I want to end up with a string like this '3,12,7.' Instead Im just getting a single number. Am I doing this the right way. Any help wud be just fantastic!!
I am passing the following variables....
City - name of city
RentLow - low range of rent
RentHigh - high range of rent
myquery - keywords
The following is the start of my query string but I am having issues with the City portion already and I have not gotten to the rent yet
I know the SQLquery portion right below is fine - it tested perfectly, along with the rest of the query, it was when I added in the request city string that gives me No value given for one or more required parameters. even though one is passed in the string.
SQLquery = "(" &parsethis(strText ,words ,wCount, 3) & ")"
SQLquery = Replace(SQLquery, "<FIELD1>", "title")
SQLquery = Replace(SQLquery, "<FIELD2>", "description")
SQLquery = Replace(SQLquery, "<FIELD3>", "comments")
SQLstr = "SELECT * FROM links WHERE " & SQLquery & " AND city = " & Request.QueryString("city") & " AND linktype = 2 AND active = " & myTrue & " " & SortSQL & ";"
end if