acidzombie24 - Page 15 - Developer IT

Why cant i use the field user in SQL Server 8?

- by acidzombie24

Maybe not literally but the query below gets an error near user. If i change it to userZ it works. WHY can i not use that name? Is there a way to specific its a field instead of a keyword? (or whatever it is) create table Post2 ( id INTEGER PRIMARY KEY NOT NULL, title nvarchar(max) NOT NULL, body nvarchar(max) NOT NULL, user integer REFERENCES Post1(id));

Read the article

How do i use SQL Server 2008? With Visual Studios?

- by acidzombie24

Its a two part question. How do i use SQL Server 2008? With Visual Studios? I started up a dummy project and with server explorer i tried with create new sql server database and add connection using my computer name (it came from a dropdown) as the server location. When i tried to create the database 'TestDB1' i got an error. I dont understand why. Its a fresh install and i have restarted the comp a few times since then. I havent messed with visual studios or the servers or even the control options to disable anything that would have been automatic. So whats with this? -edit- My goals are 1) create a database. 2) Be able to see all the database that exist on the server 3) execute sql queries in the ide 4) be able to browse tables. I dont need all of these but as many possible would be nice.

Read the article

Is it possible to add code to a compiled SWF?

- by acidzombie24

I asked this question about passing keystrokes to the page. Is there a simple way for me to add this to an already compiled swf?

Read the article

jquery not select?

- by acidzombie24

i have a click event for $('#blah div'). div has text inside of it (not inside a div, span, p, etc) and has a textarea in it. The textarea is triggering the event as well, how do i make it only trigger when i click the text and ignore the textarea?

Read the article

equivalent to getch(), mac/linux crash

- by acidzombie24

Hey guys. So I am using getch() and my app crashes instantly. Including when doing: int main() { getch(); } I can't find the link but supposedly the problem is, it needs to turn off buffering or something strange along those lines and I still want cout to work along with cross platform code. I was told to use std::cin.get(), but I'd like the app to quit when a key is pressed, not when the user typed in a letter or number then press enter to quit. Is there any function for this? The code must work under Mac (my os) and Windows.

Read the article

Best way to ignore less specific click event with jquery?

- by acidzombie24

