|
May
30 |
|
awarded | Civic Duty |
|
May
30 |
|
comment |
correct syntax for sql query and a WHERE EXISTS alternative Do you have any influence on the database design? You could move the relation between user and profession/subprofession to relation tables (user-profession, user-subprofession, profession-subprofession). @Tim If the user did not specify a subprofession (think specialization), then get all jobs for the profession. Otherwise just those that match the subprofession, I guess. |
|
May
26 |
|
comment |
How to allow user to insert values into table that already exists? Instead of creating a table for each folder, you could have a Folders table where you store the id of the user and the name of the folder. Generally, most approaches where the usual user does not have to have owner previleges would be preferable ... Maybe you should read more about relational database design. (ID CHAR(3) is pretty uncommon, too.)
|
|
May
21 |
|
revised |
ASP.NET web.sitemap - roles do not seem to control visibility? Updated the link, because the old URL is dead. |
|
May
21 |
|
awarded | Popular Question |
|
Apr
30 |
|
answered | SQLite date function failing on datetime which includes UTC designator ("Z") |
|
Apr
18 |
|
comment |
What is static indexer? possible duplicate of Static Indexers? |
|
Apr
5 |
|
comment |
Retrieve medium blob from MySQL return only 13 bytes dev.mysql.com/doc/connector-net/en/… explains that pretty well. Instead of ,'" + buffer + "',, you would use , @buffer, and call it like MySqlHelper.ExecuteNonQuery(connectionString, sqlPhotoQuery, new MySqlParameter("@buffer", buffer));. (Repeat that for all values to be safer against SQL injection attacks.)
|
|
Apr
5 |
|
answered | Retrieve medium blob from MySQL return only 13 bytes |
|
Apr
4 |
|
awarded | Supporter |
|
Apr
4 |
|
awarded | Autobiographer |
|
Mar
23 |
|
awarded | Great Answer |
|
Mar
11 |
|
answered | Why DataTable.Select sorts the data by default |
|
Mar
8 |
|
comment |
What's the difference between using the Serializable attribute & implementing ISerializable? In which version of .NET is it okay to add the Serializable attribute to a property? MSDN says it can only be applied to classes, structs, enums and delegates.
|
|
Feb
23 |
|
awarded | Revival |
|
Feb
14 |
|
revised |
Convert MailMessage to Raw text Added a small workaround, so that this code can theoretically target .NET 4.0 and .NET 4.5 (and .NET 4.0 compiled in VS 2012 with .NET 4.5 but run on .NET 4.0 only). |
|
Feb
11 |
|
comment |
Convert MailMessage to Raw text Yes, it should work like that, but I also added a check for .NET 4.5. I could update the answer with what works, if that's okay with you? |
|
Jan
31 |
|
awarded | Yearling |
|
Jan
31 |
|
awarded | Autobiographer |
|
Jan
21 |
|
awarded | Enlightened |
