Date: 12/07/05 (Asp Dot Net)    Keywords: css, asp, sql

FYI: Problem resolved


Anyone know how I can access controls within the EmptyDataTemplate of my GridView?

<asp:GridView ID="grdProjectHours" DataSourceID="sqlModifyProjectHours" 
        PageSize="15" AllowPaging=true AllowSorting=true 
        AutoGenerateColumns=false GridLines="Both" 
        ShowFooter=true BorderWidth="2" BorderColor="#000000" 
        runat=server Width="100%" 
        OnDataBound="grdProjectHours_OnDataBound" 
        OnRowUpdating="grdProjectHours_OnRowUpdating" 
        EditRowStyle-VerticalAlign="top">
	...
	<Columns>
		<asp:TemplateField HeaderText="Project" SortExpression="project">
			...
		</asp:TemplateField>
	</Columns>
	<EmptyDataTemplate>
		<table width="100%" cellpadding="0" cellspacing="0" border="0">
			<tr>
				<td class="gridHeader"><asp:Label ID="lblEmptyProject" runat="server" Text="Project" /></td>
				<td class="gridHeader"><asp:Label ID="lblEmptyHours" runat="server" Text="Hours" /></td>
				<td class="gridHeader"><asp:Label ID="lblEmptyWorkDate" runat="server" Text="Date of Work" /></td>
				<td class="gridHeader"><asp:Label ID="lblEmptyChangeNumber" runat="server" Text="Change Order" /></td>
				<td class="gridHeader"><asp:Label ID="lblEmptyComments" runat="server" Text="Comments" /></td>
				<td class="gridHeader"></td>
			</tr>
			<tr>
				<td colspan="7" height="2"></td>
			</tr>
			<tr>
				<td colspan="7" bgcolor="#cccccc"></td>
			</tr>
			<tr>
				<td colspan="7" height="1"></td>
			</tr>
			<tr>
				<td class="gridContent"><asp:DropDownList ID="cboNewProject" Width="225" runat="server" DataSourceID="sqlProject" DataTextField="project" DataValueField="id" OnDataBound="cboNewProject_OnDataBound" /></td>
				<td class="gridContent"><asp:TextBox ID="txtNewHours" Width="50" runat="server" /></td>
				<td class="gridContent"><asp:TextBox ID="txtNewWorkDate" Width="50" runat="server" /></td>
				<td class="gridContent"><asp:TextBox ID="txtNewChangeNumber" MaxLength="10" Width="50" runat="server" /></td>
				<td class="gridContent"><asp:TextBox ID="txtNewComments" MaxLength="155" Width="100" runat="server" /></td>
				<td class="gridContent" align="right"><asp:LinkButton ID="btnAddProjectHours" runat="server" CommandName="insert" Text="add" OnClick="btnAddProjectHours_OnClick" /></td>
			</tr>
			<tr>
				<td class="gridContent"><asp:RequiredFieldValidator ID="reqNewProject" ControlToValidate="cboNewProject" ErrorMessage="Project" CssClass="ErrorMessage" EnableClientScript="false" Display="Dynamic" runat="server" /></td>
				<td class="gridContent"><asp:RequiredFieldValidator ID="reqNewHours" ControlToValidate="txtNewHours" ErrorMessage="Hours" CssClass="ErrorMessage" EnableClientScript="false" Display="Dynamic" runat="server" /></td>
				<td class="gridContent"><asp:RequiredFieldValidator ID="reqNewWorkDate" ControlToValidate="txtNewWorkDate" ErrorMessage="Date of Work" CssClass="ErrorMessage" EnableClientScript="false" runat="server" /><asp:RangeValidator id="rngWorkDate" runat="server" CssClass="ErrorMessage" ControlToValidate="txtNewWorkDate" MaximumValue="1/1/2100" MinimumValue="1/1/1900" Type="Date" EnableClientScript="false" ErrorMessage="Date of Work (mm/dd/yyyy)" Display="dynamic" /></td>
				<td class="gridContent"></td>
				<td class="gridContent"></td>
				<td class="gridContent" align="right"></td>
			</tr>
		</table>
	</EmptyDataTemplate>
</asp:GridView>

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

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

FYI: Resolved.

Hey gang,

I'm in the process of fixing an application a former programmer slap together. We found the database design went against company standards, so our DBA went through to fix her up. Now I'm working on the task of fixing the UI code to interact properly with the new changes.

