Hi
I wana creat a boolean field in my oracle table but I seen there is no boolean or byte data type so,which one of the oracle datatype I must choose for a boolean value?
Hi,
I have two tables like of this structure
content (content_id, content_type, user_id, time, comment_count)
comments (comment_id, content_id, userid, comment, comment_time)
What I wold like to do is update the comments_count field with sum of comments i.e COUNT(content_id) fromthe comments table.
I am not able to figure out the right syntax
Thanks
I want to ensure that a certain text field does not contain a specific value. Is there any way for me to do this using CI's Form Validation class or do I have to write my own extension for it?
How do I get shortcodes to process properly in custom fields?
I've tried using the code below, but I cannot figure out where to place it ("button" is the name of the field):
<?php
if ( get_post_meta($post->ID, 'button', true) )
echo do_shortcode(get_post_meta($post->ID, 'button', $single = true));
?>
As of now, the shortcode is working in the sense that the button is displaying, but the shortcode text is displaying where the "buy now" button is supposed to be. See screenshot:
http://i.imgur.com/41vsr.png
Here's my function:
def check_form(request):
if request.method == 'POST':
form = UsersForm(request.POST)
if form.is_valid():
cd = form.cleaned_data
try:
newUser = form.save()
return HttpResponseRedirect('/testproject/summery/)
except Exception, ex:
# sys.stderr.write('Value error: %s\n' % str(ex)
return HttpResponse("Error %s" % str(ex))
else:
return render_to_response('index.html', {'form': form}, context_instance=RequestContext(request))
else:
form = CiviguardUsersForm()
return render_to_response('index.html',context_instance=RequestContext(request))
I want to pass each and every field in to a page call summery and display all the fields when user submits the form, so then users can view it before confirming the registration.
Thanks..
i am a computer science student and have just entered in my final year. i wanna do a project on something new and exciting in thefield of networking dbms os or ai.
i am proficient in java c, oracle and am improving my linux skills..
please give me some suggestions for hot topics..
After creating an EF4 model from a SQL Server database I noticed that all the relationships of my Users table were not imported into the model as associations. All the other relationships were imported fine.
My Users table has a PK userId which is a char(7) field and it is integrated into several other tables in the database as an FK but for some reason EF4 does not import these relationships as associations during the model generation process...
Does anyone have any ideas why this would be happening?
hey guys
i need to add a special text to all rows in my mysql table ,
how to add some text to the end of all rows' content in a table just for one field
i used this code :
UPDATE `blogs` SET `title`= `title`+ 'mytext';
but didnt work for me
I am trying to run the following SQL statement:
"SELECT *, (IIF([Field]=TRUE,'StringValue1','StringValue2') AS [NewField] FROM [Table1] ORDER BY [NewField] ASC"
But this gives me an error "Parameter NewField has no default value". How can I solve it?
I am using Microsoft Access (MDB) database using Jet Engine from Delphi 7.
Thank you!
I was just wondering how System.identityHashCode() is able to always yield the same result for a given object, even if the garbage collector moves it around in memory. Does every object have an additional invisible field storing its identity, independent from its current address?
For example I have long list of buttons: <input type=button name=clickbutton onclick='dosomething(this)'>
But instead of putting call to the same funcion in every button it would be more rational to add a single listening event that would wait for click of that button with this name. But again, there are maany this buttons so I need pass clicked object to a function. For example this function must update a textarea field that is adjacent (nextSibling) to this button.
I'm doing a web application for articles
Articles must be shown by month, with its published date stored as mm/yyyy
Now:
1- Should I use a DATE type field for storing?
2- Will jQuery UI datePicker be useful for showing mm/yyyy?
3- How could I sort by mm/yyyy?
I guess it will be more complicated if I store date normally and extract the day from date each time I want to do something, right?
Thanks,
I have some data that I needs to be searched for the comma character.
example entry I need to locate in thefield Citation in the Citations table:
This is sometimes true, Textual Reference
In the end, I'm looking to extract Textual Reference
Selecting the column with the data:
select Citation from Citations;
I want to create a list of records with checkboxes on the left side....kinda like the inbox in Gmail. Then if a user selects some or all of these checkboxes, then the selected record(s) can be updated (only one field will be updated BTW), possibly by clicking a button.
I'm stuck on how to do this though....ideas?
In each table have many number of rows with amount. Like this i have different numbers of amount in each table. Each tables field name is different. How can i get the total of all values in the four tables in a single query? Any way is there?
Hello,
I am trying to insert data into a mysql table from a csv file. I am using the infile sql command, but I am having trouble because the first column of the table is an id that is set as an auto increment field. what do I have to set my first column value to in order to get this to work, or can I do it at all?
Thanks
This question goes along with another one of my post that I already accepted
How do I get the "date number" in php
2010-08-24 20:00:00.000
I want to assign the current date number to a variable $current_date_num so I can use it in my query to compare what is already in the database.
$query ="SELECT * FROM Reservations WHERE [Room_ID] = '$field' AND [Meeting Start] > '$current_date_num' ORDER BY [Meeting Start] asc ";
Using JDO / DataNucleus / NeoDatis datastore
I added @Unique to a field of a persistable object, however I am allowed to create multiple objects which violate the unique constraint. The docs for DataNucleus/NeoDatis suggest that Unique fields are supported.
@PersistenceCapable
public class User {
@Persistent
@Unique
private String username;
//...
}
If I add multiple objects to the DB with the same username there's no problem doing so. :(
I have a model which is referenced to a table registries extending Zend_Db and some methods which bascially uses fetchAll() all the time.
What happens is: my table has a DATE field and I'd like it to output already formated when I call $row-reg_date. Is it possible by doing something in the model or do I have to manually format?
So, I'm working in eclipse were everything compiles and runs correctly. However, when compiling under ant for the build server, A large number of tests fail with a NoSuchMethodError saying:
class A implements B
interface B extends C
C requires method getSyncID() // standard getter for an int field.
A.java contains getSyncID()
A.class contains getSyncID()
and yet the Error is still thrown.
Does anyone know how the hell this could happen? how to fix it.
Actually I have a domain - domainone.com
I have created a subdomain cname of anoter domain as
abc.domaintwo.com - CNAME as - domainone.com
so that I can use the js and css files e.g domainone.com/js/jquery.js files as abc.domaintwo.com/js/jquery.js
SO Far everything is FINE, no issues at all.
Problem:
I have a custom 404 page for domainone.com and now when that abc.domaintwo.com goes 404 same page appears which i don't want. Any help is appreciated.
Htaccess of domainone.com:
ErrorDocument 404 /404/
All i want is to have different 404 for both.....
Notes: Don't have access to shell for symlinks or alias as I am on shared hosting.
I need to fire certain server side validation for a page when the user is trying move from that page to another..
Even though he is not clicking on any buttons these server side validations have to be fired when he is moving out of this page..
Could you please help me how to handle this.. Required field validations will not happen as the user is entering the page and leaving the page without doing any action in the page..
Hello!
There's photologue application, simple photo gallery for django, implementing Photo and Gallery objects.
Gallery object has ManyToMany field, which references Photo objects.
I need to be able to get list of all Photos for a given Gallery. Is it possible to add Gallery filter to Photo's admin page?
If it's possible, how to do it best?
I have
EMPLOYEE-ID,DATE,IsPresent
I want to calculate longest streak for a employee presence.The Present bit will be false for days he didnt come..So I want to calculate the longest number of days he came to office for consecutive dates..I have the Date column field is unique...So I tried this way -
Select Id,Count(*) from Employee where IsPresent=1
But the above doesnt work...Can anyone guide me towards how I can calculate streak for this?....I am sure people have come across this...I tried searching online but...didnt understand it well...please help me out..