hi! I want to create a procedure which execute given below query using dynamic sql. i am getting some error i.e. "Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'GROUP'."
my query which i want to run by procedure is:

;with cte as (select *,t.opening+Recieve+returnback-Issue … Topic by abhinav_8 in Software Development

database

The above given query i am using to generate a ledger report. I am getting right output from this query but i want to pass a table name from a string in this query, so I want to use dynamic SQL query. I am doing any syntax mistake using dynamic … Reply by abhinav_8

Hello

I am trying to create chaper links for my Vimeo videos on my site. I have managed to get a script working with direct links but cannot get it to work with a drop-down menu.

Here is my code:



<script src="http://ajax.googleapis.com/ajax/libs/jquery/2.2.4/jquery.js"></script>
<script src="https://f.vimeocdn.com/js/froogaloop2.min.js"></script>

<script>
$(window).load(function(){

var link_1_track = 26; … Topic by Robert_79 in Software Development

java

I have just noticed that the drop-down menu actually works in Firefox and also IE.

The issue seems to be with Chrome and also Safari (on iPhone/iPad)

Also I only want the drop-down menu to work. The hard links are there just to show that the chapters work. Afterwards I … Reply by Robert_79

Hi guys,
I need to do guest blogging and get back links for the same. since I heard guet posting or guest blogging is the best way to get backlinks these days.
But I don't know how to do so, can anyone please help? Topic by SN Technologies in Digital Marketing

google links ranking seo traffic

Guest posting can be a great option --- just make sure that you're contacting high quality, trustworthy websites with good DAs. You'll want to contact the editor and ask for their pricing rates and guidelines if they're not posted on the site already. Make sure you use relevant anchor texts … Reply by Michelle_12

I have a table called `volume_issue` that looks like this:



+----+-------------------------------------------------------+-----------------+-----------+---------------------+
| id | url | journal_title | issn | volume_issue |
+----+-------------------------------------------------------+-----------------+-----------+---------------------+
| 1 | https://www.ajol.info/index.php/asan/issue/view/17048 | Africa Sanguine | 1560-8646 | Vol 19, No 2 (2018) |
| 2 | https://www.ajol.info/index.php/asan/issue/view/16693 | Africa Sanguine | 1560-8646 | Vol … Topic by Gurjit_2 in Web Development

php

Thanks @rbjolly and @alan.davies. I am studying your suggestions and will get back here soon Reply by Gurjit_2

Hello

I am trying to create chaper links for my Vimeo videos on my site. I have managed to get a script working with direct links but cannot get it to work with a drop-down menu.

Here is my code:



<script src="http://ajax.googleapis.com/ajax/libs/jquery/2.2.4/jquery.js"></script>
<script src="https://f.vimeocdn.com/js/froogaloop2.min.js"></script>

<script>
$(window).load(function(){

var link_1_track = 26; … Topic by Robert_79 in Software Development

java

So almost everyone who's been here for quite some time will relate to this nostalgic feeling like this once was an active populated city and now it's nearly a ghost town, it's somehow depressing for me to see old ruins and abandoned places and things, not sure about you.

Anyway, … Topic by 3bdelhakeem in DaniWeb Community Feedback

daniweb-contest daniweb.com

Hey Dani. Not been on here for a while. Not because of anything to do with the site but life in general. Look forward to seeing the new site.

I wondered if there was a mobile app for the site? Reply by Andy_12

I interpolated temperature data observed on an urban area formed by 12 locations. Now i would like to remove all interpolated values that are outside the shapefile layer. How can i do it?

The shapefile links:

https://www.dropbox.com/s/0u76k3yegvr09sx/LimiteAMG.shp?dl=0

https://www.dropbox.com/s/yxsmm3v2ey3ngsp/LimiteAMG.cpg?dl=0

https://www.dropbox.com/s/yx05n31dfkggbb6/LimiteAMG.dbf?dl=0

https://www.dropbox.com/s/a6nk0xczgjeen2d/LimiteAMG.prj?dl=0

https://www.dropbox.com/s/royw7s51n2f0a6x/LimiteAMG.qpj?dl=0

https://www.dropbox.com/s/7k44dcl1k5891qc/LimiteAMG.shx?dl=0




The Data is:

Lat Lon T
0 20.8208 … Topic by glez_b in Software Development

gis matplotlib python shapes

How do you determine boundaries? I would suggest that you post some stripped down code, i.e without all of the plotting, etc. as that has nothing to do with "outside boundaries". Include also an explanation of how you would like to determine what is outside the boundaries. Reply by woooee

$query = "SELECT SUM(amount) FROM income_daily";
$sum = mysqli_fetch_row(mysqli_query($con, $query));
echo "Total Income : ". "¢" .$sum[0];

echo '<br>';
echo '-';
echo '<br>';

$query1 = "SELECT SUM(amount) FROM expenses_daily";
$sum = mysqli_fetch_row(mysqli_query($con, $query));
echo "Total Expenses : ". "¢" .$sum[0]; Topic by David_139 in Web Development

php

There are a few ways you could do this, depending on your needs. Here's a botch-job, but gives a single value based on a date:


SELECT (SELECT COALESCE(SUM(di.`amount`),0) FROM `daily_income` di WHERE di.`income_date` = ?) - (SELECT COALESCE(SUM(de.`amount`),0) FROM `daily_expenses` de WHERE de.`expenses_date` = ?) AS daily_difference

The question marks … Reply by alan.davies

hi everyone

i have not been here in a while. so here I am practicing building a forensic managment java application but the thing, i am trying to connect to the database, so, like i am importing the codes that would help connect to the database, like I mean the … Topic by divinity02 in Software Development

java

There's a clue you are not using Java as you wrote 2.5.2. There is no such version noted at https://en.wikipedia.org/wiki/Java_version_history

There are 1.x versions then we see a jump to 5.x versions and up.

Can you share where you obtained this version? Link please. Reply by rproffitt

I need some help to add few audio effects to website.

I found some examples like following,

audioOn: true

audio.muted = false

setAudioOn true

ref: "audio",
attrs: {
"id": "projects-audio"
}
}, [_c('source', {
attrs: {
"src": "/audio/click.mp3"
}

playAudio: function playAudio() {
this.$parent.$refs.clickAudio.volume = 0.8;
this.$parent.$refs.clickAudio.play();
},


I need … Topic by tun712 in Web Development

ajax javascript jquery

I'm still working on little issues. Following is updated code.

**index.php**

<p>Sound Link:- http://soundbible.com/mp3/cartoon-birds-2_daniel-simion.mp3</p>
<a href="#" class="birds">Cartoon Birds</a>
<br />
<h4><a href="#" class="ToggleMute">Toggle Mute</a></h4>

**main.js**

jQuery(document).ready(function($) {
"use strict";

var audioOn = true;

function toggleSound() {
if (audioOn) {
audioOn = false;
} else {
audioOn = true;
}
} … Reply by tun712

hi everyone

i have not been here in a while. so here I am practicing building a forensic managment java application but the thing, i am trying to connect to the database, so, like i am importing the codes that would help connect to the database, like I mean the … Topic by divinity02 in Software Development

java

Java micro edition is a cut-down version of Java to run on very small computers. If you are writing for a pc or a server then it’s not relevant. I only mentioned it because it would explain your problem. But no.
Now all I can guess is that it’s a … Reply by JamesCherrill

$query = "SELECT SUM(amount) FROM income_daily";
$sum = mysqli_fetch_row(mysqli_query($con, $query));
echo "Total Income : ". "¢" .$sum[0];

echo '<br>';
echo '-';
echo '<br>';

$query1 = "SELECT SUM(amount) FROM expenses_daily";
$sum = mysqli_fetch_row(mysqli_query($con, $query));
echo "Total Expenses : ". "¢" .$sum[0]; First Post in Topic by David_139 in Web Development

php

$query = "SELECT SUM(amount) FROM income_daily";
$sum = mysqli_fetch_row(mysqli_query($con, $query));
echo "Total Income : ". "¢" .$sum[0];

echo '<br>';
echo '-';
echo '<br>';

$query1 = "SELECT SUM(amount) FROM expenses_daily";
$sum = mysqli_fetch_row(mysqli_query($con, $query));
echo "Total Expenses : ". "¢" .$sum[0]; Topic by David_139 in Web Development

php

hi everyone

i have not been here in a while. so here I am practicing building a forensic managment java application but the thing, i am trying to connect to the database, so, like i am importing the codes that would help connect to the database, like I mean the … Topic by divinity02 in Software Development

java

hi james

if I download the javame edition, seeing that it is the upgrade to the one that I hve which is 2.5.2 which is the old versio, will it over ride that one that I have at present or will it be just be separate Reply by divinity02

hi everyone

i have not been here in a while. so here I am practicing building a forensic managment java application but the thing, i am trying to connect to the database, so, like i am importing the codes that would help connect to the database, like I mean the … Topic by divinity02 in Software Development

java

javame is what" is that another software where u can write programs or is it an upgraded version Reply by divinity02

hi everyone

i have not been here in a while. so here I am practicing building a forensic managment java application but the thing, i am trying to connect to the database, so, like i am importing the codes that would help connect to the database, like I mean the … Topic by divinity02 in Software Development

java

yes i have other program that I am currently working on and it doesnt have that problem, Reply by divinity02

hi everyone

i have not been here in a while. so here I am practicing building a forensic managment java application but the thing, i am trying to connect to the database, so, like i am importing the codes that would help connect to the database, like I mean the … Topic by divinity02 in Software Development

java

I was referring to JavaME - the micro edition of a Java, because I don’t think that has sql as standard. Apart from that all I can guess is some kind of configuration or installation problem. Do you have any other code in the same IDE that successfully imports any … Reply by JamesCherrill

hi everyone

i have not been here in a while. so here I am practicing building a forensic managment java application but the thing, i am trying to connect to the database, so, like i am importing the codes that would help connect to the database, like I mean the … Topic by divinity02 in Software Development

java

hi james

yes it is java am using, i have not starting using any other languages, or have learned any other languages as yet Reply by divinity02

hi everyone

i have not been here in a while. so here I am practicing building a forensic managment java application but the thing, i am trying to connect to the database, so, like i am importing the codes that would help connect to the database, like I mean the … Topic by divinity02 in Software Development

java

Puzzling! Are you using Java ME? Reply by JamesCherrill

hi everyone

i have not been here in a while. so here I am practicing building a forensic managment java application but the thing, i am trying to connect to the database, so, like i am importing the codes that would help connect to the database, like I mean the … Topic by divinity02 in Software Development

java

hey jc

i have upload the file for you to see where the error, is it called screenshot, all the errors are there and the error message says, it cannot find symbol the red lines underneath
Connection
ResultSet
PreparedStatement

that is the error, Reply by divinity02

I need some help to add few audio effects to website.

I found some examples like following,

audioOn: true

audio.muted = false

setAudioOn true

ref: "audio",
attrs: {
"id": "projects-audio"
}
}, [_c('source', {
attrs: {
"src": "/audio/click.mp3"
}

playAudio: function playAudio() {
this.$parent.$refs.clickAudio.volume = 0.8;
this.$parent.$refs.clickAudio.play();
},


I need … Topic by tun712 in Web Development

ajax javascript jquery

**Please help** Reply by tun712

hi everyone

i have not been here in a while. so here I am practicing building a forensic managment java application but the thing, i am trying to connect to the database, so, like i am importing the codes that would help connect to the database, like I mean the … Topic by divinity02 in Software Development

java

Where is the full error message? You know, the one that says which line number and which symbol??. Reply by JamesCherrill

I pre booked this phone and I am really excited about it, so can anybody suggest me is it worth it or not? Topic by HAMMAD_5 in Mobile and Wearables

android

So almost everyone who's been here for quite some time will relate to this nostalgic feeling like this once was an active populated city and now it's nearly a ghost town, it's somehow depressing for me to see old ruins and abandoned places and things, not sure about you.

Anyway, … Topic by 3bdelhakeem in DaniWeb Community Feedback

daniweb-contest daniweb.com

Hi there,

Thank you for your suggestions. It's hard for me to comment right now because I'm just so busy working so hard behind the scenes to upgrade the site to the new version. Hopefully you guys won't be disappointed when we launch (hopefully next month).

At that time, I'll … Reply by Dani

hi everyone

i have not been here in a while. so here I am practicing building a forensic managment java application but the thing, i am trying to connect to the database, so, like i am importing the codes that would help connect to the database, like I mean the … Topic by divinity02 in Software Development

java

hi james and rproffitt

here is the code


package forensic;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.swing.*;


/**
*
* @author luana taylor
*/
public class forensic_login extends javax.swing.JFrame {
Connection conn = null;
PreparedStatement pst = null;
ResultSet rs = null;

/**


the errors that I … Reply by divinity02

hi everyone

i have not been here in a while. so here I am practicing building a forensic managment java application but the thing, i am trying to connect to the database, so, like i am importing the codes that would help connect to the database, like I mean the … Topic by divinity02 in Software Development

java

Hi divinity02
You know me. We have worked together many times. But this time I agree with the previous posts. You haven’t given anywhere near enough information that we could possibly use to help you. Please try again with actual code, error message etc.

JC Reply by JamesCherrill

Hey, I'm looking to learn more back-end managing as I'm primarily a front-ender. So, maybe you could suggest some learning resources? Idealy free, but I know it's not always possible. I've already completed a couple of courses on the internet mainly https://www.bitdegree.org/course/sql-course and been on YouTube, Google (that's how I … Topic by Douglas_10 in Web Development

mysql

I should add that a good Mysql GUI (not phpmysql!) is a great tool to have as you can test and practice to your heart's content. I like SQLyog - I believe they still have a community version. There are loads of other ones available for your operating system though. … Reply by alan.davies

hi everyone

i have not been here in a while. so here I am practicing building a forensic managment java application but the thing, i am trying to connect to the database, so, like i am importing the codes that would help connect to the database, like I mean the … Topic by divinity02 in Software Development

java

@d, it's incredibly hard to troubleshoot without seeing the code and the error messages from that line of code. Rather than me write at length how to make a better post, I supplied a link to where pritaeas wrote about everything that is needed to get working on a problem. … Reply by rproffitt

Hey, I'm looking to learn more back-end managing as I'm primarily a front-ender. So, maybe you could suggest some learning resources? Idealy free, but I know it's not always possible. I've already completed a couple of courses on the internet mainly https://www.bitdegree.org/course/sql-course and been on YouTube, Google (that's how I … Topic by Douglas_10 in Web Development

mysql

Although mysql is language agnostic what are you using php?

The official mysql manual is pretty good but not that user friendly. There are some examples on w3schools that are OK https://www.w3schools.com/sql/default.asp Reply by alan.davies

hi everyone

i have not been here in a while. so here I am practicing building a forensic managment java application but the thing, i am trying to connect to the database, so, like i am importing the codes that would help connect to the database, like I mean the … Topic by divinity02 in Software Development

java

rproffitt
what is wrong with my question, i have seen question asked worst than mine and it was answered and yes I did check to see if there was any questions that may be pertaining to mine but I didnt see any hence the reason for asking if my question … Reply by divinity02