Date: 04/28/06 (WebDesign)    Keywords: php, mysql, database, sql, web

Hello all. I am in the process of starting a member's section for the website at my job. My boss wants members to be able to login and view information that is specific to them.. such as pricing, sales history, etc. What I'm wanting to know is what is the best way to go about doing this? A PHP/MySQL database? Something different? This will be my first time doing anything like this. I'm really looking forward to it as I'll be able to learn some new and interesting things, but where's a good place to start? I appreciate any suggestions you guys can offer. You're all always such a huge help!

Source: http://community.livejournal.com/webdesign/1101500.html

Date: 05/03/06 (Algorithms)    Keywords: mysql, database, sql

I've got a large transition matrix (2000+ states) that is pretty sparse (most transitions are 0 probability). Right now I'm storing the thing in a MySQL database, and generating sequences based on the probability matrix is soooo slow.

There must be a more compact way to represent these transition probabilities, so that I don't have to do a query on a 2000+ row x 2000+ column database table every iteration of the system. But I don't know how.

Any thoughts?

Source: http://community.livejournal.com/algorithms/75944.html

Date: 05/05/06 (WebDesign)    Keywords: database, web

I'm looking for information on dynamically-generated server-side images. For example, at a set interval, a program on my webserver could read some data from a database, and create a small image that contains this information, laid out all nice and neat.

I've browsed around for some information, but I can't seem to find any simple tutorials. How would I go about doing something like this? What languages should/could I use? Would I be able to assemble larger images from a composite of smaller images, or would I have to hard-code the entire image from hand?

Any help is greatly appreciated.

Source: http://community.livejournal.com/webdesign/1104018.html

Date: 05/04/06 (Security)    Keywords: mysql, software, database, sql, security

Security patch is designed for the latest versions of MySQL's open-source database software.

Source: http://news.zdnet.com/2100-1009_22-6068514.html

Date: 05/05/06 (PHP Community)    Keywords: php, database, sql

Hey guys! I'm working on a project for my company, and running into a big of a block. Let's just say I'm a newbie at PHP, but intermediate on SQL.

The project I'm working on is to create a PHP/SQL system that we can enter outage ticket information into, and then query the database of tickets. I've got the query working, however with all the data that's being put in, it spreads the table way out over to the right and makes me have to scroll to see the rest of the info. Which is a pain.

What I'd like to do is have it query the information, and in the ticket# field have it hyperlink the # so that people can click the # and it'll query the database for all the information related to that ticket.

Any thoughts on how to accomplish this easily?

Thanks,
Chris

Source: http://community.livejournal.com/php/447603.html

Date: 05/07/06 (MySQL Communtiy)    Keywords: php, mysql, database, sql, web

I'm currently moving hosts, from a host with mySQL 4.1.18 to 4.0.25. The site was made with a php templating program called website baker. For some reason when I backup the database in mySQL 4.1.18 (with compatibility for earlier versions) and I try to upload the database using cpanel in the new one, it just doesn't recognize anything and won't restore the database. Any ideas on how I could get around this?

x posted in mysql and php_mysql

Source: http://community.livejournal.com/mysql/95054.html

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

I'm currently developing a small community site (WOW Guild site), and am working on optimizing the database calls and such.

Currently, when a user loads a page the system checks the user's authentication, and then to see who else is online, checks a field in the db to see how many people have a comparable time...:

1. user loads page > SELECT * FROM `Members` WHERE `name`=$name AND `pass`=$pass




2. update user > UPDATE `Members` SET `lastclick`=$now WHERE `id`=$id




3. find other users online > SELECT `id` FROM `Members` WHERE `lastclick` >= $now

mysql

php_mysql

Source: http://community.livejournal.com/mysql/94558.html

Date: 05/09/06 (Asp Dot Net)    Keywords: database, asp, sql, web

Christ I post so much to this group that its like if I keep doing it I'm automatically entered in a raffle..

Anyways I have a ASP.Net/VB.net webform that allows a user to upload a file into a SQL Server database. I can't figure out how to get the file to be inserted correctly though. We have to use a data access class, but I can modify it to my needs. I also need to pass this to a stored procedure on the database, as opposed to using commands in the vb code.