However, I've ran in to a strange behavior with UpdateParameters within my SqlDataSource.

Originally, the Stored Proc calls for the following parameters:

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

Date: 12/01/05 (Asp Dot Net)    Keywords: database, sql

I'm writing a program that does queries on a database, and we just converted to a code-table format (instead of whole strings going in the DB we just put in numbers that reference another table which has all the definitions. Note that these tables are NOT connected (sadly.)) Anyways I'm writing this program that returns data from the database into a datagridview. I've been told that I can't do the conversion on the DataSet or the DGV side and that SQL server needs to do it, so basically I need to write a query that will get all the records that match the request, and then in a particular column, instead of putting in the number that is in teh database, have it look at the code table, find the matching id, and have THAT be displayed instead.

Here's conceptually what I'm going for (this is NOT SQL compliant and my SQL knowledge isn't that great. Hell if it was I wouldn't be here asking this question which I know any standard SQL DB user will likely know the answer to):

SELECT * FROM Table1, Table2
In Table1.Column,
instead of showing the code in it,
WHERE Table1.Column = Table2.Column(id),
Display in Table1.Column the info in Table2.Description.

I realize this is sort of hard to describe in text vs speech. I know there's an easy way to do this with an Inner Join, but that simply adds the info from the 2nd table to the end of the first (and displayed) table.

Here's the SQL code

SELECT * FROM sfrf_request
INNER JOIN sfrf_request_type
ON CONVERT(int,sfrf_request.request_type)=sfrf_request_type.id
WHERE sfrf_request.id = ddl1.SelectedIndex

BTW the CONVERT function is used because the column has string data in it still and thus I can't reference it as an integer.

Any help would be greatly appreciated.

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

Date: 11/29/05 (Asp Dot Net)    Keywords: programming, sql, web

Ok this is a weird question that may not be appropriate here but here's my situation: I'll be getting a new computer for Xmas that will be a powerful machine that will be used for 2 primary functions: Programming and Gaming. Thing is that basically I do alot of web programming so I'm going to have VS 2003 and 2005, SQL Server (possibly 2000 AND 2005), and IIS. As you know gaming requires alot of system resources and memory and I don't want to have to go to task manager everytime I boot up to play a game to close off all the programming and server programs. So what I'm wondering is whether or not I should:

A: Set up 2 user accounts on my computer (this is an XP Pro machine) with one for programming and one for gaming that has a modified startup script to disable everything (which i have no experience in writing BTW). I also don't know if this would even free up all the memory that I'd want.

B: Install 2 instances of XP Pro and use a dual boot configuration with one config with all the server and programming tools and one without. HD space isnt' really an issue since I will have a 250 gig hard drive (and likely will be adding more at a later date.) However I'm not very experienced with this sort of setup. I do plan on installing Windows XP 64-bit as well, so I'd have to do the 2 32-bit installations first and then do the 64-bit one. I'm not very keen on dealing with multiple partitions for all my programs, especially if they can't talk to one another (although I bet there's tools that allow you to view on the parttions, like I said I don't have much experience with this.) I know the 64 will require its own partition.

Sorry if this is really "out there" or inappropriate for this community. If someone knows a more appropriate one please let me know. I just figured since there appears to be a decent number of intelligent computer users here that perhaps there'd be someone here who could help me as well. Thanks alot.

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

Date: 01/17/06 (WebDesign)    Keywords: php, programming, mysql, database, sql, java, postgresql, web, apache

I need some advice in regard to which language to use for developing a dynamic website. My wife and I are thinking about creating a LMAO website, which will allow people to organize various LMAO projects. The website will allow users to register, log in, create projects, join projects, upload pictures, and so on. It's not terribly large project, but still pretty complicated for people who haven't done any web development and little programming in general.

