Date: 03/20/05 (MySQL Communtiy)    Keywords: php, mysql, sql, web

Hi all, lurker here and whatnot.

I just created a LJ-community for the discussion of the phpBB messageboards: phpbb

(if comunity promos such as this aren't allowed here, feel free to delete)
cross-posted: webmasterguild, php, mysql

Source: http://www.livejournal.com/community/mysql/51677.html

Date: 03/21/05 (Application Development)    Keywords: software, sql

The software maker says new versions of Visual Studio and SQL Server won't debut until later this year.

Source: http://news.zdnet.com/Microsoft+delays+tool%2C+database+updates/2100-9593_22-5628166.html?part=rss&tag=feed&subj=zdnn

Date: 03/24/05 (SQL Server)    Keywords: database, sql

Using ONLY T-SQL (a stored proc really), is there a way to gain access to a MS Access DB and pull data out of it into a SQL Server database?

I know one theoretical solution is to create a linked server against the MS Access DB, pull my data out that way, kill the linked server property, and go along my merry way, but there's gotta be a better way to do this!

And no, DTS really isn't an option either I'm afraid.

x-posted to databases

Source: http://www.livejournal.com/community/sqlserver/22438.html

Date: 03/25/05 (SQL Server)    Keywords: mysql, database, sql

I'm used to working with MySQL and I have to make this forray into SQL server. So, I need a quick bit of help.

I need to be able to browse through a database one record at a time. For that, I guess I need a way to give my query a start row and. I can end it just fine. What should I use? And how do I figure out what row I am currently on. With MySQL theres the LIMIT clause and I know thats not available in SQL server.

Thanks in advance.

Source: http://www.livejournal.com/community/sqlserver/22596.html

Date: 03/25/05 (MySQL Communtiy)    Keywords: php, mysql, browser, database, sql

I'm trying to create a PHP browser-based chat room application. It will include Savant, JPSpan, and a custom MySQL wrapper class. The server is running PHP 4.3.10 and MySQL 4.0.18-standard. Now that the background information is out of the way, to the real issue at hand...

I obviously want the application to be able to support as many users as the server will allow. That said, the application must be as efficient as possible in terms of the database design and implementation. The database will be relational in design. There will be tables for rooms, users, and posts made by users to rooms. The application will also include a feature to allow users to search posts. My plan at the moment is to use a HEAP table as a buffer for current posts, given that they provide a speed advantage because they exist in memory and use hash indexing. On some sort of timed interval, posts would be moved from the HEAP table to a separate permanent table for archived posts.

However, this approach would require that posts be archived regularly over the course of the day. The more frequently posts are archived, the smaller the number of posts that could potentially be lost due to a server crash, power less, etc. The HEAP table really only needs to hold posts long enough for them to propagate to users. I'm not certain what frequency would be best.

Also, because HEAP tables don't support the TEXT field type, the HEAP table would initially need a VARCHAR(255) field for the post body. The application would have to check the length of posts when users submit them and then ALTER the table to add additional VARCHAR(255) fields, split the post body up to store it across those fields, and then concatenate the value of those fields to display the post. Since displaying each post would require getting all fields in the table anyway, it should be fairly easy for the application to figure out with each display how many fields it needs to concatenate to display the post body.

Any input? Any alternative approaches? I probably neglected to mention some tenant of my application requirements, so if you have questions, please ask, and I'll most certainly answer them. I think I've covered most of the bases, though. HEAP tables are a new concept to me, so I'm mostly lingering in the world of hypotheses before I actually try to make this work.

Source: http://www.livejournal.com/community/mysql/52183.html

Date: 03/25/05 (PHP Development)    Keywords: php, mysql, browser, sql, web

Hi, I do not know how to code PHP, but I do know how to impliment PHP scripts. I've been looking for a GPL one that does the following:

Forces download (header script that forces the "save" dialog. I'm serving mp4s and I want to make sure they don't load in the browser).

Anti-Leech (hides the true URL of my mp4s, and allows only referring servers I've entered into the script to download, otherwise people are redirected to the page of my choice)

Download Counter (either flat files or MySQL).

And that's it. I found scripts that do bits and pieces of this, but only one that does it all—and you have to pay for it (you can actually use it for free but it appends the site's name to the downloaded files unless you register the pro version). This script is called "Download Center Lite" and can be found at www.Stadtaus.com. I tried to crack it, but they've done clever things in the script to prevent that.

Also, I've found "Download Centers" that do much of these, but that's just for having a specific page with download links. I want to be able to dynamically call to these mp4 links from various pages on my website, not just from one.

Ideas?

This message was also posted in the LJ community "PHP."

Source: http://www.livejournal.com/community/php_dev/53455.html

Date: 03/25/05 (PHP Community)    Keywords: php, mysql, browser, sql, web

Hi, I do not know how to code PHP, but I do know how to impliment PHP scripts. I've been looking for a GPL one that does the following:

Forces download (header script that forces the "save" dialog. I'm serving mp4s and I want to make sure they don't load in the browser).

Anti-Leech (hides the true URL of my mp4s, and allows only referring servers I've entered into the script to download, otherwise people are redirected to the page of my choice)

Download Counter (either flat files or MySQL).

And that's it. I found scripts that do bits and pieces of this, but only one that does it all—and you have to pay for it (you can actually use it for free but it appends the site's name to the downloaded files unless you register the pro version). This script is called "Download Center Lite" and can be found at www.Stadtaus.com. I tried to crack it, but they've done clever things in the script to prevent that.

Also, I've found "Download Centers" that do much of these, but that's just for having a specific page with download links. I want to be able to dynamically call to these mp4 links from various pages on my website, not just from one.

Ideas?

Source: http://www.livejournal.com/community/php/277137.html

Date: 03/28/05 (PHP Community)    Keywords: php, mysql, sql, web

i'm looking for a good webhost company to host my website. what are your recomendations?

my needs are pretty standard.

- php (5 would be nice)
- mysql
- ftp
- email
- subdomains
- +200mbs space
- +20gbs bandwith
- CPanel, URCHIN statistics are a plus
- if possible, ssh access. :)