This is how I get the file:
Dim strFileName As String = _
fileupload1.PostedFile.FileName.Substring _
(fileupload1.PostedFile.FileName.LastIndexOf("\") + 1)
Dim fileLength As Integer = CInt(fileupload1.PostedFile.ContentLength)
Dim fileContent(fileLength) As Byte
fileupload1.PostedFile.InputStream.Read(fileContent, 0, fileLength)

I keep getting all sort of casting errors and other crap when I try and pass this through my stored procedure. I don't think my error lies in there, because it looks like its not being "converted" to the proper format or it just isn't going over properly. I can't seem to find any tangible "good" info online about this. Can anyone help out? Thanks.

Source: http://community.livejournal.com/aspdotnet/65161.html

Date: 05/12/06 (Application Development)    Keywords: database, java

The database giant will participate in Grails, an open-source development that combines the Groovy scripting language and Java infrastructure.

Source: http://news.zdnet.com/2100-9593_22-6071763.html

Date: 05/12/06 (Asp Dot Net)    Keywords: database

Ok... I know there is probably an easy answer to this but I can't figure it out. I have a program where I query a database, return a dataset, add columns to the dataset which are basically just formatted information, then display the information in the datagrid. If I had .Net 2.0 available I wouldn't be here asking this question (as I'd have the God-send DataGridView at my disposal,) but I can't figure out how I can do the following for the datagrid:

A: Only show a few of the columns in the dataset.
B: Specify the order of the columns in the dataset.

I know I can hide columns easily in the Datagrid, but I need to move some of them too. I've looked all around and I can't find a real straightforward explaination as to how to do it, whether it be through using a datatable or a dataview.. I'm re-using a class that I made for formatting for a repeater control (god I wish those could be used on Windows Forms.) Does anyone have any ideas for this? Thanks.

Source: http://community.livejournal.com/aspdotnet/65772.html

Date: 05/15/06 (Java Web)    Keywords: mysql, html, database, sql

I wanted to create ajax based commenting system for some html pages. The design goals were: 1. Simple to use and install 2. Database (MySQL) backed 3. Minimal changes to HTML template / files 4. Support effective (no frequent cache refreshes) html page compression / caching strategy for heavily commented sites. An AJAX based system fits the bill. The new [...]

Source: http://blog.taragana.com/index.php/archive/how-to-create-ajax-commenting-system-for-static-html-pages/

Date: 05/16/06 (MySQL Communtiy)    Keywords: php, mysql, browser, database, sql, web

I'm currently working on re-engineering a web stack completely to use mysql as a back end instead of (shiver) a bunch of Access files. I've used mysql for years both personally and professionally, but being a UNIX dork I've almost exclusively done so from the command line. Whenever I've needed something a little more user-friendly than that, I've installed a web tool like phpmyadmin.

However in this case, I'm working in an all-Windows shop (mostly server 2003) and I know that I'm going to be passing this on to someone in a couple years. As I document various tasks, I'd like to use a desktop client with a GUI interface for doing things like "browsing" the database, modifying stuff now and then, etc.

I see that mysql.com has a nice "administrator" and "query browser" available and they're pretty nice - but neither is really what I'm looking for in terms of something that has a GUI interface and actually manipulates the data itself. Unfortunately I cannot count on a successor knowing much SQL or being comfortable on the command line.

I'm guessing there are many free tools out there but would love to start out on whatever people who already love to use such things find the most mature, featureful, easy to use, etc. So, any suggestions? TIA!

EDIT - solved, thanks!

Source: http://community.livejournal.com/mysql/95405.html

Date: 05/18/06 (PHP Community)    Keywords: database

Howdy here's what I'm needing help with tonight:

I want to be able to let $refer be the refering url but I'm not sure if I can get that from the HTTP headers, can I?

Application: Basically, what I want to do is, if the user gets the 404 error page then the refering URL (obviously with a dead link) will be put into a database for review. I can do all that, I just need to know how to set $refer.

Thanks,
Shamess

Source: http://community.livejournal.com/php/450672.html

Date: 05/18/06 (Computer Geeks)    Keywords: database

I'm using VB 6 with an Access Database (I know... I know...) and I'm trying to get it to generate a report based on user selected criteria.

Basically my database is full of contacts that can be involved in my company's programs. The user should be able to select a program from a dropdown and then print a report of all the contacts participating in that program.

I've been able to make it print every contact in every program, but not for a specific program only

Thoughts?

Source: http://community.livejournal.com/computergeeks/924276.html

Date: 05/22/06 (PHP Development)    Keywords: php, browser, database, linux

Hello All.

I want to write an application that does the following.

1)Upload an image from browser,
2)Resize the image to 300 x N
3)Save the image to a database table or file system.
4)Create a thumbnail of that image sized to 75 x N
5) Save the thumbnail to a database table or file system.

I have all mechanics of the database table or file structure down as well as the uploading of the file. I am not sure how to do the image editing part however. I am assuming after some research that the GD library is what I want to use. Is that correct? Or do I have to write an interface to GIMP? That wont work, because although I am developing on Linux its gonna end up on a Windows server.

Can I install GD after PHP has been installed?

Thanks for any advice on how to accomplish this task.

Source: http://community.livejournal.com/php_dev/68567.html

Date: 05/23/06 (Asp Dot Net)    Keywords: browser, database, asp, microsoft

Ok here's the situation. I have an ASP.net app that gets a file from a database and then prompts the user to run, saveAs, or cancel the file. The code is:

Response.Buffer = True
Response.AddHeader("Content-Disposition", "inline;filename=" & ds.Tables(0).Rows(0).Item("reqJobDescName"))
Response.ContentType = "application / msword"
Response.BinaryWrite(myData)

