|
Hello,
I am working on a decisonal project including multi-dimentional and spatial data , therefore i have to adopt a SOLAP architecture.
At this point, i have to load data derived from an ETL into a Data Warehouse on PostgreSQL/PostGis, and then include this data into a cube with dimentions and measures.
I'm not familiar to this new approach ,if someone has already manipulated datawarehouses and cubes on Potgre/PostGis, could give me some answers, i would be very thankful .
|
|
|
|
|
Hi,
I am new to rakuten. I have worked with ebay trading api and amazon mws. The rakuten is being a little different.
Can any one guide how could I get started, from where could I download api docs.
I really need the API docs for inventory, order and other.
Please give useful links.
Thank you, Rashid Sarwar
|
|
|
|
|
|
Googled many times but like ebay trading api and amazon mws webservices, rakuten has it but it still not public i guess b/c google/bing/yahoo didn't returned any link that allow the developer api documentation (Inventory api, order api etc..) to be downloaded....
|
|
|
|
|
|
Thanks Richard for your reply, I have seen this link and after several hours, I found these API are for Rakuten affiliate program only. As you can see in the introduction page image, there are API to search product, coupon/promotion management etc.
I am in need of the API that enable seller to list there items on rakuten( Rakuten Inventory API ), fetch Orders ( Order API ) and two other api.(Operation/Product API).
|
|
|
|
|
Go and talk to Rakuten. No one here can do anything about their policies.
|
|
|
|
|
Hi,
I am trying to open the crystal report in google chrome without any success. it is not giving any error at all, but screen remains blank..
It is working fine in IE 9..
Crystal version: 8.5
VS 2010
.NET framework 2.0
PLease let me know your suggestion on this..
Thanks,
SMA
|
|
|
|
|
try with
CrystalReportViewer1.PDFOneClickPrinting = false;
Krishna Murthy G
|
|
|
|
|
Could not connect to the database. Connector returned number: Could not connect to MySQL.
i m getting this error. can anybody help me?
|
|
|
|
|
Rituhardy wrote: Could not connect to MySQL.
The error seems pretty clear, doesn't it?
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
How can I copyright content of a website?
Let's say the website have blog, 2D-3D art, Photographs etc.
What are the best practices?
Will I have to go to government registration office or there are websites(one I can trust) which offer such services?
PS: I googled it for last 2-3 hours, the website which I ended up on were charging a lot to copyright 10 pages and other sites seemed like 15-20 years old.
|
|
|
|
|
Copyright is automatic, you don't have to do anything. If you've made it, the copyright is yours.
|
|
|
|
|
Not necessarily true. You need to understand copyright laws in the relevant country.
|
|
|
|
|
The question was how do you copyright an Indian website. My answer was that you don't have to do anything, copyright is automatic. There is nothing either incorrect nor ambiguous in my reply so I don't see what value there was in your response.
|
|
|
|
|
F-ES Sitecore wrote: copyright is automatic
Not necessarily, in most cases copyright needs to be asserted, it is not automatic.
|
|
|
|
|
So answer his question and tell him how he asserts his copyright then 
|
|
|
|
|
According to Wikipedia[^] the Indian Copyright Law automatically grants you the copyright for intellectual works that you're the author of. And it doesn't say anything about the need to register or even pay for it (it's the same here in Germany). I guess the website you have found there charging for "issuing copyrights" is a scam.
|
|
|
|
|
I have inherited a website and need to make some changes. It would be nice to know before i start, what files are used/called within each page on the website.
Apart from Google sitemap (which I cant get to work at home, so don't want to try at work), is there a way to get these results.
|
|
|
|
|
On the assumption that you are in a situation where no external tools will be available (for whatever reason) and there is nothing built in to the development tool you are using (or it is broke and wont be fixed) you only really have two choices:
1. Open every file and look for all the links
2. Do what I did and create a web app that will open all the files for you and search them for what you're looking for.
|
|
|
|
|
Following is the code for jqgrid -
html page-
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<script src="Scripts/JQGridReq/jquery-1.9.0.min.js"></script>
<link href="Scripts/JQGridReq/jquery-ui-1.9.2.custom.css" rel="stylesheet" />
<script src="Scripts/JQGridReq/jquery.jqGrid.js"></script>
<link href="Scripts/JQGridReq/ui.jqgrid.css" rel="stylesheet" />
<script src="Scripts/JQGridReq/grid.locale-en.js"></script>
<title>
jQuery("#jqGrid").jqGrid({
url: 'Handler1.ashx',
datatype: "json",
colNames: ['S_Course_Name', 'S_Course_Desc'],
colModel: [
{ name: 'S_Course_Name', index: 'S_Course_Name', width: 50, stype: 'text', editable: true },
{ name: 'S_Course_Desc', index: 'S_Course_Desc', width: 80, stype: 'text', sortable: true, editable: true }
],
rowNum: 10,
mtype: 'GET',
loadonce: true,
rowList: [10, 20, 30],
pager: '#Pager',
sortname: 'S_Course_Name',
viewrecords: true,
sortorder: 'desc',
caption: "Course Detail",
width: 500,
editurl: 'Handler1.ashx'
});
$('#jqGrid').jqGrid('navGrid', '#Pager',
{
edit: true,
add: false,
del: true,
search: true,
searchtext: "Search",
addtext: "Add",
edittext: "Edit",
deltext: "Delete"
},
{ //EDIT
// height: 300,
// width: 400,
// top: 50,
// left: 100,
// dataheight: 280,
closeOnEscape: true, //Closes the popup on pressing escape key
reloadAfterSubmit: true,
drag: true,
afterSubmit: function (response, postdata) {
if (response.responseText == "") {
$(this).jqGrid('setGridParam', { datatype: 'json' }).trigger('reloadGrid'); //Reloads the grid after edit
return [true, '']
}
else {
$(this).jqGrid('setGridParam', { datatype: 'json' }).trigger('reloadGrid'); //Reloads the grid after edit
return [false, response.responseText]//Captures and displays the response text on th Edit window
}
},
editData: {
EmpId: function () {
var sel_id = $('#jqGrid').jqGrid('getGridParam', 'selrow');
var value = $('#jqGrid').jqGrid('getCell', sel_id, 'S_Course_Name');
return value;
}
}
},
{
closeAfterAdd: true, //Closes the add window after add
afterSubmit: function (response, postdata) {
if (response.responseText == "") {
$(this).jqGrid('setGridParam', { datatype: 'json' }).trigger('reloadGrid')//Reloads the grid after Add
return [true, '']
}
else {
$(this).jqGrid('setGridParam', { datatype: 'json' }).trigger('reloadGrid')//Reloads the grid after Add
return [false, response.responseText]
}
}
},
{ //DELETE
closeOnEscape: true,
closeAfterDelete: true,
reloadAfterSubmit: true,
closeOnEscape: true,
drag: true,
afterSubmit: function (response, postdata) {
if (response.responseText == "") {
$("#jqGrid").trigger("reloadGrid", [{ current: true }]);
return [false, response.responseText]
}
else {
$(this).jqGrid('setGridParam', { datatype: 'json' }).trigger('reloadGrid');
return [true, response.responseText]
}
},
delData: {
EmpId: function () {
var sel_id = $('#jqGrid').jqGrid('getGridParam', 'selrow');
var value = $('#jqGrid').jqGrid('getCell', sel_id, 'S_Course_Name');
return value;
}
}
},
{//SEARCH
closeOnEscape: true
}
);
Handler1.ashx.cs-
public class Handler1 : IHttpHandler
{
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "application/json";
System.Collections.Specialized.NameValueCollection forms = context.Request.Form;
string strOperation = forms.Get("oper");
string strResponse = string.Empty;
if (strOperation == null)
{
DataTable dt = getCourseDetail();
var jsonSerializer = new JavaScriptSerializer();
context.Response.Write(jsonSerializer.Serialize(GetCourseDetailListFromDataTable(dt)));
}
else if (strOperation == "del")
{
//var query = Query.EQ("_id", forms.Get("EmpId").ToString());
//collectionEmployee.Remove(query);
//strResponse = "Employee record successfully removed";
//context.Response.Write(strResponse);
}
else
{
//string strOut = string.Empty;
//AddEdit(forms, collectionEmployee, out strOut);
//context.Response.Write(strOut);
}
}
public bool IsReusable
{
get
{
return false;
}
}
public static DataTable getCourseDetail()
{
string strConnection = System.Configuration.ConfigurationManager.ConnectionStrings["connectionstring"].ToString();
using (SqlConnection con = new SqlConnection(strConnection))
{
con.Open();
SqlCommand sqlcomm = new SqlCommand("SELECT TOP 5 S_Course_Name,S_Course_Desc FROM T_Course_Master", con);
//SqlCommand sqlcomm = new SqlCommand("SELECT TOP 10 I_Course_ID,I_CourseFamily_ID,S_Course_Code,S_Course_Name,S_Course_Desc FROM T_Course_Master", con);
SqlDataAdapter da = new SqlDataAdapter(sqlcomm);
DataTable table = new DataTable();
da.Fill(table);
//string data = GetJson(table);
//return data;
return table;
}
}
public static string GetJson(DataTable dt)
{
System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
List> rows = new List>();
Dictionary row;
foreach (DataRow dr in dt.Rows)
{
row = new Dictionary();
foreach (DataColumn col in dt.Columns)
{
row.Add(col.ColumnName, dr[col]);
}
rows.Add(row);
}
return serializer.Serialize(rows);
}
private List GetCourseDetailListFromDataTable(DataTable dt)
{
//List type object of the property class
List courseDetailClass = new List();
foreach (DataRow dr in dt.Rows)
{
//Object of the propery class
CourseDetail objCourseDetail = new CourseDetail();
//asign values
objCourseDetail.S_Course_Name = dr["S_Course_Name"].ToString();
objCourseDetail.S_Course_Desc = dr["S_Course_Desc"].ToString();
//add one row to the list
courseDetailClass.Add(objCourseDetail);
}
//return final list
return courseDetailClass;
}
method is getting called but data is not displayed in the grid.I m getting the json string also proper format. kindly some help on this.
|
|
|
|
|
Please edit this, remove all the code not relevant to the problem, and explain where the problem occurs. Also ensure all your code is within <pre></pre> tags so it is readable.
|
|
|
|
|
Hello Guys,
Any urgent help on this would be highly appreciated. am about to start working on a project which involves retrieving data from a remote API. its gonna be a web-project whereby a user already registered on a desktop application would be able to view their basic and other information on a website.
i understand i need to make API calls to be able to make the information saved on the desktop database available for the user on the web. but i dont how to start.
Please i need guidelines/tutorials/help to kick-off.
thanks in advance.
IsoftTech
|
|
|
|
|
The database for your website will not be saved on the desktop, instead it will be present on the server of your hosting provider (or if you're hosting it yourself, then on your own hosting system). Secondly, API calls, and the simple website has a difference. API calls are used, when you allow third-party applications to use your own framework and let them use the data of the user. Since it is your own application why do you need to create an API?
If you're going to create a desktop application for your website, then yes, you will need an API because now your desktop application would be as a third-party client accessing the data.
The sh*t I complain about
It's like there ain't a cloud in the sky and it's raining out - Eminem
~! Firewall !~
|
|
|
|
|
Hi,
I am trying to use OUT parameter with PDO and PHP to return an email address from my stored pocedure but getting this error:
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1414 OUT or INOUT argument 13 for routine hrms.sp_web_add_new_employee_leave is not a variable or NEW pseudo-variable in BEFORE trigger' in /home/jassimuser/mybluefile.com/submit_leave.php:37 Stack trace: #0 /home/jassimuser/mybluefile.com/submit_leave.php(37): PDOStatement->execute() #1 {main} thrown in /home/jassimuser/mybluefile.com/submit_leave.php on line 37
this is my code:
$mysql_query = $mysql_connection->prepare('CALL sp_web_add_new_employee_leave(:param_employee_id, :param_is_paid, :param_category, :param_payment, :param_date_from, :param_date_to, :param_total_days, :param_flight_entitlement, :param_flight_destination, :param_address_while_traveling, :param_leave_remarks, :param_created_user, :reporting_to_email)');
$mysql_query->bindParam(':param_employee_id', $_SESSION["employee_number"], PDO::PARAM_STR);
$mysql_query->bindParam(':param_is_paid', $leave_paid, PDO::PARAM_BOOL);
$mysql_query->bindParam(':param_category', $leave_category, PDO::PARAM_STR);
$mysql_query->bindParam(':param_payment', $leave_payment, PDO::PARAM_STR);
$mysql_query->bindParam(':param_date_from', $leave_from, PDO::PARAM_STR);
$mysql_query->bindParam(':param_date_to', $leave_to, PDO::PARAM_STR);
$mysql_query->bindParam(':param_total_days', $leave_days, PDO::PARAM_STR);
$mysql_query->bindParam(':param_flight_entitlement', $flight_entitlement, PDO::PARAM_STR);
$mysql_query->bindParam(':param_flight_destination', $flight_destination, PDO::PARAM_STR);
$mysql_query->bindParam(':param_address_while_traveling', $address_while_traveling, PDO::PARAM_STR);
$mysql_query->bindParam(':param_leave_remarks', $leave_comment, PDO::PARAM_STR);
$mysql_query->bindParam(':param_created_user', $_SESSION["employee_number"], PDO::PARAM_STR);
$mysql_query->bindParam(':reporting_to_email', $reporting_to_email, PDO::PARAM_STR|PDO::PARAM_INPUT_OUTPUT, 255);
$mysql_query->execute();
and line 37 is the ->execute()
How can I fix this please?
Technology News @ www.JassimRahma.com
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
