How to the excel data please help me In the original excel sheet data show column wise. But now I want to same change to data showing structure and re arrange the data structure. I can't upload the excel sheet that for i attached the IMG please help me https://ibb.co/jdzC4m I mean my original data is column "A" to "K" and row 1 is heading row 2 to 5 is data I want set data as per column "B" to "F" and row 7 is heading and row 8 to 22 is data I want do it using formula I …

Member Avatar
Member Avatar
+0 forum 3

Hi guys, I just got into a little problem.I just deployed an application with backend db access.It works fine on major OSs being used like win7 and XP. But some functionality related to the database doesn't work properly when deployed on win8. I used a code to delete temp table if it exists.This feature completely works on the other OSs.But i don't know why the code is not working on the later OS. Any thought to solve the problem? Public Sub DroptempProject() On Error GoTo ErrorHandler Dim str As String str = "DROP TABLE ptempTable" ExecSQL(str) 'Exit Sub ErrorHandler: If …

Member Avatar
Member Avatar
+0 forum 5

Hi everyone, I have database which has data of past 2 years. I want to get that data for current financial year. [COLOR="Green"](Here financial year is 1st april to 31st of March)[/COLOR] This query returns data for current calender year i.e. [Jan-to-Dec] [COde=sql] SELECT DATENAME(MONTH, DATE) AS MonthName, SUM(NetAMOUNT) AS dsfd from SALESMASTER GROUP BY DATEPART(MONTH, DATE), DATENAME(MONTH, DATE) ORDER BY DATEPART(MONTH, DATE)[/COde] I want to see the same data in the form of financial year i.e. [April-to-March] just take care financial year involves 9 months of previous year and 3 months of current year. please reply..

Member Avatar
Member Avatar
+0 forum 4

I want to associate a REST API end point to two urls, "manager" and "manager/". So I added two path entries in the urlpatterns with these urls. But it seems something that can be handled with some kind of configuration. Is there such a configuration with django? thanks

Member Avatar
Member Avatar
+0 forum 1

Hi, I have the following XML file (it is a TCX file) <?xml version="1.0"?> <TrainingCenterDatabase xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://www.garmin.com/xmlschemas/TrainingCenterDatabase/v2"> <Activities> <Activity Sport="Biking"> <Id>..</Id> <Lap StartTime=".."> <TotalTimeSeconds>..</TotalTimeSeconds> <DistanceMeters>..</DistanceMeters> <MaximumSpeed>..</MaximumSpeed> <Calories>..</Calories> <Intensity>Active</Intensity> <Cadence>75</Cadence> <TriggerMethod>Manual</TriggerMethod> <Track> <Trackpoint> <Time>2017-12-16T12:43:10Z</Time> <DistanceMeters>0</DistanceMeters> <Cadence>1</Cadence> <Extensions> <TPX xmlns="http://www.garmin.com/xmlschemas/ActivityExtension/v2"> <Speed>0</Speed> <Watts>1</Watts> <Slope>-1.49</Slope> </TPX> </Extensions> </Trackpoint> . . . . I want to add the following to each <Trackpoint> tag: <AltitudeMeters>..</AltitudeMeters> <Position> <LatitudeDegrees>..</LatitudeDegrees> <LongitudeDegrees>..</LongitudeDegrees> </Position> Using the attached xsl sheet. When I run the file with PHP only the identity template is being invoked and not the second template. I think it may be due to namespace but have no idea …

Member Avatar
Member Avatar
+0 forum 1

Hello i want to access my SQL database with a Android Studio Emulator. I use `ionic cordova run android` and the project/app begins correctly but when i put the credentials (username and password) it stucks there. It works fine when i use `ionic serve` Any hint?

Member Avatar
+0 forum 0

Hello I am needing some assistance with setting up a function to check if a user is logged in or not with Passport.js using the local and slack strategy. I have a localstrategy which works fine but I also want to implement a sign in with slack as well. I have added my app to slack and set the redirect URL. Everything is working fine however regardless if a user signs in or not they can still access the main page from the URL. Example I have my login page 123.456.7.891:3000/login and when a user logs in through the local …

Member Avatar
+0 forum 0

I work in VB.net only. I cal read an entire file in one statement, sort it with another statement and write it bacl in another. Three statements to sort a csv file! This is aswome, but I wan to know how to sort the file on different columns. Here is my code, Dim codes(), Saveline As String ' 'Read/Write file data ' codes = File.ReadAllLines(FileName) ' 'Save sorted copy ' Saveline = codes(0) codes(0) = "" Array.Sort(codes) codes(0) = Saveline ' File.WriteAllLines(FileName, codes) What I want to do is use array.sort(codes,2) where the 2 is column 2 or any other …

Member Avatar
Member Avatar
+0 forum 3

This may sound confusing but I have a textbox which is a cell number textbox and I want when the max length of 10 has been reached then fire the php code which is inside the same html page as form and this php code will then get the value or data which has been keyed in to this text box. I've tried Javascript and the problem I'm having with javasacript is to now display this data so that why I've deiced to change to php because I know how to display the php session data within the textbox with …

Member Avatar
Member Avatar
+0 forum 20

Question, I have a `$each(array, function());` and within that statement, i have a` for` loop , Is it safe to be doing this? and could this be the reason that i am getting the same values multiple times returned even though the object array length is 8, i am getting basically doubled up results, sometimes its more. if you need to see my code, i can post it.

Member Avatar
Member Avatar
+0 forum 6