so far, and based on my past experience, i'm set on using eyow.com. but i want to hear what you guys recommend.

(sorry if there is a list somewhere of recommended webhosts. i've searched the lj communities and nothing has come up.)


crossposted to webdev , php , mysql

Source: http://www.livejournal.com/community/php/277786.html

Date: 03/28/05 (MySQL Communtiy)    Keywords: php, mysql, sql, web

i'm looking for a good webhost company to host my website. what are your recomendations?

my needs are pretty standard.

- php (5 would be nice)
- mysql
- ftp
- email
- subdomains
- +200mbs space
- +20gbs bandwith
- CPanel, URCHIN statistics are a plus
- if possible, ssh access. :)

so far, and based on my past experience, i'm set on using eyow.com. but i want to hear what you guys recommend.

(sorry if there is a list somewhere of recommended webhosts. i've searched the lj communities and nothing has come up.)


crossposted to webdev , php , mysql

Source: http://www.livejournal.com/community/mysql/52298.html

Date: 03/28/05 (Web Development)    Keywords: php, mysql, sql, web

i'm looking for a good webhost company to host my website. what are your recomendations?

my needs are pretty standard.

- php (5 would be nice)
- mysql
- ftp
- email
- subdomains
- +200mbs space
- +20gbs bandwith
- CPanel, URCHIN statistics are a plus
- if possible, ssh access. :)

so far, and based on my past experience, i'm set on using eyow.com. but i want to hear what you guys recommend.

