Hi , I want to create a class in lib folder , from that class want to create mysql view . such as in mysql CREATE VIEW rocket_current_activities AS SELECT rocket_activities.status AS status from rocket_activities.... This can be do in mysql but how to do from rails. I dont want in migration file. Please help!!!

Member Avatar
Member Avatar
+0 forum 3

I'm making an app that allows users to add speech bubbles on runtime and place them any where on the screen. First I was using a different approach and I failed. So I found a tutorial that had a simple drag and drop way. I am able to create a textview with background set as my 9patch image with the text that the user wants. This is my code public class Show extends Activity { LinearLayout rel; private View selected_item = null; private int offset_x = 0; private int offset_y = 0; String message; @Override protected void onCreate(Bundle savedInstanceState) { …

Member Avatar
+0 forum 0

hi guys, im not that new to the zend framework. i just started a new project with zend framework 1.12 and cant figure out why the framework would display output 3 time? so for example in the index.phtml view script, whether i put hello, or <?= 'hello';?> i always get output: hellohellohello. always 3times unless i put an exit right after the output, then it would only output once. this is completely unsual and does not make any sense to me what so ever. please let me know if anyone of you have any ideas. thanks...

Member Avatar
Member Avatar
+0 forum 1

I came up with this query now when i tried to create a view it failed to create SELECT aDate FROM ( SELECT @maxDate - INTERVAL (a.a+(10*b.a)+(100*c.a)+(1000*d.a)) DAY aDate FROM (SELECT 0 AS a UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9) a, (SELECT 0 AS a UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION …

Member Avatar
Member Avatar
+0 forum 6

Hi all... gud evening.......... I want to share one link to tumblr page. How to do? And also i want to calculte the number of likes counts, share counts, post counts, follow counts.. Kindly send me examples or any reference website. Thank you.

Member Avatar
Member Avatar
+0 forum 1

I realized something just now. A few months ago. I post a question regarding about stats and I think **Dani** mention she has no intention of doing this at all. Even the Gravatar was done within a few minutes last night. What is the benefit of having this now? For **10** years nothing even come close to this design. I'm just curious why the change of heart? I feel changing for you takes time but it seems you handle it very well. I attached a image of what **Dani** did: ![daniwebty](/attachments/small/3/daniwebty.png "align-left")

Member Avatar
Member Avatar
+0 forum 9

Hey guys, I am setting my viewmodel as datacontext in my xaml but I override it to my view to make few functions work however to achieve the visibility on some grids and I have a property in my VM can I override my datacontext back to my VM? If so how? I have a stackpanel that has datacontext overriden as my grid and within that stackpanel I need to change the datacontext for a button. Any help will be appreciated thanks

Member Avatar
Member Avatar
+0 forum 1

Hello, I'm using MySQL for a database containing 1 table with 10 columns. The point is to get a view of a few columns and use it in a web application So, I need 2 columns from this table - Pad(varchar) and Sequence(integer), then I create 8 views like this: [CODE] CREATE VIEW vv1 AS SELECT pad, sequence as lift1 FROM management WHERE LEFT(activity_id, 9) = 'MOUN.SECB'; create view vv2 as SELECT sequence as lift2 from management where left(activity_id, 9) = 'MOUN.SECT'; [/CODE] And so forth until vv8 which represents Task8. I end up with 8 views - lift1, lift2, …

Member Avatar
Member Avatar
-1 forum 5

Hi All, I have a SQL database which has many views and needs indexing. Unfortunately SQL server does not let me add indexes with schema bind error. There are app. 50 views created on the database and I don't want to delete and re-create them one by one. Is there an easier way to convert regular views to schemabind views to save time and effort? Many thanks telmessos

Member Avatar
Member Avatar
+0 forum 1

Hi All experts, I am facing problem with mysql view. I have migrated my database from oracle to mysql qith views, View on Mysql is created , but when i try to execute query it takes a long timw , some times it time qout server connection, Any body help me urgent plz. Keep in mind , all tables used in view are in database with data. here is My View [code] CREATE OR REPLACE VIEW `ictm_proj_user` (COMPANY_ID, PROJECT_ID, PROJ_ID, USER_ID) AS SELECT ict.company_id,prj.project_id,usr.proj_id, usr.user_id FROM ictm_project ict, ictm_project_user usr, ictm_project_detail prj WHERE ((usr.proj_id = prj.proj_id) AND (prj.project_id = ict.project_id) …

Member Avatar
Member Avatar
+0 forum 3

hi all, I guess my first thread here, and I am on with some questions too. Actually I am doing an article on importance of writing among IT professionals. So what better place than Daniweb to ask it. In order to form such an article I will need your views. Answer the following questions in order. And guide me if this isn't the best place to ask. Q1. What is your name and job profile (like Database Administrator, Programmer etc.)? Q2. How often do you write each day a week? Q3. How important is what you write to the successful …

Member Avatar
Member Avatar
+0 forum 6

The End.