Date: 09/07/05 (WebDesign)    Keywords: database, sql

Hey.. random question..

does anyone know a mass email program.. such as maybe dada mail but that i can import addresses from a sql database?

Source: http://www.livejournal.com/community/webdesign/972640.html

Date: 09/08/05 (SQL Server)    Keywords: mysql, database, sql, postgresql, web, linux, microsoft

(my background)
Using MySQL and PostgreSQL on FreeBSD and Linux machines
(the problem)
I have four databases (actually MDF and LDF files) from a client. They want to know if they can extract data from the four databases by year and place them in to individual databases. This sounds ok, but I am new to Microsoft's SQL server. I sacrificed one of my personal dev machines and installed 2k3 Enterprise and 2000 SQL server. Created new databases with the same name as the files and then replaced the new files with the original ones from the client. Super.
Now what?

Again my background is in the command line/web front end so I am running a little blind. What is the simplest way to see the data in each database? What are some _quality_ sites I can read (because googling information you have no idea about takes time to filter out the bs).

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

Date: 09/08/05 (Java Web)    Keywords: database, security, web

A web based pilot program is currently underway to rapidly determine the eligibility of a worker to work legally in US. Under the "Basic Pilot Program," employers enter a person's name, birth date and other data on a website. The information is then run through databases maintained by the Social Security Administration and U.S. Citizenship and [...]

Source: http://blog.taragana.com/index.php/archive/web-based-immigration-checks-for-companies/

Date: 09/13/05 (Web Development)    Keywords: php, database, sql, web

I have been working on some databases that I'd like to put up on the web eventually. They are mostly inventories of my philatelic, numismatic collections, mp3s, videos in Excel format right now. I would be able to add, update, and remove entries from my website (with admin password of course) using forms or if I have tons of entries to do I can upload the updated database instead. Visitors, including myself would be able to search the databases by using dropboxes to narrow down the query and find relevant entries or use a simple keyword search. The results would be displayed in a table with links to individual entries than would be displayed in a form-like fashion with any graphic available relating to the entry (ex. a photograph of a coin).

The problem is, i have no clue how to do this. First of all, what format should these database be in? Access dbs? What resources are there to learn how to set up this searchable/queriable database? I intend to have these searchable inventories on my website and the individual pages are php. So the display of these results should be compatible with them. Do I use WebSQL? I need to learn how to set up a form and have it hooked up with the database, but what language is it?

I'm so clueless I don't even know where to look. Any help is appreciated!

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

Date: 09/13/05 (Open Source)    Keywords: software, database

Oracle has spent billions consolidating its space, not just the big database software area but the application space.

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

Date: 09/15/05 (Asp Dot Net)    Keywords: database, asp

I have a set of dropdownlists that are used contantly so
i put them in ascx files. Now i need to set the SelectItem
in the dropdownlist in the ascx file based on the database
values pulled out in the aspx file EditResort.aspx for
editing the resort information. How do i set SelectItem
in the usercontrol from the aspx file or pass the value
into the ascx file from EditResort.aspx (i've been told
that you cannot pass values into a ascx file).

very confused
Fuzzygoth

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

Date: 09/17/05 (MySQL Communtiy)    Keywords: php, mysql, software, database, sql, web

Does anyone know how much one can expect to spend to hire someone to create a mysql/php script? The one in particular is for allowing a member to view online statements at a gym website and needless to say, quite secure. The software we use for gym management uses a mysql database. I've got to run this by my manager in two days so I'm looking for how much he can expect to spend and what is a good and reliable source to get this done. Thanks for any assistance. Trinity

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

Date: 09/19/05 (SQL Server)    Keywords: database, sql

Alright, here's the scenario. I have 65 million row table of zip codes... the table just has three columns: zip_cd varchar(10), lattitude, and longitude values. Zip_cd is varchar(10) because we have to store zip + plus 4 values in "xxxxx-xxxx" format... and no, my senior DBA has already overruled me adding two more numeric columns which would offer more optimized indexing. There's a clustered index on the zip_cd and we only ever run lookups on zip_cd, to get lat/long values.

Anyway, we have one simple query as follows:

--

DECLARE @zip_cd varchar(10)
SET @zip_cd = '60440-0001'

IF EXISTS(SELECT zip_cd
FROM serverX.databaseY.dbo.geodata
WHERE zip_cd = @zip_cd)
PRINT 'one'
ELSE
PRINT 'two'

--