Inside of a class template having parameter `typename T` the compiler generates an error concerning 2 functions. `T` does not seem to be recongnized as the template class parameter it was declared as. template <class Return, class ...Args> void executeOnAll(Return (T::*function) (Args &&...), Args &&...args) { for(T &s : *this) (s.*function) (std::forward<Args>(args)...); } template <class Return, class ...Args> void executeOnAll(Return (T::*function) (Args &&...) const, Args &&...args) const { for(const T &s : *this) (s.*function) (std::forward<Args>(args)...); } As my array class has many other member functions, this error is specific to the 2 above. Error Output: c:\appprojects\js3d\source\jscommon\msvc\../jarray.h(244) : error C2825: 'T': …

Member Avatar
Member Avatar
+0 forum 2

[CODE] #include <stdio.h> #include <stdlib.h> typedef struct filedata { char data[100]; }data_t; data_t * fname=NULL; //IS AN ARRAY OF the structure filedata REQUIRED HERE void quit() { printf("\nPress enter to exit"); fflush(stdin); getchar(); } int main() { char ch; fname=(data_t *)malloc(sizeof(data_t)); FILE *fptr=NULL; atexit(quit); printf("Please enter the file name to read : "); fflush(stdin); scanf("%s",fname->data); fptr=fopen(fname->data,"rb"); if(fptr == NULL) { perror("Could not open the file "); return; } printf("\n+++++++++++++++++++++++++++++++++++++++++++++++++++++++++\n"); printf("Contents of the file %s are : ",fname->data); [B] while(fread(&fname, sizeof(data_t), 1,fptr) == 1) { // what do I put here? }[/B] fclose(fptr); return 0; } [/CODE] I want to read …

Member Avatar
Member Avatar
+0 forum 11

What are Similarities and differences, written in concise form? Thanks!

Member Avatar
Member Avatar
+0 forum 9

Hi, I got a project to load a pdf into a picturebox in vb6. How do I handle that? Is there anyone who sell that .ocx? is there anyway to do it? Thanks

Member Avatar
Member Avatar
+0 forum 12

I have a pascal script, which basically pushes information into a 3rd party system. I have an excel macro written, which saves raw data into a CSV file, which I would like my script to read, and take the data (each row is 1 record) and put each portion in a specific field (setValue) I cannot seem to find a way to do this (I am able to do this in a single field) but am unsure how to have 444,555,666 work so 444 goes here, 555 goes here, etc. into my 3rd party program. The VBA (works great no …

Member Avatar
Member Avatar
+0 forum 5

$count1 = array(); $count1[0] = " 1"; $count1[1] = " 2 1"; $count1[2] = " 3 2 1"; $count1[3] = " 4 3 2 1"; $count1[4] = " 5 4 3 2 1"; $count1[5] = " 6 5 4 3 2 1"; for ($b = 1;$b <= 6;$b++) { echo $count[$b]; echo "<br>"; } why does this not work? it just goes on forever. How do i use the $b to up the count of $count[]?

Member Avatar
Member Avatar
+0 forum 1

Hello ! I'm having a university project where I have to make a database on MS Access . The subject is : We have a company that deals with trading. You need to make a database to serve cost and product discounts for customers. The database must contain : -Nomenclature of customers with fields of your choice -Nomenclature of items with fields of your choice -Nomenclature, which represents individual prices for certain items pertaining to specific customers. When selecting a customer, the database must show all items with the respective prices depending on whether a customer is using it individual …

Member Avatar
Member Avatar
+0 forum 4

hi. i have a really basic question (really new to python). how do i read an entire binary file? from https://www.devdungeon.com/content/working-binary-data-python , `data = binary_file.read()` is to read the whole file at once. so i have a .dng file to test, which is 16.2mb, and i did: with open("portrait1.dng", "rb") as binary_file: #Read the whole file at once data = binary_file.read() #Return the hexadecimal representation of the binary data, byte instance hexa = binascii.hexlify(data) with open("readprotrait1.raw", "wb") as write_file: write_file.write(hexa) im using a hex editor to see if the data from .dng gets copied to the .raw file but only …

Member Avatar
Member Avatar
+0 forum 2

I got a syntax error flag in my "users" database table, but can't figure the issue out. Please, I need your help. The following is the error message: Error SQL query: --------------------------------------------------------- -- -- -- Table structure for table `users` -- CREATE TABLE IF NOT EXISTS `users` ( `user_id` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT , `username` VARCHAR( 255 ) COLLATE utf8_unicode_ci NOT NULL , `firstname` VARCHAR( 32 ) COLLATE utf8_unicode_ci NOT NULL , `lastname` VARCHAR( 32 ) COLLATE utf8_unicode_ci NOT NULL , `email` VARCHAR( 255 ) COLLATE utf8_unicode_ci NOT NULL , `phone` VARCHAR( 30 ) COLLATE utf8_unicode_ci NOT …

Member Avatar
Member Avatar
+0 forum 2

A person starts out as the "Curator" and stands at the end of a field. Everyone else playing stands at the far end (distance depends upon playing area selected). The object of the game is for a "Statue" to tag the Curator, thereby becoming the Curator and resetting the game. The Curator turns their back to the field, and the "Statues" attempt to race across and tag the Curator. Whenever the Curator turns around, the Statues must freeze in position and hold that for as long as the Curator looks at them. The Curator can even walk around the Statues, …

Member Avatar
Member Avatar
+0 forum 4

The End.