When rs("firstname") is called on my page,
it returns the first name and a blank space before it.
I want to pass it throught the QueryString,
but URL's can't have blank spaces.
On my DB (Access), the none of the firstnames have any spaces in front of them.
Any ideas?
I retrieved some data from the database and put it in a textbox but the words after the blank sapace cannot be shown, why is that?
Name = rs("requestor") 'where the name is "Sam Siew"
<TD><INPUT TYPE=TEXT Name=requestor size=12 Value=<%=Name%>></TD>
In the text box, it only show "Sam".
I have entries in the database that have spaces (Todd's Place) but when I try to get the info into an input box it only shows the first part of the string before the space (Todd's) Here is my code
strSQL = "SELECT ID, memname FROM tblMembers WHERE ID =" & numID
Set rsEdit = adoCon.Execute (strSQL)
<input type=text value=<%= rsEdit.Fields("memname").Value %>>
The funny thing is I can see the whole string when I view the source on the page (<input type=text value=Todd's Place>) but why can't I see it in the form.
what i am trying to do is when the database field is empty to not display the box (table) that is in my css file, whereas when there's something in the field i would like the box to display!!! So i'm basically trying to get a 'when field empy, do nothing!!! my code at present generates the box no matter whether the field is full or not!!! Code:
View Replies View RelatedHow do I change a blank database entry, so when I retrieve it blank I output a string say <i>N/A</i> into a table? Currently I have an if/elseif/else like this.Code:
if tf.name = "ID" then
Response.write(bla bla)
else if tf.value = null then
Response.write(bla bla)
else
Response.write(bla bla)
end if
*Note, where the word null is, I have also used the string "" and it still does not work.
Here's what my code looks like...
View Replies View Relatedwhat this means: Code:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Can't allocate space for object 'Syslogs' in database 'grdb' because the 'logsegment' segment is full. If you ran out of space in Syslogs, dump the transaction log. Otherwise, use ALTER DATABASE or sp_extendsegment to increase the size of the segment.
/dosearch.asp, line 300 .
When a file is uploaded, notifications go out to Admins. Currently Admins have the ability to have 3 email addresses that the notification can be sent to.
Now lets say they only have 1 email address for a contact. When I run the code below, it cycles through to everyone that needs to be contacted and sends email to all 3 addresses.....BUT #2 & #3 are empty and then in my SMTP folder I receive a bunch of files in the badmail folder.
I need to correct this so that I can eliminate having to go and purge on a daily basis.
Now I am sure that there is a better way of doing this... I inherited this and am looking for some help with correcting this....
is it possible to create a database on the server side on the fly. i know creating tables is not a problem sql. but creating a database on the fly im not sure. what are my options?
View Replies View RelatedHow i create a new sql database, i need to use some program to do that ? I never work with SQL, i always use ACCESS, sql is like access?
View Replies View Relatedhow can I create a MDB Database on the ASP server. With the FSO I have some Problems because the Browser tells me that the file with the same name is on the server but there is no file.
View Replies View Relatedhow can i Creat new table in mdb database. Does exist any command to do that?
View Replies View RelatedI've made a website for a little athletics club in HTML. I want to transform the records page into an ASP page that has an admin page so i can go to the admin page and easily add in the records without having to create all the tables and doing it all the manual way.
I know how to create the admin page and the database, but in my case, i want to be able to create a new table in the database for each week of records (as seen in the link below), and each of these tables will have the same fields (age, gender, event, athlete name etc.) I know how to make it so that asp can add, edit and delete a field in a table, but how would i get it to add a new table for each week of records?
I want to check if this database is exist so I avoid the error that appears when I try to create it another time and also I want to know how to delete this database.
View Replies View RelatedHow can I create a database access using asp+javascript withen the code?Is there (createdatabase)?If yes how can we use it?
View Replies View RelatedHow to create a database paging with the code i have. im trying to do database record paging, im not quite sure how i had tried couple of open source code but cant not get it to work with my code:
View Replies View RelatedWhat I am wanting to do is list the last 10 submissions to a knowledge base and create a link to each one with the question text serving as the visual representation of the link.
I have searched the forums for info on how to do this in ASP and have come up empty. I will detail what I have so far.
I have a database table called kbase and want to have html table with links to the last 10 things entered. I just can't figure out how to get a dynamic link to point back to the database entry.
I may be missing something very simple here but as this is work related my time frame for learning is small at best. Code:
I have a form where a user enters their name, date etc. i also want them to be able to click on a browse button and select a file which will then appear in a textbox. when they press submit i want the file name and path to be put into the database. e.g.
"C:windowsworkwork.doc".
Basically I don't want to UPLOAD the file just enable the user to browse to it and send the filename and path to the database.
how to create a shopping cart by using mysql as database?
View Replies View RelatedI would like to create a page of hyperlinks that are constructed from the contents of a database field. When the user clicks the link they are taken to a page that will display all fields from that particular record.
I already have the page structures in place. There are two pages, one with the links and the other to display the record. Code:
I have certain Keywords stored in a table of the Database.All i need is when ever i find the Keyword in the webpage i need to have a link which opens up as a seperate page and give me the detail information from the database for the seleted keyword.
View Replies View RelatedI have index.asp (Form) & process.asp (submit data from index.asp to Access Database), the Form is running Perfectly.
But, How can I create a login name and page for the applicants to edit the information they submitted?
Let say I have Email (username), Password (password) & lastname on index.asp, then I really have no clue!
i have a form where a user will enter their information.... i know how to check if the user didn't enter a value so that they are not redirected to the next page but how to check if the user pressed space and not allow that space character to be a valid character?
View Replies View RelatedI have a webpage with some hyperlink within a button. The problem is that some of my hyperlink is shorter that others and therefore the user must navigate to the hyperlink to click on the link
The thing I want is to make the button more user-friendly user can click anywhere on the button and not only on the hyperlink within the button
Here is my code ....
In an ASP Page is there a way to have a link that calls another page whose name includes a space? For example, I'd like to be able to call "My Page.asp" by building a href type link the user can click on. The equivalent of:
<a href="My Page.asp"> Open </a> the page
I've tried URLEncode but that didn't work.
I’m reading a list of values from a database table a creating a dropdown list on a web page. These are used as search criteria to search on a second table. The user selects and item from a list and then clicks a button to submit the search. All of that works.
Most search words in the list are a single word with no spaces. Some are two words. When that is passed, anything passed second space gets lopped off. Here is the line of code that creates the dropdown box
sDataSet = rs1("Dataset")
response.write "<OPTION selected value=" & sDataSet & ">" & sDataSet
I tried this, but it didn’t work
response.write "<OPTION selected value=" & Replace(sDataSet, “ “, “%20”) & ">" & sDataSet
It replaced the space with %20, and the entire search phrase was passed, but the search failed because the %20 was not converted to a space on the other end. So now I doing the conversion myself after I do the Request.Form. Is there a better way though, to deal with spaces.
My form gets populated from an access database. Now in the database there are fields containg <br>. While in a normal page everything works as it's supposed to, in my listbox the <br> shows as it is. What I would like to do is replace it with a space so I've used this:
<option value="<%=(rsProducts.Fields.Item("CatNum").Value)%>"><%=replace(rsProducts.Fi elds.Item("NotesR").Value),"<BR>"," "%></option>
but it doesn't seem to work.
What exactly am I doing wrong here?
i need to combine 2 vriables that are retrieved from a form. idate and
itime.i want to put these into the t_date field in my sql db. but for it to work
properly, there needs to be a space between the idate and itime.
how do i do this?
i know i should know this, and i have used it before. but it has been so
long, that i can't remember for the life of me.
1. dopage.asp?<% =SessionID=value_here%> is different tha
2. dopage.asp?<%=SessionID=value_here%> ??
Please note that there is a space between the asp tags and the = sign in the first item. I thought ASP will treat #1 and #2 as the same. However it seems that is not the case.
can anyone fix the space problem in my sql statement? I am getting this error message:
ADODB.Recordset (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
This is my sql statement:
sql = "SELECT * FROM " & tblname & " WHERE " &Col& " = N'" &Var& "' AND [Show]=1 ORDER BY [Code] ASC"
And I am passing the parameters to the url something like this:
Product.asp?Visit=Yes&Var=Hong%20-%20Kong&Col=Place
Problem is that most of my data contain a space (eg. Hong Kong).
I don't have this error when my data is single word (eg. Sydney)
I want to check the disk drive space on a small intranet. Like 30 computers. All have been partitioned and have a D: drive that is shared and is the drive I'm trying to check. This is basically what I have tried:
Code:
Dim fs, pcdrive, cdrive, n
Set fs=Server.CreateObject("Scripting.FileSystemObject")
Set pcdrive = fs.GetDrive("xx.xx.xx.xxshare01-d")
Response.Write("Share01 Free Drive Space is: " & pcdrive & "<br>")
set pcdrive = nothing
set fs = nothing
Is there something wrong with the code or would it possibly have to do with permissions? When this script runs,I get a page cannot be displayed.
when it writes the varFault option to SQL, there is lots of whitespace written too!I have tried the Trim option but to no joy
<%@LANGUAGE="VBSCRIPT" %>
<%OPTION EXPLICIT
Dim objConn, strSQL, objRS, varName, VarExt, VarFault, varDept, strSQL1, objRS1
Set objConn = Server.Createobject("ADODB.Connection")
objConn.open Application("helpdesk")
varName = Request.Form("name")
varDept = Request.Form("departments")
varFault = Request.Form("txtFault")
strSQL = "INSERT INTO new_calls (Name, Department, Fault) VALUES "
strSQL = strSQL & "( '" & varName & "','" & varDept & "','" & varFault & "')"
strSQL1 = "SELECT * FROM new_calls "
strSQl1 = strSQL1 & "WHERE call_id= '"'
set objRS = objConn.Execute(strSQL)
%>
Say I have a 'Mc Paul' in the database, what would i need to do if the user searched for 'McPaul' how could i pull that record out of the DB.
View Replies View Related