This function returns a string with whitespace stripped from the beginning and end of str . Without the second parameter, trim() will strip these characters:
header('Location: http://www.example.com/');exit;Base (from browser): 16px;Body (CSS): 75% (12px);
SELECT column FROM table ORDER BY RAND() LIMIT 1
SELECT column FROM table ORDER BY RANDOM() LIMIT 1
SELECT TOP 1 column FROM table ORDER BY NEWID()
Thanks to: http://www.petefreitag.com/item/466.cfm
I had a previous post about LEFT JOINS but I believe w3schools does a better job at explaining them.
The count query is very useful in SQL. Below is the syntax:
SELECT COUNT(thefield) AS outputvariable FROM tablename GROUP BY thefield HAVING anyfield = yourvalue
This may also work the same for MYSQL.
| Data Types | Description |
|---|---|
| bigint | Integer data from -2^63 through 2^63-1 |
| int | Integer data from -2^31 through 2^31 - 1 |
| smallint | Integer data from -2^15 through 2^15 - 1 |
| tinyint | Integer data from 0 through 255 |
| bit | Integer data with either a 1 or 0 value |
| decimal | Fixed precision and scale numeric data from -10^38 +1 through 10^38 -1 |
| numeric | Fixed precision and scale numeric data from -10^38 +1 through 10^38 -1 |
| money | Monetary data values from -2^63 through 2^63 - 1 |
| smallmoney | Monetary data values from -214,748.3648 through +214,748.3647 |
| float | Floating precision number data from -1.79E + 308 through 1.79E + 308 |
| real | Floating precision number data from -3.40E + 38 through 3.40E + 38 |
| datetime | Date and time data from January 1, 1753, through December 31, 9999, with an accuracy of 3.33 milliseconds |
| smalldatetime | Date and time data from January 1, 1900, through June 6, 2079, with an accuracy of one minute |
| char | Fixed-length character data with a maximum length of 8,000 characters |
| varchar | Variable-length data with a maximum of 8,000 characters |
| text | Variable-length data with a maximum length of 2^31 - 1 characters |
| nchar | Fixed-length Unicode data with a maximum length of 4,000 characters |
| nvarchar | Variable-length Unicode data with a maximum length of 4,000 characters |
| ntext | Variable-length Unicode data with a maximum length of 2^30 - 1 characters |
| binary | Fixed-length binary data with a maximum length of 8,000 bytes |
| varbinary | Variable-length binary data with a maximum length of 8,000 bytes |
| image | Variable-length binary data with a maximum length of 2^31 - 1 bytes |
| cursor | A reference to a cursor |
| sql_variant | A data type that stores values of various data types, except text, ntext, timestamp, and sql_variant |
| table | A special data type used to store a result set for later processing |
| timestamp | A database-wide unique number that gets updated every time a row gets updated |
| uniqueidentifier | A globally unique identifier |
I also found something similar related to PHP. My solution in both cases was as stated above, to reduce the limit for the field to something that the server-side languages could deal with. This was the case with both PHP and ASP along with both MySQL and MSSQL.After some testing I found there are no SQL Server 2005 data types
that can be read by an ASP page that hold more than 8000 characters. I
speculate that the 2-byte field length indicator is not read by ASP.
Maybe the field length of the old Access memo data type was encoded
differently. - kirkatsfw-ga
I found a nice list of functions in ASP.
Here it is: http://www.haneng.com/FunctionSearch.asp?s=a
'Setup the connection
Dim aConnectionString
aConnectionString = "Driver={SQL Native Client};Server=sitename\sqlexpress;Database=databasename;Uid=username;Pwd=password;"
'Connect to DB
Dim conn, R, SQL, RecsAffected
Set conn = Server.CreateObject("ADODB.Connection")
conn.Mode = adModeReadWrite
conn.ConnectionString = aConnectionString
conn.Open
'select a record set
set rs = Server.CreateObject("ADODB.Recordset")
rs.Open "Select * from table", conn
do until rs.EOF
for each x in rs.Fields
response.write(x.name)
response.write(" = ")
response.write(x.value)
next
rs.MoveNext
loop
rs.close
set rs = Server.CreateObject("ADODB.Recordset")
rs.Open "Select * FROM tablename WHERE fieldname = 'fieldvalue'", conn
'check if login worked
dim found
if rs.BOF and rs.EOF then
'no entry found
found = false
else
'entry found
found = true
end if
'add an entry
'conn.Execute "INSERT INTO tablename (fieldnames) VALUES (fieldvalues)"
'delete an entry
'conn.Execute "DELETE FROM tablename WHERE fieldname = 'fieldvalue'"
'update an entry
'conn.Execute "UPDATE tablename SET fieldname = 'somevalue' WHERE fieldname = 'fieldvalue'"
I wanted a quick list of event handlers so here they are. This is courtesy of our friends at the w3schools.
FF: Firefox, N: Netscape, IE: Internet Explorer
| Attribute | The event occurs when... | FF | N | IE |
| onabort | Loading of an image is interrupted | 1 | 3 | 4 |
| onblur | An element loses focus | 1 | 2 | 3 |
| onchange | The user changes the content of a field | 1 | 2 | 3 |
| onclick | Mouse clicks an object | 1 | 2 | 3 |
| ondblclick | Mouse double-clicks an object | 1 | 4 | 4 |
| onerror | An error occurs when loading a document or an image | 1 | 3 | 4 |
| onfocus | An element gets focus | 1 | 2 | 3 |
| onkeydown | A keyboard key is pressed | 1 | 4 | 3 |
| onkeypress | A keyboard key is pressed or held down | 1 | 4 | 3 |
| onkeyup | A keyboard key is released | 1 | 4 | 3 |
| onload | A page or an image is finished loading | 1 | 2 | 3 |
| onmousedown | A mouse button is pressed | 1 | 4 | 4 |
| onmousemove | The mouse is moved | 1 | 6 | 3 |
| onmouseout | The mouse is moved off an element | 1 | 4 | 4 |
| onmouseover | The mouse is moved over an element | 1 | 2 | 3 |
| onmouseup | A mouse button is released | 1 | 4 | 4 |
| onreset | The reset button is clicked | 1 | 3 | 4 |
| onresize | A window or frame is resized | 1 | 4 | 4 |
| onselect | Text is selected | 1 | 2 | 3 |
| onsubmit | The submit button is clicked | 1 | 2 | 3 |
| onunload | The user exits the page | 1 | 2 | 3 |
Listing can be found here: http://www.w3schools.com/jsref/jsref_events.asp
<%
Response.Buffer = True
Dim strAbsFile
Dim strFileExtension
Dim objFSO
Dim objFile
Dim objStream
'Set this to the variable in your GET
Set filename = request.QueryString("wp")
'-- set absolute file location
strAbsFile = Server.MapPath(filename)
'-- create FSO object to check if file exists and get properties
Set objFSO = Server.CreateObject("Scripting.FileSystemObject")
'-- check to see if the file exists
If objFSO.FileExists(strAbsFile) Then
Set objFile = objFSO.GetFile(strAbsFile)
'-- first clear the response, and then set the appropriate headers
Response.Clear
'-- the filename you give it will be the one that is shown
' to the users by default when they save
Response.AddHeader "Content-Disposition", "attachment; filename=" & objFile.Name
Response.AddHeader "Content-Length", objFile.Size
Response.ContentType = "application/octet-stream"
Set objStream = Server.CreateObject("ADODB.Stream")
objStream.Open
'-- set as binary
objStream.Type = 1
Response.CharSet = "UTF-8"
'-- load into the stream the file
objStream.LoadFromFile(strAbsFile)
'-- send the stream in the response
Response.BinaryWrite(objStream.Read)
objStream.Close
Set objStream = Nothing
Set objFile = Nothing
Else 'objFSO.FileExists(strAbsFile)
Response.Clear
Response.Write("Le fichier est inexistant.")
End If
Set objFSO = Nothing
%>
Posts
All Comments
