My strings are of this kind: City (PR) from a Database, where PR stands for Province.
At the end I want two separate variables. City and PR.
I have to do this with C#. Any idea? Thanks.
I'm familiar with VB.NET, but VBA in excel has me stumped.
With my best attempt, I get a "Type mismatch" error:
Sub AddQuotes()
For Each x In Range("List").Cells
x.Text = "*" * " & x.text & " & "*"
Next
End Sub
In my database I calculate distance between nodes with:
SELECT DISTINCT
dest.name,
AsText(orig.location),
AsText(dest.location),
round((glength(linestringfromwkb(linestring((orig.location), (dest.location)))))) as distance
FROM
nodes orig,
nodes dest
WHERE
orig.name='GERP'
I would like to add "and
distance < dest.visibility" at the end, but am told that distance is an unknown column.
Any insight very much appreciated.
hey everybody
i'm trying to do somthing simple like this
SET i = 0;
WHILE (i <= 2230686) DO
INSERT INTO customers(check) VALUE(0);
SET i=i+1;
END WHILE;
in the phpmyadmin SQL query box
and it doesntwork and the mysql doesnt throw an understandable reason
any clues ?
Write an assembly program to input keystrokes from the PC’s keyboard and display the characters on the system monitor. Pressing any of the function keys F1-F10 should cause the program to end.
I have no idea how to write this code, and need some help por favor.
I've got the following code for a search form, but how would I add an ID or a class to the submit button?
<% form_tag '/wine/search/', :method => 'get' do %>
<%= label_tag "Search" %>
<%= text_field_tag :search_string, params[:search_string] %>
<%= submit_tag "Go" %>
<% end %>
Thanks
I am trying to remove all 's in my model with the following method :
def about_us_sans_spaces
self.about_us = replace(self.about_us, " ", " ")
end
Except! it turns out 'replace' isn't a method in rails. How would you remove the s?
Mind you, I have already tried sanitized, simple_format. My view looks like this right now:
= truncate(sanitize(simple_format(organization.about_us_sans_spaces), :tags => ''), 125).titleize
Can I somehow use a specific database given a specific condition? To clarify I will give a naive example:
CASE
WHEN @dbnum = 1 THEN USE Db1
ELSE USE DefaultDb
END
Hello people!
I'm a bit confused here.
I have a php array like this Array(2010,2009,2008 ...1992) and i want to create a loop to print a menu with a four year range counting down like this
2010-2006
2005-2001
2000-1996 etc..
How can i do this Everything i tried end up in an endless loop.
THnx in advance.
J.
I have been given a context schema for a database i need to make for my coursework but some of the attributes (column names) contain letters in brackets at the end of them such as:
*x_Number (Adm)
*x_Number (A)
*x_Number (P)
The problem is i have no idea what these letters mean!
Can anyone help?
I want to sort a vector using std::sort, but my sort method is a static method of a class, and I want to call std::sort outside it, but it seems to be trouble doing it this way.
On the class:
static int CompareIt(void *sol1, void *sol2) { ... }
std::sort call:
sort(distanceList.at(q).begin(),
distanceList.at(q).end(),
&DistanceNodeComparator::CompareIt);
Shouldn't it be possible to do this way?
I'm trying to make a stored procedure but it doesn't seem to be recognizing the parameters I've given it.
Procedure
create procedure test_pro(IN searchTable VARCHAR(55))
begin
select * from searchTable limit 10;
end //
Trying to execute
mysql> call test_pro('exampleTable');
ERROR 1146 (42S02): Table 'db.searchTable' doesn't exist
It isn't replacing the searchTable with the parameter that is passed in.
I have a data set in excel that I am trying to create a multiple line plot with on R. The data set contains 7 food groups and the calories consumed daily associated to the groups. As well, there is that set of data over 38 years (from 1970-2008) and I am attempting to use this data set to create a multiple line plot on R. I have tried for hours on end but can not seem to get R to recognize the variables within the data set.
In my project,"admin" can create text fields dynamically (using jsp +javascript) and enter can enter data in text fields for saving.in the back end i have to save them in database.
here the problem is
1)how we can create columns dynamically depending on the textfields admin is creating.
like if he is creating 5textfields then we should create 5 columns in database,if he going with 10 we should do 10 columns.
im doing this in mysql,jsp,struts,hibernate
Hey all, I'm running into an error using form_tag in Rails 2.3 and can't seem to wrap my head around it. What may I be doing wrong syntactically?
=form_tag :action => 'form', :name => "admin_form"
#images_actions_bar
=submit_tag "Approve", :class => "button", :name => "approve"
=submit_tag "Update", :class => "button", :name => "update"
I am seeing "syntax error, unexpected kENSURE, expecting $end"
So i want to open a URL and regex all the image urls from the page.
then i want to curl all of them and check what size they have. in the end i want to get the biggest one
I have some techniacal question, in this function:
string report() const {
if(list.begin() == list.end()){
throw "not good";
}
//do something
}
if I throw exception what is going on with the program? Will my function terminate or it will run further? if it terminates, what value will it return?
I have a game and i use function gotoAndStop in actionscript to play frame "moving" in my character game.And in this frame have movieclip. How can i detect when movieclip inside frame "moving" end ?
I try to create downloadable links to files which can be downloaded directly after clicking the link. I added "dl" instead of "www" and "?dl=1" in the end of the dropbox link (dropbox api: directly download files). The direct download works perfectly in the chrome browser but if I package the app which phonegap and click on the same link whithin the resulting app the file will not be downloaded. Is this not possible whithin the adroid browser or do I have to modify some android browser preferences?
can you please help me?, i can't explain my question clearly, I define x & y ,i can write plot(f(end,y)) ,but I want to know that how can i must type this code for f(first,y)?thank you!
Hi everyone,
In the nearest future I'll end university with master degree in computer science. I wanna work abrooad after that.
Could you please advise me sites, rss feeds where I can found info about open vacancies and job suggestions.
Many thanks.
You're welcome send me an email to ohoncharuk[at]hotmail.com
I'm working on a method to end the level, but to do so, I have to see that all of the enemy character have been killed.
If my enemies are CCSprites, how do I make a method that detects if all of them are dead? I'm tracking their health with an int called enemyHp. For example, this is an if statement I made to remove the enemy if (enemy.enemyHp <= 0) {
To recap - I want to make a method that detects when all enemies have been killed.
Thanks
ASP.NET is changing id, name values according to control's parent control name. That's why i am searching id with JQUERY as below.
// $ is looking to the end of "id" attribute of input elements
$("input[id$='cbAddToNews']")
Only one element is returning by jQuery. But when i want to change the attribute, I'm using this syntax:
$($("input[id$='cbAddToNews']")[0]).show()
Is there any way to do this without wrapping it with $(...[0]) ?