I have the code below. The main code is in the 2nd function however the first is called which is interfering with the more specific a.One code. Whats the best way to not run code in the first function if the div i click is a .main .a.One event? $('.main .a').live('click', function () { alert('first'); //2 lines of code }); $('.main .a.One').live('click', function () { alert('second'); //lots of logic });

Read the article

Change File ext with GreaseMonkey?

- by acidzombie24

One of the sites i visit has an annoying habit of naming all their files showimage.php. When i save the image or file it saves as a .php so i cannot open the file. The worse part is, there is a &ext=zip&more=blah in the url. Is it possible to use greasemonkey to rename the file ext so it isnt php? (maybe injecting a content disposition header?)

Read the article

Easiest way to copy a mysql database from windows to linux?

- by acidzombie24

I dont have perl install on windows. I would like to copy the entire testdb to testdb on my linux VM. What is the easiest way to do that? I can run code on my windows machine to connect to both DB and do sql operations. I am using C#.NET so if i need to write code and its simple then i'm open to that.

Read the article

How would i write this in F# or another functional language

- by acidzombie24

I know in F# you declare variables when you assign them. I'm sure you can declare vars in a C way but how might i write this long id=0 using (SQLiteDataReader r = command.ExecuteReader()) { while (r.Read()) { id = r.GetInt64(0); //... break; } } //use id in sqlite now that it isnt locked

Read the article

create a readonly connection to MySQL?

- by acidzombie24

I looked at the MySql Connection Options and it doesnt seem to be there. Is there a way to create a read only connection/command for .NET? With SQLite i could specify read only=true to do this. What can i do with MySQL?

Read the article

Using linq what is the easiest way to conv list<long> to list<int>?

- by acidzombie24

Using link what is the easiest way to convert a list of longs to a list of ints? I need it to be a list, if it cant be possibly i would like to see a solution with a int array or some kind f int container.

Read the article

How do i use the top keyword in an insert statement?

- by acidzombie24

I was using it as LIMIT when i got the exception Incorrect syntax near the keyword 'TOP'. Maybe i can omit it in this case without problem? but if i couldnt where do i put top? INSERT INTO [user_data] (...) SELECT ... @14 WHERE not exists (SELECT * FROM [user_data] WHERE [email] = @15 OR [name] = @16 OR [unconfirmed_email] = @17 TOP 1);

Read the article

MySql. What is there error on this insert+select+where statement?

- by acidzombie24

What is wrong with this statement? It works with sqlite and MS sql (last time i tested it) I would like a select unless there is no match with name or email. Then i would like to insert. I have it as one statement because its easy to keep concurrent safe as one statement. (its not that complex of a statement). INSERT INTO `user_data` ( `last_login_ip`, `login_date`, ...) SELECT @0, @14 WHERE not exists (SELECT * FROM `user_data` WHERE `name` = @15 OR `unconfirmed_email` = @16 LIMIT 1); Exception You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE not exists (SELECT * FROM `user_data` WHERE `name` = 'thename' OR `unconfirmed' at line 31

Read the article

Where can i learn about search engine crawling and SEO?

- by acidzombie24

I have asked What should i know about search engine crawling? Now i would like to know where can i learn about search engines and search engines optimization? Instead of reading dozen of articles with most saying the same thing as another i would like to read one book or resource and find everything i need to know.

Read the article

Can i exclude a word in my pattern?

- by acidzombie24

I know i can do something like ab[^c]+def which should match ab_blah_hi_blah_def but is there a way to do something like ab(^hi)+def which will exclude the word hi causeing ab_blah_hi_blah_def to fail? but not ab_blah_h_i_blah_def

Read the article

How do i put an X on the right side of a <a> block?

- by acidzombie24

if i remove a.three display block this shows up fine. However what i want is the X to be at the right side. I tried float: right but it puts the x on the next line. How do i get the X on the same line? Here is some code.

Read the article

.NET prerequisites, 3.5sp1 but no 3.5? problem with 4.0?

- by acidzombie24

The title is confusing but the problem is not so much. I made a prerequisite with the default 3.5sp1 and windows installer 3.1. I ran it in my VM and to my surprise it asked me to install .NET. I checked the version and i have .NET 2 sp1, 3 sp1, 3.5, and two variants of 4.0 (client and extended beta). I looked in prerequisites and there doesnt seem to be an options for a non 3.5sp1. Is there some way i can select the non sp1? or compile so i dont need sp1? (it crashes upon startup but i am willing to bet i forgot a resource file)

Read the article

make objects and fields dynamically in javascript

- by acidzombie24

instead of using getParameterByName('Field', PostData) (PostData == $('form').serialize();) I would like to write PostData.Field, how can i do that with javascript?

Read the article

How do i check if something exist without using count(*) ... limit 1

- by acidzombie24

My code is SELECT COUNT(*) FROM name_list WHERE [name]='a' LIMIT 1 It appears there is no limit clause in SQL Server. So how do i say tell me if 'a' exist in name_list.name?

Read the article

Find the table(column) that a FK links to? MySql

- by acidzombie24

I am ok with mysql. when i use desc tablename i can see columns with MUL meaning it is a foreign key. Now my question is, how do i find out exactly what table and column that column is pointing to.

Read the article

Why does do this code do if(sz !=sz2) sz = sz2 !?!

- by acidzombie24

For the first time i created a linq to sql classes. I decided to look at the class and found this. What... why is it doing if(sz !=sz2) { sz = sz2; }. I dont understand. Why isnt the set generated as this._Property1 = value? private string _Property1; [Column(Storage="_Property1", CanBeNull=false)] public string Property1 { get { return this._Property1; } set { if ((this._Property1 != value)) { this._Property1 = value; } } }