Starting late last week, one of our servers running this query started taking forever and a day. Upon running it manually and checking the execution plan, I see that SQL Server, in all of its wisdom, decided to run the "SELECT zip_cd" portion WITHOUT the WHERE clause on the remote server, THEN apply a "filter" step for the WHERE clause. I attempted to replicate this on other servers and 2/3s of our other servers runs the query correctly, by sending everything to the remote server, whereas 2 other servers also just pull all 65 million rows down THEN filters it locally.

So my question is this... how in the hell can I force SQL Server to run the query in one fashion, rather than another? I know about using table and query hints, but the problem is that this is a remote server scenario, which Query Analyzer was complaining that index hints won't work.

Help?

x-posted...

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

Date: 09/24/05 (C Sharp)    Keywords: database, asp, web

Hey all,

I've been running into a seriously weird problem of late... I have a Virtual Directory set up on my dev machine, on which I've developed my personal website. I have forms authentication and it's working fine. I come to deploy it under my pre-prod server (which is now a Website rather than a V. Dir.) and forms authentication gives me grief: once authenticated, it displays a blank page (correct address, but blank).

On the same machine, I stop the website and create a virtual directory, specifying the same location. Not a single file or permission changed. Bingo, lets me in. Anyone have any info on this?

Config: ASP.NET v 1.1, Forms Authentication done by a user control. No database, just DataSets running from .config files (I really don't foresee much traffic... Me, a couple of friends. I'm lucky if I get one hit a week outside of my own usage). Using a templating scheme as suggested by Joe Agster on devx here. My authentication code in a nutshell:

if (Authenticate(UserTextBox.Text, PassTextBox.Text))
{
FormsAuthentication.SetAuthCookie(UserTextBox.Text, PersistentCheck.Checked);
Response.Redirect(Request.ApplicationPath + "/default.aspx");
}
else
{
CommentLabel.Text = "Wrong credentials, please try again.";
CommentLabel.Visible = true;
}

Any idears?

Thanks in advance!

Source: http://www.livejournal.com/community/csharp/36027.html

Date: 09/24/05 (PHP Community)    Keywords: php, mysql, database, sql, web

I'm doing a web application with PHP and MySQL where members can enter their birthday on their profile. I've done a nice monthly calendar view, and I want to populate the calendar with members' birthdays.

Can anyone advise me the best way of doing this? Obviously I don't want to do a database request for each day: "Does anybody have a birthday on this day?" - I think we can all guess that 30 database requests would be rather excessive for one page!!

What I'd like to do is one database request to get all the birthdays for the month and then write it to a 2-dimensional array. Each row in the array will have the user's name, their userid (to link to their profile) and the day of the month which is their birthday. Then all I need do is ask the array if there's any birthdays when I'm writing out the days.

The trouble is, I'm very unfamiliar with arrays and I'm not sure the best way to do this. Can anyone help?


Update
I've found a very useful function which is helping a lot:

$birthdayquery = "SELECT ID, RealName, DOBDay from Users where DOBMonth = '$month'";
$birthdays = mysql_query($birthdayquery);
$arrayindex = 0;
while ( $birthdayarray[$arrayindex++] = mysql_fetch_assoc($birthdays) );

You can then do

$arrayindex = 0;
foreach ($birthdayarray as $value) {
	if ($birthdayarray[$arrayindex]["DOBDay"] == $day) {
		echo $birthdayarray[$arrayindex]["RealName"];
		echo "'s birthday";
	}
	$arrayindex++;
}

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

Date: 09/26/05 (PHP Community)    Keywords: php, mysql, html, database, sql

Hi everyone! I've slowly been teaching myself php and mysql over the past few months, but it's slow going, and I tend to learn better from someone teaching me something than I do from a book. I finally got the bright idea today (after having been on LJ for how long? lol) to look for a php help community, and lo and behold, I find you! :D If anyone could help me, I'd be very appreciative.

Here's the situation: I'm trying to build forms that will gather the information provided, check to make sure that everything necessary is included, and either redirect to an error page or a success page as needed. The html form looks like this (obviously without the spaces):

< form action="add_entry.php" method="post">
Subject: < input type="text" name="subject" />
Text: < textarea rows=6 cols=60 name="text">< /textarea>
< input type ="submit" name="add_entry" value="Add Entry" />
< /form>

add_entry.php looks like this (again, without the spaces):


