Script

Filter
2003-08-11

MySQL - grant

Sql
Lägg till en super-användare i mySql
GRANT ALL PRIVILEGES 
ON <dbname>.* 
TO <dbuser>@<dbhost> 
IDENTIFIED BY '<dbpass>' 
WITH GRANT OPTION;
2003-08-11

Lösenord i MySQL

Mysql
Ändra masterlösenord i MySql
set password for root@localhost = password('mittlösen');
2003-08-10

Inkludera text - om

Asp
Conditional include
set fso = server.createobject("scripting.filesystemobject")
set infile = fso.opentextfile(server.mappath(variabel_fil))
response.write infile.readall
infile.close
set infile = nothing
' (Endast text, ej asp-kod)
2003-08-07

Enumerator

Asp
for each genom en samling
for each var in request.servervariables
    response.write(var & " = ")
    response.write(request.servervariables(var) & "<br>")
next
2003-03-08

Begränsad databasfråga

Asp
Begränsa antalet poster som visas från en sql-fråga till de tio senaste inläggen i en databastabell.
<% 
set conn = server.createobject("ADODB.Connection") 
conn.open "SystemDSN" 
sql = ”select * from tabell order by id desc” 
set rs = conn.execute(sql) 
antal = 0 
do until rs.eof 

	response.write(rs(”data”) & "<br>") 
	antal = antal + 1 
	if antal > 9 then 
		rs.close 
		conn.close 
	else 
		rs.movenext 
		loop 
		rs.close 
		conn.close 
	end if 
%>
🙂