I have to create a view from more than one table in MS Sql Server database, but i am not able to get the correct syntax for the same. need help.
thanks.
Yesterday, I have been watching discussion here, about compilers and linkers. It was about C library function definitions. I have never thought of that, so it inspired me to do some searching, but I cannot find exactly what I want. I wonder, what is the smallest syntax you need to add into your source code to enable just printf() function. I mean the function declaration from stdio.h you need.
Looking at the information under the heading "Precision can be omitted or be any of:".
The example: printf("%.*s", 3, "abcdef"); works, outputting:abc (truncating the rest of the string.)
Now, I would like to have a string with multiple parameters formatted (truncated):
printf("%.*s", "%.*s", 3, 3, "abcdef", "xyz123");
but the program crashes.
What is the correct syntax?
Thank You.
I try to declare a variable in a code like this, but it's doesn't work. Can you tell me what's the problem?
ERROR: syntax error at or near "VARCHAR"
LINE 2: p_country VARCHAR;
DECLARE
p_country VARCHAR;
p_country : = '';
SELECT p_country;
Hi guys,
Let's assume:
$time = '2010-05-17 02:49:30' // (retrieved from MySQL TIMESTAMP field)
How do I do the following in PHP:
1) Check if it has been more than one week since this time has passed?
2) Assuming "false" on (1), find out how much more time until the one week mark, rounded to days and hours remaining.
I know this is pretty straightforward, but it uses a very specific syntax. Having never played with time calculations before, I'd appreciate some guidance.
Thanks!
Hi all,
Under Hudson, does somebody know how to specify a release tag name in a cvs checkout ?
At the moment, i only specify the CVSROOT and modules names to checkout my project in my workspace. I tried to add '-r TAG_NAME' for each module name, but it doesn't work.
I think that this functionality exist, so if someone as the right syntax/way to do it.. :)
Thanks in advance for your help.
Best regards.
I am able to backup mysql database via command line by executing the below :
C:\MySQL\MySQL Server
5.0\bin\mysqldump\" -uroot -ppassword sample \"D:/admindb/AAR12.sql\"
But there is no DROP and CREATE database queries in my .mysql file
What should i add in the syntax to get the create info to my generated .sql file ?
Hello,
I am trying to get the Treemap plugin (http://www.jquery.info/spip.php?article40) working with jQuery v1.3.x. The plugin works with jQuery v1.1 and v1.2 but for some reason it fails with the v1.3 base.
This is the browser error "Error: uncaught exception: Syntax error, unrecognized expression: "
Does anyone know changes occurred between JQuery v1.2 and v1.3 that could cause this?
Cheers,
D
I'm working in VS2005 and I need the C# syntax write to write collection values in an Excel sheet. I initialize the collection like this:
Reports oReports =new Reports();//oReports is a collection
Assuming that this collection has values, how would I write them to Excel?
Hi guys,
How to refactor the follow to put NOT is(":checked") syntax, instead put the codes being executed in the else block?
if ($(this).is(":checked")) {
// do nothing
}
else {
// To do here
}
Thanks for all the help.
I have table "PICKITEM"
PARTID QTY
A 1
A 3
B 11
C 8
D 5
D 3
I need a select statement that will return one line for like PARTIDs and add the qty field to together, yet also return the rest of the lines in the table as is
PARTID QTY
A 4
B 11
C 8
D 8
Probably a newb question, but I am new to SQL syntax and queries. Any help in getting me on the right path would be appreciated!
Hi
I am quite new to programming, i have a question please help me. ( this question is java question but i can't remember the syntax but what i write here is mostly it.)
A class Person speaks i am a person
A class Student speaks i am a student
Student extends from Person
Person p = new Student
then what is p speaking then?
When our server comes up we need to check a file to see how the server is configured.
We want to search for the following string inside our /etc/aws/hosts.conf file:
MYSQL_ROLE=master
Then, we want to test whether that string exists and use an if/else statement to run one of two options depending on whether the string exists or not.
What is the BASH syntax for the if statement?
if [ ????? ]; then
#do one thing
else
#do another thing
fi
Say you have a String literal with a lot of quotation marks inside it. You could escape them all, but it's a pain, and difficult to read.
In some languages, you can just do this:
foo = '"Hello, World"';
In Java, however, '' is used for chars, so you can't use it for Strings this way. Some languages have syntax to work around this. For example, in python, you can do this:
"""A pretty "convenient" string"""
Does Java have anything similar?
Team,
Can you please help me to understand why I m getting the following exception.
05-07 10:57:20.652: ERROR/AndroidRuntime(470): android.database.sqlite.SQLiteException: near "1": syntax error: , while compiling: SELECT Id,Name FROM act WHERE Id 1-IJUS-1
Thanks in advance,
I am in search of a programming language with the below characteristics:
it has existing, large and supportive/helpful community
it has consice syntax
it's fast
it can create standalone apps with no dependencies, totally portable and compatible with windows
I can easily set event listeners of almost anything
I can easily do automatically every action possible
has as extensive as possible ready-to-use commands list
works easily with winxp, win com, firefox, etc api
for example, I want to detect that I have clicked a specific button in a webpage in firefox or in a third-party app in windows:
I want to do this easily, not with writing 100 lines of code
Hi,
What is the correct jQuery syntax to only select certain file types?
e.g.
$("#fragment-1 a[SELECT ONLY ANCHOR TAGS WITH FILE TYPE OF MP3]").hide();
Thanks.
Hi, I'm trying to learn java from bottom up, and I got this great book to read http://www.amazon.com/o/ASIN/0071591060/ca0cc-20 . Now I found example in the book about declaring Enums inside a class but outside any methods so I gave it a shot :
Enum CoffeeSize { BIG, HUGE, OVERWHELMING };
In the book its spelled enum and I get this compile message Syntax error, insert ";" to complete BlockStatements
Are the Enums that important at all?I mean should I skip it or its possible that I will be using those some day?
Basically I want the books to be text book based, ie, author discusses the background,philosophy,syntax,semtantix for every language AND after every section there are questions what you learned so far and mini projects. Is there any books like this, I'm absolutely new to php/mysql/javascript and web development in general. Thanks in advance.
Hi,
I am writing the SPQuery for getting the data in contact list of sharepoint site.but how to write that?
Means I want to retrieve data as :
Name:aaa
Cell No: 13123131
Address : something address here..
so on...
of given LAst Name in search text box (build by me).
how to do that? Means what query i have to write? (Syntax please).
hi,
i have an string like this
string strdate =@"5/2/2006";
which is in a form of month/day/year
i need to display it in a form of like this 02-05-2006
how do i format the data like this
if the value is like this 12/28/2005
it should be displayed like this 28-12-2010
i know we should be splitting the data based on that we should do it.
i am not getting the syntax how to do it .
any help would be great
I was looking for a tool that can convert C code expressions for the form:
a = (A) ? B : C;
into the 'default' syntax with if/else statements:
if (A)
a = B
else
a = C
Does someone know a tool that's capable to do such a transformation?
I work with GCC 4.4.2 and create a preprocessed file with -E but do not want such structures in it.