(sorry if there is a list somewhere of recommended webhosts. i've searched the lj communities and nothing has come up.)


crossposted to webdev , php , mysql

Source: http://www.livejournal.com/community/webdev/183770.html

Date: 03/29/05 (MySQL Communtiy)    Keywords: database, sql

Okay, I don't know how to form this SQL statement... I'm so not a database person, I always knew it.

I've got three tables: users, questions, and answers. Each user can answer a question only once, but each question has lots of different answers, each by different users.

What I want to do is let a user search for questions that he has not answered. I know how to do the search for questions he has answered, it's just one neat SQL statement that links all the tables together (user id matches userid in answer table, which also has a question id which matches the question id in the question table) but I don't know how to go the other way. I need to list all the questions for which no answer (with this user's user ID) exists.

Source: http://www.livejournal.com/community/mysql/52672.html

Date: 03/30/05 (MySQL Communtiy)    Keywords: php, mysql, database, sql

hi all ~ i have a vB board out there in cyberland and it's got a "random quote" hack (the UQH by kurafire) ~

anyway, after three years of smooth sailing, it recently developed some kvetchy sickness and i can't figure out the problem.

this is the error message:

Database error in vBulletin 2.3.0:

Invalid SQL: SELECT *
FROM quotes
WHERE 1=1 AND mod!='N'
ORDER BY letter,name ASC
LIMIT 0,30
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '!='N'
ORDER BY letter,name ASC


mysql error number: 1064

Date: Tuesday 29th of March 2005 07:20:54 PM
Script: http://www.lookingland.com/board/board/quotelist.php?s=

Source: http://www.livejournal.com/community/mysql/53159.html

Date: 03/30/05 (SQL Server)    Keywords: sql, web

My sql server is driving me crazy. It's pegging out at 100% CPU for almost anything. dropping tables, truncating tables. It will be at 0% CPU, I'll attempt to drop a table and it will sit at 100% until I cancel the request. Some of my webpages are timing out. Anyone have any idea where to start? Event viewer doesnt give much info.

I'm running sql server 2000 sp3 on win2k3 sp1.

Source: http://www.livejournal.com/community/sqlserver/22992.html

Date: 03/31/05 (Open Source)    Keywords: php, mysql, database, sql, web, apache

Open source bundling is the new trend. Martin Lamonica's story yesterday about SourceLabs describes one such bundles. Most are aimed at businesses. Many, like the SourceLabs bundle, are AMP Stacks, with the Apache Web Server, MySQL database, and PHP scripting tools. The idea is for a company to give ...

Source: http://blogs.zdnet.com/open-source/index.php?p=215&part=rss&tag=feed&subj=zdblog

Date: 04/01/05 (PHP Community)    Keywords: mysql, html, sql

I’m working on some code and I am trying to make sure all the incoming data is secure. I currently call mysql_real_escape_string()
on all incoming data, but I am wondering if it would be worth my while to call htmlspecialchars() on it as well. Does anyone else have any good tips on un-tainting user data.

Source: http://www.livejournal.com/community/php/279632.html

Date: 04/05/05 (PHP Community)    Keywords: mysql, sql

Hi,

Does anyone know if its possible to do something like:-

SELECT * FROM $table if(query_bit(flags, 2))

in a MySQL call.

Thanks


Pual

Source: http://www.livejournal.com/community/php/279904.html

Date: 04/06/05 (Computer Geeks)    Keywords: programming, sql, linux

Hey all -

my work has offered to spring for a programming class for me. I mostly do junior system admin. type stuff now so better shell scripting would be great to know but i'd like to branch out more into simple programming. everyone at my job is a hotshot perl coder and i'd love to be able to write perl. but perl programming classes dont seem to exist.
does anyone have suggestions on what kind of beginner class i should take?
or if youre in philly: where i should take it would be nice too.
also i'm not looking to go the self taught route on this. i usually learn better in a non classroom environment but i've been up to my eyeballs trying to teach myself linux, bash and zsh, sql, postfix, networking, hardware and bunch more, so i'm looking forward to some classroom type structure for a minute.

thanks!

Source: http://www.livejournal.com/community/computergeeks/654071.html

Date: 04/06/05 (Web Development)    Keywords: php, mysql, sql

Hello
Yesterday I started work on a small FAQ or help system, made with PHP, mod_rewrite, and MySQL
I really just starting to learn MySQL and I thought that this would be a good place to start.
I have not started on the Style yet,

Demo: http://lj.funvill.com/help/
Source: http://lj.funvill.com/help/source/

Tell me what you think.
Anything suggestions comments?

Source: http://www.livejournal.com/community/webdev/186580.html

Date: 04/06/05 (SQL Server)    Keywords: sql

My boss asked me to do some research to find Transact SQL training for people at work which wouldn't be too expensive. Everyone (I hope) has basic skills with using Select statements and such. We mostly do a lot of report writing, but the need is for everyone to have more understanding and be able to manipulate data and be able to pull in data from other sources (Conversions from competitor systems to ours) and also be able to write procedures, functions and triggers.

Any suggestions which wouldn't break the bank? Local colleges have prerequisites that I don't think most here would have already. Also the two main colleges teach using Oracle and Sybase, while we only use MS SQL now, but will most likely branch off in the future.

Thanks for any input provided.

Xposted to DB_Community

Source: http://www.livejournal.com/community/sqlserver/23315.html

Date: 04/08/05 (Asp Dot Net)    Keywords: database, asp, sql, microsoft

Hello peoples, I am having a bitta trouble with my code and can't seem to find an answer. Im currently running XP Pro with SP2, IIS 5.1, and try to do a simple DSNless SQL Update from a form connecting to a Access 2000 database. The ASP code is as follows.

<% 
	Dim strDataPath, objConnection
	strDataPath = Server.MapPath("rest.mdb")
	Set objConnection = Server.CreateObject("ADODB.Connection")
	strConnectString = "Provider=Microsoft.Jet.OLEDB.4.0;"_
	+ " Data Source= " & strDataPath & ";"
	objConnection.ConnectionTimeout = 15
	objConnection.CommandTimeout = 10
	objConnection.Mode = 3
	
	if objConnection.State = 0 then
	objConnection.Open strConnectString
	end if
			
	Dim strSQL, objRS
			
	strSQL = "SELECT * FROM food"
	Set objRS = Server.CreateObject("ADODB.RecordSet")
	objRS.Open strSQL, objConnection,3,3
	objRS.AddNew
	objRS("tableno") = Request.Form("tableno")
	tableno = Request.Form("tableno")
	objRS("people") = Request.Form("people")
	people = Request.Form("people")				
	objRS.Update

	Set objRS = Nothing
	objConnection.Close
	Set objConnection = Nothing
			
	Response.Redirect("placeorder2.asp?tableno=") + tableno + "&people=" + people
		
%>

Source: http://www.livejournal.com/community/aspdotnet/31731.html