Posts by dickersonka

table names are the top row of each set, each first row is a primary key

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

if you need to be more specific and need more help let me know

What kind of webpage is it? What are you wanting to modify it with? Do you want to edit only or save as well? Any clarification?

Hmmm.

Here's another microsoft link with that exact problem if you haven't tried it already.

http://support.microsoft.com/?kbid=926623

I don't know what your code is, but you should change your sql code

select * from employees where 
DateDiff(dd, getdate(), dateofbirth) between 0 and 3

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
http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.gridview.datakeynames.aspx

Or you can

Agree with varma

if you are using php

mysql_connect(server, username , password);

if jsp then

jdbc:mysql://servername/database?user=username&password=password

Looks like a corrupt wmi

How to fix it:
http://slashstar.com/blogs/tim/archive/2007/01/22/sql-server-installation-problems-on-vista-failed-to-compile-the-managed-object-format.aspx

Also from microsoft's site.
http://www.microsoft.com/downloads/details.aspx?familyid=D7BA3CD6-18D1-4D05-B11E-4C64192AE97D&displaylang=en

As long as you are clicking on an add, subtract button etc with a number click.

It would also be easy to store two arrays, one of the numbers, one of the operators. And when equals is pressed loop through number then operator then number etc. I don't know which method you are using, let me know if you need more clarification based upon which method you are using.

look at string.split

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);

you'll need to do more than this for each operator, but this is the concept

take a look at your text-mate project file and look for the work checkboard and make sure you are using the proper case

lowercase for the filename, windows can find the file and mac can't

I see the code now, you must have class and filename as the same

checkerboard and Checkerboard.java

if it comes to it, just copy the file contents, delete the file from the project, create the file with the uppercase and paste it back in the project

The project file you are using, assuming eclipse, will reference a file named with a capital C and it could not be changed inside of the project without manually changing it. Remember mac's are case sensitive and windows machines are not.

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.

Are you sure you have a 'Checkerboard.java' or 'checkorboard.java'?

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, store them as images in sql, byte arrays as code, and pull them out as byte arrays.

It never hurts with Microsoft products to have fresh installs. Love their products, but sometimes they just don't play well together, or at least if not installed in some certain order.

Interesting concept. Here's a link that I think this is what you are looking for

http://research.microsoft.com/research/pubs/view.aspx?tr_id=841

Is it a possibility to remove these sql files and start with a fresh install?

Then if vs2008 is installed you already have sql express installed. I think the workstation components caused an issue.

Go into programs and features, select sql server 2005, and click uninstall then select workstation tools and complete that piece of the uninstall.

Then you should be able to run the install for sql server.

And one more thing, did you install visual studio 2008 on the machine?

not for sure on the file size limits, if you could just post a few errors or last error encountered. Did you install vista sp1 yet?

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?

Start by thinking of simple examples and making them happen. Ie employee with companies tables, students with teachers and classes tables, database design takes time.

Mysql isn't ran from a dll, its a standalone application, that can be accessed through dll's, this can be thought of as connection and objects used by mysql.

If you're using python here's a link to get you started

http://www.devshed.com/c/a/Python/Database-Programming-in-Python-Accessing-MySQL/

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

http://www.codeproject.com/KB/recipes/ImageConverter.aspx

Might help to say what line.

looks like you may have mistyped this

mysql_fetch_assoc($sq1)

should be

mysql_fetch_assoc($sql)

select * from products where categoryid = ?

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

This might not be the most interesting read, but it explains the concepts on database design and modeling.

http://www.deeptraining.com/litwin/dbdesign/FundamentalsOfRelationalDatabaseDesign.aspx

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

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

Change

order by isnull desc

to

order by isnull

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.

my bad, used my sql
here is the correct way

SELECT completed, ISNULL(completed, NULL) AS 'isnull'
from table
order by isnull desc, completed desc

the order by might need to be changed, based upon the column type of completed, but the select works

If you have functionality in the exe then go the webservice route

If you have display then use php or html, for that

Here's a sample of php calling C# web service
http://randompost.ca/random/php-calling-c-net-webservice/

For c++ it will be a little different, but thats the idea

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.

what about this

<td>
<img src="<%=j%>" />

That should work.

You might need to use

out.print(j);

Does anyone have any experience using Instant Virtual Office.
http://ivoapp.com

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 this server infrastructure and wondered if anyone here has some experience dealing with it?

Thanks

Will be glad to help, please post the code that you have for now and we can go off of that.

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.

You are hitting a local port, most likely assigned by visual studio.

Are you sure you have the webservice launched on that port? If you are running a client app, hitting that url, i don't think you have the webservice deployed or running.

Do you have windows firewall turned on?

I wouldn't say that is insecure at all. You should rely up on your code to enforce the security, not rely up on security to enforce your code.

If you want an additional level of security, create a specific user for selecting from this table only. You will always know the group/user id from the current user's login information.

If you really think it will be an issue, take a look at row level security, depending upon what database you are using.

You don't necessarily need 'permission accounts'. Lets say for instance you have a user account id, group account id they are part of.

You can create your files table something like this

file_id
user_id
group_id
file_name
file_path

then when you need to show the user/group their files

select * from files where group_id = ?

select * from files where user_id = ?

you can create separate file paths based upon the group id as well, once you get a descent amount of groups, it can be much harder and complicated to manage

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

you might need to change g.paid = false, depending upon your column type

Very well may have to do with the decimal, if you are just using int's stick with int's. I forgot about passing double with a decimal point after. Take a look at this to convert double to hex.

http://www.codeguru.com/forum/showthread.php?t=371326

Look at singletons, which uses a static variable

Create the user in this, and reference through the program using this singleton

http://www.yoda.arachsys.com/csharp/singleton.html

You can pass in any value, i just made a simple example of getting a string from a textbox

if you calculate it, just pass in the calculated value and set d to the value

you can do it as select it from the mysql side

select time1, time2, addtime(time1,time2)
from table

Normally it is due to permissions on the mdb.

Here are suggestions to fix your problem.

http://support.microsoft.com/kb/175168