The first problem is deciding upon a language to use. The site will, at least in the beginning, run on our server at home, which is FreeBSD running Apache2 (or anything else we want, to be honest. I'm not giving up FreeBSD, though!). It looks like all major languages in the field, including PERL, Ruby (and Ruby on Rails), Python, and PHP work well with Apache, so that shouldn't be a problem. For the database back-end, we'll be using PostgreSQL or MySQL (if we have to), both of which are widely supported as well.

My wife doesn't have much experience in programming, so for her it will be new experience one way or the other. I have some, but still little. The only language I'm familiar with and can actually write something useful in is Common Lisp. There exists mod_lisp and a couple of web development frameworks, TBNL and UnCommon Web, but the process seems hacky -- from what I can tell -- unless one uses a commercial CL implementations that cost a lot.

I've looked briefly at Python and Ruby, as well as asked for opinions from various groups of people (programmers who prefer Lisp, Ruby, or Python), but it's all still looks like mambo-jumbo to me. The only thing they agree on is that one should refrain from using PHP for anything non-trivial, so I'm inclined to believe that. As far as PERL is concerned, I've always had a distaste for it, so am not all that keen on using it.

Could anyone recommend one of these language, or perhaps another one, that would be suitable for our needs? I've pretty much made up my mind in regards to PHP and PERL, so I'm not looking for a debate about why they're good. I also wish to stay away from Windows-based and Java-based solutions.

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

Date: 01/09/06 (C Sharp)    Keywords: database, sql

Okay, I'm stumped.

I'm using Intersystems Cache, for which there seem to be no peer help fora anywhere on the net, though theoretically it shouldn't matter, should it? ODBC is ODBC, I hope. In any case, here's a quick code snippet:

       private void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                string InsertString = "INSERT INTO Erasmus.Publisher(Name, PublisherURL) VALUES(@Name,@URL)";
                ErasmusTransaction = ErasmusConnection.BeginTransaction(IsolationLevel.ReadCommitted);
                ErasmusInsertCommand = new OdbcCommand(InsertString, ErasmusConnection, ErasmusTransaction);

                OdbcParameter prmName = new OdbcParameter();
                prmName.Direction = ParameterDirection.Input;
                prmName.OdbcType = OdbcType.VarChar;
                prmName.Value = txtName.Text;
                prmName.ParameterName = "@Name";
                ErasmusInsertCommand.Parameters.Add(prmName);

       private void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                string InsertString = "INSERT INTO Erasmus.Publisher(Name, PublisherURL) VALUES(@Name,@URL)";
                ErasmusTransaction = ErasmusConnection.BeginTransaction(IsolationLevel.ReadCommitted);
                ErasmusInsertCommand = new OdbcCommand(InsertString, ErasmusConnection, ErasmusTransaction);

                ErasmusInsertCommand.Parameters.Add("@Name", OdbcType.VarChar, 100).Value = txtName.Text;

Source: http://community.livejournal.com/csharp/46500.html

Date: 11/18/05 (C Sharp)    Keywords: database, asp, sql, web

I am converting a web app from ASP to ASP.net and have stumbled on an annoying problem.

1. ASP code accepts user input and stores value in the database
SQL field type is nvarchar(200).
BUT the query does not use N'' to specify that the string is unicode.

2. Value stored in the database is '陳小春'

3. Value displayed on web page (utf8 encoding, no server side changes) is '陳小春'

4. Actual UTF data in the database is displayed on screen as ???
(database value: 人, display value: ?)

5. ASP.net application using the EXACT same queries results in point 4 being displayed correctly (as japanese) but the values that were displayed correctly in the ASP app are now exactly as they are in the database.

Please Help ... My only guess was that the ADO connection was converting the UTF in the database to Non-UTF for display in ASP and the ADO connection in .Net is preserving the Unicodeness of it.

But i did a simple test in ASP where i selected the data, stored it in a variable and then inserted back into the database (non using N'')
and well ... i got the exact same .... japanese was japanese the rest was garbage.


Anyone have any ideas???

Source: http://community.livejournal.com/csharp/41546.html

Date: 12/21/05 (Code WTF)    Keywords: database, sql

public static void isDBConnectionValid(Connection dbConnection)
throws Exception
{
if(dbConnection == null)
throw new SQLException("Database connection does not exist");
else
return;
}

Source: http://community.livejournal.com/code_wtf/21568.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://community.livejournal.com/php_dev/61141.html

Date: 06/28/05 (PHP Development)    Keywords: mysql, database, sql, google

I'm working on a site at the moment and I'm trying to optimise the MySQL queries, to place less of a strain on the server and make generally neater code. I'm currently using this technique to pull the last 10 topics flagged as news from the database:

$query = mysql_query( "SELECT * FROM frm_topics t WHERE t.tpc_news = '1' AND t.tpc_news_mod_id > 0 ORDER BY t.tpc_sticky DESC, t.tpc_time DESC LIMIT 10", $_GLOBALS[ 'sql' ] );

$news_sql = mysql_query( "SELECT * FROM frm_posts p WHERE p.pst_tpc_id = '".$results[ 'tpc_id' ]."' ORDER BY pst_time ASC LIMIT 1", $_GLOBALS[ 'sql' ] );

$query = mysql_query( "SELECT * FROM frm_posts p, frm_topics t WHERE p.pst_tpc_id = ( SELECT tpc_id FROM frm_topics t WHERE t.tpc_news = '1' AND t.tpc_news_mod_id > 0 ORDER BY t.tpc_sticky DESC, t.tpc_time DESC LIMIT 10 ) AND t.tpc_id = p.pst_tpc_id ORDER BY p.pst_time ASC LIMIT 1", $_GLOBALS[ 'sql' ] );

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

Date: 06/07/05 (PHP Development)    Keywords: php, mysql, software, html, xml, database, asp, sql, security, web, apache

Here's what I have
Apache 1.3.33
PHP 5.0.4
MySQL 4.1.12a
Operating System: Windows 98

The error that I got when I tried using mysql_connect() on a php page:

Fatal error: Call to undefined function mysql_connect()

Things that I have done so far:
Apache, mySQL, and PHP are in directories on the C drive, named accordingly

in php.ini, this is what I changed (change in italics)
doc_root = "C:\Apache\htdocs"
extension_dir "C:\php\ext"

Removed the ";" in front of extension = php_mysql.dll (Is there supposed to be quotation marks on this line?)

Saved a copy of php.ini (after these changes) in the C:\Windows directory
Saved copies of c:\php\libmysql.dll & c:\php\ext\php_mysql.dll to the C:\Windows directory


--------------
What else am I missing?


PHP Version 5.0.4

System Windows 9x JESSICA 4.10
Build Date Mar 31 2005 02:44:34
Configure Command cscript /nologo configure.js "--enable-snapshot-build" "--with-gd=shared"
Server API Apache
Virtual Directory Support enabled
Configuration File (php.ini) Path no value
PHP API 20031224
PHP Extension 20041030
Zend Extension 220040412
Debug Build no
Thread Safety enabled
IPv6 Support enabled
Registered PHP Streams php, file, http, ftp, compress.zlib
Registered Stream Socket Transports tcp, udp

This program makes use of the Zend Scripting Language Engine:
Zend Engine v2.0.4-dev, Copyright (c) 1998-2004 Zend Technologies



--------------------------------------------------------------------------------

PHP Credits

--------------------------------------------------------------------------------

Configuration
PHP Core
Directive Local Value Master Value
allow_call_time_pass_reference On On
allow_url_fopen On On
always_populate_raw_post_data Off Off
arg_separator.input & &
arg_separator.output & &
asp_tags Off Off
auto_append_file no value no value
auto_globals_jit On On
auto_prepend_file no value no value
browscap no value no value
default_charset no value no value
default_mimetype text/html text/html
define_syslog_variables Off Off
disable_classes no value no value
disable_functions no value no value
display_errors On On
display_startup_errors Off Off
doc_root no value no value
docref_ext no value no value
docref_root no value no value
enable_dl On On
error_append_string no value no value
error_log no value no value
error_prepend_string no value no value
error_reporting no value no value
expose_php On On
extension_dir C:\php5 C:\php5
file_uploads On On
highlight.bg #FFFFFF #FFFFFF
highlight.comment #FF8000 #FF8000
highlight.default #0000BB #0000BB
highlight.html #000000 #000000
highlight.keyword #007700 #007700
highlight.string #DD0000 #DD0000
html_errors On On
ignore_repeated_errors Off Off
ignore_repeated_source Off Off
ignore_user_abort Off Off
implicit_flush Off Off
include_path .;C:\php5\pear .;C:\php5\pear
log_errors Off Off
log_errors_max_len 1024 1024
magic_quotes_gpc On On
magic_quotes_runtime Off Off
magic_quotes_sybase Off Off
mail.force_extra_parameters no value no value
max_execution_time 30 30
max_input_time -1 -1
open_basedir no value no value
output_buffering 0 0
output_handler no value no value
post_max_size 8M 8M
precision 14 14
register_argc_argv On On
register_globals Off Off
register_long_arrays On On
report_memleaks On On
report_zend_debug On On
safe_mode Off Off
safe_mode_exec_dir no value no value
safe_mode_gid Off Off
safe_mode_include_dir no value no value
sendmail_from no value no value
sendmail_path no value no value
serialize_precision 100 100
short_open_tag On On
SMTP localhost localhost
smtp_port 25 25
sql.safe_mode Off Off
track_errors Off Off
unserialize_callback_func no value no value
upload_max_filesize 2M 2M
upload_tmp_dir no value no value
user_dir no value no value
variables_order EGPCS EGPCS
xmlrpc_error_number 0 0
xmlrpc_errors Off Off
y2k_compliance On On
zend.ze1_compatibility_mode Off Off


apache
Apache for Windows 95/NT

Apache Version Apache/1.3.33 (Win32) PHP/5.0.4
Apache Release 10329100
Apache API Version 19990320
Hostname:Port localhost:80
Timeouts Connection: 300 - Keep-Alive: 15

Directive Local Value Master Value
child_terminate 0 0
engine 1 1
last_modified 0 0
xbithack 0 0


Apache Environment
Variable Value
COMSPEC C:\WINDOWS\COMMAND.COM
DOCUMENT_ROOT c:/apache/htdocs
HTTP________________ ----- -------
HTTP_ACCEPT image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, application/x-shockwave-flash, */*
HTTP_ACCEPT_LANGUAGE en-us
HTTP_CONNECTION Keep-Alive
HTTP_HOST localhost
HTTP_USER_AGENT Mozilla/4.0 (compatible; MSIE 6.0; Windows 98)
PATH C:\WINDOWS;c:\windows;c:\windows\COMMAND
PHPRC C:/php
REMOTE_ADDR 127.0.0.1
REMOTE_PORT 2477
SCRIPT_FILENAME c:/apache/htdocs/phptest.php
SERVER_ADDR 127.0.0.1
SERVER_ADMIN jessica.karels@gmail.com
SERVER_NAME localhost
SERVER_PORT 80
SERVER_SIGNATURE

Date: 01/18/06 (SQL Server)    Keywords: sql

Hi all,

I'm looking for a way to update a table based upon a recordset returned from a stored procedure.

It appears as if you can't join on the results from a stored procedure nor loop over those records using a cursor.

I will be the first to admit, I often miss things when combing through documentation, but I was hoping to use a join in an update statement (which I could do, but I would prefer not to duplicate the logic that I've already got stored in this stored procedure)

If anyone can offer any suggestions, I would be most greatful.


--gryff

EDIT: I'm using SQL Server 2000

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

Date: 01/17/06 (SQL Server)    Keywords: database, sql

A new product that might be of interest to users in this community: TextConverter

Synopsis:
- extraction of data from text files (from simple CSV to complex)
- script-enabled transformation
- load into any database including SQL Server

Any feedback would be greatly appreciated.

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

Date: 01/15/06 (SQL Server)    Keywords: sql

table_name
- column_name

utterance
- utteranceID
- speakerID

utteranceHistory
- utteranceHistoryID
- utteranceID
- speakerName
- workTypeDescription
- businessEntityDescription
- eventDate

speaker
- speakerID
- personID

person
- personID
- firstName
- lastName

the task: i need to collect all occurrences when a speakername had been changed in the system. returning in this query: the utteranceID, original speakerName, and final speakerName. I am using MS SQL Server, so i can't use a MINUS as i would have liked to.

-- here is what i tried
-- sadly this is lacking by not returning all of the rows where a speakerName change has occurred
select uh1.utteranceID,
uh1.speakerName AS originalSpearkerName,
uh2.speakerName AS finalSpearkerName
from utteranceHistory uh1 INNER JOIN utteranceHistory uh2
ON (uh1.locationId = uh2.locationId
AND uh1.utteranceID = uh2.utteranceID
AND uh1.utteranceHistoryID <> uh2.utteranceHistoryID)
WHERE uh1.speakerName <> uh2.speakerName
AND uh1.utteranceHistoryID = (SELECT MIN(utteranceHistoryID) FROM
utteranceHistory where utteranceID = uh1.utteranceID)
AND uh2.utteranceHistoryID = (SELECT MAX(utteranceHistoryID) FROM
utteranceHistory utteranceID = uh2.utteranceID)
ORDER BY uh1.utteranceID

-- here is what returns all the changes in the speakerName, however
-- returns two rows per utteranceId, which is really not easy to format
-- especially when the results i am working with are in the thousands.

SELECT utteranceID, speakerName
FROM utteranceHistory
WHERE utteranceID IN
(
SELECT utteranceID
FROM utteranceHistory
WHERE speakerName IS NOT NULL
GROUP BY utteranceid HAVING count(utteranceid) =2
)
and speakerName IS NOT NULL
ORDER BY utteranceid, eventdate

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

Date: 01/03/06 (SQL Server)    Keywords: database, sql

Just joined. Looks like a nice comm.

Quick question:

I have a production database that is about 1 GB in size. I have been tasked to script that baby out into sql files. The tables, procedures, etc. should be little problem (thanks to the database scripting wizard), but the data is eluding me. How can I (relatively automated) script table data into a series of INSERT statements?

Is there any way to avoid manually typing:
"INSERT INTO tbl_WHATEVER (ID, FIELD1, FIELD2, ...) VALUES (1, 1, 1, ...)"?

Thanks in advance!

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

Date: 12/30/05 (SQL Server)    Keywords: sql

1. In query nalyzer, type either of the following and run it:
PRINT 365/183
PRINT CAST(365/183 AS float)

If your answer is 1 (or 1.0), congratulations, you win. You get to tell me what switch we both need to flip to get the correct (mathematically, anyway) answer.

* * *

2. I'm porting a horribly-written Access application to SQL Server. It contains a table with three columns. Each of these columns corresponds to a dropdown box on a form. The way it's supposed to be written is that a value selected in column A will populate the list in column B, etc., since only certain values in column B should be present for any given value in column A. The monkeywrench in the works is that the values in B are not necessarily unique to the values in A, and the values in C are definitely not unique to the values in B-- but not all values in B are applicable to all values of A, and all values in C are not etc. As an example:

A: Inpatient, Outpatient, Other
B: Transplant, Maternity, Addiction Treatment
C: Bone Marrow Transplant Allogenic, Caesarian Section, Emergency Room

It's relatively obvious that Outpatient in A will never correspond to Transplant in B; Transplant will always, short of a medical miracle, be an inpatient procedure. Addiction Treatment, though, can be on either an inpatient or outpatient basis. (I'm lobbying for getting rid of "other" altogether.) Similarly, Bone Marrow Transplant Allergenic will, good lord willin' and cricks don't rise, never apply to maternity-- but Emergency Room could concievably apply to just about anything in either column A or column B, because you can show up at the ER needing, well, anything.

What I've been mulling over is having three different lookup tables, each with two columns-- ID and Description-- and a fourth column that would list the valid IDs that can go together for each. That, however, ultimately saves me not much room, will require manual additions to the core table whenever new categories are added, and would probably end up being slower. (Actually, anything will end up being slower, seeing as the Access app takes the Chinese-menu method-- display anything and let the user pick whatever-- but I'd like to cut the speed decrease as much as possible.) We're still in the brainstorming phase with this, so there aren't any ideas which will undercut work that's already been done. If you have any to throw into the ring, I'd appreciate it.

Thanks!

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

Date: 12/20/05 (SQL Server)    Keywords: sql

Is there any way to stop this from occurring?

(SQL Server 2000, most recent service pack applied.)

Thanks.

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

Date: 12/08/05 (SQL Server)    Keywords: database, sql

I am having some issues starting a procedure. I need to create a sql procedure where the user creates a new dog in a database. The information that is going to be inserted is : gender first, which will stop the program if not identified in the database, breed, which will go under unknown if there is no existing record in database, owner id, which will go under ORPHAN if no existing record, eye color, which will create a new entry for a new eye color is not already in DB, and finally create the dog with dog_id once all the other parts are taken care of. I need to have exception handling in this procedure as well. I would like someone to help me to start this.

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

Date: 11/18/05 (SQL Server)    Keywords: database, sql, security, google

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

Date: 10/14/05 (SQL Server)    Keywords: sql

Is there an equivalent to the SEEK command in T-SQL?

In other words, I need

SELECT left (some_column, number_of_characters_until_you_hit_the_first_space_[which_is_not_uniform]) FROM some_table

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