include('common.php');
if(isset($formname) && $formname == 'add_entry'){
if($subject != '' && $description != ''){
$dbh=mysql_connect ($host, $user, $pass) or die
('I cannot connect to the database because I do not like you' . mysql_error());
mysql_select_db ($database) or die('I could not find the database you are searching for');
$query = "INSERT INTO journal
SET dateadd = NOW(),
subject = '$subject',
message = '$description'";
mysql_query($query);
mysql_close($dbh);
$redirect = 'success.html';
}
else{
$redirect = 'error.html';
}
}
else{
$redirect = 'error.html';
}

< html>
< head>
< meta http-equiv="Refresh" content="1;url=< ?php echo $redirect ?>" />
< /head>
< /html>

My problem is that it never seems to go through the mysql query and always redirects to the error page. I know that the query is good--I've checked it through phpMyAdmin--so I'm thinking it has something to do with the isset.

Any help would be greatly appreciated! :D

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

Date: 10/10/05 (Web Development)    Keywords: database, sql, web

I have been told we need to make a feature that will
allow the user to upload an excel spreadsheet (this
will always be formatted in the same was) to the server
then on postback link to the spreadsheet and read the
information from specific cells out into a web form
which can be checked before submission by web form
to the sql server database.

I've never done this before i am fairly sure that i
can connected to a excel spreadsheet as a datasource
*hopes with fingers crossed* but can i specify individual
cells to write from? how difficult is to specify which
worksheet your wanting information from etc

I am going to look into it on the web later but if anyone
has any ideas or has done something similar i'd very
much appreciate any help with this, I did in the past
have to attempt connecting to a excel sheet which
didn't go well.

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

Date: 10/10/05 (Web Development)    Keywords: database

Well, I want to create a questionaire/survey of sorts. A page with a bunch (10?) of questions and a bunch of option answers (4?) for each of the questions.

First thing I can't set my mind on is whether to use a database or text files, or both.

If I use a database, it becomes too complicated for such a simple thing: a table for questions, a table for options, and a table for answers.

I guess text files sound much more attractive to me.. and somehow just feel wrong.

Any suggestions?

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

Date: 10/10/05 (Asp Dot Net)    Keywords: database, sql, web

I have been told we need to make a feature that will
allow the user to upload an excel spreadsheet (this
will always be formatted in the same was) to the server
then on postback link to the spreadsheet and read the
information from specific cells out into a web form
which can be checked before submission by web form
to the sql server database.

I've never done this before i am fairly sure that i
can connected to a excel spreadsheet as a datasource
*hopes with fingers crossed* but can i specify individual
cells to write from? how difficult is to specify which
worksheet your wanting information from etc

I am going to look into it on the web later but if anyone
has any ideas or has done something similar i'd very
much appreciate any help with this, I did in the past
have to attempt connecting to a excel sheet which
didn't go well.

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

Date: 10/10/05 (PHP Community)    Keywords: programming, mysql, database, sql

Most of us are aware of the function Live Journal has to assign "tags" to journal entries. I have also seen Flickr.com do this and use as a path for search and browsing (Pretty cool).

As far as I can tell this is just a list of keywords, probably stored as a Text Blog per journal entry (Live Journal) or per image (Flicker).


How would you go about programming a tag function? I am not looking for code, but rather logic steps.

EDIT: BTW the database will be MySQL.

From the initial response, I see a BLOG isnt the way to go. Also, let me give a little more detail: the function I am building will also function kinda like Live Journal's Interests where a user will list interests and then be matched up to the tags (keywords) of other database entries (not necessarily other users).

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

Date: 10/10/05 (Asp Dot Net)    Keywords: browser, database, sql

Okay this has been bothing me for some time now
whenever i am working with the database (ms-sql 2k)
i keep running into problems with nulls and empty
values, I am passing an empty string into the db
and its fine i pass it through my string cleaner
function and it can't find the value its trying to
enter also with number field unless theres a value
in it the it crashes with the same error my sting
cleanner causes ... what am i doing wrong





