dickersonka

1. The database is already built for transactional processing to handle multiple users. You will most likely have a single 'user account' that you will use to communicate with the database. 2. There are a couple of ways to do this. Normally you can put the connection string in the …

might try [ShopCode] if your error is in that line also use columns instead of star

You can do it two ways. If you just need a basic excel sheet, just save it out as a csv format with xls extension. If you need more advanced, then take a look using office pia's. They are DOM for office for all versions. Here's a link on msdn …

you could also use something like this [code] select person_id, hairmatch, colormatch, eyematch, sum(hairmatch, colormatch, eyematch) as total from (select person_id, (case when Hair = 'Tall' then 1 else 0 end) as hairmatch, (case when HairColor = 'brown' then 1 else 0 end) as colormatch, (case when EyeColor = 'blue' …

Might want to try disabling UAC, disabling antivirus, and installing the most minimal set of options to start with. Also make sure you have vista sp1. If all that fails, can you post some error messages or event log errors?

Add something like an active flag to the user. And in all queries when pulling users add where active_flag = 1 for active users, and the '0' user will not be pulled back. So this allows you to maintain the user still in the db, but not returned from queries …

Might help to say what line. looks like you may have mistyped this [code] mysql_fetch_assoc($sq1) should be mysql_fetch_assoc($sql) [/code]

table names are the top row of each set, each first row is a primary key [code] members member_id first_name last_name zip zipcodes zip city state cars car_id manufacturer_id car_model carmanufacturer manufacturer_id manufacturer_name membercars member_car_id member_id car_id [/code] if you need to be more specific and need more help let …

look at string.split [code] string dig1, oper, dig2; string[] calcs = calc.Split(' '); dig1 = calcs[0]; oper = calcs[1]; dig2 = calcs[2]; int result; switch(oper) { case "+": result = Convert.ToInt32(dig1) + Convert.ToInt32(dig2); break; default: break; } String numdisplay = result.ToString(); Event_Handler(this, numdisplay); [/code] you'll need to do more than …

I don't know what your code is, but you should change your sql code [code] select * from employees where DateDiff(dd, getdate(), dateofbirth) between 0 and 3 [/code] you might need to change the 3 to 2 depending if you are including or excluding it

Because invisible gridviewcolumns are not posted back, they are marked invisble and not added to viewstate. If you want the value to to be posted back, set visible=true and ItemStyle and HeaderStyle of the gridviewcolumn display:none using css. You can also use datakeynames [url]http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.gridview.datakeynames.aspx[/url] Or you can

Agree with varma if you are using php [code] mysql_connect(server, username , password); [/code] if jsp then [code] jdbc:mysql://servername/database?user=username&password=password [/code]

I use both business and enterprise, i think business is more than sufficient.

You can specify to disable caching of the page or you can specify that a request for each page require a unique key that is generated as a hash or something like that from the previous page.

It really depends on the amount of images you will expect to have in your database, security and speed needed. Of course more image mean more space. If speed is an issue, the database isn't optimized for files, the filesystem is. If you need the images in the database, correct, …

Interesting concept. Here's a link that I think this is what you are looking for [url]http://research.microsoft.com/research/pubs/view.aspx?tr_id=841[/url]

This might not be the most interesting read, but it explains the concepts on database design and modeling. [url]http://www.deeptraining.com/litwin/dbdesign/FundamentalsOfRelationalDatabaseDesign.aspx[/url]

Are you sure you have .net registered on server side in iis? The page itself should render in text/html, but the page needs to be compiled from server which sounds like its not happening. Make sure have registered asp.net with iis.

Look at this codeproject article. Just pass your byte array to the method byteArrayToImage, its in c# but you can figure it out [url]http://www.codeproject.com/KB/recipes/ImageConverter.aspx[/url]

[code] select * from products where categoryid = ? [/code] the other option is to set an active field, which could be a boolean column and set it to true or false, then select from 'active' columns only if you wanted to do updates rather than physical deletes

Do you have the latest services packs and did you apply this hotfix if so? [url]http://support.microsoft.com/kb/925744[/url]

Maybe the thing he is worried about is that peraltu.edu is a registered domain name tied to an ip address. For peralta.edu to be changed to a separate ip, you need to update it with the registrar. You can't flip a switch to get it to work also, the domain …

add an extra column to the select [code] SELECT completed, completed IS NULL AS isnull from table order by isnull desc, completed desc [/code]

You can connect to a sql 2005 database with .net 1.1 no problem. You shouldn't run into any issues, but framework 1.1 is well outdated.

An option could be to change your exe to a web service. Communicating with an executable from a web application and distributed application is not something you normally want to do and super complicates things.

to find the first in mssql use a order by with with select top 1

Is that User.mainuser or User mainuser? Create the user as a private variable inside of the form.

[code] select c.customerid, c.name, c.address, c.postcode, c.pricepercut, g.dateofcut, g.paid from grasscut g inner join customer c on c.customerid = g.customerid where g.paid = 0 [/code] you might need to change g.paid = false, depending upon your column type

Query the database with the information you are going to insert. If a record exists, do not do the insert and specify a 'duplicate message', otherwise continue and make an insert database call.

That should work. You might need to use [code] out.print(j); [/code]

Does anyone have any experience using Instant Virtual Office. [url]http://ivoapp.com[/url] I have an application that reads from HKCU, which runs fine on w2k, w2k3, and w2k8 servers, but it fails to read the HKCU when running on the IVO server. I haven't been able to find any development document for …

Do you have windows firewall turned on?

Would you be able to convert the double to a string, then loop through the string and pass that on to the com? [code] //Might want to use a format provider here string s = A.ToString(); foreach(char c in s) { comBobbySue.Write(c); } [/code]

session is only for the time the user has your site opened if you need expiry time after you close the browser, use cookies as architact stated

you can do it as select it from the mysql side [code] select time1, time2, addtime(time1,time2) from table [/code]

ConfigurationManager did not exist until .net 2.0, use visual studio 2005 to be able to use it.

If you are using asp.net you need to use bind

Normally it is due to permissions on the mdb. Here are suggestions to fix your problem. [url]http://support.microsoft.com/kb/175168[/url]

If they have javascript disabled, you'll never be able to update the quantites. Think of adding an item, the same as changing quantities, overall it is a change. You could repost the quantities and reflect them that way along with any new additional items.

agree with kavitha use this to destroy the session [code] session_destroy(); [/code] this to reset the cookie if its cookie just set to its name [code] setcookie('nameofcookie'); [/code]

on the submit, do a query on the database before trying to do the insert display the message and make the user reenter the field then do the same thing all over again

i can't tell completely what you are meaning, but looks like a group by should take care of it

take a look at using a repeater control

Look at the foreach loop if you want insert multiple records at the same time [url]http://us2.php.net/foreach[/url] If you need a date, just use getdate() for the current date, not sure what you are meaning

You are just missing the additions of the strings here, in all your numbered lines do this [code] System.out.println("1." +first.getTitle() [B][COLOR="Red"]+[/COLOR][/B] "........." +first.getPages()); [/code]

If they are only supporting index.htm, they might not be supporting asp.net pages. Normally, you can set through cpanel or whatever you have, a startup page or set the order on default.aspx, index.htc, etc.. But if they do, then create an index.htm page to redirect to your home.aspx page. [code] …

Might want to use ajax with a pop up date time picker and a read only textbox. This way, you can be sure to have a consistent display and parsing of the value.

Check out this link. [url]http://www.csharp-station.com/Articles/Thumbnails.aspx[/url] Then you can create 5 images in a table, or however you choose to do it, and set each to have a url of this thumbnailpage with a query string of file, and pass 'file' into it, with the file path.

Separate out the classes, and create a singleton [code] public class Server { private bool _stopped; public bool Stopped { get { return _stopped; } set { _stopped = value; } } private static Server _instance = new Server(); public static Server instance { return _instance; } } //from your …

[code] select date, count(date) from blabla group by date [/code]