Hi, I've got an Access '07 database that imports data from text files. The problem is one of the fields that is taken in comes with a date value before a place value that I don't need. For example, the field comes in like so: 01012010DUBLIN whereas I need it to just display DUBLIN.
I'm stumped on this and any help would be greatly appreciated
Thanks.
Hi all,
Anybody know how can I add multiple email addresses in Outlook field "To" via C#?
foreach (var to in mailTo)
newMail.To += to + "; ";
When I try do it how I described this above I receive next kind of string:
[email protected]@[email protected]
I'm writing an iPhone web app, and I want to automatically focus a text field when the page is loaded, bringing up the keyboard. The usual Javascript:
input.focus();
doesn't seem to be working. Any ideas?
I would like to define a class that accept the pointer to it's parent class as an Argument, but would it be possible to somehow pass it without needing to pass it directly such as:
class Child
{
public:
Child(Parent* hiddenArg);
};
class Parent
{
public:
Child myChild;
};
I know this is weird, but I am making my own Signal/Slot implementation and Child would be a signal defined, but I would like to get the parent so I can use it's Event Dispatcher...
Hello,
I am making a small personal application regarding my trade of shares of various companies.
The actions can be selling shares of a company or buying. Therefore, the details to be saved in both cases would be:
Number of Shares
Average Price
Would it be better to use a separate tables for "buy" and "sell" or just use one table for "trade" and keep a field that demarcates "buy" from "sell"?
Hi there, just wondering if it is possible to hide/disable the quicktime logo when displaying .MOV video on my site?
Because the size of the video is large (3MB), I have included a rotating loading animation, however once the video player loads, the Quicktime logo hides the animation, which makes the user less likely in my opinion to wait for the movie to load?
Any advice would be great!
Cheers!
Decbrad
HI,
I am just trying to set a field value and disable it at the same time.
Can this be done in ext js? The docs are very weak on this subject.
something like this generates errors:
myForm.getForm().findField('start_date').setValue('').setDisabled(true);
I'm used to JQuery which does this sort of thing nicely but haven't had luck with Ext.
Thanks for any help.
As the title says I want to know what is, on an average a web developer should know in your opinion by the end of 1 year into the field in terms of concepts to learn, exposure to technologies, should he have mastered some area .. etc and so on.
Hoping to get a huge input from the community!
Thanks
(rest_branches) is the table of restaurants.
(phone_numbers) is another table which contains the restaurants phone_numbers, and it has a field called (branch_id) which references the restaurant id.
When I try:
SELECT *
FROM rest_branches
NATURAL JOIN phone_numbers
I only get the restaurants which have a phone_number.
What should I do to get all restaurants even if they don't have a phone number?
When using MySQL SELECT can you change the value of a returned field based on other fields?
For example, if I have this select:
SELECT city,state,country FROM table
Now if city is empty AND state is empty, I want the value of country to returned empty as well (whether country actually has a value or not).
Example table:
id | city | state | country
-----------------------------
1 | Here | There | MyCountry
2 | | | YourCountry
So with the above table, I want the results for id=1 to return Here,There,MyCountry but the results for id=2 should be empty,empty,empty
Thanks
I have a screen where the first field is an EditText, and it gains the focus at startup, also popups the numeric input type, which is very annoying.
How can I make sure that when the activity is started the focus is not gained, and/or the input panel is not raised?
So I have
<form id="formA">
<input id="uuid">
</form>
<form id="formB">
<input id="uuid">
</form>
is this ok to have 2 field names on different forms? I'm thinking access via javascript.
I'm doing a project I'm encountering a problem in my project.........
the problem is i would like to increase or decrease the quantity in my sql quantity field when i pass the issued or delivered quantity i.e....
initially the quantity in the quantity filed is 1 when i intake the product of a quantity 10 then automatically it should update the quantity as 10+1=11
so it must update as 11, if i remove a 1 quantity it should update as 0........
how to write a code in jsp..........
pls do help
Hi,
I want to sort document by relevancy i.e. First all docs having "Burj Khalifa" in title and then in summary field? and sort by publishdate as well. means latest documents must have high score.
criteria is like sort by score with publishdate
http://localhost:8080/solr/select?sort=score+desc,publishdate+desc&q=Burj Khalifa
Hi,
I have a report in report services 2005 that has two date fields. The problem is that if users run this for a large section of time it uses too much resources on our server.
It is possible to only allow the end user to enter the start date and then the end date be auto populated/derived from this field (for example they enter the 1st of a month and this automatically change the end date to the last of a month.)
So I have a model that has a field, which originally defaulted to not allow nulls. I want to change it to allow nulls, but syncdb doesn't make the change. Is it as simple as changing it in the database and reflecting it in the models.py file just for the next time its run against a new database?
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));
Hey Guys
I want to set two different look and fields on one frame.
I have two different panels in that.
i want to set two different look and field for both.
Can I do that?
And if yes then how?
Alright totally new to jeditable,
Say I have some <div>'s and <input type='hidden' /> items that are generated dynamically with PHP like this:
<?php while($row = $db->fetch_assoc($query)) : ?>
<input name="hiddenID" type="hidden" value="<?php echo $row['id'] ?>"
<div class="items"><?php echo $row['item']; ?></div>
<?php endwhile; ?>
Which gives me say...this:
1 //hidden value
item1
2 //hidden value
item2
3 //hidden value
item3
And a jeditable inline-edit script to go along with it:
hidden = $(".items").siblings("[name=hiddenID]").val(); //using a global var..don't know how to pass it into the editable function.
$(".items").editable('save.php', {
type : 'text',
tooltip : 'Double-Click to edit...',
onblur : 'submit',
event : 'dblclick',
submitdata : function() {
return {id : hidden }; //how do I pass mutiple hiddenID values??
}
});
I am wondering how to pass multiple values into the editable function. The way I've shown here only passes one value...the first row.
Hi,
I want to use django.contrib.comments in a blogging application and customize the way the form is displayed. My problem is that I can't get the fields to display although displaying the hidden fields works just fine. I had a look at the docs and compared it with the regular way of displaying forms but honestly I don't know why the following doesn't work out:
{% get_comment_form for comments_object as form %}
<form action="{% comment_form_target %}" method="POST">
[…]
{% for hidden in form.hidden_fields %}
{{ hidden }}
{% endfor %}
{% for field in form.fields %}
{{field}}
{% endfor %}
[…]
</form>
The output looks like this:
<form action="/comments/post/" method="POST">
<input type="hidden" name="content_type" value="flatpages.flatpage" id="id_content_type" />
<input type="hidden" name="object_pk" value="1" id="id_object_pk" />
<input type="hidden" name="timestamp" value="1269522506" id="id_timestamp" />
<input type="hidden" name="security_hash" value="ec4…0fd" id="id_security_hash" />
content_type
object_pk
timestamp
security_hash
name
email
url
comment
honeypot
[…]
</form>
</div>
Can you tell me what I'm doing wrong? Thanks in advance
I've been having a problem for the past month and can't seem to figure out what is wrong. Here's the setup and a little background.
Background:
I have a web-host who was running my website on Windows Server 2003 and SQL Server 2000. One of my webpages returned a result set from a stored procedure from the SQL server as xml. Below is the code:
Stored Procedure:
select top 10
1 as tag
, null as parent
, column1 as [item!1!column1!element]
, column2 as [item!1!column2!element]
from
table1
for XML EXPLICIT
ASP Page: index.asp
Call OpenConn
Set cmd = Server.CreateObject("ADODB.Command")
With cmd
.ActiveConnection = dbc
.CommandText = "name of proc"
.CommandType = adCmdStoredProc
.Parameters.Append .CreateParameter("@RetVal", adInteger, adParamReturnValue, 4)
.Parameters.Append .CreateParameter("@Level", adInteger, adParamInput, 4, Level)
End With
Set rsItems = Server.CreateObject("ADODB.Recordset")
With rsItems
.CursorLocation = adUseClient
.CursorType = adOpenStatic
.LockType = adLockBatchOptimistic
Set .Source = cmd
.Open
Set .ActiveConnection = Nothing
End With
If NOT rsItems.BOF AND NOT rsItems.EOF Then
OutputXMLQueryResults rsItems,"items"
End If
Set rsItems = Nothing
Set cmd = Nothing
Call CloseConn
Sub OpenConn()
strConn = "Provider=SQLOLEDB;Data Source=[hidden];User Id=[hidden];Password=[hidden];Initial Catalog=[hidden];"
Set dbc = Server.CreateObject("ADODB.Connection")
dbc.open strConn
End Sub
Sub CloseConn()
If IsObject(dbc) Then
If dbc.State = adStateOpen Then
dbc.Close
End If
Set dbc = Nothing
End If
End Sub
Sub OutputXMLQueryResults(RS,RootElementName)
Response.Clear
Response.ContentType = "text/xml"
Response.Codepage = 65001
Response.Charset = "utf-8"
Response.Write ""
Response.Write ""
While Not RS.EOF
Response.Write RS(0).Value
RS.MoveNext
WEnd
Response.Write ""
Response.End
End Sub
Present:
All was working great, until my host upgraded to Windows Server 2008 and SQL Server 2008. All of the sudden I was getting results like this:
From Browser:
From View Source:
However, I found that if I use a DSN connection strConn = "DSN=[my DSN Name];User Id=[hidden];Password=[hidden];Initial Catalog=[hidden];" it works perfectly fine!
My current host is not going to support DSN any longer, but that's out of scope for this issue. Someone told me to use an ADO.Stream object instead of a Recordset object, but I'm unsure how to implement that.
Question:
Has anyone run into this and found a way to fix it?
What about that ADO.Stream object, can someone help me with a sample that would fit my code?