The problem is that if you click on Run, the file opens up in another browser. I want it to be opened by the actual program. Therefore, I don't want this to "run" on another browser window that has Microsoft Word in it. I want Microsoft Word to open up the file directly. Is there any way to do this? I have to figure there is, although perhaps it can't be done in Response since that is all based on httpResponse. Thanks.

Source: http://community.livejournal.com/aspdotnet/67367.html

Date: 05/24/06 (WebDesign)    Keywords: programming, database, web

Are any of you familiar with Mason?

I've been given a task at work to build something basic, displaying items from a database and whatnot... and I have no idea where the hell to start! I'm just a designer who's never touched much programming...

Any tips would be helpful, or other web developper communities whether it's on LJ or a message board.

Thank you in advance.

Source: http://community.livejournal.com/webdesign/1114204.html

Date: 05/25/06 (PHP Community)    Keywords: html, database, sql, security

Currently I'm working on a small and simple blogger for someone.  It doesn't have to be anything extraordinary or anything, however, of course, I want it to be as secure as possible within my means.

I've heard all of the horror stories of SQL injection and whatnot where users input bad things to make bad things happen and that there is a general rule about NEVER letting the user input directly into a database without cleaning it up.

Well... in this case, it isn't that simple.


I don't want to really limit what characters the user can enter in (except for html.. That I'm stripping out).  But, I don't want to limit it to alpha-numerical characters.  So, I thought of another way where the user has more freedom, but I'm hitting some walls with it... and perhaps some of you could let me know if you see any glaringly obvious problems.

I was thinking of having the users input sent to a text file.  A file, automatically named, maybe by timestamp or whatever, that contains the text the user has entered.  Then, the DB would only contain the name of the file created, its ID number, and the user associated with it.  Then, when viewing them, simply pull the name of the file from the DB, fopen and fread it and echo the results.  I have the open and reading part working, however... I want to avoid people being able to go to that file directly (by some stroke of luck by guessing its name).  So... my two concerns are:

1. Are there any obvious security issues by doing this with external files?
2. Is there any way I can prevent direct opening of these files?

Thank you in advance.

Source: http://community.livejournal.com/php/453279.html

Date: 05/25/06 (SQL Server)    Keywords: software, xml, database, sql, microsoft

Okay. So I've been trying to install SQL Server 2005 for about a month now, on and off. I keep running into the usual problems. My boss wants it installed now now now, so this time I went whole hog. I uninstalled everything remotely Microsoft (including all versions of Visual Studio, all versions of the .NET framework, Office, and a bunch of little add-ons I assumed went to Visual Studio, like WSE and the XML parsers) from the machine. I physically deleted every file I could from the C:\Program Files\Microsoft SQL Server directory. (instapi.dll, from the Microsoft SQL Server\90 directory could not be deleted, no matter what I did, but everything else went away). I try to install, and when I get to the point where it's actually going to install the software< I get the following dialog box:

The following components that you chose to install are already installed on the machine. To view a report of available options and alternatives click on Details.
SQL Server Database Services 9.00.1309.06
Analysis Services 9.00.1309.06
Reporting Services 9.00.852
Notification Services 9.00.852
Integration Services 9.00.852
Workstation Components, Books Online, and development tools 9.00.852

Each of these has a checkbox next to it, but all the checkboxes are blank. When I hit Next, I get the following dialog box:
None of the selected features can be installed or upgraded. Setup cannot proceed since no effective change can be made to the machine. To continue, click Back and select features to install.

Now, I know the physical fiels aren't there, since I uninstalled the software and then deleted any artifactas, so the problem must be that there are some stray registry keys telling the install procedure that the software still exists on the machine. Does anyone have a comprehensive list of registry keys written by SQL Server 2005, so I can make sure everything is gone before I try this again?

Source: http://community.livejournal.com/sqlserver/48457.html

Date: 05/28/06 (Code WTF)    Keywords: database

Heeelp!!! I'm making a database in Access and I have this form that retrieves a Vendor's name from the Vendor table.

The thing is, it needs to - ugh how can I 'splain this without a picture? hm...

VENDOR TABLE FIELDS
ven_id (PK)
ven_name

CHECK TABLE FIELDS
check_ven_id (FK - looks up a value in the ven_id field in the vendor table)

CHECK FORM
combo box that looks up vendor.ven_name
several text boxes that enter info into the check table (such as check amount and check number)

The problem is, when I put the vendor name into the combo box, the form complains because it can't match vendor.ven_id with any values in check.check_ven_id

I need it to automatically enter the appropriate vendor ID into the check.check_ven_id field as soon as the vendor name is selected in the combo box and I can't for the life of me figure out how to do this.

Wow that was wordy. I hope you guys can decipher it. It would be much easier to explain it if you could see it.

Source: http://community.livejournal.com/code_wtf/40917.html