### String cleaner function ###
Function Strip_SQL(ByVal strValue as String)
Dim ModStrValue As String
' the values replacing the char values are actually ascii and are rended by the browser here
Dim ModStrValue1 As String = replace(strValue,vbCrLf,"[br/]")
Dim ModStrValue2 As String = replace(ModStrValue1, chr(34),""")
Dim ModStrValue3 As String = replace(ModStrValue2, chr(9),"    ")
Dim ModStrValue4 As String = replace(ModStrValue3, chr(13),"[BR/]")
Dim ModStrValue5 As String = replace(ModStrValue4, chr(39),"'")
Dim ModStrValue6 As String = replace(ModStrValue5, chr(40),"(")
Dim ModStrValue7 As String = replace(ModStrValue6, chr(41),")")
Dim ModStrValue8 As String = replace(ModStrValue7, chr(61),"=")
Dim ModStrValue9 As String = replace(ModStrValue8, chr(64),"@")

Return ModStrValue9

End Function

### how the function is places on the request ###
Dim editorial As String = Strip_SQL(Request.Form("editorial"))

### passing the variable to codebehind ###
Dim EditAdminResort As New Devotion2Motion.AdminComp()
EditAdminResort.EditResort(editorial )


### The function that passes the variable to the query ###
Public Function EditResort(ByVal editorial As String)
' Create Instance of Connection and Command Object
Dim myConnection As New SqlConnection(ConfigurationSettings.AppSettings("strConn"))
Dim myCommand As New SqlDataAdapter("sp_call_Resort_Update", myConnection)
' Mark the Command as a SPROC
myCommand.SelectCommand.CommandType = CommandType.StoredProcedure

' Add Parameters to SPROC
Dim parametereditorial As New SqlParameter("@editorial ", SqlDbType.nVarChar, 4000)
parametereditorial .Value = editorial
myCommand.SelectCommand.Parameters.Add(parametereditorial )


' Create and Fill the DataSet
Dim myDataSet As New DataSet()
myCommand.Fill(myDataSet)

' Return the DataSet
Return myDataSet

End Function


### the error ###
System.Data.SqlClient.SqlException: Procedure 'sp_call_Resort_Update' expects parameter '@editorial ', which was not supplied.

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

Date: 10/11/05 (PHP Community)    Keywords: php, mysql, database, sql, web

This has irked me for some time: The lack of INI handlers in PHP.

I was moving my website around from host to host, until I settled, and needed a universal standard that I could write on and rely on that would work anywhere as I really wouldn't have a MySQL database everywhere I went. So I wrote this up after not finding a shred of a command for userlevel INI file handling. INI.Lib (Last Built Oct. 3rd, 2004)

I hope some other people can make some use out of it as well I was able to. If you see any major errors or when you use it you can't for the life of you get past a certain bug, let me know and I will see if this one is any real difference from my current build (Apr. 3rd 2005). I may have just patched up a few commands here and there with my build that I caught in the original code and done a few optimizations. If anyone wants the current build, go ahead and drop me a line to cynagen at cynagen dot com, and I'll be more than happy to send you a copy of the current copy on my server; if enough of you report problems, I'll just repackage my current build and post that instead.

(X-Posted on October 10th 19:54)

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

Date: 10/11/05 (PHP Community)    Keywords: php, database

I had posted a while ago (I can't even remember if it was the php community) on the best way to pick a random item out of a database. The code I was given was "ORDER BY rand() LIMIT 1", except this is not random - the percentage of times the first item is taken out of the database is very high. Does anybody have a better way?

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

Date: 10/11/05 (PHP Development)    Keywords: php, mysql, database, sql, web

This has irked me for some time: The lack of INI handlers in PHP.

I was moving my website around from host to host, until I settled, and needed a universal standard that I could write on and rely on that would work anywhere as I really wouldn't have a MySQL database everywhere I went. So I wrote this up after not finding a shred of a command for userlevel INI file handling. INI.Lib (Last Built Oct. 3rd, 2004)

I hope some other people can make some use out of it as well I was able to. If you see any major errors or when you use it you can't for the life of you get past a certain bug, let me know and I will see if this one is any real difference from my current build (Apr. 3rd 2005). I may have just patched up a few commands here and there with my build that I caught in the original code and done a few optimizations. If anyone wants the current build, go ahead and drop me a line to cynagen at cynagen dot com, and I'll be more than happy to send you a copy of the current copy on my server; if enough of you report problems, I'll just repackage my current build and post that instead.

(X-Posted on October 10th 19:54)

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

Date: 10/11/05 (PHP Community)    Keywords: database

I want to pull information on 'archives' from a database - I need to show each month that content was added and how many posts there are.

E.g.
October, 05: 1 posts
September, 05: 5 posts
August, 05: 4 posts

..and so on. I thought KNOW I'd figured it out before and got it working but I must have changed something because (before I 'lost' the code) I got the months times by amount of posts:

# October, 05
# September, 05
# September, 05
# September, 05
# September, 05
# September, 05
# August, 05
# August, 05
# August, 05
# August, 05

..and so on.

The month is stored in a 'normal' date format (YYYY-MM-DD). Any help would be appreciated, ask if you need more info from me. I don't have the original code I was working on (I have to start from scratch) so please don't ask, sorry :(

SOLVED Thanks :D

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